· 4 years ago · Jan 04, 2021, 06:58 PM
1-- MySQL dump 10.13 Distrib 5.5.51-38.2, for Linux (x86_64)
2--
3-- Host: localhost Database: blackc_mstr2
4-- ------------------------------------------------------
5-- Server version 5.5.51-38.2
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `account_types`
20--
21
22DROP TABLE IF EXISTS `account_types`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account_types` (
26 `acc_ty_id` int(11) NOT NULL AUTO_INCREMENT,
27 `acc_ty_account` int(11) NOT NULL,
28 `acc_ty_type` int(11) NOT NULL,
29 PRIMARY KEY (`acc_ty_id`)
30) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `account_types`
35--
36
37LOCK TABLES `account_types` WRITE;
38/*!40000 ALTER TABLE `account_types` DISABLE KEYS */;
39INSERT INTO `account_types` (`acc_ty_id`, `acc_ty_account`, `acc_ty_type`) VALUES (37,14,6),(38,14,7),(58,39,2),(59,39,3),(60,39,4),(61,39,5),(62,42,3),(63,42,20),(68,56,1),(69,55,7),(70,51,22),(71,51,23),(72,51,24),(73,49,6),(74,43,2),(75,43,4),(76,43,6),(77,43,9),(78,15,1),(79,15,10),(80,13,1),(81,12,3),(82,12,9),(83,11,6),(84,11,7),(85,10,1),(89,1,3),(90,1,4),(91,1,5);
40/*!40000 ALTER TABLE `account_types` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `accounts`
45--
46
47DROP TABLE IF EXISTS `accounts`;
48/*!40101 SET @saved_cs_client = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `accounts` (
51 `acc_id` int(11) NOT NULL AUTO_INCREMENT,
52 `acc_code` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
53 `acc_name_1` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
54 `acc_name_2` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
55 `acc_desc_1` text COLLATE utf8_unicode_ci NOT NULL,
56 `acc_desc_2` text COLLATE utf8_unicode_ci NOT NULL,
57 `acc_email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
58 `acc_mobile` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
59 `acc_website` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
60 `acc_contacts` text COLLATE utf8_unicode_ci NOT NULL,
61 `acc_map` text COLLATE utf8_unicode_ci NOT NULL,
62 `acc_address` varchar(2000) CHARACTER SET utf8 DEFAULT NULL,
63 `acc_logo` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
64 `acc_types` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
65 `acc_block` int(11) NOT NULL DEFAULT '1',
66 `acc_indte` date NOT NULL,
67 `acc_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
68 PRIMARY KEY (`acc_id`),
69 UNIQUE KEY `acc_email` (`acc_email`),
70 UNIQUE KEY `acc_code` (`acc_code`)
71) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `accounts`
76--
77
78LOCK TABLES `accounts` WRITE;
79/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
80INSERT INTO `accounts` (`acc_id`, `acc_code`, `acc_name_1`, `acc_name_2`, `acc_desc_1`, `acc_desc_2`, `acc_email`, `acc_mobile`, `acc_website`, `acc_contacts`, `acc_map`, `acc_address`, `acc_logo`, `acc_types`, `acc_block`, `acc_indte`, `acc_ip`) VALUES (1,'1','Test','G','','','giordano@gmail.com','464654564','dadasdasd','','https://www.google.com.co/maps/@24.7241504,46.2620616,9z','المملكة العربية السعودية - الرياض','','3,4,5',0,'2019-12-16','93.168.146.233'),(10,'10','الوفاق لتأجير السيارات','Alwefaq for rent cars','','','carsco@gmail.com','654654654','http://www.google.com','','https://www.google.com.co/maps/@24.7241504,46.2620616,9z','المملكة العربية السعودية - الرياض','1573992050.jpeg','1',0,'2019-11-17','213.6.243.210'),(11,'111223','احتياجي للمواد الغذائية','Ehtiyagi for food','eee','yyy','test@test.com','654654654','www.google.com','','https://www.google.com.co/maps/@24.7241504,46.2620616,9z','المملكة العربية السعودية - الرياض','1573991990.png','6,7',0,'2019-11-17','213.6.243.210'),(12,'111222','بيوتي للتجميل','Beauty Every Where','','','bdoor@gmail.com','966 56 98 76 543','http://www.bdoor.com','966 56 98 76 543\r\n966 56 98 76 544\r\n966 56 98 76 545','https://www.google.com.co/maps/@24.7241504,46.2620616,9z','المملكة العربية السعودية - الرياض','1573991944.png','3,9',0,'2019-11-17','213.6.243.210'),(13,'13','معارض سيارات MG','MG for Cars','','','new_account@blackcoupon.com','972 59 2398095','http://www.facebook.com','','',NULL,'1573991900.jpg','1',0,'2019-11-17','213.6.243.210'),(15,'15','معرض مشعل للسيارات','meshaal for cars','','','info@extra.com','0565330501','extra.com','','',NULL,'1573991840.jpg','1,10',0,'2019-11-17','213.6.243.210'),(18,'18','متجر نعناع','nanaa shop','','','majid.aldalbahi@gmail.com','345345345','nanaashop@gmail.com','','',NULL,'1573991767.jpeg','',0,'2019-11-17','213.6.243.210'),(29,'29','متاجر اوفرلي','Offerlee Store','','','1','34543534','offerlee@gmail.com','','',NULL,'1573991675.jpg','',0,'2019-11-17','213.6.243.210'),(39,'39','بازار','Bazar','','','jameljamal3000002@yahoo.com','55544444','http://facebook.com/bazar/','','',NULL,'','2,3,4,5',0,'2019-10-21','188.161.159.240'),(41,'41','متاجر السعودية','Matajer al suadia','','','jameljamal30202@yahoo.com','787878787878','','','',NULL,'1573991618.jpeg','',0,'2019-11-17','213.6.243.210'),(51,'51','حلويات عرفات','Arafat Sweets','','','myonamm','0544337653','www.wowowowowo.com','','https://maps.app.goo.gl/edRdspeekibWTQNZA',NULL,'1573991287.png','22,23,24',0,'2019-11-17','213.6.243.210'),(56,'100056','متجر الواحة','Alwaha store','','','majid555m@hotmail.com','550026000','','0550026000','https://maps.app.goo.gl/6o96PFxYNu5WGPAE9',NULL,'1573991144.png','1',0,'2019-11-17','213.6.243.210'),(57,'100057','Dee','Bffd','','','dodododo@gamil.com','0544338465','','','https://maps.app.goo.gl/edRdspeekibWTQNZA',NULL,'','',0,'2019-12-09','95.184.102.139'),(58,'100058','Dee','Dee23','','','Dalalalotaibi30@gmail.com','054433222','','','https://maps.app.goo.gl/edRdspeekibWTQNZA',NULL,'','',0,'2019-12-09','95.184.102.139'),(59,'100059','عطورات تالين','Taleen','','','majid260moh@gmail.com','550026000','','0550026000','https://maps.app.goo.gl/edRdspeekibWTQNZA','الرياض الروضه','','5,9',0,'2019-12-09','95.184.102.139'),(60,'100060','يزيد','Yazeed','','','otbyaz98@gmail.com','0505461042','Hsbehd.com.sa','0505461129','https://maps.app.goo.gl/edRdspeekibWTQNZA','الرياض','1575910013.png','',0,'2019-12-09','95.184.102.139'),(64,'100064','يزيد تجربة','Yazeed','','','yotb46280@gmail.com','0505461042','','','https://maps.app.goo.gl/edRdspeekibWTQNZA',NULL,'','',0,'2019-12-16','93.168.146.233'),(65,'100065','بيوتي','بيوتي','','','eme4664@hotmail.com','0570242395','','','',NULL,'','',0,'2019-12-17','151.254.119.109'),(66,'100066','إبتسام','Abtsam','','','abt3556@gmail.com','0532612090','','','',NULL,'','',0,'2019-12-19','78.95.35.121'),(67,'100067','درع الرجل','DERA AL-RAJOL','','','nykasem1@gmail.com','0508055668','','','',NULL,'','',0,'2019-12-19','95.184.47.167'),(68,'100068','عبدالعزيز','Aziz','','','aziz_ksa11@hotmail.com','0550023000','','','',NULL,'','',0,'2019-12-22','93.168.178.210'),(69,'100069','اوستن ريد','Austin reed','','','mmdonzi64@gmail.com','0509761370','','','',NULL,'','',0,'2019-12-22','51.253.57.104'),(70,'100070','منارات السعد للاثاث','منارات السعد لاثاث','','','alwthlan1975@gmail.com','0556376244','','','',NULL,'','',0,'2019-12-25','151.254.123.38'),(72,'100072','neveena','neveena','','','neveen.fares@hotmail.com','0599296232','','','',NULL,'','',0,'2020-01-13','151.254.67.16'),(73,'100073','','','','','','','','','',NULL,'','',0,'2020-01-14','51.253.3.225'),(74,'100074','test','test','','','ammar3408@hotmail.com','05965874','','','',NULL,'','',0,'2020-01-15','51.253.3.225'),(75,'100075','عالم ابل','0533377462','','','kg.3@hotmail.com','0533377462','','','',NULL,'','',0,'2020-02-25','78.95.245.230');
81/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `appslider`
86--
87
88DROP TABLE IF EXISTS `appslider`;
89/*!40101 SET @saved_cs_client = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `appslider` (
92 `slider_id` int(11) NOT NULL AUTO_INCREMENT,
93 `slider_text1_ar` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
94 `slider_text2_ar` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
95 `slider_text1_en` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
96 `slider_text2_en` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
97 `slider_image` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
98 `slider_indte` datetime NOT NULL,
99 `slider_inusr` int(11) NOT NULL,
100 `slider_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
101 PRIMARY KEY (`slider_id`)
102) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `appslider`
107--
108
109LOCK TABLES `appslider` WRITE;
110/*!40000 ALTER TABLE `appslider` DISABLE KEYS */;
111INSERT INTO `appslider` (`slider_id`, `slider_text1_ar`, `slider_text2_ar`, `slider_text1_en`, `slider_text2_en`, `slider_image`, `slider_indte`, `slider_inusr`, `slider_ip`) VALUES (30,NULL,NULL,NULL,NULL,'1576508654.jpg','2019-12-16 10:09:46',21,'93.168.146.233');
112/*!40000 ALTER TABLE `appslider` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `cities`
117--
118
119DROP TABLE IF EXISTS `cities`;
120/*!40101 SET @saved_cs_client = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `cities` (
123 `ct_id` int(11) NOT NULL AUTO_INCREMENT,
124 `ct_name_1` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
125 `ct_name_2` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
126 `ct_indte` datetime NOT NULL,
127 `ct_inusr` int(11) NOT NULL,
128 `ct_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
129 PRIMARY KEY (`ct_id`)
130) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133--
134-- Dumping data for table `cities`
135--
136
137LOCK TABLES `cities` WRITE;
138/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
139INSERT INTO `cities` (`ct_id`, `ct_name_1`, `ct_name_2`, `ct_indte`, `ct_inusr`, `ct_ip`) VALUES (1,'جدة','Jeddah','2019-10-21 18:47:03',21,'188.161.159.240'),(2,'الرياض','Al-Ryadh','2019-10-21 18:47:14',21,'188.161.159.240'),(3,'الدمام','dammam','2019-10-22 03:50:09',21,'77.232.102.84');
140/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `offers`
145--
146
147DROP TABLE IF EXISTS `offers`;
148/*!40101 SET @saved_cs_client = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `offers` (
151 `off_id` int(11) NOT NULL AUTO_INCREMENT,
152 `off_account` int(11) NOT NULL,
153 `off_code` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
154 `off_number` int(11) NOT NULL,
155 `off_title_1` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
156 `off_title_2` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
157 `off_desc_1` text COLLATE utf8_unicode_ci NOT NULL,
158 `off_desc_2` text COLLATE utf8_unicode_ci NOT NULL,
159 `off_main_img` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
160 `off_types` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
161 `off_cities` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
162 `off_block` int(11) NOT NULL DEFAULT '1',
163 `off_discount_code` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
164 `off_discount_type` int(11) NOT NULL,
165 `off_discount_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
166 `off_indte` date NOT NULL,
167 `off_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
168 PRIMARY KEY (`off_id`),
169 UNIQUE KEY `ofer_codes_of_account_unique` (`off_account`,`off_discount_code`)
170) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
171/*!40101 SET character_set_client = @saved_cs_client */;
172
173--
174-- Dumping data for table `offers`
175--
176
177LOCK TABLES `offers` WRITE;
178/*!40000 ALTER TABLE `offers` DISABLE KEYS */;
179INSERT INTO `offers` (`off_id`, `off_account`, `off_code`, `off_number`, `off_title_1`, `off_title_2`, `off_desc_1`, `off_desc_2`, `off_main_img`, `off_types`, `off_cities`, `off_block`, `off_discount_code`, `off_discount_type`, `off_discount_amount`, `off_indte`, `off_ip`) VALUES (14,11,'14',0,'العرض الاول - كوبون خصم 50%','First offer - 50% discount coupon','تفاصيل العرض الاول - كوبون خصم 50%','Details of First offer - 50% discount coupon','1573992712.jpg','6','',0,'111',0,'25','2019-11-17','213.6.243.210'),(21,11,'21',0,'كوبون خصم 20% من متجر الفلاح','20% Discount from Al-Falah','كوبون خصم 20% من متجر الفلاح','20% Discount from Al-Falah','1573992675.jpeg','7','',1,'MLHT98752',0,'10','2019-11-17','213.6.243.210'),(22,12,'22',0,'عرض على مستحضرات التجميل','Offers for All Beauty Products','عرض على مستحضرات التجميل','Offers for all Beauty products','1566431945.jpg','3,9','',0,'fz90',0,'2.5','2019-11-17','213.6.243.210'),(23,12,'23',0,'عرض على مستحضرات التجميل','Offers for All Beauty Products','عرض على مستحضرات التجميل','Offers for all Beauty products','1573992630.jpg','9','',0,'ll30',0,'44','2019-11-17','213.6.243.210'),(25,13,'25',28,'خصم على سيارة موديل 2019 بي ام دبليو\r\n','2019 Car 20% discount','خصم على سيارة موديل 2019 بي ام دبليو التفاصيل','2019 Car 20% discount details','1567336134.png','1','',0,'BMW20100D',0,'20','2019-09-01','::1'),(29,12,'29',20020,'عرض على مستحضرات التجميل','Offers for All Beauty Products','عرض على مستحضرات التجميل','Offers for all Beauty products','1568473244.png','3','',0,'qo10',0,'15','2019-11-17','213.6.243.210'),(31,39,'31',1000,'عرض على كافة الملابس داخل المعرض','Offers for All dress on shop','عرض على كافة الملابس داخل المعرض','Offers for All dress on shop','1573992516.jpeg','3,4','',0,'Cgep40I15f',0,'20','2019-11-17','213.6.243.210'),(34,12,'34',0,'عرض على مستحضرات التجميل','Offers for All Beauty Products','عرض على مستحضرات التجميل','Offers for All Beauty Products','1573992428.jpg','3,9','2,3',0,'pt73',0,'22','2019-11-17','213.6.243.210'),(37,51,'37',0,'عرض على جميع الحلويات داخل المعرض','Offers for All Cake','عرض على جميع الحلويات داخل المعرض','Offers for All Cake','1573992384.jpeg','22','2',0,'F77',0,'10','2019-11-17','213.6.243.210'),(39,12,'',0,'عرض على مستحضرات التجميل','عرض على مستحضرات التجميل','Offers for all Beauty products','Offers for all Beauty products','1573992310.jpg','3','2',0,'wr46',0,'44','2019-11-17','213.6.243.210'),(41,56,'',0,'موسم الرياض','Half price','الله كريم','Rezq','1573992213.jpg','1','2',0,'re72',0,'25','2019-11-17','213.6.243.210'),(42,59,'',0,'خصم','Nn','بب','Nn','','5,9','2',0,'tn82',0,'20','2019-12-09','95.184.102.139'),(43,60,'',0,'اطعمة صحية','Healthy foods','خصم علئ الأطعمة الصحية','Discount on healthy foods','','6','2',0,'100060',0,'22','2019-12-09','51.253.92.185'),(44,69,'',0,'تخفيضات من 50 % الى 70 % على جميع البضاعه','sale 50% to 70%','خصم ثابت','sale','','2,3,4','1,2,3',0,'لا يوجد',0,'60','2019-12-22','176.19.187.214');
180/*!40000 ALTER TABLE `offers` ENABLE KEYS */;
181UNLOCK TABLES;
182
183--
184-- Table structure for table `types`
185--
186
187DROP TABLE IF EXISTS `types`;
188/*!40101 SET @saved_cs_client = @@character_set_client */;
189/*!40101 SET character_set_client = utf8 */;
190CREATE TABLE `types` (
191 `ty_id` int(11) NOT NULL AUTO_INCREMENT,
192 `ty_name_1` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
193 `ty_name_2` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
194 `ty_indte` datetime NOT NULL,
195 `ty_inusr` int(11) NOT NULL,
196 `ty_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
197 PRIMARY KEY (`ty_id`)
198) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
199/*!40101 SET character_set_client = @saved_cs_client */;
200
201--
202-- Dumping data for table `types`
203--
204
205LOCK TABLES `types` WRITE;
206/*!40000 ALTER TABLE `types` DISABLE KEYS */;
207INSERT INTO `types` (`ty_id`, `ty_name_1`, `ty_name_2`, `ty_indte`, `ty_inusr`, `ty_ip`) VALUES (1,'سيارة وملحقاتها','Car and Accessories','2019-10-21 18:41:39',21,'188.161.159.240'),(2,'ملابس رجاليه','Men Clothes','2019-10-21 18:41:53',21,'188.161.159.240'),(3,'ملابس النساء','Women Clothes','2019-10-21 18:42:04',21,'188.161.159.240'),(4,'ملابس الاطفال','Kids Clothes','2019-10-21 18:42:29',21,'188.161.159.240'),(5,'الملابس والاكسسوارات','Clothes and Accessories','2019-10-21 18:42:41',21,'188.161.159.240'),(6,'الأطعمة','Foods','2019-10-21 18:42:57',21,'188.161.159.240'),(7,'المعدات والأدوات والمعدات والملحقات','Equipment, tools, equipment and accessories','2019-10-21 18:43:09',21,'188.161.159.240'),(9,'أدوات التجميل','Beauty tools','2019-10-21 18:43:21',21,'188.161.159.240'),(10,'أدوات الكتاب','Book tools','2019-10-21 18:43:38',21,'188.161.159.240'),(11,'كتب','Books','2019-10-21 18:43:51',21,'188.161.159.240'),(12,'جلديات واكسسوارات','Leathers and accessories','2019-10-21 18:44:40',21,'188.161.159.240'),(13,'ورش عمل','Workshops','2019-10-21 18:44:11',21,'188.161.159.240'),(14,'وسائل النقل','Transportation','2019-10-21 18:44:30',21,'188.161.159.240'),(15,'الاتصالات','Communication','2019-10-21 18:44:02',21,'188.161.159.240'),(16,'المستشفيات والخدمات الصحية والمختبرات','Hospitals, health services and laboratories','2019-10-21 18:44:49',21,'188.161.159.240'),(17,'المعادن الثمينة والأحجار','Precious metals and stones','2019-10-21 18:44:21',21,'188.161.159.240'),(18,'الشركات والمؤسسات والمكاتب','Companies, institutions and offices','2019-10-21 18:45:00',21,'188.161.159.240'),(19,'خدمات تجارية','commercial services','2019-10-21 18:45:09',21,'188.161.159.240'),(20,'التصوير والنسخ والمكتبات والمطابع','Photocopying, copying, libraries, printing presses','2019-10-21 18:45:18',21,'188.161.159.240'),(21,'الزراعة والحيوانات','Agriculture and animals','2019-10-21 18:49:46',21,'188.161.159.240'),(22,'المخبوزات والحلويات والحلويات','Bakery, sweets, and confectionery','2019-10-21 18:45:28',21,'188.161.159.240'),(23,'اللحوم والدواجن والأسماك','Meat, poultry and fish','2019-10-21 18:46:50',21,'188.161.159.240'),(24,'الغذاء والتموين','Food and Catering','2019-10-21 18:46:41',21,'188.161.159.240'),(25,'نشاطات رياضية','sport activities','2019-10-21 18:46:29',21,'188.161.159.240'),(26,'المصانع والتصنيع','Factories and manufacturing','2019-10-21 18:46:21',21,'188.161.159.240'),(27,'أثاث المنزل وملحقاته','Home Furniture & Accessories','2019-10-21 18:46:11',21,'188.161.159.240'),(28,'المستودعات','Warehouses','2019-10-21 18:46:03',21,'188.161.159.240'),(29,'الخدمات التعليمية والتدريبية','Educational and training services','2019-10-21 18:45:54',21,'188.161.159.240'),(30,'شاحنة الغذاء','Food truck','2019-10-21 18:45:44',21,'188.161.159.240'),(31,'العائلات المنتجة','Productive Families','2019-10-21 18:45:36',21,'188.161.159.240');
208/*!40000 ALTER TABLE `types` ENABLE KEYS */;
209UNLOCK TABLES;
210
211--
212-- Table structure for table `usedoffers`
213--
214
215DROP TABLE IF EXISTS `usedoffers`;
216/*!40101 SET @saved_cs_client = @@character_set_client */;
217/*!40101 SET character_set_client = utf8 */;
218CREATE TABLE `usedoffers` (
219 `usd_ofr_id` int(11) NOT NULL AUTO_INCREMENT,
220 `usd_ofr_offer` int(11) NOT NULL,
221 `usd_ofr_invoice` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
222 `usd_ofr_ammount` decimal(10,0) NOT NULL,
223 `usd_ofr_discount_amount` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
224 `usd_ofr_discount_percentage` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
225 `usd_ofr_total_amount` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
226 `usd_ofr_indte` date NOT NULL,
227 `usd_ofr_ip` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
228 PRIMARY KEY (`usd_ofr_id`)
229) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230/*!40101 SET character_set_client = @saved_cs_client */;
231
232--
233-- Dumping data for table `usedoffers`
234--
235
236LOCK TABLES `usedoffers` WRITE;
237/*!40000 ALTER TABLE `usedoffers` DISABLE KEYS */;
238INSERT INTO `usedoffers` (`usd_ofr_id`, `usd_ofr_offer`, `usd_ofr_invoice`, `usd_ofr_ammount`, `usd_ofr_discount_amount`, `usd_ofr_discount_percentage`, `usd_ofr_total_amount`, `usd_ofr_indte`, `usd_ofr_ip`) VALUES (1,14,'522',360,NULL,NULL,NULL,'2019-08-22','::1'),(2,14,'658',1250,NULL,NULL,NULL,'2019-08-22','::1'),(3,22,'6699',3200,NULL,NULL,NULL,'2019-08-22','::1'),(4,24,'2255',500,'9521','165','335','2019-09-06',''),(5,24,'2255',500,'165','33','335','2019-09-06',''),(6,24,'2255',500,'165','33','335','2019-09-06',''),(7,24,'2255',500,'165','33','335','2019-09-06',''),(8,24,'2255',500,'165','33','335','2019-09-06',''),(9,24,'2255',500,'165','33','335','2019-09-06',''),(10,24,'2255',500,'165','33','335','2019-09-06',''),(11,24,'2255',500,'165','33','335','2019-09-06',''),(12,14,'2255',500,'125','25','375','2019-09-06',''),(13,14,'2255',500,'125','25','375','2019-09-06',''),(14,14,'2255',500,'125','25','375','2019-09-06',''),(15,24,'2255',500,'165','33','335','2019-09-06',''),(16,14,'2255',500,'125','25','375','2019-09-06',''),(17,14,'2255',500,'125','25','375','2019-09-06',''),(18,14,'2255',500,'125','25','375','2019-09-06',''),(19,24,'2255',500,'165','33','335','2019-09-06',''),(20,24,'2255',500,'165','33','335','2019-09-06',''),(21,24,'2255',500,'165','33','335','2019-09-06',''),(22,14,'324234',320,'80','25','240','2019-09-06',''),(23,14,'23234',230,'57.5','25','172.5','2019-09-06',''),(24,14,'123432',230,'57.5','25','172.5','2019-09-06',''),(25,14,'234234',240,'60','25','180','2019-09-06',''),(26,14,'234324',200,'50','25','150','2019-09-06',''),(27,14,'34234',333,'83.25','25','249.75','2019-09-06',''),(28,14,'467854',120,'30','25','90','2019-09-07',''),(29,22,'Y654',500,'12.5','2.5','487.5','2019-09-07',''),(30,24,'2255',500,'165','33','335','2019-09-07',''),(31,24,'2255',500,'165','33','335','2019-09-07',''),(32,24,'2255',500,'165','33','335','2019-09-07',''),(33,24,'123456789',500,'165','33','335','2019-09-07',''),(34,24,'12345',500,'165','33','335','2019-09-07',''),(35,24,'55555',800,'264','33','536','2019-09-07',''),(36,23,'undefined',0,'0','44','0','2019-09-08',''),(37,24,'2255',500,'165','33','335','2019-09-08',''),(38,27,'undefined',0,'0','','0','2019-09-08',''),(39,27,'undefined',0,'0','','0','2019-09-08',''),(40,28,'44',20,'4','20','16','2019-09-08',''),(41,28,'77',520,'104','20','416','2019-09-08',''),(42,28,'34234234',345,'69','20','276','2019-09-08',''),(43,28,'34234234',345,'69','20','276','2019-09-08',''),(44,28,'324234',324234324,'64846864.8','20','259387459.2','2019-09-08',''),(45,14,'334234',3434,'858.5','25','2575.5','2019-09-08',''),(46,32,'8897',230,'115','50','115','2019-10-04',''),(47,32,'667',600,'300','50','300','2019-10-04',''),(48,31,'55',12000,'2400','20','9600','2019-10-23',''),(49,31,'55',33,'6.6','20','26.4','2019-10-23',''),(50,35,'٧٦٥',5500,'2750','50','2750','2019-10-25',''),(51,37,'Yy',100,'10','10','90','2019-10-26',''),(52,14,'234234',450,'112.5','25','337.5','2019-11-04',''),(53,14,'01234',540,'135','25','405','2019-11-04',''),(54,14,'01234',320,'80','25','240','2019-11-04',''),(55,14,'01234',20,'5','25','15','2019-11-04',''),(56,14,'10',450,'112.5','25','337.5','2019-11-04',''),(57,14,'30055',456,'114','25','342','2019-11-04',''),(58,21,'30167',656,'65.6','10','590.4','2019-11-04',''),(59,40,'31505',500,'165','33','335','2019-11-06',''),(60,41,'15950',66,'16.5','25','49.5','2019-11-06',''),(61,41,'34087',200,'50','25','150','2019-11-21',''),(62,41,'5965',100,'25','25','75','2019-11-22',''),(63,41,'23768',500,'125','25','375','2019-11-26',''),(64,41,'17679',111222,'27805.5','25','83416.5','2019-12-01',''),(65,41,'32223',111222,'27805.5','25','83416.5','2019-12-01',''),(66,42,'13292',340,'68','20','272','2019-12-09',''),(67,43,'21926',400,'88','22','312','2019-12-09',''),(68,43,'6178',244,'53.68','22','190.32','2019-12-09',''),(69,43,'32509',2000000,'440000','22','1560000','2019-12-09',''),(70,43,'27604',9999999999,'2.2E+19','22','7.8E+19','2019-12-09',''),(71,43,'27420',300,'66','22','234','2019-12-09',''),(72,43,'6201',4000,'880','22','3120','2019-12-12',''),(73,43,'13992',1000,'220','22','780','2019-12-17','');
239/*!40000 ALTER TABLE `usedoffers` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `users`
244--
245
246DROP TABLE IF EXISTS `users`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `users` (
250 `usr_id` int(11) NOT NULL AUTO_INCREMENT,
251 `usr_account` int(11) NOT NULL,
252 `usr_username` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
253 `usr_password` mediumtext COLLATE utf8_unicode_ci NOT NULL,
254 `usr_password_txt` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
255 `usr_block` int(11) NOT NULL,
256 `usr_current_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
257 `usr_last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
258 PRIMARY KEY (`usr_id`),
259 UNIQUE KEY `usr_username` (`usr_username`)
260) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
261/*!40101 SET character_set_client = @saved_cs_client */;
262
263--
264-- Dumping data for table `users`
265--
266
267LOCK TABLES `users` WRITE;
268/*!40000 ALTER TABLE `users` DISABLE KEYS */;
269INSERT INTO `users` (`usr_id`, `usr_account`, `usr_username`, `usr_password`, `usr_password_txt`, `usr_block`, `usr_current_login`, `usr_last_login`) VALUES (21,0,'admin','e10adc3949ba59abbe56e057f20f883e','',0,'2020-06-11 17:09:12','2020-05-05 19:10:02'),(22,0,'admin2','7a5a81291b1b19f27db77a51995a44b4','',0,'2019-06-27 21:07:03','2019-06-27 20:48:09'),(23,1,'jameel','12345','',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,11,'aaa111','e10adc3949ba59abbe56e057f20f883e','',0,'2019-10-31 00:13:44','2019-08-21 21:47:50'),(32,12,'bdoor','e10adc3949ba59abbe56e057f20f883e','',0,'2019-10-31 00:15:45','2019-10-24 16:49:21'),(33,13,'bmw','e10adc3949ba59abbe56e057f20f883e','',0,'2019-09-01 12:11:54','2019-09-01 12:09:07'),(34,15,'extra','e10adc3949ba59abbe56e057f20f883e','',0,'2019-11-03 03:49:02','2019-09-19 14:28:10'),(36,18,'majid','2b792dabb4328a140caef066322c49ff','',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,21,'wael','e10adc3949ba59abbe56e057f20f883e','',0,'2019-09-22 09:01:42','0000-00-00 00:00:00'),(46,29,'aa','4124bc0a9335c27f086f24ba207a4912','aa',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(48,31,'Neveen','e10adc3949ba59abbe56e057f20f883e','123456',0,'2019-09-25 17:16:51','2019-09-24 16:20:18'),(52,36,'wael45','51802e059b5dc435495f8cc9abe8679a','wael1234',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(55,39,'bazar','e10adc3949ba59abbe56e057f20f883e','123456',0,'2019-10-01 01:01:41','2019-10-01 01:01:06'),(56,41,'jamjam','e10adc3949ba59abbe56e057f20f883e','123456',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(64,51,'wow11','8d70d8ab2768f232ebe874175065ead3','1234566',0,'2019-10-30 14:03:41','2019-10-28 14:27:52'),(69,56,'Rezq','e10adc3949ba59abbe56e057f20f883e','123456',0,'2019-11-17 13:10:34','2019-11-11 12:42:23'),(70,57,'Deeo','25d55ad283aa400af464c76d713c07ad','12345678',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(71,58,'dee23','fcea920f7412b5da7be0cf42b8c93759','1234567',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(72,59,'Taleen','2b792dabb4328a140caef066322c49ff','445566',0,'2019-12-15 20:00:05','2019-12-15 17:42:34'),(73,60,'Yazeed','7b156bf942f20c70e77abb3f054c9340','Asdfghjkl',0,'2019-12-09 17:46:30','2019-12-09 17:40:01'),(76,64,'Ali','f96e0286f049bd92b804e1237b97c064','Yazeed11',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(77,65,'ايمي','469b9117094aae82feac3101a5ac2be3','333e4',0,'2019-12-17 20:28:16','2019-12-17 20:25:07'),(78,66,'abtsam11919','5f27326f582949e3c7f8accf6984008b','0532612090',0,'2019-12-18 19:32:45','0000-00-00 00:00:00'),(79,67,'nykasem','64d3b31f20ea14865a10f4a5ccbe5865','2600465nabil',0,'2019-12-19 20:56:14','0000-00-00 00:00:00'),(80,68,'Aziz','9293e910395ea1e6762de2e00e43abd9','rojzuz-6bivgy-mohvEc',0,'2019-12-22 08:50:28','0000-00-00 00:00:00'),(81,69,'csmdb','2958aa0d8b008fee9bf94afa40cdaf66','AbA654321',0,'2019-12-22 15:23:38','2019-12-22 15:23:08'),(82,70,'Abduallah','de5649948f17fb28f7bf17317a30c986','abduallah7005',0,'2019-12-25 19:05:24','0000-00-00 00:00:00'),(84,72,'neveena','e10adc3949ba59abbe56e057f20f883e','123456',0,'2020-01-14 08:20:16','2020-01-13 17:25:07'),(85,73,'','d41d8cd98f00b204e9800998ecf8427e','',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(86,74,'ammar3408','e4fd911e686630020a2ff46d38f2d559','ammar3408',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(87,75,'appleworld786','35d1278dfe706aa728664e1eec7298a0','Apple1515',0,'2020-09-25 08:58:58','2020-09-25 08:58:03');
270/*!40000 ALTER TABLE `users` ENABLE KEYS */;
271UNLOCK TABLES;
272
273--
274-- Dumping events for database 'blackc_mstr2'
275--
276
277--
278-- Dumping routines for database 'blackc_mstr2'
279--
280/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
281
282/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
283/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
284/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
285/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
286/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
287/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
288/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
289
290-- Dump completed on 2020-12-09 12:36:36
291