aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/lite.sql2
-rw-r--r--sql/mysql.sql2
-rw-r--r--sql/pg.sql2
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()
);