oracle表文件脚本.txt

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

------(1)TBADMIN

CREATE TABLE SYSTEM.TBADMIN ("ADMINID" NUMBER(10)  NOT NULL  , "USERNAME"  VARCHAR2(50) , "PWD"  VARCHAR2(50) , "EMAIL"  VARCHAR2(100) , "TNAME"  VARCHAR2(50) , "SYSPOWER"  VARCHAR2(10) , "TIM"  DATE , "SEX"  VARCHAR2(10) , "KCPOWER"  VARCHAR2(250) ,  PRIMARY KEY (ADMINID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBADMIN INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBADMIN 
BEFORE INSERT ON SYSTEM.TBADMIN
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBADMIN.NEXTVAL INTO :NEW.ADMINID FROM DUAL;
END;
------(1)TBADMIN


------(2)TBBANJI
CREATE TABLE SYSTEM.TBBANJI ("BANJIID" NUMBER(10)  NOT NULL, "BANJI" VARCHAR2 (100) , "BANJINO" VARCHAR2 (50) , "BANORD" NUMBER(10),  PRIMARY KEY (BANJIID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBBANJI INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBBANJI 
BEFORE INSERT ON SYSTEM.TBBANJI
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBBANJI.NEXTVAL INTO :NEW.BANJIID FROM DUAL;
END;
------(2)TBBANJI


------(3)TBBIJI
CREATE TABLE SYSTEM.TBBIJI ("BJID" NUMBER(10)  NOT NULL  , "BJCONTENT" NCLOB, "BJTIM" DATE, "USERID" NUMBER(10), PRIMARY KEY (BJID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBBIJI INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBBIJI 
BEFORE INSERT ON SYSTEM.TBBIJI
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBBIJI.NEXTVAL INTO :NEW.BJID FROM DUAL;
END;
------(3)TBBIJI


----------(4)TBCAT
CREATE TABLE SYSTEM.TBCAT ("ID" NUMBER(10)  NOT NULL  , "CNAME" VARCHAR2 (150) , "CNO" NUMBER(10), "ISOPEN" NUMBER(10), "KCID" NUMBER(10), PRIMARY KEY (ID) ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBCAT INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBCAT 
BEFORE INSERT ON SYSTEM.TBCAT
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBCAT.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
----------(4)TBCAT


--------(5)TBCHAPTER
CREATE TABLE SYSTEM.TBCHAPTER ("ID"  NUMBER(10)  NOT NULL  , "KCID" NUMBER(10), "CHAPTER" NUMBER(10), "SDATE" DATE, "EDATE" DATE, "TESTOPEN" NUMBER(10), "ISDEL" NUMBER(10), "CHTITLE" VARCHAR2 (150) ,PRIMARY KEY (ID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBCHAPTER INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBCHAPTER 
BEFORE INSERT ON SYSTEM.TBCHAPTER
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBCHAPTER.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
--------(5)TBCHAPTER


------(6)TBCHART
CREATE TABLE SYSTEM.TBCHART ("ID" NUMBER(10)  NOT NULL  , "X" NUMBER(10) , "Y" NUMBER(10), "PAPERNO" NUMBER(10), PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBCHART INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBCHART 
BEFORE INSERT ON SYSTEM.TBCHART
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBCHART.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
------(6)TBCHART


---------(7)TBCONFIG
CREATE TABLE SYSTEM.TBCONFIG ("ID" NUMBER(10)  NOT NULL , "LOGO" VARCHAR2 (200) , "LOGOLINK" VARCHAR2 (200) , "TITLE" VARCHAR2 (200) , "HAPPYSOFT" VARCHAR2 (100) , "ISLOGIN" NUMBER(10), "REFRESHTIME" NUMBER(10), "ISLOOK" NUMBER(10), "ISCHECK" NUMBER(10), "ISPOWER" NUMBER(10), "ISUPLOAD" NUMBER(10), "ISSAMETIME" NUMBER(10), "UPFILETYPE" VARCHAR2 (250), "MAXFILESIZE" NUMBER(10), "VERNO" VARCHAR2 (50), "ISEMAIL" NUMBER(10), "ISUSERORDER" NUMBER(10), "ORDERLEN" NUMBER(10), "ISZHIJI" NUMBER(10), "CHMODEL" VARCHAR2 (50), "ISSAMEIP" NUMBER(10), "GONGSI" VARCHAR2 (100), "WANGZHI" VARCHAR2 (100), "ISPHOTO" NUMBER(10), "PWIDTH" NUMBER(10), "PHEIGHT" NUMBER(10), "ISSFZH" NUMBER(10), "SUBJECTNUM" NUMBER(10), "TMNUM" NUMBER(10), "LONGHNUM" NUMBER(10), "ISSHOWPOINT" NUMBER(10), "ISSHOWLONGH" NUMBER(10), "ISNIANJIVIEW" NUMBER(10), "ISOPENFORUM" NUMBER(10), "ISFIRSTTIM" NUMBER(10), "ISSECONDTIM" NUMBER(10),PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBCONFIG INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBCONFIG 
BEFORE INSERT ON SYSTEM.TBCONFIG
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBCONFIG.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
---------(7)TBCONFIG


--------(8)TBFORUM
CREATE TABLE  SYSTEM.TBFORUM ("FORUMID" NUMBER(10)  NOT NULL  , "REPLYID" NUMBER(10), "USERNAME" VARCHAR2 (50) , "TOPIC" VARCHAR2 (50) , "WORD" NCLOB, "ICON" NUMBER(10), "TIM" DATE, "HITS" NUMBER(10), "LASTNAME" VARCHAR2 (50) , "LASTTIME" DATE, "IP" VARCHAR2 (50) , "OS" VARCHAR2 (150) , PRIMARY KEY (FORUMID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBFORUM INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBFORUM 
BEFORE INSERT ON SYSTEM.TBFORUM
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBFORUM.NEXTVAL INTO :NEW.FORUMID FROM DUAL;
END;
--------(8)TBFORUM


--------(9)TBISTEST
CREATE TABLE SYSTEM.TBISTEST ("ID" NUMBER(10)  NOT NULL  , "USERID" NUMBER(10), "KCID" NUMBER(10), "KAO" NUMBER(10), "ISTEST" NUMBER(10), "CHAPTER" NUMBER(10), "ISDEL" NUMBER(10), PRIMARY KEY (ID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBISTEST INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBISTEST 
BEFORE INSERT ON SYSTEM.TBISTEST
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBISTEST.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
--------(9)TBISTEST


-----------(10)TBKC
CREATE TABLE SYSTEM.TBKC ("KCID" NUMBER(10)  NOT NULL  , "KCM" VARCHAR2 (100) , "ISOPEN" NUMBER(10) , "ISSHARE" NUMBER(10) , "KCORD" NUMBER(10) ,PRIMARY KEY (KCID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBKC INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBKC 
BEFORE INSERT ON SYSTEM.TBKC
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBKC.NEXTVAL INTO :NEW.KCID FROM DUAL;
END;
-----------(10)TBKC


------------(11)TBKCCONFIG
CREATE TABLE  SYSTEM.TBKCCONFIG ("ID" NUMBER(10)  NOT NULL  , "KCID" NUMBER(10), "CATEGORY" NUMBER(10), "DATANO" NUMBER(10), "DATAVALUE" FLOAT(10), "PAPERNO" NUMBER(10), "ORDERNO" NUMBER(10), PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBKCCONFIG INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBKCCONFIG 
BEFORE INSERT ON SYSTEM.TBKCCONFIG
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBKCCONFIG.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
------------(11)TBKCCONFIG


-----------(12)TBKSDATA
CREATE TABLE SYSTEM.TBKSDATA ("ID" NUMBER(10)  NOT NULL  , "USERID" NUMBER(10), "PAPERNO" NUMBER(10), "SCORE" FLOAT(10), "ISEXAM" NUMBER(10), "ISADMIN" NUMBER(10), "STIME" DATE, "ETIME" DATE, "KSNUM" NUMBER(10), "ISSCAN" NUMBER(10), "ISCREATE" NUMBER(10), "PINGYU" NCLOB, "IP" VARCHAR2 (50) , "ISDEL" NUMBER(10), PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBKSDATA INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBKSDATA 
BEFORE INSERT ON SYSTEM.TBKSDATA
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBKSDATA.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
-----------(12)TBKSDATA


-----------(13)TBLOGIN
CREATE TABLE SYSTEM.TBLOGIN ("LOGINID" NUMBER(10) NOT NULL  , "USERID" NUMBER(10), "LTIM" DATE, "IP" VARCHAR2 (50) , PRIMARY KEY (LOGINID)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBLOGIN INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBLOGIN 
BEFORE INSERT ON SYSTEM.TBLOGIN
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBLOGIN.NEXTVAL INTO :NEW.LOGINID FROM DUAL;
END;
-----------(13)TBLOGIN


--------(14)TBNEWS
CREATE TABLE SYSTEM.TBNEWS ("ID" NUMBER(10)  NOT NULL  , "TITLE" VARCHAR2 (100) , "CONTENT" NCLOB, "FABSJ" DATE, "ADMINNAME" VARCHAR2 (50) , PRIMARY KEY (ID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBNEWS INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBNEWS 
BEFORE INSERT ON SYSTEM.TBNEWS
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBNEWS.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
--------(14)TBNEWS


-------(15)TBNIANJI
CREATE TABLE SYSTEM.TBNIANJI ("NIANJIID" NUMBER(10)  NOT NULL, "NIANJI" VARCHAR2 (100) , "NIANJINO" VARCHAR2 (50) , "NIANORD" NUMBER(10),  PRIMARY KEY (NIANJIID)  )  ;
CREATE SEQUENCE SYSTEM.SEQ_TBNIANJI INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBNIANJI 
BEFORE INSERT ON SYSTEM.TBNIANJI
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBNIANJI.NEXTVAL INTO :NEW.NIANJIID FROM DUAL;
END;
-------(15)TBNIANJI


-------(16)TBPAPER
CREATE TABLE  SYSTEM.TBPAPER ("PAPERNO" NUMBER(10)  NOT NULL  , "KCID" NUMBER(10), "INFO" VARCHAR2 (100) , "SCHAP" NUMBER(10), "ECHAP" NUMBER(10), "PAPERDATETIME" NUMBER(10), "STIME" DATE, "ETIME" DATE, "ISOPEN" NUMBER(10), "ISCHOOSE" NUMBER(10), "ADMINNAME" VARCHAR2 (50) , "ISSHOW" NUMBER(10), "ISLOOK" NUMBER(10), "EXAMTIME" NUMBER(10), "NANDU" NUMBER(10), "ISKAO" NUMBER(10), "ISCONN" NUMBER(10), "GGID" VARCHAR2 (250) , "TEA_USER" NUMBER(10), "ISDEL" NUMBER(10), "SAVEWAY" NUMBER(10), "PASS" FLOAT(10), "ISPOINT" NUMBER(10),PRIMARY KEY (PAPERNO)  ) ;
CREATE SEQUENCE SYSTEM.SEQ_TBPAPER INCREMENT BY 1 START WITH 1  MAXVALUE 1.0E28 MINVALUE 1  NOCYCLE  NOCACHE NOORDER;
CREATE OR REPLACE TRIGGER SYSTEM.TRG_TBPAPER 
BEFORE INSERT ON SYSTEM.TBPAPER
    FOR EACH ROW 
BEGIN
        SELECT SYSTEM.SEQ_TBPAPER.NEXTVAL INTO :NEW.PAPERNO FROM DUAL;
END;
-------(16)TBPAPER