63J0BgL4

1-- Dumping structure for tabel vrpfx.phone_app_chat
2DROP TABLE IF EXISTS `phone_app_chat`;
3CREATE TABLE IF NOT EXISTS `phone_app_chat` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `channel` varchar(20) NOT NULL,
6  `message` varchar(255) NOT NULL,
7  `time` timestamp NOT NULL DEFAULT current_timestamp(),
8  `userid` int(11) NOT NULL,
9  PRIMARY KEY (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12-- Dumping data for table vrpfx.phone_app_chat: ~0 rows (approximately)
13/*!40000 ALTER TABLE `phone_app_chat` DISABLE KEYS */;
14/*!40000 ALTER TABLE `phone_app_chat` ENABLE KEYS */;
15
16-- Dumping structure for tabel vrpfx.phone_calls
17DROP TABLE IF EXISTS `phone_calls`;
18CREATE TABLE IF NOT EXISTS `phone_calls` (
19  `id` int(11) NOT NULL AUTO_INCREMENT,
20  `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
21  `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
22  `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
23  `time` timestamp NOT NULL DEFAULT current_timestamp(),
24  `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
25  PRIMARY KEY (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28-- Dumping data for table vrpfx.phone_calls: ~0 rows (approximately)
29/*!40000 ALTER TABLE `phone_calls` DISABLE KEYS */;
30/*!40000 ALTER TABLE `phone_calls` ENABLE KEYS */;
31
32-- Dumping structure for tabel vrpfx.phone_messages
33DROP TABLE IF EXISTS `phone_messages`;
34CREATE TABLE IF NOT EXISTS `phone_messages` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `transmitter` varchar(10) NOT NULL,
37  `receiver` varchar(10) NOT NULL,
38  `message` varchar(255) NOT NULL DEFAULT '0',
39  `time` timestamp NOT NULL DEFAULT current_timestamp(),
40  `isRead` int(11) NOT NULL DEFAULT 0,
41  `owner` int(11) NOT NULL DEFAULT 0,
42  PRIMARY KEY (`id`)
43) ENGINE=MyISAM DEFAULT CHARSET=utf8;
44
45-- Dumping data for table vrpfx.phone_messages: 0 rows
46/*!40000 ALTER TABLE `phone_messages` DISABLE KEYS */;
47/*!40000 ALTER TABLE `phone_messages` ENABLE KEYS */;
48
49-- Dumping structure for tabel vrpfx.phone_twitter
50DROP TABLE IF EXISTS `phone_twitter`;
51CREATE TABLE IF NOT EXISTS `phone_twitter` (
52  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `userid` int(11) NOT NULL,
54  `name` varchar(300) NOT NULL,
55  `message` varchar(300) NOT NULL,
56  `time` varchar(30) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;