KJXxtqfG

1CREATE TABLE IF NOT EXISTS `phone_app_chat` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `userid` int(11) NOT NULL,
4  `channel` varchar(20) NOT NULL,
5  `message` varchar(255) NOT NULL,
6  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=11069 DEFAULT CHARSET=utf8;
9
10-- Data exporting was unselected.
11-- Dumping structure for tabel testdb.phone_calls
12CREATE TABLE IF NOT EXISTS `phone_calls` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `owner` varchar(20) NOT NULL COMMENT 'Num tel proprio',
15  `num` varchar(20) NOT NULL COMMENT 'Num reférence du contact',
16  `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
17  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
18  `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21
22-- Data exporting was unselected.
23-- Dumping structure for tabel testdb.phone_messages
24CREATE TABLE IF NOT EXISTS `phone_messages` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `transmitter` varchar(20) NOT NULL,
27  `receiver` varchar(20) NOT NULL,
28  `message` varchar(1000) NOT NULL DEFAULT '0',
29  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
30  `isRead` int(11) NOT NULL DEFAULT '0',
31  `owner` int(11) NOT NULL DEFAULT '0',
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35-- Data exporting was unselected.
36-- Dumping structure for tabel testdb.phone_twitter
37CREATE TABLE IF NOT EXISTS `phone_twitter` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `userid` int(11) NOT NULL,
40  `name` varchar(300) NOT NULL,
41  `message` varchar(300) NOT NULL,
42  `time` varchar(30) NOT NULL,
43  PRIMARY KEY (`id`)
44) ENGINE=InnoDB AUTO_INCREMENT=49713 DEFAULT CHARSET=latin1;