diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-02 15:21:54 +1000 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-02 15:21:54 +1000 |
| commit | ca5f028016078244853456cbfdd9bd35b794432a (patch) | |
| tree | 80b078bcf5909f2e38515ef082437e40feb517a3 /src/odbc/mysql.sql | |
| parent | ODBC support for mod_announce (diff) | |
ODBC support for mod_vcard_xupdate
Diffstat (limited to 'src/odbc/mysql.sql')
| -rw-r--r-- | src/odbc/mysql.sql | 5 |
1 files changed, 5 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, |