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 ||