bb.sql

hibernate 简单的例子

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', '[e-mail]', '赵', '杰', null, '西安市', '西安市', '西安市', '陕西省', '71000', '中国', '13669292765');
insert into ACCOUNT (USERID, EMAIL, FIRSTNAME, LASTNAME, STATUS, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE)
values ('204', '[e-mail]', '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);