zeM9ew1G

1-- --------------------------------------------------------
2-- Vært:                         127.0.0.1
3-- Server-version:               10.1.31-MariaDB - mariadb.org binary distribution
4-- ServerOS:                     Win32
5-- HeidiSQL Version:             10.1.0.5464
6-- --------------------------------------------------------
7 
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13 
14 
15 
16-- Dumping structure for tabel testdb.phone_app_chat
17CREATE TABLE IF NOT EXISTS `phone_app_chat` (
18  `id` int(11) NOT NULL AUTO_INCREMENT,
19  `userid` int(11) NOT NULL,
20  `channel` varchar(20) NOT NULL,
21  `message` varchar(255) NOT NULL,
22  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB AUTO_INCREMENT=11069 DEFAULT CHARSET=utf8;
25 
26-- Data exporting was unselected.
27-- Dumping structure for tabel testdb.phone_calls
28CREATE TABLE IF NOT EXISTS `phone_calls` (
29  `id` int(11) NOT NULL AUTO_INCREMENT,
30  `owner` varchar(20) NOT NULL COMMENT 'Num tel proprio',
31  `num` varchar(20) NOT NULL COMMENT 'Num reférence du contact',
32  `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
33  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34  `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8;
37 
38-- Data exporting was unselected.
39-- Dumping structure for tabel testdb.phone_messages
40CREATE TABLE IF NOT EXISTS `phone_messages` (
41  `id` int(11) NOT NULL AUTO_INCREMENT,
42  `transmitter` varchar(20) NOT NULL,
43  `receiver` varchar(20) NOT NULL,
44  `message` varchar(1000) NOT NULL DEFAULT '0',
45  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
46  `isRead` int(11) NOT NULL DEFAULT '0',
47  `owner` int(11) NOT NULL DEFAULT '0',
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8;
50 
51-- Data exporting was unselected.
52-- Dumping structure for tabel testdb.phone_twitter
53CREATE TABLE IF NOT EXISTS `phone_twitter` (
54  `id` int(11) NOT NULL AUTO_INCREMENT,
55  `userid` int(11) NOT NULL,
56  `name` varchar(300) NOT NULL,
57  `message` varchar(300) NOT NULL,
58  `time` varchar(30) NOT NULL,
59  PRIMARY KEY (`id`)
60) ENGINE=InnoDB AUTO_INCREMENT=49713 DEFAULT CHARSET=latin1;
61 
62-- Data exporting was unselected.
63/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
64/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;