· 8 years ago · May 29, 2018, 09:26 PM
1CREATE TABLE IF NOT EXISTS `messages` (
2 `uid` int(12) NOT NULL AUTO_INCREMENT,
3 `fromID` varchar(50) NOT NULL,
4 `toID` varchar(50) NOT NULL,
5 `message` text,
6 `fromName` varchar(32) NOT NULL,
7 `toName` varchar(32) NOT NULL,
8 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
9 PRIMARY KEY (`uid`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;