【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了xwfb_table.sql相关资料,希望对各位网友有所帮助!
prompt PL/SQL Developer import file
prompt Created on 2006年10月21日 by Jerry
set feedback off
set define off
prompt Creating XWFB_COMMENT...
create table XWFB_COMMENT
(
ID NUMBER,
NEWS_ID NUMBER,
COMMENT_DATE VARCHAR2(100),
AUTHOR VARCHAR2(100),
COMMENT_AUTHOR VARCHAR2(100),
COMMENT_CONTENT VARCHAR2(1000)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating XWFB_NEWS...
create table XWFB_NEWS
(
ID NUMBER,
TITLE VARCHAR2(200),
CONTENT VARCHAR2(2000),
AUTHOR VARCHAR2(100),
EDITOR VARCHAR2(100),
EDITOR_TIME VARCHAR2(100),
CREATE_TIME VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating XWFB_USER...
create table XWFB_USER
(
USERNAME VARCHAR2(100),
PASSWORD VARCHAR2(100),
PRIORITY VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for XWFB_COMMENT...
alter table XWFB_COMMENT disable all triggers;
prompt Disabling triggers for XWFB_NEWS...
alter table XWFB_NEWS disable all triggers;
prompt Disabling triggers for XWFB_USER...
alter table XWFB_USER disable all triggers;
prompt Deleting XWFB_USER...
delete from XWFB_USER;
commit;
prompt Deleting XWFB_NEWS...
delete from XWFB_NEWS;
commit;
prompt Deleting XWFB_COMMENT...
delete from XWFB_COMMENT;
commit;
prompt Loading XWFB_COMMENT...
insert into XWFB_COMMENT (ID, NEWS_ID, COMMENT_DATE, AUTHOR, COMMENT_AUTHOR, COMMENT_CONTENT)
values (1, 7, '2006-3-17 16:13:33', 'jerry', 'jerry', 'dsfhasdf阿黄色分开哈三分');
insert into XWFB_COMMENT (ID, NEWS_ID, COMMENT_DATE, AUTHOR, COMMENT_AUTHOR, COMMENT_CONTENT)
values (2, 7, '2006-3-17 16:19:03', 'jerry', 'linkboycn', 'jkhf');
insert into XWFB_COMMENT (ID, NEWS_ID, COMMENT_DATE, AUTHOR, COMMENT_AUTHOR, COMMENT_CONTENT)
values (1, 6, '2006-3-17 18:42:45', 'admin', 'jerry', 'sdfasjf');
insert into XWFB_COMMENT (ID, NEWS_ID, COMMENT_DATE, AUTHOR, COMMENT_AUTHOR, COMMENT_CONTENT)
values (1, 9, '2006-4-16 10:15:58', 'a', 'admin', 'sdgssg');
insert into XWFB_COMMENT (ID, NEWS_ID, COMMENT_DATE, AUTHOR, COMMENT_AUTHOR, COMMENT_CONTENT)
values (1, 8, '2006-4-22 10:57:13', 'admin', 'jerry', 'sad');
commit;
prompt 5 records loaded
prompt Loading XWFB_NEWS...
insert into XWFB_NEWS (ID, TITLE, CONTENT, AUTHOR, EDITOR, EDITOR_TIME, CREATE_TIME)
values (6, '5999元买神舟奔腾M1.73G、512M DDR2强本', '开学伊始,为迎接年后第一个周末购机热潮,神舟电脑再次给初开学的学生朋友们带来惊喜:一举将其旗下一款性能超强的sonoma本本承运B740S狂降400元,现仅售5999,成为5999元价格线上又一精品机型。它采用奔腾740处理器,搭配512M DDR2内存,915GM芯片组等,提供了完整的SONOMA特性,尤其更配备了14.1寸东芝原厂出产的高品质液晶屏,打造更完美组合。' || chr(13) || '' || chr(10) || '奔腾M 740、512M DDRII内存,性能优越' || chr(13) || '' || chr(10) || '' || chr(13) || '' || chr(10) || '神舟承运B740S基于高端Sonoma平台,采用1.73G奔腾M740处理器,具有极强的兼容性,对软件、特别是大、中型软件的运算在稳定性和运算速度方面也是非常出色的。同时Intel 915GM高速芯片组、512M DDRII内存以及Intel GMA900显卡的搭配采用,为整机提供了完整的SONOMA特性,大幅度提高了数据传输速度,展现了这款高端笔记本电脑的优越性能,处理繁琐
工作、演绎动画
程序或是剪辑大型图片都不再是难题。' || chr(13) || '' || chr(10) || '', 'admin', 'admin', '2006-3-17 19:31:52', '2006-3-17 15:37:21');
insert into XWFB_NEWS (ID, TITLE, CONTENT, AUTHOR, EDITOR, EDITOR_TIME, CREATE_TIME)
values (7, '降价、新品不断,迎开学神舟更多优惠', '接口丰富,创造数码新生活' || chr(13) || '' || chr(10) || '' || chr(13) || '' || chr(10) || '除了上述的亮点外,神舟承运B740S那丰富的外部接口,也让我们再次见识到了神舟的实惠。除简单的日常接口,如麦克风输入、音频输出和S-Video输出等外,4个USB接口、1个IEEE1394、PC卡插槽以及红外通讯口的提供,完全可以满足数码爱好者的需求,为他们创造了一展才华的空间。' || chr(13) || '' || chr(10) || '' || chr(13) || '' || chr(10) || '加499元,随心所欲上网冲浪' || chr(13) || '' || chr(10) || '' || chr(13) || '' || chr(10) || '神舟承运B740S凭借高端的性能、精细的做工、丰富的接口等诸多亮点,一上市就成为市场上的新宠,现在又狂降