?? db - postgresql.sql
字號:
DROP TABLE Item;
DROP TABLE Report;
DROP TABLE NextID;
CREATE TABLE Report (
ID INT PRIMARY KEY,
RVersion VARCHAR(255),
RHost VARCHAR(255),
RHostComment VARCHAR(255),
RUser VARCHAR(255),
RLocation VARCHAR(255),
RDateTime VARCHAR(16),
RComplete SMALLINT
);
CREATE TABLE Item (
INum INT,
IPage VARCHAR(100),
IDevice VARCHAR(255),
IGroup VARCHAR(255),
IField VARCHAR(255),
IValue VARCHAR(255),
IIcon INT,
IID INT,
ReportID INT NOT NULL,
CONSTRAINT cnstI1 FOREIGN KEY(ReportID) REFERENCES Report(ID)
);
CREATE TABLE NextID (
TableName VARCHAR(6) PRIMARY KEY,
NextID INT NOT NULL
);
INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -