?? mysql.sql
字號:
-- 創(chuàng)建客戶表
DROP TABLE IF EXISTS CUSTOMER;
CREATE TABLE CUSTOMER (
CUSTOMER_ID int(20) NOT NULL default '0',
DISPLAY_NAME varchar(255) NOT NULL default '',
WEB_SITE varchar(255) default NULL,
CUSTOMER_CATEGORY varchar(64) default NULL,
NUM_EMPLOYEE varchar(255) default NULL,
ACTIVE_STATUS varchar(4) NOT NULL default 'Y'
) TYPE=MyISAM ;
-- 創(chuàng)建聯(lián)系人表
DROP TABLE IF EXISTS CONTACT;
CREATE TABLE CONTACT(
CONTACT_ID int(20) NOT NULL default '0',
CUSTOMER_ID int(20) NOT NULL default '0',
DISPLAY_NAME varchar(255) NOT NULL default '',
CONTACT_TYPE varchar(16) NOT NULL default '',
SEX varchar(64) default NULL,
BIRTH_DATE varchar(64) default NULL,
JOB_TITLE varchar(64) default NULL,
ACTIVE_STATUS varchar(4) NOT NULL default 'Y'
) TYPE=MyISAM ;
-- 初始化客戶和聯(lián)系人表數(shù)據(jù)
INSERT INTO CUSTOMER VALUES(1,'Nest Cafe','http://www.aaaa.com','Customer','51-100','Y');
INSERT INTO CUSTOMER VALUES(2,'Apache Fundation','http://www.bbbb.com','Customer','11-50','Y');
INSERT INTO CUSTOMER VALUES(3,'Sun System','http://www.cccc.com','Partener','101-500','Y');
INSERT INTO CONTACT VALUES(1,1,'Janet','Friend','Female','8.5','CEO','Y');
INSERT INTO CONTACT VALUES(2,1,'Tina','Family','Male','6.6','CTO','Y');
INSERT INTO CONTACT VALUES(3,2,'Jone','Friend','Female','10.6','CIO','Y');
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -