Changeset 1529

(2010/03/15 01:09) Almost 2 years ago

- fix for mail DB table. Changing message max length from 500 to correct 1000.
use mail-rev1529.sql to update mail table

Affected files

	1528		1529
322	CREATE TABLE IF NOT EXISTS `mail` (	322	CREATE TABLE IF NOT EXISTS `mail` (
323	`mailUniqueId` int(11) NOT NULL, `mailRecipientId` int(11) NOT NULL,	323	`mailUniqueId` int(11) NOT NULL, `mailRecipientId` int(11) NOT NULL,
324	`senderName` varchar(16) character set utf8 NOT NULL,`mailTitle` varchar(20) character set utf8 NOT NULL,	324	`senderName` varchar(16) character set utf8 NOT NULL,`mailTitle` varchar(20) character set utf8 NOT NULL,
325	`mailMessage` varchar(500) character set utf8 NOT NULL, `unread` tinyint(4) NOT NULL default '1',	325	`mailMessage` varchar(1000) character set utf8 NOT NULL, `unread` tinyint(4) NOT NULL default '1',
326	`attachedItemId` int(11) NOT NULL, `attachedKinahCount` int(11) NOT NULL,	326	`attachedItemId` int(11) NOT NULL, `attachedKinahCount` int(11) NOT NULL,
327	`express` tinyint(4) NOT NULL default '0',	327	`express` tinyint(4) NOT NULL default '0',
328	`recievedTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,	328	`recievedTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,