diff options
Diffstat (limited to 'src/odbc')
-rw-r--r-- | src/odbc/mysql.sql | 5 | ||||
-rw-r--r-- | src/odbc/pg.sql | 6 |
2 files changed, 11 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index 104b44481..ecb2b08e9 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -76,6 +76,11 @@ CREATE TABLE vcard ( created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) CHARACTER SET utf8; +CREATE TABLE vcard_xupdate ( + username varchar(250) PRIMARY KEY, + hash text NOT NULL, + created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP +) CHARACTER SET utf8; CREATE TABLE vcard_search ( username varchar(250) NOT NULL, diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index f28cf8af2..30ea19ca5 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -74,6 +74,12 @@ CREATE TABLE vcard ( created_at TIMESTAMP NOT NULL DEFAULT now() ); +CREATE TABLE vcard_xupdate ( + username text PRIMARY KEY, + hash text NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT now() +); + CREATE TABLE vcard_search ( username text NOT NULL, lusername text PRIMARY KEY, |