Mercurial > prosody-wiki
changeset 351:817e175c37df
Fix the suggested mysql schema
author | Kim Alvefur <zash@zash.se> |
---|---|
date | Mon, 13 May 2013 20:02:13 +0200 |
parents | 0e0883870058 |
children | 31eb570f6bc0 |
files | mod_mam_sql.wiki |
diffstat | 1 files changed, 6 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/mod_mam_sql.wiki Thu May 09 10:58:01 2013 +0000 +++ b/mod_mam_sql.wiki Mon May 13 20:02:13 2013 +0200 @@ -44,13 +44,13 @@ {{{ CREATE TABLE prosodyarchive ( - `host` VARCHAR(16) NOT NULL, - `user` VARCHAR(16) NOT NULL, - `store` CHAR(8) NOT NULL, + `host` VARCHAR(1023) NOT NULL, + `user` VARCHAR(1023) NOT NULL, + `store` VARCHAR(1023) NOT NULL, `id` INTEGER PRIMARY KEY AUTO_INCREMENT, `when` INTEGER NOT NULL, - `with` VARCHAR(32) NOT NULL, - `resource` VARCHAR(16) NOT NULL, + `with` VARCHAR(2047) NOT NULL, + `resource` VARCHAR(1023), `stanza` TEXT NOT NULL ); CREATE INDEX hus ON prosodyarchive (host, user, store); @@ -67,4 +67,4 @@ = Compatibility = || 0.8 || ? || || 0.9 || Works || -|| trunk || Works || \ No newline at end of file +|| trunk || Works ||