diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2015-08-06 13:33:39 +0300 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2015-08-08 22:15:36 +0300 |
| commit | 40feed723d3b651ff19fdcd7fb31b1c3bad24943 (patch) | |
| tree | a605fecc6df97ee70e30eca79715bf1bbc0abcca /sql | |
| parent | Handle merging of append_host_config as is done for host_config (diff) | |
Add support for MUC MAM
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() ); |