root/trunk/AE-go_GameServer/sql/au_server_gs.sql
Download diff| 1503 | 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, |