An1b25F4

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : Invule project
5 Source Server Type    : MySQL
6 Source Server Version : 50559
7 Source Host           : 213.32.101.215:3306
8 Source Schema         : entregameur
9
10 Target Server Type    : MySQL
11 Target Server Version : 50559
12 File Encoding         : 65001
13
14 Date: 10/03/2018 19:04:04
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for CGUPermissions
22-- ----------------------------
23DROP TABLE IF EXISTS `CGUPermissions`;
24CREATE TABLE `CGUPermissions`  (
25  `id` int(10) NOT NULL,
26  `may_edit_cgu` tinyint(1) NOT NULL DEFAULT 0
27) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
28
29-- ----------------------------
30-- Table structure for FlagPermissions
31-- ----------------------------
32DROP TABLE IF EXISTS `FlagPermissions`;
33CREATE TABLE `FlagPermissions`  (
34  `id` int(11) NOT NULL,
35  `may_upload_informations` tinyint(1) NOT NULL DEFAULT 1,
36  `may_accept_profile` tinyint(1) NOT NULL DEFAULT 0,
37  `may_revoke_profile` tinyint(1) NOT NULL DEFAULT 0,
38  `may_freeze_user` tinyint(1) NOT NULL DEFAULT 0
39) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
40
41-- ----------------------------
42-- Table structure for NewsPermissions
43-- ----------------------------
44DROP TABLE IF EXISTS `NewsPermissions`;
45CREATE TABLE `NewsPermissions`  (
46  `id` int(10) NOT NULL,
47  `may_edit_blog_post` tinyint(255) NOT NULL DEFAULT 1,
48  `may_create_blog_post` tinyint(255) NOT NULL DEFAULT 0,
49  `may_remove_blog_post` tinyint(255) NOT NULL DEFAULT 0,
50  `may_view_blog_post` tinyint(255) NOT NULL DEFAULT 0
51) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
52
53-- ----------------------------
54-- Table structure for QueuedPurchase
55-- ----------------------------
56DROP TABLE IF EXISTS `QueuedPurchase`;
57CREATE TABLE `QueuedPurchase`  (
58  `id` int(10) NOT NULL AUTO_INCREMENT,
59  `user_id` int(10) NOT NULL,
60  `product_id` int(10) NOT NULL,
61  `amounts` int(10) NOT NULL,
62  PRIMARY KEY (`id`) USING BTREE
63) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
64
65-- ----------------------------
66-- Table structure for ShopItem
67-- ----------------------------
68DROP TABLE IF EXISTS `ShopItem`;
69CREATE TABLE `ShopItem`  (
70  `id` int(10) NOT NULL AUTO_INCREMENT,
71  `section_id` int(10) NOT NULL,
72  `product_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
73  `product_desc` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
74  `product_price` decimal(10, 2) NOT NULL,
75  `consumable` tinyint(1) NOT NULL DEFAULT 0,
76  `product_disponibility` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
77  `item_id` int(10) DEFAULT NULL,
78  `command` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
79  PRIMARY KEY (`id`) USING BTREE,
80  INDEX `sectionId`(`section_id`) USING BTREE,
81  CONSTRAINT `sectionId` FOREIGN KEY (`section_id`) REFERENCES `shopCategories` (`section_id`) ON DELETE NO ACTION ON UPDATE CASCADE
82) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
83
84-- ----------------------------
85-- Table structure for ShopOrderHistory
86-- ----------------------------
87DROP TABLE IF EXISTS `ShopOrderHistory`;
88CREATE TABLE `ShopOrderHistory`  (
89  `id` int(10) NOT NULL AUTO_INCREMENT,
90  `product_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
91  `user_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
92  `amount` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
93  `price` decimal(10, 2) DEFAULT NULL,
94  `purchase_state` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
95  `iso_date` datetime NOT NULL,
96  PRIMARY KEY (`id`) USING BTREE
97) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
98
99-- ----------------------------
100-- Table structure for ShopPermissions
101-- ----------------------------
102DROP TABLE IF EXISTS `ShopPermissions`;
103CREATE TABLE `ShopPermissions`  (
104  `id` int(11) NOT NULL,
105  `may_add_an_item` tinyint(255) NOT NULL DEFAULT 1,
106  `may_remove_an_item` tinyint(255) NOT NULL DEFAULT 1,
107  `may_force_purchasing_validation` tinyint(255) NOT NULL DEFAULT 0,
108  `may_create_new_product` tinyint(255) NOT NULL DEFAULT 0,
109  `may_remove_new_product` tinyint(255) NOT NULL DEFAULT 0,
110  `may_edit_new_product` tinyint(255) NOT NULL DEFAULT 0
111) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
112
113-- ----------------------------
114-- Table structure for TicketSupportPermissions
115-- ----------------------------
116DROP TABLE IF EXISTS `TicketSupportPermissions`;
117CREATE TABLE `TicketSupportPermissions`  (
118  `id` int(11) NOT NULL,
119  `may_view_his_ticket` tinyint(1) NOT NULL DEFAULT 1,
120  `may_create_ticket` tinyint(1) NOT NULL DEFAULT 1,
121  `may_view_opened_ticket` tinyint(1) NOT NULL DEFAULT 0,
122  `may_answer_to_ticket` tinyint(1) NOT NULL DEFAULT 0,
123  `may_close_ticket` tinyint(1) NOT NULL DEFAULT 0
124) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
125
126-- ----------------------------
127-- Table structure for UserHandlingPermissions
128-- ----------------------------
129DROP TABLE IF EXISTS `UserHandlingPermissions`;
130CREATE TABLE `UserHandlingPermissions`  (
131  `id` int(10) NOT NULL,
132  `may_view_user_informations` tinyint(1) NOT NULL DEFAULT 0,
133  `may_edit_critical_informations` tinyint(1) NOT NULL DEFAULT 0,
134  `may_edit_user_money` tinyint(1) NOT NULL DEFAULT 0,
135  `may_ban_user` tinyint(1) NOT NULL DEFAULT 0,
136  `may_unban_use` tinyint(1) NOT NULL DEFAULT 0,
137  `may_edit_his_own_info` tinyint(1) NOT NULL DEFAULT 1,
138  `may_view_user_purchase` tinyint(1) NOT NULL DEFAULT 0,
139  `may_view_ticket_history` tinyint(1) NOT NULL DEFAULT 0,
140  `may_view_current_ip_user` tinyint(1) NOT NULL DEFAULT 0,
141  `may_view_history_ip_user` tinyint(1) NOT NULL DEFAULT 0,
142  `may_view_his_purchase_list` tinyint(1) NOT NULL DEFAULT 1,
143  `may_flag_user_account` tinyint(1) NOT NULL DEFAULT 0
144) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
145
146-- ----------------------------
147-- Table structure for shopCategories
148-- ----------------------------
149DROP TABLE IF EXISTS `shopCategories`;
150CREATE TABLE `shopCategories`  (
151  `section_id` int(10) NOT NULL,
152  `nom_categorie` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
153  PRIMARY KEY (`section_id`) USING BTREE
154) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
155
156-- ----------------------------
157-- Records of shopCategories
158-- ----------------------------
159INSERT INTO `shopCategories` VALUES (0, '');
160INSERT INTO `shopCategories` VALUES (1, 'Grade 24H');
161INSERT INTO `shopCategories` VALUES (2, 'Grade 7J');
162INSERT INTO `shopCategories` VALUES (3, 'Grade 30J');
163INSERT INTO `shopCategories` VALUES (4, 'Grade à Vie');
164INSERT INTO `shopCategories` VALUES (5, 'Economie');
165INSERT INTO `shopCategories` VALUES (6, 'Les Kits');
166INSERT INTO `shopCategories` VALUES (7, 'Bypass');
167INSERT INTO `shopCategories` VALUES (8, 'Activer mon compte');
168INSERT INTO `shopCategories` VALUES (9, 'Autres');
169
170-- ----------------------------
171-- Table structure for users
172-- ----------------------------
173DROP TABLE IF EXISTS `users`;
174CREATE TABLE `users`  (
175  `id` int(255) NOT NULL AUTO_INCREMENT,
176  `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
177  `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
178  `mail` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
179  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
180  `paypal` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
181  `first_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
182  `phone_number` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
183  `country` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
184  `age` int(255) DEFAULT NULL,
185  `is_banned` tinyint(1) NOT NULL DEFAULT 0,
186  `is_frozen` tinyint(1) NOT NULL DEFAULT 0,
187  `verification_enabled` tinyint(1) NOT NULL DEFAULT 0,
188  `current_ip` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
189  PRIMARY KEY (`id`) USING BTREE
190) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
191
192SET FOREIGN_KEY_CHECKS = 1;