· 9 years ago · Oct 17, 2016, 06:32 PM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4CREATE TABLE IF NOT EXISTS `chat_messages` (
5 `msg_id` bigint(14) NOT NULL AUTO_INCREMENT,
6 `chat_id` bigint(10) NOT NULL,
7 `to_enroll` int(8) NOT NULL,
8 `to_user` varchar(30) NOT NULL,
9 `from_enroll` int(8) NOT NULL,
10 `from_user` varchar(30) NOT NULL,
11 `msg` text NOT NULL,
12 `time` bigint(14) NOT NULL,
13 PRIMARY KEY (`msg_id`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;