?? jpetstore.sql
字號:
PRIMARY KEY (orderid,linenum)
) TYPE=MyISAM;
#
# 導出表中的數據 `LINEITEM`
#
INSERT INTO LINEITEM VALUES (1000, 1, 'EST-1', 2, '16.50');
# --------------------------------------------------------
#
# 表的結構 `ORDERS`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 17:19
#
CREATE TABLE ORDERS (
orderid int(11) NOT NULL default '0',
userid varchar(80) NOT NULL default '',
orderdate date NOT NULL default '0000-00-00',
shipaddr1 varchar(80) NOT NULL default '',
shipaddr2 varchar(80) default NULL,
shipcity varchar(80) NOT NULL default '',
shipstate varchar(80) NOT NULL default '',
shipzip varchar(20) NOT NULL default '',
shipcountry varchar(20) NOT NULL default '',
billaddr1 varchar(80) NOT NULL default '',
billcity varchar(80) NOT NULL default '',
billstate varchar(80) NOT NULL default '',
billzip varchar(20) NOT NULL default '',
billcountry varchar(20) NOT NULL default '',
courier varchar(80) NOT NULL default '',
totalprice decimal(10,2) NOT NULL default '0.00',
billtofirstname varchar(80) NOT NULL default '',
billtolastname varchar(80) NOT NULL default '',
shiptofirstname varchar(80) NOT NULL default '',
shiptolastname varchar(80) NOT NULL default '',
creditcard varchar(80) NOT NULL default '',
exprdate varchar(7) NOT NULL default '',
cardtype varchar(80) NOT NULL default '',
locale varchar(80) NOT NULL default '',
PRIMARY KEY (orderid)
) TYPE=MyISAM;
#
# 導出表中的數據 `ORDERS`
#
INSERT INTO ORDERS VALUES (1000, 'j2ee', '2005-07-08', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', 'UPS', '33.00', 'ABC', 'XYX', 'ABC', 'XYX', '999 9999 9999 9999', '12/03', 'Visa', 'CA');
# --------------------------------------------------------
#
# 表的結構 `ORDERSTATUS`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 17:19
#
CREATE TABLE ORDERSTATUS (
orderid int(11) NOT NULL default '0',
linenum int(11) NOT NULL default '0',
timestamp date NOT NULL default '0000-00-00',
status char(2) NOT NULL default '',
PRIMARY KEY (orderid,linenum)
) TYPE=MyISAM;
#
# 導出表中的數據 `ORDERSTATUS`
#
INSERT INTO ORDERSTATUS VALUES (1000, 1000, '2005-07-08', 'P');
# --------------------------------------------------------
#
# 表的結構 `PRODUCT`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE PRODUCT (
productid varchar(10) NOT NULL default '',
category varchar(10) NOT NULL default '',
name varchar(80) default NULL,
descn varchar(255) default NULL,
PRIMARY KEY (productid),
KEY productCat (category),
KEY productName (name)
) TYPE=MyISAM;
#
# 導出表中的數據 `PRODUCT`
#
INSERT INTO PRODUCT VALUES ('FI-SW-01', 'FISH', 'Angelfish', '<image src="../images/fish1.jpg">Salt Water fish from Australia');
INSERT INTO PRODUCT VALUES ('FI-SW-02', 'FISH', 'Tiger Shark', '<image src="../images/fish4.gif">Salt Water fish from Australia');
INSERT INTO PRODUCT VALUES ('FI-FW-01', 'FISH', 'Koi', '<image src="../images/fish3.gif">Fresh Water fish from Japan');
INSERT INTO PRODUCT VALUES ('FI-FW-02', 'FISH', 'Goldfish', '<image src="../images/fish2.gif">Fresh Water fish from China');
INSERT INTO PRODUCT VALUES ('K9-BD-01', 'DOGS', 'Bulldog', '<image src="../images/dog2.gif">Friendly dog from England');
INSERT INTO PRODUCT VALUES ('K9-PO-02', 'DOGS', 'Poodle', '<image src="../images/dog6.gif">Cute dog from France');
INSERT INTO PRODUCT VALUES ('K9-DL-01', 'DOGS', 'Dalmation', '<image src="../images/dog5.gif">Great dog for a Fire Station');
INSERT INTO PRODUCT VALUES ('K9-RT-01', 'DOGS', 'Golden Retriever', '<image src="../images/dog1.gif">Great family dog');
INSERT INTO PRODUCT VALUES ('K9-RT-02', 'DOGS', 'Labrador Retriever', '<image src="../images/dog5.gif">Great hunting dog');
INSERT INTO PRODUCT VALUES ('K9-CW-01', 'DOGS', 'Chihuahua', '<image src="../images/dog4.gif">Great companion dog');
INSERT INTO PRODUCT VALUES ('RP-SN-01', 'REPTILES', 'Rattlesnake', '<image src="../images/lizard3.gif">Doubles as a watch dog');
INSERT INTO PRODUCT VALUES ('RP-LI-02', 'REPTILES', 'Iguana', '<image src="../images/lizard2.gif">Friendly green friend');
INSERT INTO PRODUCT VALUES ('FL-DSH-01', 'CATS', 'Manx', '<image src="../images/cat3.gif">Great for reducing mouse populations');
INSERT INTO PRODUCT VALUES ('FL-DLH-02', 'CATS', 'Persian', '<image src="../images/cat1.gif">Friendly house cat, doubles as a princess');
INSERT INTO PRODUCT VALUES ('AV-CB-01', 'BIRDS', 'Amazon Parrot', '<image src="../images/bird4.gif">Great companion for up to 75 years');
INSERT INTO PRODUCT VALUES ('AV-SB-02', 'BIRDS', 'Finch', '<image src="../images/bird1.gif">Great stress reliever');
# --------------------------------------------------------
#
# 表的結構 `PROFILE`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE PROFILE (
userid varchar(80) NOT NULL default '',
langpref varchar(80) NOT NULL default '',
favcategory varchar(30) default NULL,
mylistopt tinyint(1) default NULL,
banneropt tinyint(1) default NULL,
PRIMARY KEY (userid)
) TYPE=MyISAM;
#
# 導出表中的數據 `PROFILE`
#
INSERT INTO PROFILE VALUES ('j2ee', 'english', 'DOGS', 1, 1);
INSERT INTO PROFILE VALUES ('ACID', 'english', 'CATS', 1, 1);
# --------------------------------------------------------
#
# 表的結構 `SEQUENCE`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 17:19
#
CREATE TABLE SEQUENCE (
name varchar(30) NOT NULL default '',
nextid int(11) NOT NULL default '0',
PRIMARY KEY (name)
) TYPE=MyISAM;
#
# 導出表中的數據 `SEQUENCE`
#
INSERT INTO SEQUENCE VALUES ('ordernum', 1001);
INSERT INTO SEQUENCE VALUES ('linenum', 1000);
# --------------------------------------------------------
#
# 表的結構 `SIGNON`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE SIGNON (
username varchar(25) NOT NULL default '',
password varchar(25) NOT NULL default '',
PRIMARY KEY (username)
) TYPE=MyISAM;
#
# 導出表中的數據 `SIGNON`
#
INSERT INTO SIGNON VALUES ('j2ee', 'j2ee');
INSERT INTO SIGNON VALUES ('ACID', 'ACID');
# --------------------------------------------------------
#
# 表的結構 `SUPPLIER`
#
# 創建時間: 2005 年 07 月 08 日 17:05
# 最后更新時間: 2005 年 07 月 08 日 17:06
#
CREATE TABLE SUPPLIER (
suppid int(11) NOT NULL default '0',
name varchar(80) default NULL,
STATUS char(2) NOT NULL default '',
addr1 varchar(80) default NULL,
addr2 varchar(80) default NULL,
city varchar(80) default NULL,
state varchar(80) default NULL,
zip varchar(5) default NULL,
phone varchar(80) default NULL,
PRIMARY KEY (suppid)
) TYPE=MyISAM;
#
# 導出表中的數據 `SUPPLIER`
#
INSERT INTO SUPPLIER VALUES (1, 'XYZ Pets', 'AC', '600 Avon Way', '', 'Los Angeles', 'CA', '94024', '212-947-0797');
INSERT INTO SUPPLIER VALUES (2, 'ABC Pets', 'AC', '700 Abalone Way', '', 'San Francisco', 'CA', '94024', '415-947-0797');
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -