priv BOOLEAN NOT NULL,
status INTEGER NOT NULL,
stamp TIMESTAMP NOT NULL,
+ pstamp TIMESTAMP,
+ cstamp TIMESTAMP,
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
FOREIGN KEY (cat) REFERENCES SupCategory(id) ON DELETE CASCADE);
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
FOREIGN KEY (cat) REFERENCES SupCategory(id) ON DELETE CASCADE);
+CREATE TABLE WebNode(
+ id INTEGER PRIMARY KEY,
+ name TEXT NOT NULL,
+ descr TEXT NOT NULL,
+ debian TEXT NOT NULL);
+
+INSERT INTO WebNode (id, name, descr, debian)
+ VALUES (0, 'fyodor', 'old server', 'testing');
+INSERT INTO WebNode (id, name, descr, debian)
+ VALUES (1, 'deleuze', 'main server', 'stable');
+INSERT INTO WebNode (id, name, descr, debian)
+ VALUES (2, 'mire', 'member web server', 'stable');
+
CREATE TABLE Apt(
id INTEGER PRIMARY KEY,
usr INTEGER NOT NULL,
+ node INTEGER NOT NULL,
data TEXT NOT NULL,
msg TEXT NOT NULL,
status INTEGER NOT NULL,
stamp TIMESTAMP NOT NULL,
- FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
+ cstamp TIMESTAMP,
+ FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
+ FOREIGN KEY (node) REFERENCES WebNode(id) ON DELETE CASCADE);
CREATE SEQUENCE AptSeq START 1;
msg TEXT NOT NULL,
status INTEGER NOT NULL,
stamp TIMESTAMP NOT NULL,
+ cstamp TIMESTAMP,
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
CREATE SEQUENCE DomainSeq START 1;
msg TEXT NOT NULL,
status INTEGER NOT NULL,
stamp TIMESTAMP NOT NULL,
+ cstamp TIMESTAMP,
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
CREATE SEQUENCE MailingListSeq START 1;
CREATE TABLE Sec(
id INTEGER PRIMARY KEY,
usr INTEGER NOT NULL,
+ node INTEGER NOT NULL,
data TEXT NOT NULL,
msg TEXT NOT NULL,
status INTEGER NOT NULL,
stamp TIMESTAMP NOT NULL,
- FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
+ cstamp TIMESTAMP,
+ FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
+ FOREIGN KEY (node) REFERENCES WebNode(id) ON DELETE CASCADE);
CREATE SEQUENCE SecSeq START 1;