X-Git-Url: http://git.hcoop.net/hcoop/portal.git/blobdiff_plain/a4adbfb9bd12654f046bcf0289c88a97b005b92d..6704531cef294b64abf3ccef2817dc83be93af23:/tables.sql

diff --git a/tables.sql b/tables.sql
index 56a68ed..8ff5251 100644
--- a/tables.sql
+++ b/tables.sql
@@ -342,7 +342,18 @@ CREATE TABLE Cert(
 	status INTEGER NOT NULL,
 	stamp TIMESTAMP NOT NULL,
 	cstamp TIMESTAMP,
-	FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
-	FOREIGN KEY (node) REFERENCES WebNode(id) ON DELETE CASCADE);
+	FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
 
 CREATE SEQUENCE CertSeq START 1;
+
+CREATE TABLE Quota(
+	id INTEGER PRIMARY KEY,
+	usr INTEGER NOT NULL,
+	data TEXT NOT NULL,
+	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 QuotaSeq START 1;