diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/lite.sql | 2 | ||||
-rw-r--r-- | sql/mysql.sql | 2 | ||||
-rw-r--r-- | sql/pg.sql | 2 |
3 files changed, 6 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql index 461686d1a..89d68eadd 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -279,6 +279,8 @@ CREATE TABLE archive ( xml text NOT NULL, txt text, id INTEGER PRIMARY KEY AUTOINCREMENT, + kind text, + nick text, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ); diff --git a/sql/mysql.sql b/sql/mysql.sql index fab76b9a2..21e7b9b52 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -93,6 +93,8 @@ CREATE TABLE archive ( xml text NOT NULL, txt text, id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, + kind varchar(10), + nick varchar(250), created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8; diff --git a/sql/pg.sql b/sql/pg.sql index 2a052d337..099356917 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -93,6 +93,8 @@ CREATE TABLE archive ( xml text NOT NULL, txt text, id SERIAL, + kind text, + nick text, created_at TIMESTAMP NOT NULL DEFAULT now() ); |