prompt PL/SQL Developer import file
prompt Created on 2008年3月15日 by new
set feedback off
set define off
prompt Disabling triggers for SIGNON...
alter table SIGNON disable all triggers;
prompt Disabling triggers for ACCOUNT...
alter table ACCOUNT disable all triggers;
prompt Disabling triggers for BANNERDATA...
alter table BANNERDATA disable all triggers;
prompt Disabling triggers for CATEGORY...
alter table CATEGORY disable all triggers;
prompt Disabling triggers for PRODUCT...
alter table PRODUCT disable all triggers;
prompt Disabling triggers for SUPPLIER...
alter table SUPPLIER disable all triggers;
prompt Disabling triggers for ITEM...
alter table ITEM disable all triggers;
prompt Disabling triggers for INVENTORY...
alter table INVENTORY disable all triggers;
prompt Disabling triggers for ORDERS...
alter table ORDERS disable all triggers;
prompt Disabling triggers for LINEITEM...
alter table LINEITEM disable all triggers;
prompt Disabling triggers for ORDERSTATUS...
alter table ORDERSTATUS disable all triggers;
prompt Disabling triggers for PROFILE...
alter table PROFILE disable all triggers;
prompt Disabling triggers for SEQUENCE...
alter table SEQUENCE disable all triggers;
prompt Disabling foreign key constraints for ACCOUNT...
alter table ACCOUNT disable constraint FK_ACCOUNT_A_SIGNON;
prompt Disabling foreign key constraints for PRODUCT...
alter table PRODUCT disable constraint FK_PRODUCT_FK_PRODUC_CATEGORY;
prompt Disabling foreign key constraints for ITEM...
alter table ITEM disable constraint FK_ITEM_FK_ITEM_1_PRODUCT;
alter table ITEM disable constraint FK_ITEM_FK_ITEM_2_SUPPLIER;
prompt Disabling foreign key constraints for INVENTORY...
alter table INVENTORY disable constraint FK_INVENTOR_RELATIONS_ITEM;
prompt Disabling foreign key constraints for ORDERS...
alter table ORDERS disable constraint FK_ORDERS_FK_ORDERS_ACCOUNT;
prompt Disabling foreign key constraints for LINEITEM...
alter table LINEITEM disable constraint FK_LINEITEM_FK_LINEIT_ORDERS;
alter table LINEITEM disable constraint FK_LINEITEM_RELATIONS_ITEM;
prompt Disabling foreign key constraints for ORDERSTATUS...
alter table ORDERSTATUS disable constraint FK_ORDERSTA_FK_ORDERS_ORDERS;
prompt Disabling foreign key constraints for PROFILE...
alter table PROFILE disable constraint FK_PROFILE_B_SIGNON;
prompt Deleting SEQUENCE...
delete from SEQUENCE;
commit;
prompt Deleting PROFILE...
delete from PROFILE;
commit;
prompt Deleting ORDERSTATUS...
delete from ORDERSTATUS;
commit;
prompt Deleting LINEITEM...
delete from LINEITEM;
commit;
prompt Deleting ORDERS...
delete from ORDERS;
commit;
prompt Deleting INVENTORY...
delete from INVENTORY;
commit;
prompt Deleting ITEM...
delete from ITEM;
commit;
prompt Deleting SUPPLIER...
delete from SUPPLIER;
commit;
prompt Deleting PRODUCT...
delete from PRODUCT;
commit;
prompt Deleting CATEGORY...
delete from CATEGORY;
commit;
prompt Deleting BANNERDATA...
delete from BANNERDATA;
commit;
prompt Deleting ACCOUNT...
delete from ACCOUNT;
commit;
prompt Deleting SIGNON...
delete from SIGNON;
commit;
prompt Loading SIGNON...
insert into SIGNON (USERID, USERNAME, PASSWORD)
values ('204', 'test', 'test');
insert into SIGNON (USERID, USERNAME, PASSWORD)
values ('2', 'admin', 'admin');
commit;
prompt 2 records loaded
prompt Loading ACCOUNT...
insert into ACCOUNT (USERID, EMAIL, FIRSTNAME, LASTNAME, STATUS, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE)
values ('2', 'tonyhelp@163.com', '趙', '杰', null, '西安市', '西安市', '西安市', '陜西省', '71000', '中國', '13669292765');
insert into ACCOUNT (USERID, EMAIL, FIRSTNAME, LASTNAME, STATUS, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE)
values ('204', 'sean@163.com', 'test', 'test', null, '西安市', '西安市', '西安市', '陜西省', '71000', '中國', '123456789');
commit;
prompt 2 records loaded
prompt Loading BANNERDATA...
prompt Table is empty
prompt Loading CATEGORY...
insert into CATEGORY (CATID, NAME, DESCN)
values ('1', '狗', '<img src="images/dog3.jpg" border="0">');
insert into CATEGORY (CATID, NAME, DESCN)
values ('2', '貓', '<img src="images/cat1.jpg" border="0">');
insert into CATEGORY (CATID, NAME, DESCN)
values ('3', '魚', '<img src="images/fish2.jpg" border="0">');
insert into CATEGORY (CATID, NAME, DESCN)
values ('4', '蜥蜴', '<img src="images/snake1.gif" border="0">');
commit;
prompt 4 records loaded
prompt Loading PRODUCT...
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('1', '1', '寵物狗', '<img src="images/banner_dogs.gif" border="0">');
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('2', '1', '藏獒', '<img src="images/banner_dogs.gif" border="0">');
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('3', '2', '非洲貓', '<img src="images/banner_cats.gif" border="0">');
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('4', '2', '美國貓', '<img src="images/banner_cats.gif" border="0">');
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('5', '3', '金魚', '<img src="images/banner_fish.gif" border="0">');
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('6', '3', '紅魚', '<img src="images/banner_fish.gif" border="0">');
insert into PRODUCT (PRODUCTID, CATID, NAME, DESCN)
values ('7', '4', '蜥蜴', '<img src="images/banner_reptiles.gif" border="0">');
commit;
prompt 7 records loaded
prompt Loading SUPPLIER...
insert into SUPPLIER (SUPPID, NAME, STATUS, ADDR1, ADDR2, CITY, STATE, ZIP, PHONE)
values (1, '人人樂', 'a', 'aa', 'aa', '西安', '陜西', '71006', '1234567');
commit;
prompt 1 records loaded
prompt Loading ITEM...
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('1', '1', 1, 300, 150, 'y', '小獅子狗', '適合玩耍', null, null, null);
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('2', '2', 1, 70000, 60000, 'y', '雪獒', '忠誠 勇敢 有靈性', null, null, null);
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('3', '3', 1, 300, 200, 'y', '咪咪', '會自己玩耍，惹人愛', null, null, null);
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('4', '4', 1, 400, 200, 'y', '豆豆', '很愛干凈', null, null, null);
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('5', '5', 1, 1.5, .5, 'y', '金粼魚', '用于家庭裝飾', null, null, null);
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('6', '6', 1, 20, 10, null, '鯉魚', '含大量蛋白質', null, null, null);
insert into ITEM (ITEMID, PRODUCTID, SUPPID, LISTPRICE, UNITCOST, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5)
values ('7', '7', 1, 2000, 1500, null, '蜥蜴', '變色龍', null, null, null);
commit;
prompt 7 records loaded
prompt Loading INVENTORY...
prompt Table is empty
prompt Loading ORDERS...
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (95, '2', to_date('15-03-2008 09:06:49', 'dd-mm-yyyy hh24:mi:ss'), 2400, '西安', '西安', '西安市', '陜西', '710065', '中國', '杰', '趙', '西安', '西安', '西安市', '陜西', '710065', '中國', '杰', '趙', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (99, '2', to_date('15-03-2008 09:14:22', 'dd-mm-yyyy hh24:mi:ss'), 2400, '西安', '西安', '西安市', '陜西', '710065', '中國', '杰', '趙', '西安', '西安', '西安市', '陜西', '710065', '中國', '杰', '趙', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (103, '2', to_date('15-03-2008 09:21:21', 'dd-mm-yyyy hh24:mi:ss'), 2400, '西安', '西安', '西安市', '陜西', '710065', '中國', '杰', '趙', '西安', '西安', '西安市', '陜西', '710065', '中國', '杰', '趙', '123456789', '2008-03-15', 'visa', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (107, '2', to_date('15-03-2008 09:23:52', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陜西省', '710065', '中國', '杰', '趙', '西安市', '西安市', '西安市', '陜西省', '710065', '中國', '杰', '趙', '123456789', '2008-03-15', '銀聯', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (111, '2', to_date('15-03-2008 09:27:48', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陜西省', '710065', '中國', '杰', '趙', '西安市', '西安市', '西安市', '陜西省', '710065', '中國', '杰', '趙', '123456789', '2008-03-15', '銀聯', null);
insert into ORDERS (ORDERID, USERID, ORDERDATE, TOTALPRICE, SHIPADDR1, SHIPADDR2, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOUNTRY, SHIPTOFIRSTNAME, SHIPTOLASTNAME, BILLADDR1, BILLADDR2, BILLCITY, BILLSTATE, BILLZIP, BILLCOUNTRY, BILLTOFIRSTNAME, BILLTOLASTNAME, CREDITCARD, EXPRDATE, CARDTYPE, LOCAL)
values (115, '2', to_date('15-03-2008 09:28:34', 'dd-mm-yyyy hh24:mi:ss'), 76000, '西安市', '西安市', '西安市', '陜西省', '710065', '中國', '杰', '趙', '西安市', '西安市', '西安市', '陜西省', '710065', '中國', '杰', '趙', '123456789', '2008-03-15', '銀聯', null);