oracle表文件脚本.txt

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

----------(17)TBPOWER
CREATE TABLE SYSTEM.TBPOWER ("ID" NUMBER(10)  NOT NULL, "NIANJIID" NUMBER(10), "BANJIID" NUMBER(10), "POWER" VARCHAR2 (250) , "ISDEL" NUMBER(10), "YKRS" NUMBER(10), "ZCRS" NUMBER(10), "JGRS" NUMBER(10), "PJF" NUMBER(10), "PASSL" NUMBER(10),PRIMARY KEY (ID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBPOWER INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBPOWER 
BEFORE INSERT ON SYSTEM.TBPOWER
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBPOWER.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
----------(17)TBPOWER


----------(18)TBQUEUE
CREATE TABLE SYSTEM.TBQUEUE ("ID" NUMBER(10)  NOT NULL , "USERID" NUMBER(10), "TIM" DATE, "ISOK" NUMBER(10), PRIMARY KEY (ID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBQUEUE INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBQUEUE 
BEFORE INSERT ON SYSTEM.TBQUEUE
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBQUEUE.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
----------(18)TBQUEUE


----------(19)TBREAD
CREATE TABLE  SYSTEM.TBREAD ("NOID" NUMBER(10)  NOT NULL  , "TMID" NUMBER(10), "XIAOTI" NCLOB, "READANS" NCLOB, "ZHU" NCLOB, "SLEVEL" NUMBER(10), "A" NCLOB, "B" NCLOB, "C" NCLOB, "D" NCLOB, "E" NCLOB, "F" NCLOB, "READNO" NUMBER(10), "XIAOLEI" NUMBER(10), "POINTID" NUMBER(10), PRIMARY KEY (NOID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBREAD INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBREAD 
BEFORE INSERT ON SYSTEM.TBREAD
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBREAD.NEXTVAL INTO :NEW.NOID FROM DUAL;
END;
----------(19)TBREAD


--------(20)TBSCORE
CREATE TABLE SYSTEM.TBSCORE ("ID" NUMBER(10)  NOT NULL  , "USERID" NUMBER(10), "KCID" NUMBER(10), "PAPERNO" NUMBER(10), "LASTTIME" NUMBER(10), "NUM" NUMBER(10), "EXAMTIME" NUMBER(10), "ISEXAM" NUMBER(10), "ISDEL" NUMBER(10), "ISPASS" NUMBER(10), "MAXSCORE" FLOAT(10), PRIMARY KEY (ID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBSCORE INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBSCORE 
BEFORE INSERT ON SYSTEM.TBSCORE
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBSCORE.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
--------(20)TBSCORE


-------(21)TBSELECTPAPER
CREATE TABLE SYSTEM.TBSELECTPAPER ("NOID" NUMBER(10)  NOT NULL  , "TMID" NUMBER(10), "ANS" NCLOB , "ISREAD" NUMBER(10), "PAPERNO" NUMBER(10), "CATEGORY" NUMBER(10), "CHAPTER" NUMBER(10), "KCID" NUMBER(10), "ISDEL" NUMBER(10), PRIMARY KEY (NOID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBSELECTPAPER INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBSELECTPAPER 
BEFORE INSERT ON SYSTEM.TBSELECTPAPER
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBSELECTPAPER.NEXTVAL INTO :NEW.NOID FROM DUAL;
END;
-------(21)TBSELECTPAPER


-----------(22)TBTK
CREATE TABLE  SYSTEM.TBTK ("TMID" NUMBER(10)  NOT NULL, "TITLE" NCLOB , "A" NCLOB , "B" NCLOB , "C" NCLOB , "D" NCLOB , "E" NCLOB, "F" NCLOB, "ANS" NCLOB , "CHAPTER" NUMBER(10), "CATEGORY" NUMBER(10), "FLEVEL" NUMBER(10), "KCID" NUMBER(10), "KAO" NUMBER(10), "ZHU" NCLOB , "ISREAD" NUMBER(10), "ISDEL" NUMBER(10), "POINTID" NUMBER(10),PRIMARY KEY (TMID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBTK INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBTK 
BEFORE INSERT ON SYSTEM.TBTK
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBTK.NEXTVAL INTO :NEW.TMID FROM DUAL;
END;
-----------(22)TBTK


-----------(23)TBTONGJI
CREATE TABLE  SYSTEM.TBTONGJI ("ID" NUMBER(10)  NOT NULL  , "PAGENAME" VARCHAR2 (100) , "NUM" NUMBER(10), PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBTONGJI INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBTONGJI 
BEFORE INSERT ON SYSTEM.TBTONGJI
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBTONGJI.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
-----------(23)TBTONGJI


----------(24)TBUSER
CREATE TABLE  SYSTEM.TBUSER ("USERID" NUMBER(10)  NOT NULL   , "USERNAME" VARCHAR2 (50) , "TNAME" VARCHAR2 (50) , "PWD" VARCHAR2 (50) , "EMAIL" VARCHAR2 (100) , "NIANJINO" NUMBER(10), "BANJINO" NUMBER(10), "ISOPEN" NUMBER(10), "TIM" DATE, "SEX" NUMBER(10), "ISCREATE" NUMBER(10), "USERKC" VARCHAR2 (250) , "ISKC" NUMBER(10), "IP" VARCHAR2 (50) , "ISDEL" NUMBER(10), "AGE" NUMBER(10), "ZHIWUID" NUMBER(10), "ZHIJIID" NUMBER(10), "KSNO" NUMBER(10), "JSNO" NUMBER(10), "LXNO" NUMBER(10), "ZNO" NUMBER(10), "KSFEN" FLOAT(10), "JSFEN" FLOAT(10), "LXFEN" FLOAT(10), "ZFEN" FLOAT(10), "KAONUM" NUMBER(10), "JSNUM" NUMBER(10), "LXNUM" NUMBER(10), "ZNUM" NUMBER(10),  "SFZH" VARCHAR2 (50) , "UPHOTO" VARCHAR2 (200) , PRIMARY KEY (USERID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBUSER INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBUSER 
BEFORE INSERT ON SYSTEM.TBUSER
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBUSER.NEXTVAL INTO :NEW.USERID FROM DUAL;
END;
----------(24)TBUSER


------------(25)USERDATA
CREATE TABLE  SYSTEM.USERDATA ("DATAID" NUMBER(10)  NOT NULL  , "USERID" NUMBER(10), "TMID" NUMBER(10), "ANS" NCLOB , "UANS" NCLOB , "FEN" FLOAT(10), "PAPERNO" NUMBER(10), "ISREAD" NUMBER(10), "KSNUM" NUMBER(10), "NOTE" NCLOB , "ISDEL" NUMBER(10), "PY" NCLOB , PRIMARY KEY (DATAID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_USERDATA INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_USERDATA 
BEFORE INSERT ON SYSTEM.USERDATA
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_USERDATA.NEXTVAL INTO :NEW.DATAID FROM DUAL;
END;
------------(25)USERDATA


------------(26)USERDATAREAD
CREATE TABLE SYSTEM.USERDATAREAD ("READID" NUMBER(10)  NOT NULL  , "USERID" NUMBER(10), "DATAID" NUMBER(10), "TMID" NUMBER(10), "NOID" NUMBER(10), "PAPERNO" NUMBER(10), "RANS" NCLOB , "RUANS" NCLOB , "FEN" FLOAT(10), "READNO" NUMBER(10), "KSNUM" NUMBER(10), "NOTE" NCLOB , "PY" NCLOB ,PRIMARY KEY (READID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_USERDATAREAD INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_USERDATAREAD
BEFORE INSERT ON SYSTEM.USERDATAREAD
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_USERDATAREAD.NEXTVAL INTO :NEW.READID FROM DUAL;
END;
------------(26)USERDATAREAD


--------------(27)VOTE
CREATE TABLE SYSTEM.VOTE ("ID" NUMBER(10)  NOT NULL  , "VID" NUMBER(10), "VTYPE" NUMBER(10), "VNAME" VARCHAR2 (50) , "HITS" NUMBER(10), "ISOPEN" NUMBER(10), "LEI" NUMBER(10), PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_VOTE INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_VOTE 
BEFORE INSERT ON SYSTEM.VOTE
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_VOTE.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
--------------(27)VOTE


------------(28)TBSPEED
CREATE TABLE SYSTEM.TBSPEED ("ID" NUMBER(10)  NOT NULL   , "USERID" NUMBER(10), "TMID" NUMBER(10), "TIM" FLOAT(10), PRIMARY KEY (ID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBSPEED INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBSPEED 
BEFORE INSERT ON SYSTEM.TBSPEED
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBSPEED.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
------------(28)TBSPEED


------------(29)TBZHIWU
CREATE TABLE SYSTEM.TBZHIWU ("ZHIWUID" NUMBER(10)  NOT NULL   , "ZHIWU" VARCHAR2 (50), "ZWORD" NUMBER(10), PRIMARY KEY (ZHIWUID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBZHIWU INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBZHIWU 
BEFORE INSERT ON SYSTEM.TBZHIWU
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBZHIWU.NEXTVAL INTO :NEW.ZHIWUID FROM DUAL;
END;
------------(29)TBZHIWU


------------(30)TBZHIJI
CREATE TABLE SYSTEM.TBZHIJI ("ZHIJIID" NUMBER(10)  NOT NULL   , "ZHIJI" VARCHAR2 (50), "ZJORD" NUMBER(10), PRIMARY KEY (ZHIJIID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBZHIJI INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBZHIJI 
BEFORE INSERT ON SYSTEM.TBZHIJI
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBZHIJI.NEXTVAL INTO :NEW.ZHIJIID FROM DUAL;
END;
------------(30)TBZHIJI


------------(31)TBPOINT
CREATE TABLE SYSTEM.TBPOINT ("POINTID" NUMBER(10)  NOT NULL   , "POINTNAME" VARCHAR2 (150), "PARENTID" NUMBER(10), "PARENTPATH" VARCHAR2 (150), "DEPTH" NUMBER(10), "ROOTID" NUMBER(10), "CHILD" NUMBER(10), "PREVID" NUMBER(10), "NEXTID" NUMBER(10), "ORDERID" NUMBER(10), "POINTLEVEL" NUMBER(10), "CHAPTERID" NUMBER(10), "KCID" NUMBER(10), PRIMARY KEY (POINTID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBPOINT INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBPOINT 
BEFORE INSERT ON SYSTEM.TBPOINT
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBPOINT.NEXTVAL INTO :NEW.POINTID FROM DUAL;
END;
------------(31)TBPOINT


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


insert into system.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  system.tbtongji(pagename,num)  values('index',100); 
commit;
-------------数据库初始化