root/trunk/AE-go_GameServer/sql/au_server_gs.sql

Show revision log
 
14711503
32
  `last_online` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
32
  `last_online` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
33
  `cube_size` tinyint(1) NOT NULL default '0',
33
  `cube_size` tinyint(1) NOT NULL default '0',
34
  `warehouse_size` tinyint(1) NOT NULL default '0',
34
  `warehouse_size` tinyint(1) NOT NULL default '0',
 
35
  `mailboxLetters` tinyint(4) NOT NULL default '0',



35
  `bind_point` INT NOT NULL default '0',
36
  `bind_point` INT NOT NULL default '0',



36
  `title_id` int(3) NOT NULL default '-1',
37
  `title_id` int(3) NOT NULL default '-1',



37
  `online` tinyint(1) NOT NULL default '0',
38
  `online` tinyint(1) NOT NULL default '0',


...
...
313
PRIMARY KEY (`player_id`),
314
PRIMARY KEY (`player_id`),



314
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
315
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE



315
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
316
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



317



318



319
-- ----------------------------



320
-- mail_table



321
-- ----------------------------



322
CREATE TABLE IF NOT EXISTS  `mail` (



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,



325
`mailMessage` varchar(500) character set utf8 NOT NULL, `unread` tinyint(4) NOT NULL default '1',



326
`attachedItemId` int(11) NOT NULL, `attachedKinahCount` int(11) NOT NULL,



327
`express` tinyint(4) NOT NULL default '0', 



328
`recievedTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,



329
PRIMARY KEY  (`mailUniqueId`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;