www.pudn.com > j2EEnews_struts_hibernate_spring.rar > newsall.sql
prompt PL/SQL Developer import file
prompt Created on 2006年7月23日 by Administrator
set feedback off
set define off
prompt Creating ADMINUSER...
create table ADMINUSER
(
ID NVARCHAR2(30) not null,
NAME NVARCHAR2(50) not null,
PASSWORD NVARCHAR2(50) not null,
ADMINDATE NVARCHAR2(30),
AUTHOR NVARCHAR2(50),
DATE2 NVARCHAR2(50)
)
tablespace NJ01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table ADMINUSER
add constraint PK_ADMINUSER primary key (ID)
using index
tablespace NJ01
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating GUESTBOOK...
create table GUESTBOOK
(
ID NVARCHAR2(30) not null,
NAME NVARCHAR2(30) not null,
NEWID NVARCHAR2(30) not null,
GUESTDATE NVARCHAR2(50) not null,
DATE2 NVARCHAR2(50) not null,
GUESTCONTENT NVARCHAR2(300) not null,
IMAGE NVARCHAR2(50) not null
)
tablespace NJ01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table GUESTBOOK
add constraint PK_GUEST primary key (ID)
using index
tablespace NJ01
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating NEWS...
create table NEWS
(
ID NVARCHAR2(20) not null,
TYPEID NVARCHAR2(20) not null,
NEWTITLE NVARCHAR2(40) not null,
NEWAUTHOR NVARCHAR2(20) not null,
NEWFROM NVARCHAR2(20) not null,
NEWDATE NVARCHAR2(30) not null,
NEWCONTENT NVARCHAR2(400) not null,
COUNT NVARCHAR2(100),
DATE2 NVARCHAR2(100) not null
)
tablespace NJ01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table NEWS
add constraint PK_NEWS primary key (ID)
using index
tablespace NJ01
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating NEWTYPE...
create table NEWTYPE
(
ID NVARCHAR2(30) not null,
NEWTYPETITLE NVARCHAR2(50) not null,
TYPEAUTHOR NVARCHAR2(50) not null,
NEWTYPEDATE NVARCHAR2(50) not null,
DATE2 NVARCHAR2(50) not null
)
tablespace NJ01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table NEWTYPE
add constraint PK_TYPE primary key (ID)
using index
tablespace NJ01
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for ADMINUSER...
alter table ADMINUSER disable all triggers;
prompt Disabling triggers for GUESTBOOK...
alter table GUESTBOOK disable all triggers;
prompt Disabling triggers for NEWS...
alter table NEWS disable all triggers;
prompt Disabling triggers for NEWTYPE...
alter table NEWTYPE disable all triggers;
prompt Deleting NEWTYPE...
delete from NEWTYPE;
commit;
prompt Deleting NEWS...
delete from NEWS;
commit;
prompt Deleting GUESTBOOK...
delete from GUESTBOOK;
commit;
prompt Deleting ADMINUSER...
delete from ADMINUSER;
commit;
prompt Loading ADMINUSER...
insert into ADMINUSER (ID, NAME, PASSWORD, ADMINDATE, AUTHOR, DATE2)
values ('9175930499', 'qzl', 'qzl', '2006-07-18 15:14', 'admin', '20060718151414');
insert into ADMINUSER (ID, NAME, PASSWORD, ADMINDATE, AUTHOR, DATE2)
values ('1106654074', 'juny', 'juny', '2006-07-18 14:58', 'admin', '20060718145813');
insert into ADMINUSER (ID, NAME, PASSWORD, ADMINDATE, AUTHOR, DATE2)
values ('3495385236', 'admin', 'admin', '2006-07-18 14:02', 'admin', '20060718140206');
insert into ADMINUSER (ID, NAME, PASSWORD, ADMINDATE, AUTHOR, DATE2)
values ('9605863242', '路人甲', '1', '2006-07-20 20:17', 'admin', '20060720201745');
insert into ADMINUSER (ID, NAME, PASSWORD, ADMINDATE, AUTHOR, DATE2)
values ('2199443025', '联通', '联通', '2006-07-20 20:26', '路人甲', '20060720202654');
commit;
prompt 5 records loaded
prompt Loading GUESTBOOK...
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('4869083904', '1t1t', '1111', '2006-07-22 21:07', '20060722210753', 'ddd', 'guestbookimage/face4.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('1232948568', '1', '1111', '2006-07-21 21:12', '20060721211236', '111', 'guestbookimage/face2.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('8577339902', 'ss', '1111', '2006-07-21 22:01', '20060721220150', 'ss', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3935092975', 'w', '1111', '2006-07-21 22:24', '20060721222432', 'w', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('7007037004', 'aa', '1111', '2006-07-21 22:29', '20060721222902', 'aa', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('0796942977', 'r', '1111', '2006-07-22 00:10', '20060722001036', 'ww', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('4986423248', 'r', '1111', '2006-07-22 00:13', '20060722001345', 'ww', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3063690193', '1', '1111', '2006-07-22 00:18', '20060722001830', '1', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('4755785170', '1', '1111', '2006-07-22 00:20', '20060722002015', '1', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('5092498436', 'd', '1111', '2006-07-22 00:20', '20060722002037', 'd', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3121860529', 'd', '1111', '2006-07-22 00:21', '20060722002143', 'd', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('1368517768', 's', '1111', '2006-07-22 00:22', '20060722002241', 's', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('6617698057', 's', '1111', '2006-07-22 00:23', '20060722002339', 's', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('5239324682', 'qq', '1111', '2006-07-22 00:26', '20060722002656', 'qq', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3465120388', 'qq', '1111', '2006-07-22 00:29', '20060722002925', 'qq', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('8107861701', '2', '1111', '2006-07-22 00:29', '20060722002957', '2', 'guestbookimage/face2.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('5327378515', '2', '1111', '2006-07-22 00:30', '20060722003009', '2', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('1523134703', 'dd', '1111', '2006-07-23 14:55', '20060723145516', 'dd', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('0395471352', 'dd', '1111', '2006-07-23 14:59', '20060723145957', 'dd', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('9839303585', 'aa', '1111', '2006-07-23 15:11', '20060723151150', 'aa', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('6570902400', '1', '8969593665', '2006-07-23 15:12', '20060723151236', '11', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3099823056', '1', '8969593665', '2006-07-23 15:14', '20060723151410', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3620822771', '1', '8969593665', '2006-07-23 15:14', '20060723151414', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('1959665858', '1', '8969593665', '2006-07-23 15:15', '20060723151510', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('8078321158', '1', '8969593665', '2006-07-23 15:15', '20060723151514', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('9318223197', '1', '8969593665', '2006-07-23 15:15', '20060723151517', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('2912503153', '1', '8969593665', '2006-07-23 15:15', '20060723151519', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('0121657820', '1', '8969593665', '2006-07-23 15:15', '20060723151521', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('1921980341', '1', '8969593665', '2006-07-23 15:15', '20060723151524', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('6398839739', '1', '8969593665', '2006-07-23 15:15', '20060723151528', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3555620861', '1', '8969593665', '2006-07-23 15:16', '20060723151638', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('8187817015', '1', '8969593665', '2006-07-23 15:16', '20060723151642', '1', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('9796223804', '1', '1090064009', '2006-07-23 15:16', '20060723151654', '2', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3246738525', '1', '1090064009', '2006-07-23 15:16', '20060723151657', '2', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('0720273512', '4', '1090064009', '2006-07-23 15:17', '20060723151710', '4', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('4542458716', '5', '1090064009', '2006-07-23 15:17', '20060723151726', '5', 'image/face7.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('1972290061', 'd', '1090064009', '2006-07-23 15:18', '20060723151816', 'd', 'image/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('4365919654', 'd', '8969593665', '2006-07-23 15:19', '20060723151902', 'd', 'image/face2.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('3132824295', '33', '1111', '2006-07-21 23:58', '20060721235837', '333', 'guestbookimage/face1.gif');
insert into GUESTBOOK (ID, NAME, NEWID, GUESTDATE, DATE2, GUESTCONTENT, IMAGE)
values ('2876965783', 'ddd', '1111', '2006-07-23 14:59', '20060723145920', 'ddd', 'guestbookimage/face1.gif');
commit;
prompt 40 records loaded
prompt Loading NEWS...
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('1917013836', '8642130245', '2323', 'admin', '2332', '2006-07-20 20:05', '2323', '0', '20060720200534');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('6406259139', '8642130245', '99', 'admin', '99', '2006-07-20 20:04', '99', '1', '20060720200442');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('6630774636', '8642130245', 'rt', 'admin', 'rtr', '2006-07-20 20:03', 'trtrt', '0', '20060720200349');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('0572266284', '8642130245', '44', 'admin', '44', '2006-07-20 20:04', '44', '0', '20060720200424');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('4510504911', '8642130245', '77', 'admin', '7', '2006-07-20 20:04', '777', '1', '20060720200435');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('8969593665', '3817810373', 'JAVA发生7.2级地震', 'admin', 'sohu', '2006-07-19 14:36', 'JAVA发生7.2级地震', '13', '20060719143634');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('9528611282', '8642130245', 'juny', 'admin', 'junyj', '2006-07-18 17:55', 'uyny', '1', '20060718175523');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('3368987581', '8642130245', '66', 'admin', '66', '2006-07-20 20:04', '66', '1', '20060720200432');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('3622091730', '8642130245', '00', 'admin', '00', '2006-07-20 20:04', '00', '2', '20060720200446');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('1090064009', '8642130245', '1212', 'admin', '1212', '2006-07-20 20:05', '121', '2', '20060720200530');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('3093009522', '9662000923', 'll', 'juny', 'gggggg', '2006-07-18 14:59', 'll', '0', '20060718145937');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('5869043166', '8642130245', '55', 'admin', '55', '2006-07-20 20:04', '55', '0', '20060720200428');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('5002061104', '8642130245', 'ert', 'admin', 'ert', '2006-07-20 20:03', 'ert', '0', '20060720200343');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('5312247713', '8642130245', '34', 'admin', '34', '2006-07-20 20:04', '34', '0', '20060720200418');
insert into NEWS (ID, TYPEID, NEWTITLE, NEWAUTHOR, NEWFROM, NEWDATE, NEWCONTENT, COUNT, DATE2)
values ('4609500956', '8642130245', '88', 'admin', '88', '2006-07-20 20:04', '88', '2', '20060720200439');
commit;
prompt 15 records loaded
prompt Loading NEWTYPE...
insert into NEWTYPE (ID, NEWTYPETITLE, TYPEAUTHOR, NEWTYPEDATE, DATE2)
values ('8642130245', '体育新闻', 'admin', '2006-07-17 18:09', '20060717180941');
insert into NEWTYPE (ID, NEWTYPETITLE, TYPEAUTHOR, NEWTYPEDATE, DATE2)
values ('3817810373', 'IT风云', 'admin', '2006-07-17 22:55', '20060717225558');
commit;
prompt 2 records loaded
prompt Enabling triggers for ADMINUSER...
alter table ADMINUSER enable all triggers;
prompt Enabling triggers for GUESTBOOK...
alter table GUESTBOOK enable all triggers;
prompt Enabling triggers for NEWS...
alter table NEWS enable all triggers;
prompt Enabling triggers for NEWTYPE...
alter table NEWTYPE enable all triggers;
set feedback on
set define on
prompt Done.