soc.2009.transport: 66f70d1f: Added mysql_schema.sql.

[hanzz at soc.pidgin.im]

-----------------------------------------------------------------
Revision: 66f70d1ffb113508352350bcc303ef25de3fbe69
Ancestor: 61c6a707c325ccc06d4be206628d22e7df12c6af
Author: hanzz at soc.pidgin.im
Date: 2009-04-26T18:08:54
Branch: im.pidgin.soc.2009.transport
URL: http://d.pidgin.im/viewmtn/revision/info/66f70d1ffb113508352350bcc303ef25de3fbe69

Added files:
        schemas/mysql_schema.sql

ChangeLog: 

Added mysql_schema.sql.

-------------- next part --------------
============================================================
--- schemas/mysql_schema.sql	6816f9fcd4cde0b304d94c85ace4deee7f25d538
+++ schemas/mysql_schema.sql	6816f9fcd4cde0b304d94c85ace4deee7f25d538
@@ -0,0 +1,28 @@
+CREATE TABLE `users` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `jid` varchar(255) collate utf8_bin NOT NULL,
+  `uin` varchar(255) collate utf8_bin NOT NULL,
+  `password` varchar(255) collate utf8_bin NOT NULL,
+  `group` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`id`),
+  KEY `jid` (`jid`),
+  KEY `uin` (`uin`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+CREATE TABLE `rosters` (
+  `id` bigint(20) unsigned NOT NULL auto_increment,
+  `jid` varchar(255) collate utf8_bin NOT NULL,
+  `uin` varchar(255) collate utf8_bin NOT NULL,
+  `subscription` varchar(10) collate utf8_bin NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `jid` (`jid`),
+  KEY `uin` (`uin`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+CREATE TABLE `settings` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `jid` varchar(255) NOT NULL,
+  `var` varchar(255) NOT NULL,
+  `value` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;