# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1368468133 -7200
# Node ID 817e175c37df6c9bfc9eb2fe54bf40b6fb8ade25
# Parent  0e0883870058115ff394d5ceb260fc0ca56dc3b0
Fix the suggested mysql schema

diff -r 0e0883870058 -r 817e175c37df mod_mam_sql.wiki
--- 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 ||