db2表文件脚本.txt

是一个电子商务网站的功能介绍

----------使用DB2脚本说明
----------如果您使用的是DB2 7.0版本数据库，请按下面分好的段落，一段一段的复制创建表结构语句，并执行。
----------如果您使用的是DB2 8.0版本数据库，您可以一次性复制所有的创建表结构语句，并执行。

------(1)TBADMIN
CREATE TABLE NULLID.TBADMIN ("ADMINID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERNAME" VARCHAR (50) , "PWD" VARCHAR (50) , "EMAIL" VARCHAR (100) , "TNAME" VARCHAR (50) , "SYSPOWER" VARCHAR (10) , "TIM" TIMESTAMP , "SEX" INTEGER , "KCPOWER" VARCHAR (250) , PRIMARY KEY (ADMINID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------(1)TBADMIN


------(2)TBBANJI
CREATE TABLE NULLID.TBBANJI ("BANJIID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "BANJI" VARCHAR (100) , "BANJINO" VARCHAR (50) , "BANORD"  INTEGER , PRIMARY KEY (BANJIID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------(2)TBBANJI


------(3)TBBIJI
CREATE TABLE NULLID.TBBIJI ("BJID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "BJCONTENT" LONG VARCHAR , "BJTIM" TIMESTAMP , "USERID" INTEGER , PRIMARY KEY (BJID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------(3)TBBIJI


----------(4)TBCAT
CREATE TABLE NULLID.TBCAT ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "CNAME" VARCHAR (150) , "CNO" INTEGER , "ISOPEN" INTEGER , "KCID" INTEGER , PRIMARY KEY (ID) )  DATA CAPTURE NONE   IN USERSPACE1;
----------(4)TBCAT


--------(5)TBCHAPTER
CREATE TABLE NULLID.TBCHAPTER ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "KCID" INTEGER , "CHAPTER" INTEGER , "SDATE" TIMESTAMP , "EDATE" TIMESTAMP , "TESTOPEN" INTEGER , "ISDEL" INTEGER ,"CHTITLE" VARCHAR (150),  PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
--------(5)TBCHAPTER


------(6)TBCHART
CREATE TABLE NULLID.TBCHART ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "X" INTEGER , "Y" INTEGER , "PAPERNO" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------(6)TBCHART


---------(7)TBCONFIG
CREATE TABLE NULLID.TBCONFIG ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "LOGO" VARCHAR (200) , "LOGOLINK" VARCHAR (200) , "TITLE" VARCHAR (200) , "HAPPYSOFT" VARCHAR (100) , "ISLOGIN" INTEGER , "REFRESHTIME" INTEGER , "ISLOOK" INTEGER , "ISCHECK" INTEGER , "ISPOWER" INTEGER , "ISUPLOAD" INTEGER , "ISSAMETIME" INTEGER , "UPFILETYPE" VARCHAR (250), "MAXFILESIZE" INTEGER  , "VERNO" VARCHAR (50), "ISEMAIL" INTEGER  , "ISUSERORDER" INTEGER  , "ORDERLEN" INTEGER  , "ISZHIJI" INTEGER  , "CHMODEL" VARCHAR (50), "ISSAMEIP" INTEGER  , "GONGSI" VARCHAR (100), "WANGZHI" VARCHAR (100), "ISPHOTO" INTEGER  , "PWIDTH" INTEGER  , "PHEIGHT" INTEGER  , "ISSFZH" INTEGER  , "SUBJECTNUM" INTEGER  , "TMNUM" INTEGER  , "LONGHNUM" INTEGER  ,"ISSHOWPOINT" INTEGER  ,"ISSHOWLONGH" INTEGER  , "ISNIANJIVIEW" INTEGER  , "ISOPENFORUM" INTEGER  , "ISFIRSTTIM" INTEGER  , "ISSECONDTIM" INTEGER ,  PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
---------(7)TBCONFIG


--------(8)TBFORUM
CREATE TABLE NULLID.TBFORUM ("FORUMID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "REPLYID" INTEGER , "USERNAME" VARCHAR (50) , "TOPIC" VARCHAR (50) , "WORD" LONG VARCHAR , "ICON" INTEGER , "TIM" TIMESTAMP , "HITS" INTEGER , "LASTNAME" VARCHAR (50) , "LASTTIME" TIMESTAMP , "IP" VARCHAR (50) , "OS" VARCHAR (150) , PRIMARY KEY (FORUMID)  )  DATA CAPTURE NONE   IN USERSPACE1;
--------(8)TBFORUM


--------(9)TBISTEST
CREATE TABLE NULLID.TBISTEST ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "KCID" INTEGER , "KAO" INTEGER , "ISTEST" INTEGER , "CHAPTER" INTEGER , "ISDEL" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
--------(9)TBISTEST


-----------(10)TBKC
CREATE TABLE NULLID.TBKC ("KCID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "KCM" VARCHAR (100) , "ISOPEN" INTEGER , "ISSHARE" INTEGER , "KCORD" INTEGER , PRIMARY KEY (KCID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-----------(10)TBKC


------------(11)TBKCCONFIG
CREATE TABLE NULLID.TBKCCONFIG ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "KCID" INTEGER , "CATEGORY" INTEGER , "DATANO" INTEGER , "DATAVALUE" DOUBLE , "PAPERNO" INTEGER , "ORDERNO" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(11)TBKCCONFIG


-----------(12)TBKSDATA
CREATE TABLE NULLID.TBKSDATA ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "PAPERNO" INTEGER , "SCORE" DOUBLE , "ISEXAM" INTEGER , "ISADMIN" INTEGER , "STIME" TIMESTAMP , "ETIME" TIMESTAMP , "KSNUM" INTEGER , "ISSCAN" INTEGER , "ISCREATE" INTEGER , "PINGYU" LONG VARCHAR , "IP" VARCHAR (50) , "ISDEL" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-----------(12)TBKSDATA


-----------(13)TBLOGIN
CREATE TABLE NULLID.TBLOGIN ("LOGINID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "LTIM" TIMESTAMP , "IP" VARCHAR (50) , PRIMARY KEY (LOGINID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-----------(13)TBLOGIN


--------(14)TBNEWS
CREATE TABLE NULLID.TBNEWS ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "TITLE" VARCHAR (100) , "CONTENT" LONG VARCHAR , "FABSJ" TIMESTAMP , "ADMINNAME" VARCHAR (50) , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
--------(14)TBNEWS


-------(15)TBNIANJI
CREATE TABLE NULLID.TBNIANJI ("NIANJIID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "NIANJI" VARCHAR (100) , "NIANJINO" VARCHAR (50) , "NIANORD" INTEGER, PRIMARY KEY (NIANJIID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-------(15)TBNIANJI


-------(16)TBPAPER
CREATE TABLE NULLID.TBPAPER ("PAPERNO" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "KCID" INTEGER , "INFO" VARCHAR (100) , "SCHAP" INTEGER , "ECHAP" INTEGER , "PAPERDATETIME" INTEGER , "STIME" TIMESTAMP , "ETIME" TIMESTAMP , "ISOPEN" INTEGER , "ISCHOOSE" INTEGER , "ADMINNAME" VARCHAR (50) , "ISSHOW" INTEGER , "ISLOOK" INTEGER , "EXAMTIME" INTEGER , "NANDU" INTEGER , "ISKAO" INTEGER , "ISCONN" INTEGER , "GGID" VARCHAR (250) , "TEA_USER" INTEGER , "ISDEL" INTEGER , "SAVEWAY" INTEGER , "PASS" DOUBLE,"ISPOINT" INTEGER ,PRIMARY KEY (PAPERNO)  )  DATA CAPTURE NONE   IN USERSPACE1;
-------(16)TBPAPER


----------(17)TBPOWER
CREATE TABLE NULLID.TBPOWER ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "NIANJIID" INTEGER , "BANJIID" INTEGER , "POWER" VARCHAR (250) , "ISDEL" INTEGER , "YKRS" INTEGER , "ZCRS" INTEGER , "JGRS" INTEGER , "PJF" INTEGER , "PASSL" INTEGER ,  PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
----------(17)TBPOWER


----------(18)TBQUEUE
CREATE TABLE NULLID.TBQUEUE ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "TIM" TIMESTAMP , "ISOK" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
----------(18)TBQUEUE


----------(19)TBREAD
CREATE TABLE NULLID.TBREAD ("NOID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "TMID" INTEGER , "XIAOTI" LONG VARCHAR , "READANS" LONG VARCHAR , "ZHU" LONG VARCHAR , "SLEVEL" INTEGER , "A" LONG VARCHAR , "B" LONG VARCHAR , "C" LONG VARCHAR , "D" LONG VARCHAR, "E" LONG VARCHAR , "F" LONG VARCHAR , "READNO" INTEGER , "XIAOLEI" INTEGER ,"POINTID" INTEGER ,  PRIMARY KEY (NOID)  )  DATA CAPTURE NONE   IN USERSPACE1;
----------(19)TBREAD


--------(20)TBSCORE
CREATE TABLE NULLID.TBSCORE ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "KCID" INTEGER , "PAPERNO" INTEGER , "LASTTIME" INTEGER , "NUM" INTEGER , "EXAMTIME" INTEGER , "ISEXAM" INTEGER , "ISDEL" INTEGER , "ISPASS" INTEGER , "MAXSCORE" DOUBLE,PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
--------(20)TBSCORE


-------(21)TBSELECTPAPER
CREATE TABLE NULLID.TBSELECTPAPER ("NOID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "TMID" INTEGER , "ANS" LONG VARCHAR , "ISREAD" INTEGER , "PAPERNO" INTEGER , "CATEGORY" INTEGER , "CHAPTER" INTEGER , "KCID" INTEGER , "ISDEL" INTEGER , PRIMARY KEY (NOID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-------(21)TBSELECTPAPER


-----------(22)TBTK
CREATE TABLE NULLID.TBTK ("TMID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "TITLE" LONG VARCHAR , "A" LONG VARCHAR , "B" LONG VARCHAR , "C" LONG VARCHAR , "D" LONG VARCHAR , "E" LONG VARCHAR , "F" LONG VARCHAR , "ANS" LONG VARCHAR , "CHAPTER" INTEGER , "CATEGORY" INTEGER , "FLEVEL" INTEGER , "KCID" INTEGER , "KAO" INTEGER , "ZHU" LONG VARCHAR , "ISREAD" INTEGER , "ISDEL" INTEGER ,"POINTID" INTEGER ,  PRIMARY KEY (TMID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-----------(22)TBTK


-----------(23)TBTONGJI
CREATE TABLE NULLID.TBTONGJI ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "PAGENAME" VARCHAR (100) , "NUM" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
-----------(23)TBTONGJI


----------(24)TBUSER
CREATE TABLE NULLID.TBUSER ("USERID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERNAME" VARCHAR (50) , "TNAME" VARCHAR (50) , "PWD" VARCHAR (50) , "EMAIL" VARCHAR (100) , "NIANJINO" INTEGER , "BANJINO" INTEGER , "ISOPEN" INTEGER , "TIM" TIMESTAMP , "SEX" INTEGER , "ISCREATE" INTEGER , "USERKC" VARCHAR (250) , "ISKC" INTEGER , "IP" VARCHAR (50) , "ISDEL" INTEGER , "AGE" INTEGER , "ZHIWUID" INTEGER , "ZHIJIID" INTEGER , "KSNO" INTEGER , "JSNO" INTEGER , "LXNO" INTEGER , "ZNO" INTEGER , "KSFEN" DOUBLE, "JSFEN" DOUBLE, "LXFEN" DOUBLE, "ZFEN" DOUBLE, "KAONUM" INTEGER , "JSNUM" INTEGER , "LXNUM" INTEGER , "ZNUM" INTEGER , "SFZH" VARCHAR (50) , "UPHOTO" VARCHAR (200) , PRIMARY KEY (USERID)  )  DATA CAPTURE NONE   IN USERSPACE1;
----------(24)TBUSER


------------(25)USERDATA
CREATE TABLE NULLID.USERDATA ("DATAID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "TMID" INTEGER , "ANS" LONG VARCHAR , "UANS" LONG VARCHAR , "FEN" DOUBLE , "PAPERNO" INTEGER , "ISREAD" INTEGER , "KSNUM" INTEGER , "NOTE" LONG VARCHAR , "ISDEL" INTEGER , "PY" LONG VARCHAR, PRIMARY KEY (DATAID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(25)USERDATA


------------(26)USERDATAREAD
CREATE TABLE NULLID.USERDATAREAD ("READID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "DATAID" INTEGER , "TMID" INTEGER , "NOID" INTEGER , "PAPERNO" INTEGER , "RANS" LONG VARCHAR , "RUANS" LONG VARCHAR , "FEN" DOUBLE , "READNO" INTEGER , "KSNUM" INTEGER , "NOTE" LONG VARCHAR , "PY" LONG VARCHAR , PRIMARY KEY (READID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(26)USERDATAREAD


--------------(27)VOTE
CREATE TABLE NULLID.VOTE ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "VID" INTEGER , "VTYPE" INTEGER , "VNAME" VARCHAR (50) , "HITS" INTEGER , "ISOPEN" INTEGER , "LEI" INTEGER , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
--------------(27)VOTE


------------(28)TBSPEED
CREATE TABLE NULLID.TBSPEED ("ID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "USERID" INTEGER , "TMID" INTEGER , "TIM" DOUBLE  , PRIMARY KEY (ID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(28)TBSPEED


------------(29)TBZHIWU
CREATE TABLE NULLID.TBZHIWU ("ZHIWUID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "ZHIWU" VARCHAR (50), "ZWORD" INTEGER , PRIMARY KEY (ZHIWUID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(29)TBZHIWU


------------(30)TBZHIJI
CREATE TABLE NULLID.TBZHIJI ("ZHIJIID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "ZHIJI" VARCHAR (50), "ZJORD" INTEGER , PRIMARY KEY (ZHIJIID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(30)TBZHIJI

------------(31)TBPOINT 
CREATE TABLE NULLID.TBPOINT ("POINTID" INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , "POINTNAME" VARCHAR (150),"PARENTID" INTEGER , "PARENTPATH" VARCHAR (100),"DEPTH" INTEGER , "ROOTID" INTEGER, "CHILD" INTEGER, "PREVID" INTEGER, "NEXTID" INTEGER, "ORDERID" INTEGER, "POINTLEVEL" INTEGER, "CHAPTERID" INTEGER, "KCID" INTEGER,PRIMARY KEY (POINTID)  )  DATA CAPTURE NONE   IN USERSPACE1;
------------(31)TBPOINT 

-------------数据库初始化
insert into  nullid.tbadmin(username,pwd,email,tname,syspower,tim,sex,kcpower) values('admin','21232f297a57a5a743894a0e4a801fc3','[e-mail]','最高管理员','-1','2003-10-18 0:08:41',0,'0') ;

insert into nullid.tbconfig(logo,logolink,title,happysoft,islogin,refreshtime,islook,ischeck,ispower,isupload,issametime,upfiletype,maxfilesize,verno,isemail,isuserorder,orderlen,iszhiji,chmodel,issameip,gongsi,wangzhi , isphoto,pwidth,pheight,issfzh,subjectnum,tmnum,longhnum,isshowpoint,isshowlongh,isnianjiview,isopenforum,isfirsttim,issecondtim) values('images/logo.jpg','kaoshiindex.asp','NeoExam考试系统','b2bsoft',1,150,1,1,1,1,0,'rar|gif|jpg|bmp|swf|zip|doc|xls|ppt',1024,'1.0.3',1,0,7,0,'1 ,2 ,3',0,'成都祥和源','http://www.b6.cn', 0,120,180,0,5,10,10,0,0,0,1,1,30);

 
insert into  nullid.tbtongji(pagename,num) values('index',100);
-------------数据库初始化