· 8 years ago · May 09, 2018, 11:34 AM
1CREATE TABLE IF NOT EXISTS `devices` (
2 `id` int(6) unsigned NOT NULL,
3 `imei` int(3) unsigned NOT NULL,
4 `deviceid` varchar(200) NOT NULL,
5 PRIMARY KEY (`id`)
6) DEFAULT CHARSET=utf8;
7INSERT INTO `docs` (`id`, `imei`, `deviceid`) VALUES
8 ('1', '12345', 'dev1'),
9 ('2', '67890', 'dev2'),
10 ('3', '09876', 'dev3'),
11 ('4', '65432', 'dev4'),
12 ('4', '10986', 'dev5');
13
14CREATE TABLE IF NOT EXISTS `online` (
15 `id` int(6) unsigned NOT NULL,
16 `imei` int(3) unsigned NOT NULL,
17 `time` varchar(200) NOT NULL,
18 PRIMARY KEY (`id`)
19) DEFAULT CHARSET=utf8;
20INSERT INTO `docs` (`id`, `imei`, `time`) VALUES
21 ('1', '12345', '10'),
22 ('2', '67890', '40'),
23 ('3', '10986', '62');