forked from itswadesh/angularcode-datagrid
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdummy_data.sql
More file actions
73 lines (66 loc) · 7.43 KB
/
Copy pathdummy_data.sql
File metadata and controls
73 lines (66 loc) · 7.43 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
CREATE DATABASE IF NOT EXISTS csvdb;
USE csvdb;
--
-- Database: `csvdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `csvdata`
--
CREATE TABLE IF NOT EXISTS `csvdata` (
`AUDITID` VARCHAR(20) CHARACTER SET utf8mb4 NOT NULL,
`USERID` VARCHAR(20) CHARACTER SET utf8mb4,
`ACTIVITYDATE` DATETIME,
`ACTIVITYTYPE` VARCHAR(20) CHARACTER SET utf8mb4,
`DOCUMENT` VARCHAR(30) CHARACTER SET utf8mb4,
`DOCUMENTLINE` INT,
`CONSIGNEE` VARCHAR(20) CHARACTER SET utf8mb4,
`SKU` VARCHAR(50) CHARACTER SET utf8mb4,
`FROMLOAD` VARCHAR(20) CHARACTER SET utf8mb4,
`TOLOAD` VARCHAR(20) CHARACTER SET utf8mb4,
`FROMSTATUS` VARCHAR(20) CHARACTER SET utf8mb4,
`TOSTATUS` VARCHAR(20) CHARACTER SET utf8mb4,
`FROMLOC` VARCHAR(20) CHARACTER SET utf8mb4,
`TOLOC` VARCHAR(20) CHARACTER SET utf8mb4,
`FROMQTY` NUMERIC(18, 4),
`TOQTY` NUMERIC(18, 4),
`ACTIVITYTIME` INT,
`MHEID` VARCHAR(20) CHARACTER SET utf8mb4,
`TERMINALTYPE` VARCHAR(20) CHARACTER SET utf8mb4,
`FROMCONTAINER` VARCHAR(20) CHARACTER SET utf8mb4,
`TOCONTAINER` VARCHAR(20) CHARACTER SET utf8mb4,
`YARDEQUIPMENTID` VARCHAR(20) CHARACTER SET utf8mb4,
`SEAL1` VARCHAR(20) CHARACTER SET utf8mb4,
`SEAL2` VARCHAR(20) CHARACTER SET utf8mb4,
`DRIVER1` VARCHAR(20) CHARACTER SET utf8mb4,
`DRIVER2` VARCHAR(20) CHARACTER SET utf8mb4,
`CARRIER` VARCHAR(20) CHARACTER SET utf8mb4,
`DOOR` VARCHAR(20) CHARACTER SET utf8mb4,
`NOTES` VARCHAR(255) CHARACTER SET utf8mb4,
`ADDDATE` DATETIME NOT NULL,
`ADDUSER` VARCHAR(20) CHARACTER SET utf8mb4,
`EDITDATE` DATETIME NOT NULL,
`EDITUSER` VARCHAR(20) CHARACTER SET utf8mb4
);
--
-- Dumping data for table `csvdata`
--
INSERT INTO `csvdata` (`AUDITID`, `USERID`, `ACTIVITYDATE`, `ACTIVITYTYPE`, `DOCUMENT`, `DOCUMENTLINE`, `CONSIGNEE`, `SKU`, `FROMLOAD`, `TOLOAD`, `FROMSTATUS`, `TOSTATUS`, `FROMLOC`, `TOLOC`, `FROMQTY`, `TOQTY`, `ACTIVITYTIME`, `MHEID`, `TERMINALTYPE`, `FROMCONTAINER`, `TOCONTAINER`, `YARDEQUIPMENTID`, `SEAL1`, `SEAL2`, `DRIVER1`, `DRIVER2`, `CARRIER`, `DOOR`, `NOTES`, `ADDDATE`, `ADDUSER`, `EDITDATE`, `EDITUSER`) VALUES (0001981581,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-14 22:19:32.323000000',NULL,'2017-07-14 22:19:32.323000000',NULL),
(0001981582,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-14 23:32:01.937000000',NULL,'2017-07-14 23:32:01.937000000',NULL),
(0001981583,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-15 06:25:57.600000000',NULL,'2017-07-15 06:25:57.600000000',NULL),
(0001981584,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-15 13:19:31.743000000',NULL,'2017-07-15 13:19:31.743000000',NULL),
(0001981585,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-15 21:25:57.600000000',NULL,'2017-07-15 21:25:57.600000000',NULL),
(0001981586,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 04:19:31.767000000',NULL,'2017-07-16 04:19:31.767000000',NULL),
(0001981587,'oleg','2017-07-16 06:15:45','TASKASGN','TS00057010',0,NULL,NULL,NULL,NULL,'ASSIGNED','ASSIGNED',NULL,NULL,.0000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 06:15:45.443000000',NULL,'2017-07-16 06:15:45.443000000',NULL),
(0001981588,'oleg','2017-07-16 06:15:50','TASKUPD','TS00057010',0,NULL,NULL,NULL,NULL,'ASSIGNED','ASSIGNED',NULL,NULL,.0000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 06:15:50.330000000',NULL,'2017-07-16 06:15:50.330000000',NULL),
(0001981589,'oleg','2017-07-16 06:28:32','CONTINS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 06:28:32.913000000',NULL,'2017-07-16 06:28:32.913000000',NULL),
(0001982679,'shamil','2017-07-16 12:33:05','PICKLOAD','P000042883',8,'SH',3900,01000000000000059891,01000000000000089674,'AVAILABLE','AVAILABLE','AA21A1','AA21A1',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.020000000',NULL,'2017-07-16 12:33:06.020000000',NULL),
(0001982680,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',9,'SH',500,01000000000000079492,01000000000000089675,'AVAILABLE','AVAILABLE','RL01','RL01',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.123000000',NULL,'2017-07-16 12:33:06.123000000',NULL),
(0001982681,'shamil','2017-07-16 12:33:06','SUBQTY','0000001592',1,'SH',9300,01000000000000083469,01000000000000083469,'AVAILABLE','AVAILABLE','RL01','RL01',1.0000,.0000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.180000000',NULL,'2017-07-16 12:33:06.180000000',NULL),
(0001982682,'shamil','2017-07-16 12:33:06','ADDQTY','0000001592',1,'SH',9300,01000000000000083469,01000000000000083469,'AVAILABLE','AVAILABLE','RL01','RL01',.0000,1.0000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.200000000',NULL,'2017-07-16 12:33:06.200000000',NULL),
(0001982683,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',10,'SH',9300,01000000000000083469,01000000000000083469,'AVAILABLE','AVAILABLE','RL01','RL01',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.470000000',NULL,'2017-07-16 12:33:06.470000000',NULL),
(0001982684,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',11,'SH',9301,01000000000000083482,01000000000000089676,'AVAILABLE','AVAILABLE','RL01','RL01',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.670000000',NULL,'2017-07-16 12:33:06.670000000',NULL),
(0001982685,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',12,'SH',4626,01000000000000087929,01000000000000089677,'AVAILABLE','AVAILABLE','AB23A2','AB23A2',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.757000000',NULL,'2017-07-16 12:33:06.757000000',NULL),
(0001982686,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',13,'SH',6633,01000000000000081692,01000000000000089678,'AVAILABLE','AVAILABLE','AB26A2','AB26A2',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.857000000',NULL,'2017-07-16 12:33:06.857000000',NULL),
(0001982687,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',14,'SH',7900,01000000000000087927,01000000000000089679,'AVAILABLE','AVAILABLE','AC01A1','AC01A1',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:06.943000000',NULL,'2017-07-16 12:33:06.943000000',NULL),
(0001982688,'shamil','2017-07-16 12:33:06','PICKLOAD','P000042883',15,'SH',5004,01000000000000077597,01000000000000089680,'AVAILABLE','AVAILABLE','AC03A1','AC03A1',1.0000,1.0000,0,NULL,NULL,NULL,'CT000000000000041246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-16 12:33:07.030000000',NULL,'2017-07-16 12:33:07.030000000',NULL);