ins_base_data.sql

模仿腾讯QQ的

prompt PL/SQL Developer import file
prompt Created on 2007年11月26日 by admin
set feedback off
set define off
prompt Disabling triggers for TDEPARTMENT...
alter table TDEPARTMENT disable all triggers;
prompt Disabling triggers for TUSER...
alter table TUSER disable all triggers;
prompt Disabling foreign key constraints for TUSER...
alter table TUSER disable constraint FDSAJFEW;
prompt Deleting TUSER...
delete from TUSER;
commit;
prompt Deleting TDEPARTMENT...
delete from TDEPARTMENT;
commit;
prompt Loading TDEPARTMENT...
insert into TDEPARTMENT (DNO, DNAME, DSAFFICHE)
values ('0005', '财务部', '财务部成立了');
insert into TDEPARTMENT (DNO, DNAME, DSAFFICHE)
values ('0001', '开发部', '开发部成立了');
insert into TDEPARTMENT (DNO, DNAME, DSAFFICHE)
values ('0002', '设计部', '设计部成立了');
insert into TDEPARTMENT (DNO, DNAME, DSAFFICHE)
values ('0003', '市场部', '市场部成立了');
insert into TDEPARTMENT (DNO, DNAME, DSAFFICHE)
values ('0004', '实施部', '实施部成立了');
commit;
prompt 5 records loaded
prompt Loading TUSER...
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0007', '123456', '王小东', '可爱的小狗', '男', '11', '24', '0004', '13545754675', '香港', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0008', '123456', '程琳', '妮儿', '女', '15', '22', '0004', '13545754568', '福州', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0009', '123456', '李白', '酒仙', '男', '1', '20', '0002', '13705642415', '漳州', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0010', '123456', '张三', '阿甘', '男', '20', '45', '0002', '13845214574', '厦门', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0011', '123456', '李湘', '湘儿', '女', '103', '45', '0001', '13005386547', '广东', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0001', '123456', '腾讯', '信使服务', '男', '1', '38', '0001', '13024150219', '福州', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0002', '123456', '王强', 'Jimes', '男', '2', '24', '0005', '0591-87345643', '江西', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0003', '123456', '赵本山', '老赵', '男', '25', '12', '0003', '0591-87345643', '北京', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0004', '123456', '宋江', '108之首', '男', '9', '25', '0003', '0591-87345643', '上海', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0005', '123456', '柯达', '笑一笑', '男', '21', '26', '0002', '0591-87345643', '大连', null, '2007-11-20 00:00:00', '0', '0');
insert into TUSER (UNO, UPASSWORD, UNAME, UTERM, USEX, UICONID, UAGE, DNO, UPHONE, UADDRESS, ULASTLOGINTIME, UREGDATE, ULOGINCOUNT, UISONLINE)
values ('0006', '123456', '赵小平', '利剑', '男', '11', '23', '0005', '15912540145', '深圳', null, '2007-11-20 00:00:00', '0', '0');
commit;
prompt 11 records loaded
prompt Enabling foreign key constraints for TUSER...
alter table TUSER enable constraint FDSAJFEW;
prompt Enabling triggers for TDEPARTMENT...
alter table TDEPARTMENT enable all triggers;
prompt Enabling triggers for TUSER...
alter table TUSER enable all triggers;
set feedback on
set define on
prompt Done.