?? jpetstore.sql
字號:
# phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# 主機: 61.129.67.109
# 生成日期: 2005 年 07 月 08 日 17:31
# 服務器版本: 4.0.12
# PHP 版本: 4.3.4
# 數據庫 : `jpetstore`
# --------------------------------------------------------
#
# 表的結構 `ACCOUNT`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE ACCOUNT (
userid varchar(80) NOT NULL default '',
email varchar(80) NOT NULL default '',
firstname varchar(80) NOT NULL default '',
lastname varchar(80) NOT NULL default '',
status char(2) default NULL,
addr1 varchar(80) NOT NULL default '',
addr2 varchar(40) default NULL,
city varchar(80) NOT NULL default '',
state varchar(80) NOT NULL default '',
zip varchar(20) NOT NULL default '',
country varchar(20) NOT NULL default '',
phone varchar(80) NOT NULL default '',
PRIMARY KEY (userid)
) TYPE=MyISAM;
#
# 導出表中的數據 `ACCOUNT`
#
INSERT INTO ACCOUNT VALUES ('j2ee', 'yourname@yourdomain.com', 'ABC', 'XYX', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555');
INSERT INTO ACCOUNT VALUES ('ACID', 'acid@yourdomain.com', 'ABC', 'XYX', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555');
# --------------------------------------------------------
#
# 表的結構 `BANNERDATA`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE BANNERDATA (
favcategory varchar(80) NOT NULL default '',
bannername varchar(255) default NULL,
PRIMARY KEY (favcategory)
) TYPE=MyISAM;
#
# 導出表中的數據 `BANNERDATA`
#
INSERT INTO BANNERDATA VALUES ('FISH', '<image src="../images/banner_fish.gif">');
INSERT INTO BANNERDATA VALUES ('CATS', '<image src="../images/banner_cats.gif">');
INSERT INTO BANNERDATA VALUES ('DOGS', '<image src="../images/banner_dogs.gif">');
INSERT INTO BANNERDATA VALUES ('REPTILES', '<image src="../images/banner_reptiles.gif">');
INSERT INTO BANNERDATA VALUES ('BIRDS', '<image src="../images/banner_birds.gif">');
# --------------------------------------------------------
#
# 表的結構 `CATEGORY`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE CATEGORY (
catid varchar(10) NOT NULL default '',
name varchar(80) default NULL,
descn varchar(255) default NULL,
PRIMARY KEY (catid)
) TYPE=MyISAM;
#
# 導出表中的數據 `CATEGORY`
#
INSERT INTO CATEGORY VALUES ('FISH', 'Fish', '<image src="../images/fish_icon.gif"><font size="5" color="blue"> Fish</font>');
INSERT INTO CATEGORY VALUES ('DOGS', 'Dogs', '<image src="../images/dogs_icon.gif"><font size="5" color="blue"> Dogs</font>');
INSERT INTO CATEGORY VALUES ('REPTILES', 'Reptiles', '<image src="../images/reptiles_icon.gif"><font size="5" color="blue"> Reptiles</font>');
INSERT INTO CATEGORY VALUES ('CATS', 'Cats', '<image src="../images/cats_icon.gif"><font size="5" color="blue"> Cats</font>');
INSERT INTO CATEGORY VALUES ('BIRDS', 'Birds', '<image src="../images/birds_icon.gif"><font size="5" color="blue"> Birds</font>');
# --------------------------------------------------------
#
# 表的結構 `INVENTORY`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 17:19
#
CREATE TABLE INVENTORY (
itemid varchar(10) NOT NULL default '',
qty int(11) NOT NULL default '0',
PRIMARY KEY (itemid)
) TYPE=MyISAM;
#
# 導出表中的數據 `INVENTORY`
#
INSERT INTO INVENTORY VALUES ('EST-1', 9998);
INSERT INTO INVENTORY VALUES ('EST-2', 10000);
INSERT INTO INVENTORY VALUES ('EST-3', 10000);
INSERT INTO INVENTORY VALUES ('EST-4', 10000);
INSERT INTO INVENTORY VALUES ('EST-5', 10000);
INSERT INTO INVENTORY VALUES ('EST-6', 10000);
INSERT INTO INVENTORY VALUES ('EST-7', 10000);
INSERT INTO INVENTORY VALUES ('EST-8', 10000);
INSERT INTO INVENTORY VALUES ('EST-9', 10000);
INSERT INTO INVENTORY VALUES ('EST-10', 10000);
INSERT INTO INVENTORY VALUES ('EST-11', 10000);
INSERT INTO INVENTORY VALUES ('EST-12', 10000);
INSERT INTO INVENTORY VALUES ('EST-13', 10000);
INSERT INTO INVENTORY VALUES ('EST-14', 10000);
INSERT INTO INVENTORY VALUES ('EST-15', 10000);
INSERT INTO INVENTORY VALUES ('EST-16', 10000);
INSERT INTO INVENTORY VALUES ('EST-17', 10000);
INSERT INTO INVENTORY VALUES ('EST-18', 10000);
INSERT INTO INVENTORY VALUES ('EST-19', 10000);
INSERT INTO INVENTORY VALUES ('EST-20', 10000);
INSERT INTO INVENTORY VALUES ('EST-21', 10000);
INSERT INTO INVENTORY VALUES ('EST-22', 10000);
INSERT INTO INVENTORY VALUES ('EST-23', 10000);
INSERT INTO INVENTORY VALUES ('EST-24', 10000);
INSERT INTO INVENTORY VALUES ('EST-25', 10000);
INSERT INTO INVENTORY VALUES ('EST-26', 10000);
INSERT INTO INVENTORY VALUES ('EST-27', 10000);
INSERT INTO INVENTORY VALUES ('EST-28', 10000);
# --------------------------------------------------------
#
# 表的結構 `ITEM`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 16:37
#
CREATE TABLE ITEM (
itemid varchar(10) NOT NULL default '',
productid varchar(10) NOT NULL default '',
listprice decimal(10,2) default NULL,
unitcost decimal(10,2) default NULL,
supplier int(11) default NULL,
status char(2) default NULL,
attr1 varchar(80) default NULL,
attr2 varchar(80) default NULL,
attr3 varchar(80) default NULL,
attr4 varchar(80) default NULL,
attr5 varchar(80) default NULL,
PRIMARY KEY (itemid),
KEY itemProd (productid)
) TYPE=MyISAM;
#
# 導出表中的數據 `ITEM`
#
INSERT INTO ITEM VALUES ('EST-1', 'FI-SW-01', '16.50', '10.00', 1, 'P', 'Large', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-2', 'FI-SW-01', '16.50', '10.00', 1, 'P', 'Small', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-3', 'FI-SW-02', '18.50', '12.00', 1, 'P', 'Toothless', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-4', 'FI-FW-01', '18.50', '12.00', 1, 'P', 'Spotted', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-5', 'FI-FW-01', '18.50', '12.00', 1, 'P', 'Spotless', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-6', 'K9-BD-01', '18.50', '12.00', 1, 'P', 'Male Adult', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-7', 'K9-BD-01', '18.50', '12.00', 1, 'P', 'Female Puppy', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-8', 'K9-PO-02', '18.50', '12.00', 1, 'P', 'Male Puppy', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-9', 'K9-DL-01', '18.50', '12.00', 1, 'P', 'Spotless Male Puppy', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-10', 'K9-DL-01', '18.50', '12.00', 1, 'P', 'Spotted Adult Female', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-11', 'RP-SN-01', '18.50', '12.00', 1, 'P', 'Venomless', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-12', 'RP-SN-01', '18.50', '12.00', 1, 'P', 'Rattleless', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-13', 'RP-LI-02', '18.50', '12.00', 1, 'P', 'Green Adult', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-14', 'FL-DSH-01', '58.50', '12.00', 1, 'P', 'Tailless', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-15', 'FL-DSH-01', '23.50', '12.00', 1, 'P', 'With tail', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-16', 'FL-DLH-02', '93.50', '12.00', 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-17', 'FL-DLH-02', '93.50', '12.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-18', 'AV-CB-01', '193.50', '92.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-19', 'AV-SB-02', '15.50', '2.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-20', 'FI-FW-02', '5.50', '2.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-21', 'FI-FW-02', '5.29', '1.00', 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-22', 'K9-RT-02', '135.50', '100.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-23', 'K9-RT-02', '145.49', '100.00', 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-24', 'K9-RT-02', '255.50', '92.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-25', 'K9-RT-02', '325.29', '90.00', 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-26', 'K9-CW-01', '125.50', '92.00', 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-27', 'K9-CW-01', '155.29', '90.00', 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL);
INSERT INTO ITEM VALUES ('EST-28', 'K9-RT-01', '155.29', '90.00', 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL);
# --------------------------------------------------------
#
# 表的結構 `LINEITEM`
#
# 創建時間: 2005 年 07 月 08 日 16:37
# 最后更新時間: 2005 年 07 月 08 日 17:19
#
CREATE TABLE LINEITEM (
orderid int(11) NOT NULL default '0',
linenum int(11) NOT NULL default '0',
itemid varchar(10) NOT NULL default '',
quantity int(11) NOT NULL default '0',
unitprice decimal(10,2) NOT NULL default '0.00',
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -