soc.2009.transport: 14514b1a: Added vcards table schema

[hanzz at soc.pidgin.im]

-----------------------------------------------------------------
Revision: 14514b1adfebb629e83a08059b870346508ab410
Ancestor: 0b6d8db0d8973dcb84dbc0951c4183d0e40c3c8d
Author: hanzz at soc.pidgin.im
Date: 2009-06-29T14:22:31
Branch: im.pidgin.soc.2009.transport
URL: http://d.pidgin.im/viewmtn/revision/info/14514b1adfebb629e83a08059b870346508ab410

Modified files:
        schemas/mysql_schema.sql

ChangeLog: 

Added vcards table schema

-------------- next part --------------
============================================================
--- schemas/mysql_schema.sql	15ddeae4b37f90fd99861589ea332023024131d5
+++ schemas/mysql_schema.sql	a01a7f6c0b7276441842983943514f3607c8c251
@@ -30,3 +30,10 @@ CREATE TABLE `settings` (
   `value` varchar(255) NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+CREATE TABLE IF NOT EXISTS `vcards` (
+  `username` varchar(250) NOT NULL,
+  `vcard` text NOT NULL,
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  PRIMARY KEY  (`username`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;