hdnxsRfw

1-- --------------------------------------------------------
2-- Host :                        127.0.0.1
3-- Server version:               10.3.7-MariaDB - mariadb.org binary distribution
4-- OS of the server:             Win64
5-- HeidiSQL Version:             9.5.0.5196
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-- Export the structure of the table gta rp. phone_app_chat
16CREATE TABLE IF NOT EXISTS `phone_app_chat` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `channel` varchar(20) NOT NULL,
19  `message` varchar(255) NOT NULL,
20  `time` timestamp NOT NULL DEFAULT current_timestamp(),
21  PRIMARY KEY (`id`)
22) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
23
24-- The exported data was not selected.
25-- Export the structure of the table gta rp. phone calls
26CREATE TABLE IF NOT EXISTS `phone_calls` (
27  `id` int(11) NOT NULL AUTO_INCREMENT,
28  `owner` varchar(10) NOT NULL COMMENT 'Num such OWNER',
29  `num` varchar(10) NOT NULL COMMENT 'Reference number of the contact',
30  `incoming` int(11) NOT NULL COMMENT 'Defined if we are at the origin of the calls',
31  `time` timestamp NOT NULL DEFAULT current_timestamp(),
32  `accepts` int(11) NOT NULL COMMENT 'Calls accept or not',
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
35
36-- The exported data was not selected.
37-- Export the structure of the table gta rp. phone messages
38CREATE TABLE IF NOT EXISTS `phone_messages` (
39  `id` int(11) NOT NULL AUTO_INCREMENT,
40  `transmitter` varchar(10) NOT NULL,
41  `receiver` varchar(10) NOT NULL,
42  `message` varchar(255) NOT NULL DEFAULT '0',
43  `time` timestamp NOT NULL DEFAULT current_timestamp(),
44  `isRead` int(11) NOT NULL DEFAULT 0,
45  `owner` int(11) NOT NULL DEFAULT 0,
46  PRIMARY KEY (`id`)
47) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
48
49-- The exported data was not selected.
50-- Export the structure of the table gta rp. phone users contacts
51CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
52  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
54  `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
55  `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1',
56  PRIMARY KEY (`id`)
57) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
58
59-- Exported data was not selected.
60/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
61/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
62/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 
63     
64Erro SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '�FF-- ---------------------------------------------------------- Host :       ' at line 1uery