2s2dZH9w

1-- MySQL dump 10.13  Distrib 5.6.26, for Win64 (x86_64)
2--
3-- Host: localhost    Database: russia_express
4-- ------------------------------------------------------
5-- Server version	5.6.26-log
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 utf8 */;
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`
20--
21
22DROP TABLE IF EXISTS `account`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account` (
26  `account_id` int(11) NOT NULL AUTO_INCREMENT,
27  `user_name` varchar(45) DEFAULT NULL,
28  `password` varchar(45) DEFAULT NULL,
29  `first_name` varchar(100) DEFAULT NULL,
30  `last_name` varchar(100) DEFAULT NULL,
31  `phone` varchar(45) DEFAULT NULL,
32  `email` varchar(100) DEFAULT NULL,
33  `passport_no` varchar(100) DEFAULT NULL,
34  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
35  `last_update` datetime DEFAULT CURRENT_TIMESTAMP,
36  `created_by` int(11) DEFAULT NULL,
37  `updated_by` int(11) DEFAULT NULL,
38  `is_deleted` char(1) DEFAULT 'N',
39  PRIMARY KEY (`account_id`)
40) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `account`
45--
46
47LOCK TABLES `account` WRITE;
48/*!40000 ALTER TABLE `account` DISABLE KEYS */;
49INSERT INTO `account` VALUES (1,'cuong','123456','cuong','nguyen','0943012214','cuong@gmail.com','123456','2016-01-19 15:52:28','2016-01-19 15:52:28',NULL,NULL,'N'),(2,'mika','123456','Mika',NULL,'+79686834727','ngb.mika@gmail.com',NULL,'2016-02-29 21:03:36','2016-02-29 21:03:36',NULL,NULL,'N'),(3,'mrdzung','123456','Dzung','Mr','+79660387887','mr.Dzung@qq.com',NULL,'2016-02-29 21:03:37','2016-02-29 21:03:37',NULL,NULL,'N'),(4,'mrtien','123456','Tien','Doan Tran',NULL,'doantrantien@gmail.com',NULL,'2016-02-29 21:06:07','2016-02-29 21:06:07',NULL,NULL,'N'),(5,'mrminh','123456','Minh','Trinh','+79257171368','trinhminh1368@gmail.com',NULL,'2016-02-29 21:06:07','2016-02-29 21:06:07',NULL,NULL,'N'),(6,'mrislamov','123456',NULL,NULL,NULL,'islamov290292@qq.com',NULL,'2016-02-29 21:06:07','2016-02-29 21:06:07',NULL,NULL,'N'),(7,'mrkudrad','123456',NULL,NULL,NULL,'kudrad705@163.com',NULL,'2016-02-29 21:06:07','2016-02-29 21:06:07',NULL,NULL,'N'),(8,'vita','123456',NULL,NULL,NULL,'vita007.66@mail.ru',NULL,'2016-02-29 21:06:07','2016-02-29 21:06:07',NULL,NULL,'N');
50/*!40000 ALTER TABLE `account` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `account_role`
55--
56
57DROP TABLE IF EXISTS `account_role`;
58/*!40101 SET @saved_cs_client     = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `account_role` (
61  `account_id` int(11) DEFAULT NULL,
62  `role_id` int(11) DEFAULT NULL,
63  KEY `FK_ar_account_id_idx` (`account_id`),
64  KEY `FK_ar_role_id_idx` (`role_id`),
65  CONSTRAINT `FK_ar_account_id` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
66  CONSTRAINT `FK_ar_role_id` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
67) ENGINE=InnoDB DEFAULT CHARSET=utf8;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `account_role`
72--
73
74LOCK TABLES `account_role` WRITE;
75/*!40000 ALTER TABLE `account_role` DISABLE KEYS */;
76INSERT INTO `account_role` VALUES (1,1),(2,3),(3,3),(4,3),(5,3),(6,1),(7,1),(8,2);
77/*!40000 ALTER TABLE `account_role` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `account_warehouse`
82--
83
84DROP TABLE IF EXISTS `account_warehouse`;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `account_warehouse` (
88  `account_id` int(11) DEFAULT NULL,
89  `warehouse_id` int(11) DEFAULT NULL,
90  KEY `FK_aw_account_id_idx` (`account_id`),
91  KEY `FK_aw_warehouse_id_idx` (`warehouse_id`),
92  CONSTRAINT `FK_aw_account_id` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
93  CONSTRAINT `FK_aw_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouse` (`warehouse_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
94) ENGINE=InnoDB DEFAULT CHARSET=utf8;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `account_warehouse`
99--
100
101LOCK TABLES `account_warehouse` WRITE;
102/*!40000 ALTER TABLE `account_warehouse` DISABLE KEYS */;
103INSERT INTO `account_warehouse` VALUES (1,1),(2,3),(3,3),(4,3),(5,3),(6,4),(7,5),(8,6);
104/*!40000 ALTER TABLE `account_warehouse` ENABLE KEYS */;
105UNLOCK TABLES;
106
107--
108-- Table structure for table `container`
109--
110
111DROP TABLE IF EXISTS `container`;
112/*!40101 SET @saved_cs_client     = @@character_set_client */;
113/*!40101 SET character_set_client = utf8 */;
114CREATE TABLE `container` (
115  `container_id` int(11) NOT NULL AUTO_INCREMENT,
116  `driver_name` varchar(100) DEFAULT NULL,
117  `invoice_id` int(11) DEFAULT NULL,
118  `merchandise_id` int(11) DEFAULT NULL,
119  `container_base_id` int(11) DEFAULT NULL,
120  `is_deleted` char(1) DEFAULT 'N',
121  PRIMARY KEY (`container_id`),
122  KEY `FK_container_base_id_idx` (`container_base_id`),
123  CONSTRAINT `FK_container_base_id` FOREIGN KEY (`container_base_id`) REFERENCES `container_base` (`container_base_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
124) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
125/*!40101 SET character_set_client = @saved_cs_client */;
126
127--
128-- Dumping data for table `container`
129--
130
131LOCK TABLES `container` WRITE;
132/*!40000 ALTER TABLE `container` DISABLE KEYS */;
133INSERT INTO `container` VALUES (3,NULL,1,1,2,NULL),(4,NULL,1,2,2,NULL);
134/*!40000 ALTER TABLE `container` ENABLE KEYS */;
135UNLOCK TABLES;
136
137--
138-- Table structure for table `container_base`
139--
140
141DROP TABLE IF EXISTS `container_base`;
142/*!40101 SET @saved_cs_client     = @@character_set_client */;
143/*!40101 SET character_set_client = utf8 */;
144CREATE TABLE `container_base` (
145  `container_base_id` int(11) NOT NULL AUTO_INCREMENT,
146  `driver_name` varchar(100) DEFAULT NULL,
147  `driver_license_plate` varchar(100) DEFAULT NULL,
148  `driver_contact` varchar(100) DEFAULT NULL,
149  `automobile_id` varchar(50) DEFAULT NULL,
150  `pre_serie` varchar(45) DEFAULT NULL,
151  `suf_serie` int(11) DEFAULT NULL,
152  `way_path` varchar(500) DEFAULT NULL,
153  `created_by` int(11) DEFAULT NULL,
154  `updated_by` int(11) DEFAULT NULL,
155  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
156  `last_update` datetime DEFAULT CURRENT_TIMESTAMP,
157  `est_date` datetime DEFAULT NULL,
158  `is_deleted` char(1) DEFAULT 'N',
159  PRIMARY KEY (`container_base_id`)
160) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `container_base`
165--
166
167LOCK TABLES `container_base` WRITE;
168/*!40000 ALTER TABLE `container_base` DISABLE KEYS */;
169INSERT INTO `container_base` VALUES (1,'d1','d1','d1','China11','China1',1,NULL,NULL,5,'2016-03-14 17:00:56','2016-03-14 17:00:56','0001-01-01 00:00:00','N'),(2,'d2','d2','d2','China12','China1',2,NULL,1,1,'2016-03-15 18:09:50','2016-03-15 18:09:50','0001-01-01 00:00:00',NULL);
170/*!40000 ALTER TABLE `container_base` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `customer`
175--
176
177DROP TABLE IF EXISTS `customer`;
178/*!40101 SET @saved_cs_client     = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `customer` (
181  `customer_id` int(11) NOT NULL AUTO_INCREMENT,
182  `name` varchar(200) DEFAULT NULL,
183  `phone` varchar(20) DEFAULT NULL,
184  `passport_no` varchar(100) DEFAULT NULL,
185  `is_deleted` char(1) DEFAULT 'N',
186  `created_by` int(11) DEFAULT NULL,
187  `updated_by` int(11) DEFAULT NULL,
188  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
189  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP,
190  PRIMARY KEY (`customer_id`)
191) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
192/*!40101 SET character_set_client = @saved_cs_client */;
193
194--
195-- Dumping data for table `customer`
196--
197
198LOCK TABLES `customer` WRITE;
199/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
200INSERT INTO `customer` VALUES (1,'Hong Son 2','66666','77777','N',NULL,NULL,'2016-01-19 22:56:32','2016-01-19 22:56:32'),(2,'Viet Cuong','55555','66666','N',NULL,NULL,'2016-01-19 22:56:32','2016-01-19 22:56:32');
201/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
202UNLOCK TABLES;
203
204--
205-- Table structure for table `field`
206--
207
208DROP TABLE IF EXISTS `field`;
209/*!40101 SET @saved_cs_client     = @@character_set_client */;
210/*!40101 SET character_set_client = utf8 */;
211CREATE TABLE `field` (
212  `field_id` int(11) NOT NULL,
213  `field_name` varchar(45) DEFAULT NULL,
214  PRIMARY KEY (`field_id`)
215) ENGINE=InnoDB DEFAULT CHARSET=utf8;
216/*!40101 SET character_set_client = @saved_cs_client */;
217
218--
219-- Dumping data for table `field`
220--
221
222LOCK TABLES `field` WRITE;
223/*!40000 ALTER TABLE `field` DISABLE KEYS */;
224/*!40000 ALTER TABLE `field` ENABLE KEYS */;
225UNLOCK TABLES;
226
227--
228-- Table structure for table `file_upload`
229--
230
231DROP TABLE IF EXISTS `file_upload`;
232/*!40101 SET @saved_cs_client     = @@character_set_client */;
233/*!40101 SET character_set_client = utf8 */;
234CREATE TABLE `file_upload` (
235  `file_upload_id` int(11) NOT NULL AUTO_INCREMENT,
236  `file_name` varchar(200) DEFAULT NULL,
237  `validation_message` varchar(500) DEFAULT NULL,
238  `is_deleted` char(1) DEFAULT NULL,
239  PRIMARY KEY (`file_upload_id`)
240) ENGINE=InnoDB DEFAULT CHARSET=utf8;
241/*!40101 SET character_set_client = @saved_cs_client */;
242
243--
244-- Dumping data for table `file_upload`
245--
246
247LOCK TABLES `file_upload` WRITE;
248/*!40000 ALTER TABLE `file_upload` DISABLE KEYS */;
249/*!40000 ALTER TABLE `file_upload` ENABLE KEYS */;
250UNLOCK TABLES;
251
252--
253-- Table structure for table `form`
254--
255
256DROP TABLE IF EXISTS `form`;
257/*!40101 SET @saved_cs_client     = @@character_set_client */;
258/*!40101 SET character_set_client = utf8 */;
259CREATE TABLE `form` (
260  `form_id` int(11) NOT NULL AUTO_INCREMENT,
261  `form_name` varchar(45) DEFAULT NULL,
262  PRIMARY KEY (`form_id`)
263) ENGINE=InnoDB DEFAULT CHARSET=utf8;
264/*!40101 SET character_set_client = @saved_cs_client */;
265
266--
267-- Dumping data for table `form`
268--
269
270LOCK TABLES `form` WRITE;
271/*!40000 ALTER TABLE `form` DISABLE KEYS */;
272/*!40000 ALTER TABLE `form` ENABLE KEYS */;
273UNLOCK TABLES;
274
275--
276-- Table structure for table `form_field`
277--
278
279DROP TABLE IF EXISTS `form_field`;
280/*!40101 SET @saved_cs_client     = @@character_set_client */;
281/*!40101 SET character_set_client = utf8 */;
282CREATE TABLE `form_field` (
283  `form_id` int(11) DEFAULT NULL,
284  `field_id` int(11) DEFAULT NULL
285) ENGINE=InnoDB DEFAULT CHARSET=utf8;
286/*!40101 SET character_set_client = @saved_cs_client */;
287
288--
289-- Dumping data for table `form_field`
290--
291
292LOCK TABLES `form_field` WRITE;
293/*!40000 ALTER TABLE `form_field` DISABLE KEYS */;
294/*!40000 ALTER TABLE `form_field` ENABLE KEYS */;
295UNLOCK TABLES;
296
297--
298-- Table structure for table `invoice`
299--
300
301DROP TABLE IF EXISTS `invoice`;
302/*!40101 SET @saved_cs_client     = @@character_set_client */;
303/*!40101 SET character_set_client = utf8 */;
304CREATE TABLE `invoice` (
305  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
306  `source_location` varchar(45) DEFAULT NULL,
307  `destination_location` varchar(45) DEFAULT NULL,
308  `est_no_of_day` varchar(45) DEFAULT NULL,
309  `customer_id` int(11) DEFAULT NULL,
310  `status` varchar(45) DEFAULT NULL,
311  `file_upload_id` varchar(45) DEFAULT NULL,
312  `account_id` int(11) DEFAULT NULL,
313  `transport_type` varchar(200) DEFAULT NULL,
314  `list_price` decimal(19,2) DEFAULT NULL,
315  `discount_price` decimal(19,2) DEFAULT NULL,
316  `transport_tax` decimal(19,2) DEFAULT NULL,
317  `insurance_price` decimal(19,2) DEFAULT NULL,
318  `additional_price` decimal(19,2) DEFAULT NULL,
319  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
320  `last_update` datetime DEFAULT CURRENT_TIMESTAMP,
321  `created_by` int(11) DEFAULT NULL,
322  `updated_by` int(11) DEFAULT NULL,
323  `is_deleted` char(1) DEFAULT 'N',
324  `receiver_id` int(11) DEFAULT NULL,
325  `store_id` int(11) DEFAULT NULL,
326  `serie` varchar(8) DEFAULT NULL,
327  `invoice_created_date` datetime DEFAULT NULL,
328  `warehouse_id` int(11) DEFAULT NULL,
329  `final_destination` varchar(255) DEFAULT NULL,
330  `pre_serie` varchar(45) DEFAULT NULL,
331  `suf_serie` int(11) DEFAULT NULL,
332  `transport_id` int(11) DEFAULT NULL,
333  `destination_location_id` int(11) DEFAULT NULL,
334  PRIMARY KEY (`invoice_id`),
335  KEY `FK_invoice_customer_id_idx` (`customer_id`),
336  KEY `FK_transport_transport_id_idx` (`transport_id`),
337  CONSTRAINT `FK_invoice_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
338  CONSTRAINT `FK_invoice_transport_id` FOREIGN KEY (`transport_id`) REFERENCES `transport` (`transport_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
339) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
340/*!40101 SET character_set_client = @saved_cs_client */;
341
342--
343-- Dumping data for table `invoice`
344--
345
346LOCK TABLES `invoice` WRITE;
347/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
348INSERT INTO `invoice` VALUES (1,'China',NULL,'0',2,NULL,NULL,NULL,NULL,0.00,0.00,0.00,0.00,0.00,'2016-03-11 17:36:31','2016-03-11 17:36:31',1,1,NULL,1,NULL,NULL,'2016-03-11 17:36:14',1,NULL,'Viet Cuong',1,2,3);
349/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
350UNLOCK TABLES;
351
352--
353-- Table structure for table `invoice_warehouse`
354--
355
356DROP TABLE IF EXISTS `invoice_warehouse`;
357/*!40101 SET @saved_cs_client     = @@character_set_client */;
358/*!40101 SET character_set_client = utf8 */;
359CREATE TABLE `invoice_warehouse` (
360  `invoice_id` int(11) DEFAULT NULL,
361  `warehouse_id` int(11) DEFAULT NULL,
362  KEY `FK_iw_warehouse_id_idx` (`warehouse_id`),
363  KEY `FK_invoice_warehouse_invoice_id_idx` (`invoice_id`),
364  CONSTRAINT `FK_invoice_warehouse_invoice_id` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`invoice_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
365  CONSTRAINT `FK_invoice_warehouse_warehouse_id` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouse` (`warehouse_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
366) ENGINE=InnoDB DEFAULT CHARSET=utf8;
367/*!40101 SET character_set_client = @saved_cs_client */;
368
369--
370-- Dumping data for table `invoice_warehouse`
371--
372
373LOCK TABLES `invoice_warehouse` WRITE;
374/*!40000 ALTER TABLE `invoice_warehouse` DISABLE KEYS */;
375/*!40000 ALTER TABLE `invoice_warehouse` ENABLE KEYS */;
376UNLOCK TABLES;
377
378--
379-- Table structure for table `manifest`
380--
381
382DROP TABLE IF EXISTS `manifest`;
383/*!40101 SET @saved_cs_client     = @@character_set_client */;
384/*!40101 SET character_set_client = utf8 */;
385CREATE TABLE `manifest` (
386  `manifest_id` int(11) NOT NULL AUTO_INCREMENT,
387  `automobile_id` varchar(45) DEFAULT NULL,
388  `is_deleted` char(1) DEFAULT 'N',
389  PRIMARY KEY (`manifest_id`)
390) ENGINE=InnoDB DEFAULT CHARSET=utf8;
391/*!40101 SET character_set_client = @saved_cs_client */;
392
393--
394-- Dumping data for table `manifest`
395--
396
397LOCK TABLES `manifest` WRITE;
398/*!40000 ALTER TABLE `manifest` DISABLE KEYS */;
399/*!40000 ALTER TABLE `manifest` ENABLE KEYS */;
400UNLOCK TABLES;
401
402--
403-- Table structure for table `merchandise`
404--
405
406DROP TABLE IF EXISTS `merchandise`;
407/*!40101 SET @saved_cs_client     = @@character_set_client */;
408/*!40101 SET character_set_client = utf8 */;
409CREATE TABLE `merchandise` (
410  `merchandise_id` int(11) NOT NULL AUTO_INCREMENT,
411  `invoice_id` int(11) DEFAULT NULL,
412  `name` varchar(20) DEFAULT NULL,
413  `pic` varchar(100) DEFAULT NULL,
414  `brand_name` varchar(200) DEFAULT NULL,
415  `type` varchar(45) DEFAULT NULL,
416  `package_type` varchar(200) DEFAULT NULL,
417  `no_of_item_in_package` int(11) DEFAULT NULL,
418  `no_of_package` int(11) DEFAULT NULL,
419  `total_item` int(11) DEFAULT NULL,
420  `weight` decimal(19,4) DEFAULT NULL,
421  `volumne` decimal(19,4) DEFAULT NULL,
422  `note` varchar(45) DEFAULT NULL,
423  `file_upload_id` varchar(45) DEFAULT NULL,
424  `clean_price` decimal(19,4) DEFAULT NULL,
425  `code` varchar(500) DEFAULT NULL,
426  `total` decimal(19,4) DEFAULT NULL,
427  `display_order` int(11) DEFAULT NULL,
428  `is_deleted` char(1) DEFAULT 'N',
429  `created_by` int(11) DEFAULT NULL,
430  `updated_by` int(11) DEFAULT NULL,
431  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
432  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP,
433  `size` varchar(255) DEFAULT NULL,
434  `cargo` varchar(45) DEFAULT NULL,
435  `target_warhouseId` int(11) DEFAULT NULL,
436  `status` varchar(45) DEFAULT 'new',
437  `temp_warehouseId` int(11) DEFAULT NULL,
438  PRIMARY KEY (`merchandise_id`),
439  KEY `FK_merchandise_invoice_id_idx` (`invoice_id`),
440  CONSTRAINT `FK_merchandise_invoice_id` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`invoice_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
441) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
442/*!40101 SET character_set_client = @saved_cs_client */;
443
444--
445-- Dumping data for table `merchandise`
446--
447
448LOCK TABLES `merchandise` WRITE;
449/*!40000 ALTER TABLE `merchandise` DISABLE KEYS */;
450INSERT INTO `merchandise` VALUES (1,1,NULL,NULL,'1',NULL,NULL,0,0,NULL,0.0000,0.0000,NULL,NULL,0.0000,NULL,0.0000,1,NULL,NULL,1,'2016-03-11 17:36:31','2016-03-11 17:36:31',NULL,'1',NULL,'on_the_way',3),(2,1,NULL,NULL,'2',NULL,NULL,0,0,NULL,0.0000,0.0000,NULL,NULL,0.0000,NULL,0.0000,2,NULL,NULL,1,'2016-03-11 17:36:31','2016-03-11 17:36:31',NULL,'2',NULL,'on_the_way',3),(3,1,NULL,NULL,'3',NULL,NULL,0,0,NULL,0.0000,0.0000,NULL,NULL,0.0000,NULL,0.0000,3,NULL,NULL,5,'2016-03-11 17:36:31','2016-03-11 17:36:31',NULL,'3',NULL,'completed',3);
451/*!40000 ALTER TABLE `merchandise` ENABLE KEYS */;
452UNLOCK TABLES;
453
454--
455-- Table structure for table `previledge_matrix`
456--
457
458DROP TABLE IF EXISTS `previledge_matrix`;
459/*!40101 SET @saved_cs_client     = @@character_set_client */;
460/*!40101 SET character_set_client = utf8 */;
461CREATE TABLE `previledge_matrix` (
462  `form_id` int(11) DEFAULT NULL,
463  `field_id` int(11) DEFAULT NULL,
464  `role_id` int(11) DEFAULT NULL,
465  `action` varchar(45) DEFAULT NULL
466) ENGINE=InnoDB DEFAULT CHARSET=utf8;
467/*!40101 SET character_set_client = @saved_cs_client */;
468
469--
470-- Dumping data for table `previledge_matrix`
471--
472
473LOCK TABLES `previledge_matrix` WRITE;
474/*!40000 ALTER TABLE `previledge_matrix` DISABLE KEYS */;
475/*!40000 ALTER TABLE `previledge_matrix` ENABLE KEYS */;
476UNLOCK TABLES;
477
478--
479-- Table structure for table `role`
480--
481
482DROP TABLE IF EXISTS `role`;
483/*!40101 SET @saved_cs_client     = @@character_set_client */;
484/*!40101 SET character_set_client = utf8 */;
485CREATE TABLE `role` (
486  `role_id` int(11) NOT NULL AUTO_INCREMENT,
487  `role_name` varchar(45) DEFAULT NULL,
488  `is_deleted` char(1) DEFAULT 'N',
489  PRIMARY KEY (`role_id`)
490) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
491/*!40101 SET character_set_client = @saved_cs_client */;
492
493--
494-- Dumping data for table `role`
495--
496
497LOCK TABLES `role` WRITE;
498/*!40000 ALTER TABLE `role` DISABLE KEYS */;
499INSERT INTO `role` VALUES (1,'Store Manager','N'),(2,'Senior Manager','N'),(3,'Boss','N');
500/*!40000 ALTER TABLE `role` ENABLE KEYS */;
501UNLOCK TABLES;
502
503--
504-- Table structure for table `transport`
505--
506
507DROP TABLE IF EXISTS `transport`;
508/*!40101 SET @saved_cs_client     = @@character_set_client */;
509/*!40101 SET character_set_client = utf8 */;
510CREATE TABLE `transport` (
511  `transport_id` int(11) NOT NULL AUTO_INCREMENT,
512  `name` varchar(45) DEFAULT NULL,
513  PRIMARY KEY (`transport_id`)
514) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
515/*!40101 SET character_set_client = @saved_cs_client */;
516
517--
518-- Dumping data for table `transport`
519--
520
521LOCK TABLES `transport` WRITE;
522/*!40000 ALTER TABLE `transport` DISABLE KEYS */;
523INSERT INTO `transport` VALUES (1,' Z/D'),(2,'AVIA'),(3,'Automobile');
524/*!40000 ALTER TABLE `transport` ENABLE KEYS */;
525UNLOCK TABLES;
526
527--
528-- Table structure for table `warehouse`
529--
530
531DROP TABLE IF EXISTS `warehouse`;
532/*!40101 SET @saved_cs_client     = @@character_set_client */;
533/*!40101 SET character_set_client = utf8 */;
534CREATE TABLE `warehouse` (
535  `warehouse_id` int(11) NOT NULL AUTO_INCREMENT,
536  `name` varchar(100) DEFAULT NULL,
537  `description` varchar(500) DEFAULT NULL,
538  `isdeleted` char(1) DEFAULT 'N',
539  PRIMARY KEY (`warehouse_id`)
540) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
541/*!40101 SET character_set_client = @saved_cs_client */;
542
543--
544-- Dumping data for table `warehouse`
545--
546
547LOCK TABLES `warehouse` WRITE;
548/*!40000 ALTER TABLE `warehouse` DISABLE KEYS */;
549INSERT INTO `warehouse` VALUES (1,'China1','China1','N'),(2,'China2','China2','N'),(3,'Moscow','Moscow','N'),(4,'???','???','N'),(5,'??????','??????','N'),(6,'??????','??????','N');
550/*!40000 ALTER TABLE `warehouse` ENABLE KEYS */;
551UNLOCK TABLES;
552/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
553
554/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
555/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
556/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
557/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
558/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
559/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
560/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
561
562-- Dump completed on 2016-03-15 23:39:06