?? offlog.db
字號:
------------------------------------------------
-- 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;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -