offlog.db

来自「java数据库开发范例」· DB 代码 · 共 86 行

------------------------------------------------
-- DDL Statements for table "USERS"
------------------------------------------------

 CREATE TABLE "USERS"  (
                  "ID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ) ,
                  "USERNAME" VARCHAR(20) ,
                  "PASSWORD" VARCHAR(20) ,
                  "TRUENAME" VARCHAR(20) ,
                  "FLAG" SMALLINT ,
                  "PARTID" INTEGER ) ;


------------------------------------------------
-- DDL Statements for table "COMPANY"
------------------------------------------------

 CREATE TABLE "COMPANY"  (
                  "COMPANYID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ) ,
                  "CONTENT" VARCHAR(1000) ,
                  "CONTENT2" VARCHAR(200) ,
                  "TITLE" VARCHAR(100) ,
                  "HITS" INTEGER ,
                  "DATEANDTIME" TIMESTAMP ,
                  "AUTHORID" INTEGER ,
                  "WRITER" VARCHAR(20) ,
                  "WRITEFROM" VARCHAR(100) ,
                  "STATE" VARCHAR(10) ) ;


------------------------------------------------
-- DDL Statements for table "PART"
------------------------------------------------

 CREATE TABLE "PART"  (
                  "PARTID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ) ,
                  "PARTNAME" VARCHAR(20) ) ;


------------------------------------------------
-- DDL Statements for table "JOB"
------------------------------------------------

 CREATE TABLE "JOB"  (
                  "JOBID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ) ,
                  "JOBCONTENT" VARCHAR(1000) ,
                  "W" SMALLINT ,
                  "D" SMALLINT ,
                  "M" SMALLINT ,
                  "Y" SMALLINT ,
                  "DATEANDTIME" TIMESTAMP ,
                  "WRITER" VARCHAR(20) ) ;


------------------------------------------------
-- DDL Statements for table "OWN"
------------------------------------------------

 CREATE TABLE "OWN"  (
                  "OWNID" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ) ,
                  "SUMCONTENT" VARCHAR(1000) ,
                  "PLANCONTENT" VARCHAR(1000) ,
                  "REPLY1" VARCHAR(200) ,
                  "REPLY2" VARCHAR(200) ,
                  "TITLE" VARCHAR(100) ,
                  "PARTNAME" VARCHAR(20) ,
                  "PARTID" INTEGER ,
                  "FLAG" SMALLINT ,
                  "AUTHOR" VARCHAR(20) ,
                  "USER" VARCHAR(20) ,
                  "USERID" INTEGER ,
                  "DATEANDTIME" TIMESTAMP ,
                  "STATE" VARCHAR(10) ,
                  "USERNAME" VARCHAR(20) ) ;









COMMIT WORK;