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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
1646
1647
1648
1649
1650
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
1661
1662
1663
1664
1665
1666
1667
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677
1678
1679
1680
1681
1682
1683
1684
1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
1798
1799
1800
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819
1820
1821
1822
1823
1824
1825
1826
1827
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890
1891
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1924
1925
1926
1927
1928
1929
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
| using System;
| using Microsoft.EntityFrameworkCore.Migrations;
|
| #nullable disable
|
| namespace iWare.Wms.Database.Migrations.Migrations
| {
| public partial class v101 : Migration
| {
| protected override void Up(MigrationBuilder migrationBuilder)
| {
| migrationBuilder.CreateTable(
| name: "sys_app",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Active = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否默认激活"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_app", x => x.Id);
| },
| comment: "系统应用表");
|
| migrationBuilder.CreateTable(
| name: "sys_code_gen",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| AuthorName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "作者姓名"),
| TablePrefix = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否移除表前缀"),
| GenerateType = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "生成方式"),
| DatabaseName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库名"),
| TableName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库表名"),
| NameSpace = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "命名空间"),
| BusName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "业务名"),
| MenuApplication = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "菜单应用分类"),
| MenuPid = table.Column<long>(type: "bigint", nullable: false, comment: "菜单编码"),
| LowCodeId = table.Column<long>(type: "bigint", nullable: true),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_code_gen", x => x.Id);
| },
| comment: "代码生成表");
|
| migrationBuilder.CreateTable(
| name: "sys_code_gen_config",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| CodeGenId = table.Column<long>(type: "bigint", nullable: false, comment: "代码生成主表ID"),
| ColumnName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: false, comment: "数据库字段名"),
| ColumnComment = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "字段描述"),
| NetType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: ".NET数据类型"),
| DtoNetType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: ".NET数据类型(接口传入)"),
| EffectType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "作用类型"),
| FkEntityName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "外键实体名称"),
| FkColumnName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "外键显示字段"),
| FkColumnNetType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "外键显示字段.NET类型"),
| DictTypeCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "字典Code"),
| WhetherRetract = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "列表是否缩进"),
| WhetherRequired = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否必填"),
| QueryWhether = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否是查询条件"),
| QueryType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "查询方式"),
| WhetherTable = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "列表显示"),
| WhetherOrderBy = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "列表是否排序"),
| WhetherAddUpdate = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "增改"),
| ColumnKey = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "主键"),
| DataType = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: true, comment: "数据库中类型"),
| WhetherCommon = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否通用字段"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_code_gen_config", x => x.Id);
| },
| comment: "代码生成字段配置表");
|
| migrationBuilder.CreateTable(
| name: "sys_code_modular",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| AuthorName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "作者姓名"),
| DatabaseName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库名"),
| NameSpace = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "命名空间"),
| BusName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "业务名"),
| MenuApplication = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "菜单应用分类"),
| MenuPid = table.Column<long>(type: "bigint", nullable: false, comment: "菜单编码"),
| FormDesignJson = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "动态表单"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_code_modular", x => x.Id);
| },
| comment: "动态生成模块管理表");
|
| migrationBuilder.CreateTable(
| name: "sys_config",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Name = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Value = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "属性值"),
| SysFlag = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否是系统参数"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| GroupCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "常量所属分类的编码"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_config", x => x.Id);
| },
| comment: "参数配置表");
|
| migrationBuilder.CreateTable(
| name: "sys_dict_type",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Name = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_dict_type", x => x.Id);
| },
| comment: "字典类型表");
|
| migrationBuilder.CreateTable(
| name: "sys_emp",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "用户Id"),
| JobNum = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true, comment: "工号"),
| OrgId = table.Column<long>(type: "bigint", nullable: false, comment: "机构Id"),
| OrgName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "机构名称")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_emp", x => x.Id);
| },
| comment: "员工表");
|
| migrationBuilder.CreateTable(
| name: "sys_file",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| FileLocation = table.Column<int>(type: "int", nullable: false, comment: "文件存储位置"),
| FileBucket = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "文件仓库"),
| FileOriginName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "文件名称"),
| FileSuffix = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "文件后缀"),
| FileSizeKb = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "文件大小kb"),
| FileSizeInfo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "文件大小信息"),
| FileObjectName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "存储到bucket的名称"),
| FilePath = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "存储路径"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_file", x => x.Id);
| },
| comment: "文件信息表");
|
| migrationBuilder.CreateTable(
| name: "sys_forms",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Title = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "标题"),
| FormJson = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "form表单Json"),
| Publish = table.Column<bool>(type: "bit", nullable: false, comment: "是否发布"),
| TypeId = table.Column<long>(type: "bigint", nullable: false, comment: "表单类型ID"),
| Version = table.Column<int>(type: "int", nullable: false, comment: "版本"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_forms", x => x.Id);
| },
| comment: "表单表");
|
| migrationBuilder.CreateTable(
| name: "sys_log_audit",
| columns: table => new
| {
| Id = table.Column<int>(type: "int", nullable: false)
| .Annotation("SqlServer:Identity", "1, 1"),
| TableName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "表名"),
| ColumnName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "列名"),
| NewValue = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "新值"),
| OldValue = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "旧值"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "操作时间"),
| UserId = table.Column<long>(type: "bigint", nullable: false, comment: "操作人Id"),
| UserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "操作人名称"),
| Operate = table.Column<int>(type: "int", nullable: false, comment: "操作方式")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_log_audit", x => x.Id);
| },
| comment: "审计日志表");
|
| migrationBuilder.CreateTable(
| name: "sys_log_ex",
| columns: table => new
| {
| Id = table.Column<int>(type: "int", nullable: false)
| .Annotation("SqlServer:Identity", "1, 1"),
| Account = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "操作人"),
| Name = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "名称"),
| ClassName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "类名"),
| MethodName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "方法名"),
| ExceptionName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "异常名称"),
| ExceptionMsg = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "异常信息"),
| ExceptionSource = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "异常源"),
| StackTrace = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "堆栈信息"),
| ParamsObj = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "参数对象"),
| ExceptionTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "异常时间")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_log_ex", x => x.Id);
| },
| comment: "异常日志表");
|
| migrationBuilder.CreateTable(
| name: "sys_log_op",
| columns: table => new
| {
| Id = table.Column<int>(type: "int", nullable: false)
| .Annotation("SqlServer:Identity", "1, 1"),
| Name = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "名称"),
| Success = table.Column<int>(type: "int", nullable: false, comment: "是否执行成功"),
| Message = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "具体消息"),
| Ip = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "IP"),
| Location = table.Column<string>(type: "nvarchar(1024)", maxLength: 1024, nullable: true, comment: "地址"),
| Browser = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "浏览器"),
| Os = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "操作系统"),
| Url = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "请求地址"),
| ClassName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "类名称"),
| MethodName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "方法名称"),
| ReqMethod = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "请求方式"),
| Param = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "请求参数"),
| Result = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "返回结果"),
| ElapsedTime = table.Column<long>(type: "bigint", nullable: false, comment: "耗时"),
| OpTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "操作时间"),
| Account = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "操作人")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_log_op", x => x.Id);
| },
| comment: "操作日志表");
|
| migrationBuilder.CreateTable(
| name: "sys_log_vis",
| columns: table => new
| {
| Id = table.Column<int>(type: "int", nullable: false)
| .Annotation("SqlServer:Identity", "1, 1"),
| Name = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "名称"),
| Success = table.Column<int>(type: "int", nullable: false, comment: "是否执行成功"),
| Message = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "具体消息"),
| Ip = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "IP"),
| Location = table.Column<string>(type: "nvarchar(1024)", maxLength: 1024, nullable: true, comment: "地址"),
| Browser = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "浏览器"),
| Os = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "操作系统"),
| VisType = table.Column<int>(type: "int", nullable: false, comment: "访问类型"),
| VisTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "访问时间"),
| Account = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "访问人")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_log_vis", x => x.Id);
| },
| comment: "访问日志表");
|
| migrationBuilder.CreateTable(
| name: "sys_low_code_module",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| AuthorName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "作者姓名"),
| GenerateType = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "生成方式"),
| DatabaseName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库名"),
| NameSpace = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "命名空间"),
| BusName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "业务名"),
| MenuApplication = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "菜单应用分类"),
| MenuPid = table.Column<long>(type: "bigint", nullable: false, comment: "菜单编码"),
| FormDesignType = table.Column<int>(type: "int", nullable: false, comment: "动态表单类型"),
| FormDesign = table.Column<string>(type: "text", nullable: true, comment: "动态表单"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_low_code_module", x => x.Id);
| },
| comment: "低代码模块管理");
|
| migrationBuilder.CreateTable(
| name: "sys_menu",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Pid = table.Column<long>(type: "bigint", nullable: false, comment: "父Id"),
| Pids = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "父Ids"),
| Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Type = table.Column<int>(type: "int", nullable: false, comment: "菜单类型"),
| Icon = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "图标"),
| Router = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "路由地址"),
| Component = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "组件地址"),
| Permission = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "权限标识"),
| Application = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "应用分类"),
| OpenType = table.Column<int>(type: "int", nullable: false, comment: "打开方式"),
| Visible = table.Column<string>(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否可见"),
| Link = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "内链地址"),
| Redirect = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "重定向地址"),
| Weight = table.Column<int>(type: "int", nullable: false, comment: "权重"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_menu", x => x.Id);
| },
| comment: "菜单表");
|
| migrationBuilder.CreateTable(
| name: "sys_notice",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Title = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "标题"),
| Content = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "内容"),
| Type = table.Column<int>(type: "int", nullable: false, comment: "类型"),
| PublicUserId = table.Column<long>(type: "bigint", nullable: false, comment: "发布人Id"),
| PublicUserName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "发布人姓名"),
| PublicOrgId = table.Column<long>(type: "bigint", nullable: false, comment: "发布机构Id"),
| PublicOrgName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "发布机构名称"),
| PublicTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "发布时间"),
| CancelTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "撤回时间"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_notice", x => x.Id);
| },
| comment: "通知公告表");
|
| migrationBuilder.CreateTable(
| name: "sys_notice_user",
| columns: table => new
| {
| NoticeId = table.Column<long>(type: "bigint", nullable: false, comment: "通知公告Id"),
| UserId = table.Column<long>(type: "bigint", nullable: false, comment: "用户Id"),
| ReadTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "阅读时间"),
| ReadStatus = table.Column<int>(type: "int", nullable: false, comment: "状态")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_notice_user", x => new { x.NoticeId, x.UserId });
| },
| comment: "通知公告用户表");
|
| migrationBuilder.CreateTable(
| name: "sys_org",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Pid = table.Column<long>(type: "bigint", nullable: false, comment: "父Id"),
| Pids = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "父Ids"),
| Name = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Contacts = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "联系人"),
| Tel = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "电话"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| OrgType = table.Column<string>(type: "nvarchar(max)", nullable: true),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_org", x => x.Id);
| },
| comment: "组织机构表");
|
| migrationBuilder.CreateTable(
| name: "sys_pos",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_pos", x => x.Id);
| },
| comment: "职位表");
|
| migrationBuilder.CreateTable(
| name: "sys_role",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| DataScopeType = table.Column<int>(type: "int", nullable: false, comment: "数据范围类型"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| RoleType = table.Column<int>(type: "int", nullable: false, comment: "角色类型-集团角色_0、加盟商角色_1、门店角色_2"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_role", x => x.Id);
| },
| comment: "角色表");
|
| migrationBuilder.CreateTable(
| name: "sys_timer",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| JobName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "任务名称"),
| DoOnce = table.Column<bool>(type: "bit", nullable: false, comment: "只执行一次"),
| StartNow = table.Column<bool>(type: "bit", nullable: false, comment: "立即执行"),
| ExecuteType = table.Column<int>(type: "int", nullable: false, comment: "执行类型"),
| Interval = table.Column<int>(type: "int", nullable: true, comment: "间隔时间"),
| Cron = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "Cron表达式"),
| TimerType = table.Column<int>(type: "int", nullable: false, comment: "定时器类型"),
| RequestUrl = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "请求url"),
| RequestParameters = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "请求参数"),
| Headers = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "Headers"),
| RequestType = table.Column<int>(type: "int", nullable: false, comment: "请求类型"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_timer", x => x.Id);
| },
| comment: "定时任务表");
|
| migrationBuilder.CreateTable(
| name: "sys_user",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| Account = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "账号"),
| Password = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "密码"),
| NickName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "昵称"),
| Name = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "姓名"),
| Avatar = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "头像"),
| Birthday = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "生日"),
| Sex = table.Column<int>(type: "int", nullable: false, comment: "性别-男_1、女_2"),
| Email = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "邮箱"),
| Phone = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "手机"),
| Tel = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "电话"),
| LastLoginIp = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "最后登录IP"),
| LastLoginTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "最后登录时间"),
| AdminType = table.Column<int>(type: "int", nullable: false, comment: "管理员类型-超级管理员_1、管理员_2、普通账号_3"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态-正常_0、停用_1、删除_2"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_user", x => x.Id);
| },
| comment: "用户表");
|
| migrationBuilder.CreateTable(
| name: "wms_area",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| AreaName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "名称"),
| AreaDesc = table.Column<string>(type: "nvarchar(250)", maxLength: 250, nullable: true, comment: "描述"),
| AreaStatus = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| AreaType = table.Column<int>(type: "int", nullable: false, comment: "分类"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_area", x => x.Id);
| },
| comment: "库区");
|
| migrationBuilder.CreateTable(
| name: "wms_container",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| ContainerCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编号"),
| ContainerType = table.Column<int>(type: "int", nullable: false, comment: "类型"),
| ContainerStatus = table.Column<int>(type: "int", nullable: false, comment: "托盘状态"),
| SpecLength = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "长度"),
| SpecWidth = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "宽度"),
| SpecHeight = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "高度"),
| LimitLength = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "限长"),
| LimitWidth = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "限宽"),
| LimitHeight = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "限高"),
| MaxWeight = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "载重上限"),
| ParentContainerId = table.Column<long>(type: "bigint", nullable: false, comment: "父托盘ID"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_container", x => x.Id);
| },
| comment: "托盘信息");
|
| migrationBuilder.CreateTable(
| name: "wms_material",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| MaterialName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料名称"),
| MaterialNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料编号"),
| MaterialBatch = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料批次"),
| Description = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true, comment: "描述"),
| InspectionMethod = table.Column<int>(type: "int", nullable: false, comment: "检验方式"),
| MaterialType = table.Column<int>(type: "int", nullable: false, comment: "物料类别"),
| MaterialSpec = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料规格"),
| UnitType = table.Column<int>(type: "int", nullable: false, comment: "单位类别"),
| UnitNo = table.Column<int>(type: "int", nullable: false, comment: "单位编号"),
| Safeqty = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "安全存量"),
| Keymaterials = table.Column<int>(type: "int", nullable: false, comment: "是否关键物料"),
| ErpNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "Erp单号"),
| GraphNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "图号"),
| Qccategory = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "品管类别"),
| Warranty = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "保质期"),
| MaxImumqty = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "最大存量"),
| MinstorageAge = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "最小库龄"),
| MaxstorageAge = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "最大库龄"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_material", x => x.Id);
| },
| comment: "物料信息");
|
| migrationBuilder.CreateTable(
| name: "wms_materialstock",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| MaterialNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料编号"),
| MaterialType = table.Column<int>(type: "int", nullable: false, comment: "物料类别"),
| MaterialBatch = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料批次"),
| MaterialName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料名称"),
| MaterialSpec = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "物料规格"),
| InspectionMethod = table.Column<int>(type: "int", nullable: false, comment: "检验方式"),
| UnitType = table.Column<int>(type: "int", nullable: false, comment: "单位类别"),
| UnitNo = table.Column<int>(type: "int", nullable: false, comment: "单位编号"),
| StockNumber = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "库存数"),
| PlaceCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库位编码"),
| ContainerCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "托盘编码"),
| AreaId = table.Column<long>(type: "bigint", nullable: false, comment: "库区ID"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_materialstock", x => x.Id);
| },
| comment: "库存表");
|
| migrationBuilder.CreateTable(
| name: "wms_task",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| TaskNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "任务号"),
| TaskModel = table.Column<int>(type: "int", nullable: false, comment: "任务方式"),
| TaskType = table.Column<int>(type: "int", nullable: false, comment: "任务类型"),
| TaskLevel = table.Column<int>(type: "int", nullable: false, comment: "任务级别"),
| TaskStatus = table.Column<int>(type: "int", nullable: false, comment: "任务状态"),
| ContainerCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "托盘编号"),
| SourcePlace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "起始库位"),
| ToPlace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "目标库位"),
| Aisle = table.Column<int>(type: "int", nullable: false, comment: "巷道"),
| AreaName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库区名称"),
| OrderNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "组盘记录ID"),
| SendTimes = table.Column<int>(type: "int", nullable: false, comment: "发送次数"),
| DodeviceId = table.Column<int>(type: "int", nullable: false, comment: "任务执行堆垛机ID"),
| DodevicenodeId = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "设备执行节点ID"),
| Dodevicetype = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "设备类型"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_task", x => x.Id);
| },
| comment: "任务管理");
|
| migrationBuilder.CreateTable(
| name: "sys_dict_data",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| TypeId = table.Column<long>(type: "bigint", nullable: false, comment: "字典类型Id"),
| Value = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "值"),
| Code = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "编码"),
| Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
| Remark = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"),
| Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_dict_data", x => x.Id);
| table.ForeignKey(
| name: "FK_sys_dict_data_sys_dict_type_TypeId",
| column: x => x.TypeId,
| principalTable: "sys_dict_type",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "字典值表");
|
| migrationBuilder.CreateTable(
| name: "sys_low_code_module_database",
| columns: table => new
| {
| Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "Id主键"),
| SysLowCodeId = table.Column<long>(type: "bigint", nullable: false),
| Control_Key = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件Key"),
| Control_Label = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件名称"),
| Control_Model = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件字段"),
| Control_Type = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件字段"),
| TableName = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "表名"),
| ClassName = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "类名"),
| TableDesc = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "表描述"),
| FieldName = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "字段名称"),
| DbTypeName = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "数据类型"),
| DtoTypeName = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "传入数据类型"),
| DbParam = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "数据类型补充参数"),
| IsRequired = table.Column<bool>(type: "bit", nullable: true, comment: "是否必填"),
| WhetherTable = table.Column<bool>(type: "bit", nullable: true, comment: "列表显示"),
| WhetherOrderBy = table.Column<bool>(type: "bit", nullable: true, comment: "排序"),
| WhetherAddUpdate = table.Column<bool>(type: "bit", nullable: true, comment: "增改"),
| QueryWhether = table.Column<bool>(type: "bit", nullable: true, comment: "是否是查询"),
| QueryType = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "查询方式"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_low_code_module_database", x => x.Id);
| table.ForeignKey(
| name: "FK_sys_low_code_module_database_sys_low_code_module_SysLowCodeId",
| column: x => x.SysLowCodeId,
| principalTable: "sys_low_code_module",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "低代码模块管理");
|
| migrationBuilder.CreateTable(
| name: "sys_emp_ext_org_pos",
| columns: table => new
| {
| SysEmpId = table.Column<long>(type: "bigint", nullable: false, comment: "员工Id"),
| SysOrgId = table.Column<long>(type: "bigint", nullable: false, comment: "机构Id"),
| SysPosId = table.Column<long>(type: "bigint", nullable: false, comment: "职位Id")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_emp_ext_org_pos", x => new { x.SysEmpId, x.SysOrgId, x.SysPosId });
| table.ForeignKey(
| name: "FK_sys_emp_ext_org_pos_sys_emp_SysEmpId",
| column: x => x.SysEmpId,
| principalTable: "sys_emp",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_emp_ext_org_pos_sys_org_SysOrgId",
| column: x => x.SysOrgId,
| principalTable: "sys_org",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_emp_ext_org_pos_sys_pos_SysPosId",
| column: x => x.SysPosId,
| principalTable: "sys_pos",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "员工附属机构职位表");
|
| migrationBuilder.CreateTable(
| name: "sys_emp_pos",
| columns: table => new
| {
| SysEmpId = table.Column<long>(type: "bigint", nullable: false, comment: "员工Id"),
| SysPosId = table.Column<long>(type: "bigint", nullable: false, comment: "职位Id")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_emp_pos", x => new { x.SysEmpId, x.SysPosId });
| table.ForeignKey(
| name: "FK_sys_emp_pos_sys_emp_SysEmpId",
| column: x => x.SysEmpId,
| principalTable: "sys_emp",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_emp_pos_sys_pos_SysPosId",
| column: x => x.SysPosId,
| principalTable: "sys_pos",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "员工职位表");
|
| migrationBuilder.CreateTable(
| name: "sys_role_data_scope",
| columns: table => new
| {
| SysRoleId = table.Column<long>(type: "bigint", nullable: false, comment: "角色Id"),
| SysOrgId = table.Column<long>(type: "bigint", nullable: false, comment: "机构Id")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_role_data_scope", x => new { x.SysRoleId, x.SysOrgId });
| table.ForeignKey(
| name: "FK_sys_role_data_scope_sys_org_SysOrgId",
| column: x => x.SysOrgId,
| principalTable: "sys_org",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_role_data_scope_sys_role_SysRoleId",
| column: x => x.SysRoleId,
| principalTable: "sys_role",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "角色数据范围表");
|
| migrationBuilder.CreateTable(
| name: "sys_role_menu",
| columns: table => new
| {
| SysRoleId = table.Column<long>(type: "bigint", nullable: false, comment: "角色Id"),
| SysMenuId = table.Column<long>(type: "bigint", nullable: false, comment: "菜单Id")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_role_menu", x => new { x.SysRoleId, x.SysMenuId });
| table.ForeignKey(
| name: "FK_sys_role_menu_sys_menu_SysMenuId",
| column: x => x.SysMenuId,
| principalTable: "sys_menu",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_role_menu_sys_role_SysRoleId",
| column: x => x.SysRoleId,
| principalTable: "sys_role",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "角色菜单表");
|
| migrationBuilder.CreateTable(
| name: "sys_user_data_scope",
| columns: table => new
| {
| SysUserId = table.Column<long>(type: "bigint", nullable: false, comment: "用户Id"),
| SysOrgId = table.Column<long>(type: "bigint", nullable: false, comment: "机构Id")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_user_data_scope", x => new { x.SysUserId, x.SysOrgId });
| table.ForeignKey(
| name: "FK_sys_user_data_scope_sys_org_SysOrgId",
| column: x => x.SysOrgId,
| principalTable: "sys_org",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_user_data_scope_sys_user_SysUserId",
| column: x => x.SysUserId,
| principalTable: "sys_user",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "用户数据范围表");
|
| migrationBuilder.CreateTable(
| name: "sys_user_role",
| columns: table => new
| {
| SysUserId = table.Column<long>(type: "bigint", nullable: false, comment: "用户Id"),
| SysRoleId = table.Column<long>(type: "bigint", nullable: false, comment: "角色Id")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_sys_user_role", x => new { x.SysUserId, x.SysRoleId });
| table.ForeignKey(
| name: "FK_sys_user_role_sys_role_SysRoleId",
| column: x => x.SysRoleId,
| principalTable: "sys_role",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_sys_user_role_sys_user_SysUserId",
| column: x => x.SysUserId,
| principalTable: "sys_user",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "用户角色表");
|
| migrationBuilder.CreateTable(
| name: "wms_place",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| PlaceCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"),
| PlaceStatus = table.Column<int>(type: "int", nullable: false, comment: "库位状态"),
| AreaId = table.Column<long>(type: "bigint", nullable: false, comment: "所在库区"),
| RowNo = table.Column<int>(type: "int", nullable: false, comment: "排"),
| ColumnNo = table.Column<int>(type: "int", nullable: false, comment: "列"),
| LayerNo = table.Column<int>(type: "int", nullable: false, comment: "层"),
| DeepcellNo = table.Column<int>(type: "int", nullable: false, comment: "进深号"),
| Aisle = table.Column<int>(type: "int", nullable: false, comment: "巷道"),
| Line = table.Column<int>(type: "int", nullable: false, comment: "线号"),
| Islock = table.Column<int>(type: "int", nullable: false, comment: "是否锁定"),
| EmptyContainer = table.Column<int>(type: "int", nullable: false, comment: "是否空托"),
| PositionnoForSrm = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "堆垛机内部的位置"),
| Xzb = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位X坐标"),
| Yzb = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位Y坐标"),
| Zzb = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位Z坐标"),
| Length = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "库位长度"),
| Width = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "库位宽度"),
| Height = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "库位高度"),
| MaxWeight = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "最大承重"),
| HeightLevel = table.Column<int>(type: "int", nullable: false, comment: "库位高度"),
| Priority = table.Column<int>(type: "int", nullable: false, comment: "优先级"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_place", x => x.Id);
| table.ForeignKey(
| name: "FK_wms_place_wms_area_AreaId",
| column: x => x.AreaId,
| principalTable: "wms_area",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| },
| comment: "库位");
|
| migrationBuilder.CreateTable(
| name: "wms_materialcontainer",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| ContainerId = table.Column<long>(type: "bigint", nullable: false, comment: "托盘ID"),
| ContainerCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "托盘编码"),
| MaterialName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料名称"),
| MaterialNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料编号"),
| MaterialBatch = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料批次"),
| MaterialSpec = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "物料规格"),
| MaterialId = table.Column<long>(type: "bigint", nullable: false, comment: "物料ID"),
| BindQuantity = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "组盘数量"),
| BindStatus = table.Column<int>(type: "int", nullable: false, comment: "组盘状态"),
| SampleQty = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "抽检数量"),
| OrderNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "单号"),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_materialcontainer", x => x.Id);
| table.ForeignKey(
| name: "FK_wms_materialcontainer_wms_container_ContainerId",
| column: x => x.ContainerId,
| principalTable: "wms_container",
| principalColumn: "Id",
| onDelete: ReferentialAction.Cascade);
| table.ForeignKey(
| name: "FK_wms_materialcontainer_wms_material_MaterialId",
| column: x => x.MaterialId,
| principalTable: "wms_material",
| principalColumn: "Id");
| },
| comment: "物料托盘关系表");
|
| migrationBuilder.CreateTable(
| name: "wms_containerplace",
| columns: table => new
| {
| Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主键"),
| PlaceId = table.Column<long>(type: "bigint", nullable: false, comment: "库位ID"),
| PlaceCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库位编码"),
| ContainerId = table.Column<long>(type: "bigint", nullable: false, comment: "托盘ID"),
| ContainerCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库位编码"),
| ContainerPlaceStatus = table.Column<int>(type: "int", nullable: false, comment: "状态"),
| WmsContainerId = table.Column<long>(type: "bigint", nullable: true),
| WmsPlaceId = table.Column<long>(type: "bigint", nullable: true),
| CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "创建时间"),
| UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "更新时间"),
| CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "创建者Id"),
| CreatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"),
| UpdatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "修改者Id"),
| UpdatedUserName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"),
| IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "软删除标记")
| },
| constraints: table =>
| {
| table.PrimaryKey("PK_wms_containerplace", x => x.Id);
| table.ForeignKey(
| name: "FK_wms_containerplace_wms_container_WmsContainerId",
| column: x => x.WmsContainerId,
| principalTable: "wms_container",
| principalColumn: "Id");
| table.ForeignKey(
| name: "FK_wms_containerplace_wms_place_WmsPlaceId",
| column: x => x.WmsPlaceId,
| principalTable: "wms_place",
| principalColumn: "Id");
| },
| comment: "托盘库位关系表");
|
| migrationBuilder.InsertData(
| table: "sys_app",
| columns: new[] { "Id", "Active", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 142307070898245L, "Y", "system", null, null, null, false, "开发管理", 100, 0, null, null, null },
| { 142307070902341L, "N", "manage", null, null, null, false, "系统管理", 300, 0, null, null, null },
| { 142307070922869L, "N", "busiapp", null, null, null, false, "业务应用", 400, 0, null, null, null },
| { 355686432948293L, "N", "warejob", null, null, null, false, "仓库作业", 500, 0, null, null, null },
| { 355686518018117L, "N", "warecount", null, null, null, false, "统计查询", 600, 0, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_config",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "GroupCode", "IsDeleted", "Name", "Remark", "Status", "SysFlag", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
| values: new object[,]
| {
| { 142307070902342L, "DILON_JWT_SECRET", null, null, null, "DEFAULT", false, "jwt密钥", "（重要）jwt密钥，默认为空，自行设置", 0, "Y", null, null, null, "weiben" },
| { 142307070902343L, "DILON_DEFAULT_PASSWORD", null, null, null, "DEFAULT", false, "默认密码", "默认密码", 0, "Y", null, null, null, "123456" },
| { 142307070902344L, "DILON_TOKEN_EXPIRE", null, null, null, "DEFAULT", false, "token过期时间", "token过期时间（单位：秒）", 0, "Y", null, null, null, "86400" },
| { 142307070902345L, "DILON_SESSION_EXPIRE", null, null, null, "DEFAULT", false, "session会话过期时间", "session会话过期时间（单位：秒）", 0, "Y", null, null, null, "7200" },
| { 142307070902361L, "DILON_FILE_UPLOAD_PATH_FOR_WINDOWS", null, null, null, "FILE_PATH", false, "Win本地上传文件路径", "Win本地上传文件路径", 0, "Y", null, null, null, "D:/tmp" },
| { 142307070902363L, "DILON_UN_XSS_FILTER_URL", null, null, null, "DEFAULT", false, "放开XSS过滤的接口", "多个url可以用英文逗号隔开", 0, "Y", null, null, null, "/demo/xssfilter,/demo/unxss" },
| { 142307070902364L, "DILON_ENABLE_SINGLE_LOGIN", null, null, null, "DEFAULT", false, "单用户登陆的开关", "true-打开，false-关闭，如果一个人登录两次，就会将上一次登陆挤下去", 0, "Y", null, null, null, "false" },
| { 142307070902365L, "DILON_CAPTCHA_OPEN", null, null, null, "DEFAULT", false, "登录验证码的开关", "true-打开，false-关闭", 0, "Y", null, null, null, "true" }
| });
|
| migrationBuilder.InsertData(
| table: "sys_dict_type",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 142307070906483L, "common_status", null, null, null, false, "通用状态", "通用状态", 100, 0, null, null, null },
| { 142307070906484L, "sex", null, null, null, false, "性别", "性别字典", 100, 0, null, null, null },
| { 142307070906485L, "consts_type", null, null, null, false, "常量的分类", "常量的分类，用于区别一组配置", 100, 0, null, null, null },
| { 142307070906486L, "yes_or_no", null, null, null, false, "是否", "是否", 100, 0, null, null, null },
| { 142307070906487L, "vis_type", null, null, null, false, "访问类型", "访问类型", 100, 0, null, null, null },
| { 142307070906488L, "menu_type", null, null, null, false, "菜单类型", "菜单类型", 100, 0, null, null, null },
| { 142307070906489L, "send_type", null, null, null, false, "发送类型", "发送类型", 100, 0, null, null, null },
| { 142307070906490L, "open_type", null, null, null, false, "打开方式", "打开方式", 100, 0, null, null, null },
| { 142307070906491L, "menu_weight", null, null, null, false, "菜单权重", "菜单权重", 100, 0, null, null, null },
| { 142307070906492L, "data_scope_type", null, null, null, false, "数据范围类型", "数据范围类型", 100, 0, null, null, null },
| { 142307070906494L, "op_type", null, null, null, false, "操作类型", "操作类型", 100, 0, null, null, null },
| { 142307070906495L, "file_storage_location", null, null, null, false, "文件存储位置", "文件存储位置", 100, 0, null, null, null },
| { 142307070910533L, "run_status", null, null, null, false, "运行状态", "定时任务运行状态", 100, 0, null, null, null },
| { 142307070910534L, "notice_type", null, null, null, false, "通知公告类型", "通知公告类型", 100, 0, null, null, null },
| { 142307070910535L, "notice_status", null, null, null, false, "通知公告状态", "通知公告状态", 100, 0, null, null, null },
| { 142307070910536L, "yes_true_false", null, null, null, false, "是否boolean", "是否boolean", 100, 0, null, null, null },
| { 142307070910537L, "code_gen_create_type", null, null, null, false, "代码生成方式", "代码生成方式", 100, 0, null, null, null },
| { 142307070910538L, "request_type", null, null, null, false, "请求方式", "请求方式", 100, 0, null, null, null },
| { 142307070922827L, "code_gen_effect_type", null, null, null, false, "代码生成作用类型", "代码生成作用类型", 100, 0, null, null, null },
| { 142307070922828L, "code_gen_query_type", null, null, null, false, "代码生成查询类型", "代码生成查询类型", 100, 0, null, null, null },
| { 142307070922829L, "code_gen_net_type", null, null, null, false, "代码生成.NET类型", "代码生成.NET类型", 100, 0, null, null, null },
| { 142307070926941L, "role_type", null, null, null, false, "角色类型", "角色类型", 100, 0, null, null, null },
| { 142307070926942L, "org_type", null, null, null, false, "机构类型", "机构类型", 100, 0, null, null, null },
| { 285605149831237L, "form_type", null, null, null, false, "表单类型", "表单类型", 100, 0, null, null, null },
| { 285641358889029L, "workflow_group", null, null, null, false, "流程分类", "流程分类", 100, 0, null, null, null },
| { 355694205325381L, "container_type", null, null, null, false, "托盘类型", "", 100, 0, null, null, null },
| { 355697881423941L, "container_status", null, null, null, false, "托盘状态", "", 100, 0, null, null, null },
| { 355698224758853L, "area_type", null, null, null, false, "库区类型", "", 100, 0, null, null, null },
| { 355698441912389L, "place_status", null, null, null, false, "库位状态", "", 100, 0, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_dict_type",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 355698661130309L, "height_level", null, null, null, false, "库位高度", "", 100, 0, null, null, null },
| { 355698855280709L, "material_inspection", null, null, null, false, "物料检验", "", 100, 0, null, null, null },
| { 355699003580485L, "material_type", null, null, null, false, "物料类别", "", 100, 0, null, null, null },
| { 355699189051461L, "unit_type", null, null, null, false, "单位类别", "", 100, 0, null, null, null },
| { 355699314061381L, "unitno_type", null, null, null, false, "单位编号", "", 100, 0, null, null, null },
| { 355699447029829L, "task_model", null, null, null, false, "任务方式", "", 100, 0, null, null, null },
| { 355699576467525L, "task_type", null, null, null, false, "任务类型", "", 100, 0, null, null, null },
| { 355699731099717L, "task_status", null, null, null, false, "任务状态", "", 100, 0, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_emp",
| columns: new[] { "Id", "JobNum", "OrgId", "OrgName" },
| values: new object[,]
| {
| { 142307070910551L, "D1001", 142307070910539L, "华夏集团" },
| { 142307070910552L, "D1002", 142307070910539L, "华夏集团" },
| { 142307070910553L, "D1003", 142307070910539L, "华夏集团" },
| { 142307070910554L, "D1001", 142307070910547L, "租户1公司" },
| { 142307070910555L, "D1002", 142307070910547L, "租户1公司" },
| { 142307070910556L, "D1003", 142307070910547L, "租户1公司" },
| { 142307070910557L, "D1001", 142307070910548L, "租户2公司" },
| { 142307070910558L, "D1002", 142307070910548L, "租户2公司" },
| { 142307070910559L, "D1003", 142307070910548L, "租户2公司" },
| { 358533464608837L, "", 142307070910539L, "伟本股份有限公司" },
| { 358536045723717L, "", 142307070910542L, "研发部" }
| });
|
| migrationBuilder.InsertData(
| table: "sys_menu",
| columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "Weight" },
| values: new object[,]
| {
| { 142307000914633L, "manage", "sys_mgr", "PageView", null, null, null, "team", false, null, "组织架构", 0, null, 0L, "[0],", null, null, "/sys", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070910563L, "manage", "auth_manager", "PageView", null, null, null, "safety-certificate", false, null, "权限管理", 0, null, 0L, "[0],", null, null, "/auth", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070910564L, "manage", "sys_user_mgr", "system/user/index", null, null, null, null, false, null, "用户管理", 1, null, 142307070910563L, "[0],[142307070910563],", null, null, "/mgr_user", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070910565L, "manage", "sys_user_mgr_page", null, null, null, null, null, false, null, "用户查询", 0, "sysUser:page", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910566L, "manage", "sys_user_mgr_edit", null, null, null, null, null, false, null, "用户编辑", 0, "sysUser:edit", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910567L, "manage", "sys_user_mgr_add", null, null, null, null, null, false, null, "用户增加", 0, "sysUser:add", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910568L, "manage", "sys_user_mgr_delete", null, null, null, null, null, false, null, "用户删除", 0, "sysUser:delete", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910569L, "manage", "sys_user_mgr_detail", null, null, null, null, null, false, null, "用户详情", 0, "sysUser:detail", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910570L, "manage", "sys_user_mgr_export", null, null, null, null, null, false, null, "用户导出", 0, "sysUser:export", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910571L, "manage", "sys_user_mgr_selector", null, null, null, null, null, false, null, "用户选择器", 0, "sysUser:selector", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910572L, "manage", "sys_user_mgr_grant_role", null, null, null, null, null, false, null, "用户授权角色", 0, "sysUser:grantRole", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910573L, "manage", "sys_user_mgr_own_role", null, null, null, null, null, false, null, "用户拥有角色", 0, "sysUser:ownRole", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910574L, "manage", "sys_user_mgr_grant_data", null, null, null, null, null, false, null, "用户授权数据", 0, "sysUser:grantData", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910575L, "manage", "sys_user_mgr_own_data", null, null, null, null, null, false, null, "用户拥有数据", 0, "sysUser:ownData", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910576L, "manage", "sys_user_mgr_update_info", null, null, null, null, null, false, null, "用户更新信息", 0, "sysUser:updateInfo", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910577L, "manage", "sys_user_mgr_update_pwd", null, null, null, null, null, false, null, "用户修改密码", 0, "sysUser:updatePwd", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910578L, "manage", "sys_user_mgr_change_status", null, null, null, null, null, false, null, "用户修改状态", 0, "sysUser:changeStatus", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910579L, "manage", "sys_user_mgr_update_avatar", null, null, null, null, null, false, null, "用户修改头像", 0, "sysUser:updateAvatar", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910580L, "manage", "sys_user_mgr_reset_pwd", null, null, null, null, null, false, null, "用户重置密码", 0, "sysUser:resetPwd", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910581L, "manage", "sys_org_mgr", "system/org/index", null, null, null, null, false, null, "机构管理", 1, null, 142307000914633L, "[0],[142307000914633],", null, null, "/org", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070910582L, "manage", "sys_org_mgr_page", null, null, null, null, null, false, null, "机构查询", 0, "sysOrg:page", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910583L, "manage", "sys_org_mgr_list", null, null, null, null, null, false, null, "机构列表", 0, "sysOrg:list", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910584L, "manage", "sys_org_mgr_add", null, null, null, null, null, false, null, "机构增加", 0, "sysOrg:add", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }
| });
|
| migrationBuilder.InsertData(
| table: "sys_menu",
| columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "Weight" },
| values: new object[,]
| {
| { 142307070910585L, "manage", "sys_org_mgr_edit", null, null, null, null, null, false, null, "机构编辑", 0, "sysOrg:edit", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910586L, "manage", "sys_org_mgr_delete", null, null, null, null, null, false, null, "机构删除", 0, "sysOrg:delete", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910587L, "manage", "sys_org_mgr_detail", null, null, null, null, null, false, null, "机构详情", 0, "sysOrg:detail", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910588L, "manage", "sys_org_mgr_tree", null, null, null, null, null, false, null, "机构树", 0, "sysOrg:tree", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910589L, "manage", "sys_pos_mgr", "system/pos/index", null, null, null, null, false, null, "职位管理", 1, null, 142307000914633L, "[0],[142307000914633],", null, null, "/pos", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070910590L, "manage", "sys_pos_mgr_page", null, null, null, null, null, false, null, "职位查询", 0, "sysPos:page", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070910591L, "manage", "sys_pos_mgr_list", null, null, null, null, null, false, null, "职位列表", 0, "sysPos:list", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070911739L, "manage", "sys_log_mgr_ex_log", "system/log/exlog/index", null, null, null, null, false, null, "异常日志", 1, null, 142307070918732L, "[0],[142307070918732],", null, null, "/exlog", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070911740L, "manage", "sys_log_mgr_ex_log_page", null, null, null, null, null, false, null, "异常日志查询", 0, "sysExLog:page", 142307070911739L, "[0],[142307070918732],[142307070911739],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070911741L, "manage", "sys_log_mgr_ex_log_delete", null, null, null, null, null, false, null, "异常日志清空", 0, "sysExLog:delete", 142307070911739L, "[0],[142307070918732],[142307070911739],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914629L, "manage", "sys_pos_mgr_add", null, null, null, null, null, false, null, "职位增加", 0, "sysPos:add", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914630L, "manage", "sys_pos_mgr_edit", null, null, null, null, null, false, null, "职位编辑", 0, "sysPos:edit", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914631L, "manage", "sys_pos_mgr_delete", null, null, null, null, null, false, null, "职位删除", 0, "sysPos:delete", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914632L, "manage", "sys_pos_mgr_detail", null, null, null, null, null, false, null, "职位详情", 0, "sysPos:detail", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914633L, "system", "sys_platform", "PageView", null, null, null, "safety-certificate", false, null, "平台管理", 0, null, 0L, "[0],", null, null, "/platform", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070914634L, "system", "sys_app_mgr", "system/app/index", null, null, null, null, false, null, "应用管理", 1, null, 142307070914633L, "[0],[142307070914633],", null, null, "/app", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070914635L, "system", "sys_app_mgr_page", null, null, null, null, null, false, null, "应用查询", 0, "sysApp:page", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914636L, "system", "sys_app_mgr_list", null, null, null, null, null, false, null, "应用列表", 0, "sysApp:list", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914637L, "system", "sys_app_mgr_add", null, null, null, null, null, false, null, "应用增加", 0, "sysApp:add", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914638L, "system", "sys_app_mgr_edit", null, null, null, null, null, false, null, "应用编辑", 0, "sysApp:edit", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914639L, "system", "sys_app_mgr_delete", null, null, null, null, null, false, null, "应用删除", 0, "sysApp:delete", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914640L, "system", "sys_app_mgr_detail", null, null, null, null, null, false, null, "应用详情", 0, "sysApp:detail", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914641L, "system", "sys_app_mgr_set_as_default", null, null, null, null, null, false, null, "设为默认应用", 0, "sysApp:setAsDefault", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914642L, "system", "sys_menu_mgr", "system/menu/index", null, null, null, null, false, null, "菜单管理", 1, null, 142307070914633L, "[0],[142307070914633],", null, null, "/menu", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070914643L, "system", "sys_menu_mgr_list", null, null, null, null, null, false, null, "菜单列表", 0, "sysMenu:list", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914644L, "system", "sys_menu_mgr_add", null, null, null, null, null, false, null, "菜单增加", 0, "sysMenu:add", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914645L, "system", "sys_menu_mgr_edit", null, null, null, null, null, false, null, "菜单编辑", 0, "sysMenu:edit", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914646L, "system", "sys_menu_mgr_delete", null, null, null, null, null, false, null, "菜单删除", 0, "sysMenu:delete", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914647L, "system", "sys_menu_mgr_detail", null, null, null, null, null, false, null, "菜单详情", 0, "sysMenu:detail", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914648L, "manage", "sys_menu_mgr_grant_tree", null, null, null, null, null, false, null, "菜单授权树", 0, "sysMenu:treeForGrant", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914649L, "manage", "sys_menu_mgr_tree", null, null, null, null, null, false, null, "菜单树", 0, "sysMenu:tree", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914650L, "system", "sys_menu_mgr_change", null, null, null, null, null, false, null, "菜单切换", 0, "sysMenu:change", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914651L, "manage", "sys_role_mgr", "system/role/index", null, null, null, null, false, null, "角色管理", 1, null, 142307070910563L, "[0],[142307070910563],", null, null, "/role", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070914652L, "manage", "sys_role_mgr_page", null, null, null, null, null, false, null, "角色查询", 0, "sysRole:page", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914653L, "manage", "sys_role_mgr_add", null, null, null, null, null, false, null, "角色增加", 0, "sysRole:add", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914654L, "manage", "sys_role_mgr_edit", null, null, null, null, null, false, null, "角色编辑", 0, "sysRole:edit", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914655L, "manage", "sys_role_mgr_delete", null, null, null, null, null, false, null, "角色删除", 0, "sysRole:delete", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914656L, "manage", "sys_role_mgr_detail", null, null, null, null, null, false, null, "角色详情", 0, "sysRole:detail", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914657L, "manage", "sys_role_mgr_drop_down", null, null, null, null, null, false, null, "角色下拉", 0, "sysRole:dropDown", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914658L, "manage", "sys_role_mgr_grant_menu", null, null, null, null, null, false, null, "角色授权菜单", 0, "sysRole:grantMenu", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914659L, "manage", "sys_role_mgr_own_menu", null, null, null, null, null, false, null, "角色拥有菜单", 0, "sysRole:ownMenu", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914660L, "manage", "sys_role_mgr_grant_data", null, null, null, null, null, false, null, "角色授权数据", 0, "sysRole:grantData", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }
| });
|
| migrationBuilder.InsertData(
| table: "sys_menu",
| columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "Weight" },
| values: new object[,]
| {
| { 142307070914661L, "manage", "sys_role_mgr_own_data", null, null, null, null, null, false, null, "角色拥有数据", 0, "sysRole:ownData", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914662L, "system", "system_tools", "PageView", null, null, null, "euro", false, null, "开发管理", 0, null, 0L, "[0],", null, null, "/tools", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070914663L, "system", "system_tools_config", "system/config/index", null, null, null, null, false, null, "系统配置", 1, null, 142307070914662L, "[0],[142307070914662],", null, null, "/config", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070914664L, "system", "system_tools_config_page", null, null, null, null, null, false, null, "配置查询", 0, "sysConfig:page", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914665L, "system", "system_tools_config_list", null, null, null, null, null, false, null, "配置列表", 0, "sysConfig:list", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914666L, "system", "system_tools_config_add", null, null, null, null, null, false, null, "配置增加", 0, "sysConfig:add", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914667L, "system", "system_tools_config_edit", null, null, null, null, null, false, null, "配置编辑", 0, "sysConfig:edit", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914668L, "system", "system_tools_config_delete", null, null, null, null, null, false, null, "配置删除", 0, "sysConfig:delete", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914669L, "system", "system_tools_config_detail", null, null, null, null, null, false, null, "配置详情", 0, "sysConfig:detail", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914678L, "system", "sys_dict_mgr", "system/dict/index", null, null, null, null, false, null, "字典管理", 1, null, 142307070914662L, "[0],[142307070914662],", null, null, "/dict", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070914679L, "system", "sys_dict_mgr_dict_type_page", null, null, null, null, null, false, null, "字典类型查询", 0, "sysDictType:page", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914680L, "system", "sys_dict_mgr_dict_type_list", null, null, null, null, null, false, null, "字典类型列表", 0, "sysDictType:list", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914681L, "system", "sys_dict_mgr_dict_type_add", null, null, null, null, null, false, null, "字典类型增加", 0, "sysDictType:add", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914682L, "system", "sys_dict_mgr_dict_type_delete", null, null, null, null, null, false, null, "字典类型删除", 0, "sysDictType:delete", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914683L, "system", "sys_dict_mgr_dict_type_edit", null, null, null, null, null, false, null, "字典类型编辑", 0, "sysDictType:edit", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914684L, "system", "sys_dict_mgr_dict_type_detail", null, null, null, null, null, false, null, "字典类型详情", 0, "sysDictType:detail", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914685L, "system", "sys_dict_mgr_dict_type_drop_down", null, null, null, null, null, false, null, "字典类型下拉", 0, "sysDictType:dropDown", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914686L, "system", "sys_dict_mgr_dict_type_change_status", null, null, null, null, null, false, null, "字典类型修改状态", 0, "sysDictType:changeStatus", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070914687L, "system", "sys_dict_mgr_dict_page", null, null, null, null, null, false, null, "字典值查询", 0, "sysDictData:page", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918725L, "system", "sys_dict_mgr_dict_list", null, null, null, null, null, false, null, "字典值列表", 0, "sysDictData:list", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918726L, "system", "sys_dict_mgr_dict_add", null, null, null, null, null, false, null, "字典值增加", 0, "sysDictData:add", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918727L, "system", "sys_dict_mgr_dict_delete", null, null, null, null, null, false, null, "字典值删除", 0, "sysDictData:delete", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918728L, "system", "sys_dict_mgr_dict_edit", null, null, null, null, null, false, null, "字典值编辑", 0, "sysDictData:edit", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918729L, "system", "sys_dict_mgr_dict_detail", null, null, null, null, null, false, null, "字典值详情", 0, "sysDictData:detail", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918730L, "system", "sys_dict_mgr_dict_change_status", null, null, null, null, null, false, null, "字典值修改状态", 0, "sysDictData:changeStatus", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918731L, "system", "sys_swagger_mgr", "Iframe", null, null, null, null, false, "http://localhost:6677/swagger/", "接口文档", 2, null, 142307070914662L, "[0],[142307070914662],", null, null, "/swagger", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918732L, "manage", "sys_log_mgr", "PageView", null, null, null, "read", false, null, "日志管理", 0, null, 0L, "[0],", null, null, "/log", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070918733L, "manage", "sys_log_mgr_vis_log", "system/log/vislog/index", null, null, null, null, false, null, "访问日志", 1, null, 142307070918732L, "[0],[142307070918732],", null, null, "/vislog", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918734L, "manage", "sys_log_mgr_vis_log_page", null, null, null, null, null, false, null, "访问日志查询", 0, "sysVisLog:page", 142307070918733L, "[0],[142307070918732],[142307070918733],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918735L, "manage", "sys_log_mgr_vis_log_delete", null, null, null, null, null, false, null, "访问日志清空", 0, "sysVisLog:delete", 142307070918733L, "[0],[142307070918732],[142307070918733],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918736L, "manage", "sys_log_mgr_op_log", "system/log/oplog/index", null, null, null, null, false, null, "操作日志", 1, null, 142307070918732L, "[0],[142307070918732],", null, null, "/oplog", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918737L, "manage", "sys_log_mgr_op_log_page", null, null, null, null, null, false, null, "操作日志查询", 0, "sysOpLog:page", 142307070918736L, "[0],[142307070918732],[142307070918736],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918738L, "manage", "sys_log_mgr_op_log_delete", null, null, null, null, null, false, null, "操作日志清空", 0, "sysOpLog:delete", 142307070918736L, "[0],[142307070918732],[142307070918736],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918739L, "system", "sys_monitor_mgr", "PageView", null, null, null, "deployment-unit", false, null, "系统监控", 0, null, 0L, "[0],", null, null, "/monitor", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070918740L, "system", "sys_monitor_mgr_machine_monitor", "system/machine/index", null, null, null, null, false, null, "服务监控", 1, null, 142307070918739L, "[0],[142307070918739],", null, null, "/machine", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918741L, "system", "sys_monitor_mgr_machine_monitor_query", null, null, null, null, null, false, null, "服务监控查询", 0, "sysMachine:query", 142307070918740L, "[0],[142307070918739],[142307070918740],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918742L, "system", "sys_monitor_mgr_online_user", "system/onlineUser/index", null, null, null, null, false, null, "在线用户", 1, null, 142307070918739L, "[0],[142307070918739],", null, null, "/onlineUser", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918743L, "system", "sys_monitor_mgr_online_user_page", null, null, null, null, null, false, null, "在线用户查询", 0, "sysOnlineUser:page", 142307070918742L, "[0],[142307070918739],[142307070918742],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918744L, "system", "sys_monitor_mgr_online_user_force_exist", null, null, null, null, null, false, null, "在线用户强退", 0, "sysOnlineUser:forceExist", 142307070918742L, "[0],[142307070918739],[142307070918742],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918745L, "system", "sys_monitor_mgr_druid", "Iframe", null, null, null, null, false, "http://localhost:82/druid/login.html", "数据监控", 2, null, 142307070918739L, "[0],[142307070918739],", null, null, "/druid", 100, 0, 1, null, null, null, "N", 1 },
| { 142307070918746L, "manage", "sys_notice", "PageView", null, null, null, "sound", false, null, "通知公告", 0, null, 0L, "[0],", null, null, "/notice", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070918747L, "manage", "sys_notice_mgr", "system/notice/index", null, null, null, null, false, null, "公告管理", 1, null, 142307070918746L, "[0],[142307070918746],", null, null, "/notice", 100, 0, 1, null, null, null, "Y", 1 }
| });
|
| migrationBuilder.InsertData(
| table: "sys_menu",
| columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "Weight" },
| values: new object[,]
| {
| { 142307070918748L, "manage", "sys_notice_mgr_page", null, null, null, null, null, false, null, "公告查询", 0, "sysNotice:page", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918749L, "manage", "sys_notice_mgr_add", null, null, null, null, null, false, null, "公告增加", 0, "sysNotice:add", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918750L, "manage", "sys_notice_mgr_edit", null, null, null, null, null, false, null, "公告编辑", 0, "sysNotice:edit", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918751L, "manage", "sys_notice_mgr_delete", null, null, null, null, null, false, null, "公告删除", 0, "sysNotice:delete", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918752L, "manage", "sys_notice_mgr_detail", null, null, null, null, null, false, null, "公告查看", 0, "sysNotice:detail", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918753L, "manage", "sys_notice_mgr_changeStatus", null, null, null, null, null, false, null, "公告修改状态", 0, "sysNotice:changeStatus", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918754L, "manage", "sys_notice_mgr_received", "system/noticeReceived/index", null, null, null, null, false, null, "已收公告", 1, null, 142307070918746L, "[0],[142307070918746],", null, null, "/noticeReceived", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918755L, "manage", "sys_notice_mgr_received_page", null, null, null, null, null, false, null, "已收公告查询", 0, "sysNotice:received", 142307070918754L, "[0],[142307070918746],[142307070918754],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918756L, "manage", "sys_file_mgr", "PageView", null, null, null, "file", false, null, "文件管理", 0, null, 0L, "[0],", null, null, "/file", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070918757L, "manage", "sys_file_mgr_sys_file", "system/file/index", null, null, null, null, false, null, "系统文件", 1, null, 142307070918756L, "[0],[142307070918756],", null, null, "/file", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918758L, "manage", "sys_file_mgr_sys_file_page", null, null, null, null, null, false, null, "文件查询", 0, "sysFileInfo:page", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918759L, "manage", "sys_file_mgr_sys_file_list", null, null, null, null, null, false, null, "文件列表", 0, "sysFileInfo:list", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918760L, "manage", "sys_file_mgr_sys_file_delete", null, null, null, null, null, false, null, "文件删除", 0, "sysFileInfo:delete", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918761L, "manage", "sys_file_mgr_sys_file_detail", null, null, null, null, null, false, null, "文件详情", 0, "sysFileInfo:detail", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918762L, "manage", "sys_file_mgr_sys_file_upload", null, null, null, null, null, false, null, "文件上传", 0, "sysFileInfo:upload", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918763L, "manage", "sys_file_mgr_sys_file_download", null, null, null, null, null, false, null, "文件下载", 0, "sysFileInfo:download", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918764L, "manage", "sys_file_mgr_sys_file_preview", null, null, null, null, null, false, null, "图片预览", 0, "sysFileInfo:preview", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918765L, "system", "sys_timers", "PageView", null, null, null, "dashboard", false, null, "任务调度", 0, null, 0L, "[0],", null, null, "/timers", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070918766L, "system", "sys_timers_mgr", "system/timers/index", null, null, null, null, false, null, "任务管理", 1, null, 142307070918765L, "[0],[142307070918765],", null, null, "/timers", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918767L, "system", "sys_timers_mgr_page", null, null, null, null, null, false, null, "定时任务查询", 0, "sysTimers:page", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918768L, "system", "sys_timers_mgr_list", null, null, null, null, null, false, null, "定时任务列表", 0, "sysTimers:list", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918769L, "system", "sys_timers_mgr_detail", null, null, null, null, null, false, null, "定时任务详情", 0, "sysTimers:detail", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918770L, "system", "sys_timers_mgr_add", null, null, null, null, null, false, null, "定时任务增加", 0, "sysTimers:add", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918771L, "system", "sys_timers_mgr_delete", null, null, null, null, null, false, null, "定时任务删除", 0, "sysTimers:delete", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918772L, "system", "sys_timers_mgr_edit", null, null, null, null, null, false, null, "定时任务编辑", 0, "sysTimers:edit", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918773L, "system", "sys_timers_mgr_get_action_classes", null, null, null, null, null, false, null, "定时任务可执行列表", 0, "sysTimers:getActionClasses", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918774L, "system", "sys_timers_mgr_start", null, null, null, null, null, false, null, "定时任务启动", 0, "sysTimers:start", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918775L, "system", "sys_timers_mgr_stop", null, null, null, null, null, false, null, "定时任务关闭", 0, "sysTimers:stop", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070918776L, "system", "code_gen", "PageView", null, null, null, "thunderbolt", false, null, "代码生成", 0, null, 0L, "[0],", null, null, "/codeGenerate", 100, 0, 0, null, null, null, "Y", 1 },
| { 142307070918777L, "manage", "sys_user_mgr_login", null, null, null, null, null, false, null, "用户登录信息", 0, "getLoginUser", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 1, 2, null, null, null, "N", 1 },
| { 142307070918778L, "system", "low_code", "gen/lowCode/index", null, null, null, null, false, null, "表单设计", 0, null, 142307070918776L, "[0],[142307070918776],", null, null, "/lowCode/index", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070918779L, "system", "code_gen_gen", "gen/codeGenerate/index", null, null, null, null, false, null, "代码生成", 0, null, 142307070918776L, "[0],[142307070918776],", null, null, "/codeGenerate/index", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070922870L, "system", "form_design", "system/formDesign/index", null, null, null, null, false, null, "表单设计", 0, null, 285599875018821L, "[0],[285599875018821],", null, null, "/formDesign/index", 100, 0, 1, null, null, null, "Y", 1 },
| { 142307070922874L, "manage", "sys_file_mgr_sys_file_upload_avatar", null, null, null, null, null, false, null, "头像上传", 0, "sysFileInfo:uploadAvatar", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070922875L, "manage", "sys_file_mgr_sys_file_upload_document", null, null, null, null, null, false, null, "文档上传", 0, "sysFileInfo:uploadDocument", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 142307070922876L, "manage", "sys_file_mgr_sys_file_upload_shop", null, null, null, null, null, false, null, "商城上传", 0, "sysFileInfo:uploadShop", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 },
| { 285599875018821L, "system", "sys_formDesign", "PageView", null, null, null, "snippets", false, null, "表单管理", 1, null, 0L, "[0],", null, null, "/formDesign", 100, 0, 0, null, null, null, "Y", 1 },
| { 285599875018823L, "system", "sys_formDesign_list", "system/formDesign/list", null, null, null, null, false, null, "表单列表", 1, null, 285599875018821L, "[0],[285599875018821],", null, null, "/formDesign/list", 100, 0, 1, null, null, null, "Y", 1 },
| { 285635743518789L, "system", "sys_formDesign_edit", "system/formDesign/edit", null, null, null, null, false, null, "修改表单", 1, null, 285599875018821L, "[0],[285599875018821],", null, null, "/formDesign/edit", 100, 0, 1, null, null, null, "N", 1 },
| { 285640475689029L, "system", "btn_formDesign_edit", "", null, null, null, null, false, null, "修改表单", 0, "formmanager:edit", 285599875018823L, "[0],[285599875018821],[285599875018823],", null, null, "", 100, 0, 2, null, null, null, "Y", 1 },
| { 285640599859269L, "system", "btn_formDesign_delete", "", null, null, null, null, false, null, "删除表单", 0, "formmanager:delete", 285599875018823L, "[0],[285599875018821],[285599875018823],", null, null, "", 100, 0, 2, null, null, null, "Y", 1 },
| { 285640740945989L, "system", "btn_formDesign_page", "", null, null, null, null, false, null, "表单列表", 0, "formmanager:page", 285599875018823L, "[0],[285599875018821],[285599875018823],", null, null, "", 100, 0, 2, null, null, null, "Y", 1 }
| });
|
| migrationBuilder.InsertData(
| table: "sys_menu",
| columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "Weight" },
| values: new object[,]
| {
| { 355687925174341L, "busiapp", "Maste_wmscontainer_mgr", "main/WmsContainer/index", null, null, null, "border", false, null, "托盘信息", 1, null, 0L, "[0],", null, null, "/wmscontainer", 100, 0, 1, null, null, null, "Y", 2 },
| { 355687925178437L, "busiapp", "Maste_wmscontainer_mgr_page", null, null, null, null, null, false, null, "托盘信息查询", 0, "WmsContainer:page", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355687925178438L, "busiapp", "Maste_wmscontainer_mgr_detail", null, null, null, null, null, false, null, "托盘信息详情", 0, "WmsContainer:detail", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355687925178439L, "busiapp", "Maste_wmscontainer_mgr_add", null, null, null, null, null, false, null, "托盘信息增加", 0, "WmsContainer:add", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355687925182533L, "busiapp", "Maste_wmscontainer_mgr_delete", null, null, null, null, null, false, null, "托盘信息删除", 0, "WmsContainer:delete", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355687925182534L, "busiapp", "Maste_wmscontainer_mgr_edit", null, null, null, null, null, false, null, "托盘信息编辑", 0, "WmsContainer:edit", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355688792178757L, "busiapp", "Maste_wmsarea_mgr", "main/WmsArea/index", null, null, null, "appstore", false, null, "库区信息", 1, null, 0L, "[0],", null, null, "/wmsarea", 100, 0, 1, null, null, null, "Y", 2 },
| { 355688792182853L, "busiapp", "Maste_wmsarea_mgr_page", null, null, null, null, null, false, null, "库区信息查询", 0, "WmsArea:page", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355688792182854L, "busiapp", "Maste_wmsarea_mgr_detail", null, null, null, null, null, false, null, "库区信息详情", 0, "WmsArea:detail", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355688792186949L, "busiapp", "Maste_wmsarea_mgr_add", null, null, null, null, null, false, null, "库区信息增加", 0, "WmsArea:add", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355688792186950L, "busiapp", "Maste_wmsarea_mgr_delete", null, null, null, null, null, false, null, "库区信息删除", 0, "WmsArea:delete", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355688792186951L, "busiapp", "Maste_wmsarea_mgr_edit", null, null, null, null, null, false, null, "库区信息编辑", 0, "WmsArea:edit", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355689496985669L, "busiapp", "Maste_wmsplace_mgr", "main/WmsPlace/index", null, null, null, "table", false, null, "库位信息", 1, null, 0L, "[0],", null, null, "/wmsplace", 100, 0, 1, null, null, null, "Y", 2 },
| { 355689496989765L, "busiapp", "Maste_wmsplace_mgr_page", null, null, null, null, null, false, null, "库位信息查询", 0, "WmsPlace:page", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355689496993861L, "busiapp", "Maste_wmsplace_mgr_detail", null, null, null, null, null, false, null, "库位信息详情", 0, "WmsPlace:detail", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355689496993862L, "busiapp", "Maste_wmsplace_mgr_add", null, null, null, null, null, false, null, "库位信息增加", 0, "WmsPlace:add", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355689496993863L, "busiapp", "Maste_wmsplace_mgr_delete", null, null, null, null, null, false, null, "库位信息删除", 0, "WmsPlace:delete", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355689496993864L, "busiapp", "Maste_wmsplace_mgr_edit", null, null, null, null, null, false, null, "库位信息编辑", 0, "WmsPlace:edit", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355690042511429L, "busiapp", "Maste_wmsmaterial_mgr", "main/WmsMaterial/index", null, null, null, "barcode", false, null, "物料信息", 1, null, 0L, "[0],", null, null, "/wmsmaterial", 100, 0, 1, null, null, null, "Y", 2 },
| { 355690042515525L, "busiapp", "Maste_wmsmaterial_mgr_page", null, null, null, null, null, false, null, "物料信息查询", 0, "WmsMaterial:page", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355690042519621L, "busiapp", "Maste_wmsmaterial_mgr_detail", null, null, null, null, null, false, null, "物料信息详情", 0, "WmsMaterial:detail", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355690042519622L, "busiapp", "Maste_wmsmaterial_mgr_add", null, null, null, null, null, false, null, "物料信息增加", 0, "WmsMaterial:add", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355690042519623L, "busiapp", "Maste_wmsmaterial_mgr_delete", null, null, null, null, null, false, null, "物料信息删除", 0, "WmsMaterial:delete", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355690042519624L, "busiapp", "Maste_wmsmaterial_mgr_edit", null, null, null, null, null, false, null, "物料信息编辑", 0, "WmsMaterial:edit", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 },
| { 355690923847749L, "warejob", "BindEntrance", "main/BindEntrance/index", null, null, null, "logout", false, null, "组盘入库", 1, null, 0L, "[0],", null, null, "/BindEntrance", 100, 0, 1, null, null, null, "Y", 2 },
| { 355691450822725L, "warejob", "ExWarehouse", "main/ExWarehouse/index", null, null, null, "login", false, null, "出库管理", 1, null, 0L, "[0],", null, null, "/ExWarehouse", 100, 0, 1, null, null, null, "Y", 2 },
| { 355691891650629L, "warejob", "WmsTask", "main/WmsTask/index", null, null, null, "hourglass", false, null, "任务管理", 1, null, 0L, "[0],", null, null, "/WmsTask", 100, 0, 1, null, null, null, "Y", 2 },
| { 355692253458501L, "warecount", "LocationView", "main/LocationView/index", null, null, null, "hdd", false, null, "库位视图", 1, null, 0L, "[0],", null, null, "/LocationView", 100, 0, 1, null, null, null, "Y", 2 },
| { 355692487622725L, "warecount", "View_AccessDetails", "main/View_AccessDetails/index", null, null, null, "laptop", false, null, "出入库记录", 1, null, 0L, "[0],", null, null, "/View_AccessDetails", 100, 0, 1, null, null, null, "Y", 2 }
| });
|
| migrationBuilder.InsertData(
| table: "sys_org",
| columns: new[] { "Id", "Code", "Contacts", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "OrgType", "Pid", "Pids", "Remark", "Sort", "Status", "Tel", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 142307070910539L, "wbgf", null, null, null, null, false, "伟本股份有限公司", null, 0L, "[0],", "伟本股份有限公司", 100, 0, null, null, null, null },
| { 142307070910540L, "wbgf_sh", null, null, null, null, false, "伟本股份有限公司(上海)", null, 142307070910539L, "[0],[142307070910539],", "伟本股份有限公司-上海", 100, 0, null, null, null, null },
| { 142307070910541L, "wbgf_cq", null, null, null, null, false, "伟本股份有限公司(重庆)", null, 142307070910539L, "[0],[142307070910539],", "伟本股份有限公司-重庆", 100, 0, null, null, null, null },
| { 142307070910542L, "wbgf_sh_yfb", null, null, null, null, false, "研发部", null, 142307070910540L, "[0],[142307070910539],[142307070910540],", "", 100, 0, null, null, null, null },
| { 142307070910543L, "wbgf_sh_qhb", null, null, null, null, false, "企划部", null, 142307070910540L, "[0],[142307070910539],[142307070910540],", "", 100, 0, null, null, null, null },
| { 142307070910544L, "wbgf_cq_scb", null, null, null, null, false, "市场部", null, 142307070910541L, "[0],[142307070910539],[142307070910541],", "", 100, 0, null, null, null, null },
| { 142307070910545L, "wbgf_cq_cwb", null, null, null, null, false, "财务部", null, 142307070910541L, "[0],[142307070910539],[142307070910541],", "", 100, 0, null, null, null, null },
| { 142307070910546L, "wbgf_cq_scb", null, null, null, null, false, "市场部二部", null, 142307070910544L, "[0],[142307070910539],[142307070910541],[142307070910544],", "", 100, 0, null, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_pos",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 142307070910547L, "zjl", null, null, null, false, "总经理", "总经理", 100, 0, null, null, null },
| { 142307070910548L, "fzjl", null, null, null, false, "副总经理", "副总经理", 101, 0, null, null, null },
| { 142307070910549L, "bmjl", null, null, null, false, "部门经理", "部门经理", 102, 0, null, null, null },
| { 142307070910550L, "gzry", null, null, null, false, "工作人员", "工作人员", 103, 0, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_role",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "DataScopeType", "IsDeleted", "Name", "Remark", "RoleType", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[] { 142307070910554L, "sys_manager_role", null, null, null, 1, false, "系统管理员", "系统管理员", 0, 100, 0, null, null, null });
|
| migrationBuilder.InsertData(
| table: "sys_role",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "DataScopeType", "IsDeleted", "Name", "Remark", "RoleType", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 356094617575493L, "admin", null, null, null, 1, false, "管理员", "", 0, 100, 0, null, null, null },
| { 358509609758789L, "ware", null, null, null, 1, false, "仓库用户", "", 0, 100, 0, null, null, null },
| { 358536344862789L, "iWare", null, null, null, 5, false, "研发用户", "", 0, 100, 0, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_timer",
| columns: new[] { "Id", "CreatedTime", "CreatedUserId", "CreatedUserName", "Cron", "DoOnce", "ExecuteType", "Headers", "Interval", "IsDeleted", "JobName", "Remark", "RequestParameters", "RequestType", "RequestUrl", "StartNow", "TimerType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[] { 142307070910556L, null, null, null, null, false, 1, null, 5, false, "百度api", "接口API", null, 2, "https://www.baidu.com", false, 0, null, null, null });
|
| migrationBuilder.InsertData(
| table: "sys_user",
| columns: new[] { "Id", "Account", "AdminType", "Avatar", "Birthday", "CreatedTime", "CreatedUserId", "CreatedUserName", "Email", "IsDeleted", "LastLoginIp", "LastLoginTime", "Name", "NickName", "Password", "Phone", "Sex", "Status", "Tel", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 142307070910551L, "superAdmin", 1, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "超级管理员", "superAdmin", "e10adc3949ba59abbe56e057f20f883e", "18020030720", 1, 0, null, null, null, null },
| { 142307070910552L, "admin", 2, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "系统管理员", "admin", "e10adc3949ba59abbe56e057f20f883e", "18020030720", 1, 0, null, null, null, null },
| { 358533464608837L, "warehouse", 3, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "仓库用户", "warehouse", "e10adc3949ba59abbe56e057f20f883e", "13869156666", 1, 0, null, null, null, null },
| { 358536045723717L, "admin1", 3, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "研发部", "admin1", "f379eaf3c831b04de153469d1bec345e", "13869156666", 1, 0, null, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_area",
| columns: new[] { "Id", "AreaDesc", "AreaName", "AreaStatus", "AreaType", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 355701739634757L, "", "A区", 0, 2, null, null, null, false, null, null, null },
| { 358851237277765L, "", "B区", 0, 1, null, null, null, false, null, null, null },
| { 358851309400133L, "", "C区", 0, 3, null, null, null, false, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_container",
| columns: new[] { "Id", "ContainerCode", "ContainerStatus", "ContainerType", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "LimitHeight", "LimitLength", "LimitWidth", "MaxWeight", "ParentContainerId", "SpecHeight", "SpecLength", "SpecWidth", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 358852634767429L, "TM00001", 1, 3, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358852767887429L, "TM00002", 2, 3, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358852831047749L, "TM00003", 3, 1, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358853016055877L, "TM00004", 3, 1, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358853070798917L, "TM00005", 3, 2, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358853146058821L, "TM00006", 1, 2, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358853199671365L, "TM00007", 1, 0, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null },
| { 358853255102533L, "TM00008", 1, 3, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_containerplace",
| columns: new[] { "Id", "ContainerCode", "ContainerId", "ContainerPlaceStatus", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "PlaceCode", "PlaceId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "WmsContainerId", "WmsPlaceId" },
| values: new object[,]
| {
| { 358853586010181L, "TM00001", 358852634767429L, 2, null, null, null, false, "1-1-1-1-1", 358852152045637L, null, null, null, null, null },
| { 358856088039493L, "TM00001", 358852634767429L, 2, null, null, null, false, "1-1-1-2-1", 358852152119365L, null, null, null, null, null },
| { 358856888660037L, "TM00002", 358852767887429L, 2, null, null, null, false, "1-1-1-1-1", 358852152045637L, null, null, null, null, null },
| { 358857243414597L, "TM00003", 358852831047749L, 0, null, null, null, false, "1-1-1-5-1", 358852152156229L, null, null, null, null, null },
| { 358857693601867L, "TM00004", 358853016055877L, 0, null, null, null, false, "1-1-1-1-1", 358852152045637L, null, null, null, null, null },
| { 358858262188101L, "TM00005", 358853070798917L, 0, null, null, null, false, "1-1-1-4-1", 358852152143941L, null, null, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_material",
| columns: new[] { "Id", "CreatedTime", "CreatedUserId", "CreatedUserName", "Description", "ErpNo", "GraphNo", "InspectionMethod", "IsDeleted", "Keymaterials", "MaterialBatch", "MaterialName", "MaterialNo", "MaterialSpec", "MaterialType", "MaxImumqty", "MaxstorageAge", "MinstorageAge", "Qccategory", "Safeqty", "UnitNo", "UnitType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Warranty" },
| values: new object[,]
| {
| { 355707111780421L, null, null, null, null, null, null, 1, false, 0, "3570100022", "LAPP动力电缆", "3570100022", "OLFLEX CLASSIC 110 5G6", 1, 100m, 1m, 1m, null, 100m, 1, 1, null, null, null, 100m },
| { 358845906632773L, null, null, null, null, null, null, 1, false, 0, "3070400120", "气动拧松枪", "3070400120", "16SUP PRO", 1, 100m, 1m, 1m, null, 100m, 1, 1, null, null, null, 10m },
| { 358847125188677L, null, null, null, null, null, null, 1, false, 0, "3110800160", "定位销", "3110800160", "YDL31-D8-P12-L18-B8-X", 2, 1m, 1m, 1m, null, 100m, 1, 1, null, null, null, 1m },
| { 358847583273029L, null, null, null, null, null, null, 2, false, 0, "3090200565", "防爆传感器", "3090200565", "BND-JA12GT4-24PH-25M-TL", 3, 1m, 1m, 1m, null, 1m, 2, 2, null, null, null, 1m },
| { 358847917588549L, null, null, null, null, null, null, 2, false, 1, "2200074125", "套筒收纳盒安装板", "2200074125", "4301015-40-110-04-01", 3, 1m, 1m, 1m, null, 100m, 1, 1, null, null, null, 1m },
| { 358848226168901L, null, null, null, null, null, null, 1, false, 0, "2200074102", "传感器安装支架", "2200074102", "40488-020-D086", 2, 1m, 1m, 1m, null, 100m, 2, 2, null, null, null, 100m },
| { 358851158249541L, null, null, null, null, null, null, 2, false, 1, "1222202451", "电机", "1222202451", "LA21038-020.01-01.10", 3, 100m, 1m, 1m, null, 100m, 2, 2, null, null, null, 1m }
| });
|
| migrationBuilder.InsertData(
| table: "wms_materialstock",
| columns: new[] { "Id", "AreaId", "ContainerCode", "CreatedTime", "CreatedUserId", "CreatedUserName", "InspectionMethod", "IsDeleted", "MaterialBatch", "MaterialName", "MaterialNo", "MaterialSpec", "MaterialType", "PlaceCode", "StockNumber", "UnitNo", "UnitType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 358853586690117L, 0L, "TM00001", null, null, null, 1, false, "N/A", "N/A", "N/A", "N/A", 4, "N/A", 0m, 2, 2, null, null, null },
| { 358856888787013L, 0L, "TM00002", null, null, null, 1, false, "3070400120", "气动拧松枪", "3070400120", "16SUP PRO", 1, "N/A", 0m, 1, 1, null, null, null },
| { 358857243504709L, 355701739634757L, "TM00003", null, null, null, 1, false, "N/A", "N/A", "N/A", "N/A", 4, "1-1-1-5-1", 1m, 2, 2, null, null, null },
| { 358857693638725L, 355701739634757L, "TM00004", null, null, null, 1, false, "3070400120", "气动拧松枪", "3070400120", "16SUP PRO", 1, "1-1-1-1-1", 100m, 1, 1, null, null, null },
| { 358857693646917L, 355701739634757L, "TM00004", null, null, null, 1, false, "3110800160", "定位销", "3110800160", "YDL31-D8-P12-L18-B8-X", 2, "1-1-1-1-1", 100m, 1, 1, null, null, null },
| { 358858262392901L, 355701739634757L, "TM00005", null, null, null, 2, false, "1222202451", "电机", "1222202451", "LA21038-020.01-01.10", 3, "1-1-1-4-1", 10m, 2, 2, null, null, null },
| { 358858262401093L, 355701739634757L, "TM00005", null, null, null, 1, false, "2200074102", "传感器安装支架", "2200074102", "40488-020-D086", 2, "1-1-1-4-1", 1m, 2, 2, null, null, null },
| { 358858262409285L, 355701739634757L, "TM00005", null, null, null, 2, false, "2200074125", "套筒收纳盒安装板", "2200074125", "4301015-40-110-04-01", 3, "1-1-1-4-1", 10m, 1, 1, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_task",
| columns: new[] { "Id", "Aisle", "AreaName", "ContainerCode", "CreatedTime", "CreatedUserId", "CreatedUserName", "DodeviceId", "DodevicenodeId", "Dodevicetype", "IsDeleted", "OrderNo", "SendTimes", "SourcePlace", "TaskLevel", "TaskModel", "TaskNo", "TaskStatus", "TaskType", "ToPlace", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 358853585506373L, 1, "A区", "TM00001", null, null, null, 0, null, null, false, "N/A", 0, "N/A", 1, 1, "358853585506374", 3, 1, "1-1-1-1-1", null, null, null },
| { 358856088019013L, 1, "A区", "TM00001", null, null, null, 0, null, null, false, "N/A", 0, "1-1-1-1-1", 1, 1, "358856088019014", 3, 3, "1-1-1-2-1", null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_task",
| columns: new[] { "Id", "Aisle", "AreaName", "ContainerCode", "CreatedTime", "CreatedUserId", "CreatedUserName", "DodeviceId", "DodevicenodeId", "Dodevicetype", "IsDeleted", "OrderNo", "SendTimes", "SourcePlace", "TaskLevel", "TaskModel", "TaskNo", "TaskStatus", "TaskType", "ToPlace", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 358856349995077L, 1, "A区", "TM00001", null, null, null, 0, null, null, false, "N/A", 0, "1-1-1-2-1", 1, 1, "358856349995078", 3, 2, "N/A", null, null, null },
| { 358856845733957L, 1, "A区", "TM00002", null, null, null, 0, null, null, false, "358856845353029", 0, "100", 1, 2, "358856845733958", 3, 1, "1-1-1-1-1", null, null, null },
| { 358856980553799L, 1, "A区", "TM00002", null, null, null, 0, null, null, false, "358856980553798", 0, "1-1-1-1-1", 1, 2, "358856980553800", 3, 2, "101", null, null, null },
| { 358857243410501L, 1, "A区", "TM00003", null, null, null, 0, null, null, false, "N/A", 0, "N/A", 1, 1, "358857243410502", 3, 1, "1-1-1-5-1", null, null, null },
| { 358857618247749L, 1, "A区", "TM00004", null, null, null, 0, null, null, false, "358857618075717", 0, "101", 1, 2, "358857618247750", 3, 1, "1-1-1-1-1", null, null, null },
| { 358858262179909L, 1, "A区", "TM00005", null, null, null, 0, null, null, false, "358858261872712", 0, "N/A", 1, 1, "358858262179910", 3, 1, "1-1-1-4-1", null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "sys_dict_data",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Remark", "Sort", "Status", "TypeId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
| values: new object[,]
| {
| { 142307070902375L, "1", null, null, null, false, "男性", 100, 0, 142307070906484L, null, null, null, "男" },
| { 142307070902376L, "2", null, null, null, false, "女性", 100, 0, 142307070906484L, null, null, null, "女" },
| { 142307070902377L, "3", null, null, null, false, "未知性别", 100, 0, 142307070906484L, null, null, null, "未知" },
| { 142307070902384L, "0", null, null, null, false, "正常", 100, 0, 142307070906483L, null, null, null, "正常" },
| { 142307070902385L, "1", null, null, null, false, "停用", 100, 0, 142307070906483L, null, null, null, "停用" },
| { 142307070902386L, "2", null, null, null, false, "删除", 100, 0, 142307070906483L, null, null, null, "删除" },
| { 142307070902387L, "N", null, null, null, false, "否", 100, 0, 142307070906486L, null, null, null, "否" },
| { 142307070902388L, "Y", null, null, null, false, "是", 100, 0, 142307070906486L, null, null, null, "是" },
| { 142307070902389L, "1", null, null, null, false, "登录", 100, 0, 142307070906487L, null, null, null, "登录" },
| { 142307070902390L, "2", null, null, null, false, "登出", 100, 0, 142307070906487L, null, null, null, "登出" },
| { 142307070902391L, "0", null, null, null, false, "目录", 100, 0, 142307070906488L, null, null, null, "目录" },
| { 142307070902392L, "1", null, null, null, false, "菜单", 100, 0, 142307070906488L, null, null, null, "菜单" },
| { 142307070902393L, "2", null, null, null, false, "按钮", 100, 0, 142307070906488L, null, null, null, "按钮" },
| { 142307070902394L, "0", null, null, null, false, "未发送", 100, 0, 142307070906489L, null, null, null, "未发送" },
| { 142307070902395L, "1", null, null, null, false, "发送成功", 100, 0, 142307070906489L, null, null, null, "发送成功" },
| { 142307070902396L, "2", null, null, null, false, "发送失败", 100, 0, 142307070906489L, null, null, null, "发送失败" },
| { 142307070902397L, "3", null, null, null, false, "失效", 100, 0, 142307070906489L, null, null, null, "失效" },
| { 142307070902398L, "0", null, null, null, false, "无", 100, 0, 142307070906490L, null, null, null, "无" },
| { 142307070902399L, "1", null, null, null, false, "组件", 100, 0, 142307070906490L, null, null, null, "组件" },
| { 142307070906437L, "2", null, null, null, false, "内链", 100, 0, 142307070906490L, null, null, null, "内链" },
| { 142307070906438L, "3", null, null, null, false, "外链", 100, 0, 142307070906490L, null, null, null, "外链" },
| { 142307070906439L, "1", null, null, null, false, "系统权重", 100, 0, 142307070906491L, null, null, null, "系统权重" },
| { 142307070906440L, "2", null, null, null, false, "业务权重", 100, 0, 142307070906491L, null, null, null, "业务权重" },
| { 142307070906441L, "1", null, null, null, false, "全部数据", 100, 0, 142307070906492L, null, null, null, "全部数据" },
| { 142307070906442L, "2", null, null, null, false, "本部门及以下数据", 100, 0, 142307070906492L, null, null, null, "本部门及以下数据" },
| { 142307070906443L, "3", null, null, null, false, "本部门数据", 100, 0, 142307070906492L, null, null, null, "本部门数据" },
| { 142307070906444L, "4", null, null, null, false, "仅本人数据", 100, 0, 142307070906492L, null, null, null, "仅本人数据" },
| { 142307070906445L, "5", null, null, null, false, "自定义数据", 100, 0, 142307070906492L, null, null, null, "自定义数据" },
| { 142307070906449L, "0", null, null, null, false, "其它", 100, 0, 142307070906494L, null, null, null, "其它" },
| { 142307070906450L, "1", null, null, null, false, "增加", 100, 0, 142307070906494L, null, null, null, "增加" },
| { 142307070906451L, "2", null, null, null, false, "删除", 100, 0, 142307070906494L, null, null, null, "删除" },
| { 142307070906452L, "3", null, null, null, false, "编辑", 100, 0, 142307070906494L, null, null, null, "编辑" },
| { 142307070906453L, "4", null, null, null, false, "更新", 100, 0, 142307070906494L, null, null, null, "更新" },
| { 142307070906454L, "5", null, null, null, false, "查询", 100, 0, 142307070906494L, null, null, null, "查询" },
| { 142307070906455L, "6", null, null, null, false, "详情", 100, 0, 142307070906494L, null, null, null, "详情" },
| { 142307070906456L, "7", null, null, null, false, "树", 100, 0, 142307070906494L, null, null, null, "树" },
| { 142307070906457L, "8", null, null, null, false, "导入", 100, 0, 142307070906494L, null, null, null, "导入" },
| { 142307070906458L, "9", null, null, null, false, "导出", 100, 0, 142307070906494L, null, null, null, "导出" },
| { 142307070906459L, "10", null, null, null, false, "授权", 100, 0, 142307070906494L, null, null, null, "授权" },
| { 142307070906460L, "11", null, null, null, false, "强退", 100, 0, 142307070906494L, null, null, null, "强退" },
| { 142307070906461L, "12", null, null, null, false, "清空", 100, 0, 142307070906494L, null, null, null, "清空" },
| { 142307070906462L, "13", null, null, null, false, "修改状态", 100, 0, 142307070906494L, null, null, null, "修改状态" }
| });
|
| migrationBuilder.InsertData(
| table: "sys_dict_data",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Remark", "Sort", "Status", "TypeId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
| values: new object[,]
| {
| { 142307070906463L, "1", null, null, null, false, "阿里云", 100, 0, 142307070906495L, null, null, null, "阿里云" },
| { 142307070906464L, "2", null, null, null, false, "腾讯云", 100, 0, 142307070906495L, null, null, null, "腾讯云" },
| { 142307070906465L, "3", null, null, null, false, "minio", 100, 0, 142307070906495L, null, null, null, "minio" },
| { 142307070906466L, "4", null, null, null, false, "本地", 100, 0, 142307070906495L, null, null, null, "本地" },
| { 142307070906467L, "1", null, null, null, false, "运行", 100, 0, 142307070910533L, null, null, null, "运行" },
| { 142307070906468L, "2", null, null, null, false, "停止", 100, 0, 142307070910533L, null, null, null, "停止" },
| { 142307070906469L, "1", null, null, null, false, "通知", 100, 0, 142307070910534L, null, null, null, "通知" },
| { 142307070906470L, "2", null, null, null, false, "公告", 100, 0, 142307070910534L, null, null, null, "公告" },
| { 142307070906471L, "0", null, null, null, false, "草稿", 100, 0, 142307070910535L, null, null, null, "草稿" },
| { 142307070906472L, "1", null, null, null, false, "发布", 100, 0, 142307070910535L, null, null, null, "发布" },
| { 142307070906473L, "2", null, null, null, false, "撤回", 100, 0, 142307070910535L, null, null, null, "撤回" },
| { 142307070906474L, "3", null, null, null, false, "删除", 100, 0, 142307070910535L, null, null, null, "删除" },
| { 142307070906475L, "true", null, null, null, false, "是", 100, 0, 142307070910536L, null, null, null, "是" },
| { 142307070906476L, "false", null, null, null, false, "否", 100, 0, 142307070910536L, null, null, null, "否" },
| { 142307070906477L, "1", null, null, null, false, "下载压缩包", 100, 0, 142307070910537L, null, null, null, "下载压缩包" },
| { 142307070906478L, "2", null, null, null, false, "生成到本项目", 100, 0, 142307070910537L, null, null, null, "生成到本项目" },
| { 142307070906479L, "1", null, null, null, false, "GET", 100, 0, 142307070910538L, null, null, null, "GET" },
| { 142307070906480L, "2", null, null, null, false, "POST", 100, 0, 142307070910538L, null, null, null, "POST" },
| { 142307070906481L, "3", null, null, null, false, "PUT", 100, 0, 142307070910538L, null, null, null, "PUT" },
| { 142307070906482L, "4", null, null, null, false, "DELETE", 100, 0, 142307070910538L, null, null, null, "DELETE" },
| { 142307070922829L, "fk", null, null, null, false, "外键", 100, 0, 142307070922827L, null, null, null, "外键" },
| { 142307070922830L, "input", null, null, null, false, "输入框", 100, 0, 142307070922827L, null, null, null, "输入框" },
| { 142307070922831L, "datepicker", null, null, null, false, "时间选择", 100, 0, 142307070922827L, null, null, null, "时间选择" },
| { 142307070922832L, "select", null, null, null, false, "下拉框", 100, 0, 142307070922827L, null, null, null, "下拉框" },
| { 142307070922833L, "radio", null, null, null, false, "单选框", 100, 0, 142307070922827L, null, null, null, "单选框" },
| { 142307070922834L, "switch", null, null, null, false, "开关", 100, 0, 142307070922827L, null, null, null, "开关" },
| { 142307070922835L, "checkbox", null, null, null, false, "多选框", 100, 0, 142307070922827L, null, null, null, "多选框" },
| { 142307070922836L, "inputnumber", null, null, null, false, "数字输入框", 100, 0, 142307070922827L, null, null, null, "数字输入框" },
| { 142307070922837L, "textarea", null, null, null, false, "文本域", 100, 0, 142307070922827L, null, null, null, "文本域" },
| { 142307070922838L, "==", null, null, null, false, "等于", 1, 0, 142307070922828L, null, null, null, "等于" },
| { 142307070922839L, "like", null, null, null, false, "模糊", 2, 0, 142307070922828L, null, null, null, "模糊" },
| { 142307070922840L, ">", null, null, null, false, "大于", 3, 0, 142307070922828L, null, null, null, "大于" },
| { 142307070922841L, "<", null, null, null, false, "小于", 4, 0, 142307070922828L, null, null, null, "小于" },
| { 142307070922842L, "!=", null, null, null, false, "不等于", 5, 0, 142307070922828L, null, null, null, "不等于" },
| { 142307070922843L, ">=", null, null, null, false, "大于等于", 6, 0, 142307070922828L, null, null, null, "大于等于" },
| { 142307070922844L, "<=", null, null, null, false, "小于等于", 7, 0, 142307070922828L, null, null, null, "小于等于" },
| { 142307070922845L, "isNotNull", null, null, null, false, "不为空", 8, 0, 142307070922828L, null, null, null, "不为空" },
| { 142307070922846L, "long", null, null, null, false, "long", 100, 0, 142307070922829L, null, null, null, "long" },
| { 142307070922847L, "string", null, null, null, false, "string", 100, 0, 142307070922829L, null, null, null, "string" },
| { 142307070922848L, "DateTime", null, null, null, false, "DateTime", 100, 0, 142307070922829L, null, null, null, "DateTime" },
| { 142307070922850L, "bool", null, null, null, false, "bool", 100, 0, 142307070922829L, null, null, null, "bool" },
| { 142307070922851L, "int", null, null, null, false, "int", 100, 0, 142307070922829L, null, null, null, "int" }
| });
|
| migrationBuilder.InsertData(
| table: "sys_dict_data",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Remark", "Sort", "Status", "TypeId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
| values: new object[,]
| {
| { 142307070922852L, "double", null, null, null, false, "double", 100, 0, 142307070922829L, null, null, null, "double" },
| { 142307070922861L, "float", null, null, null, false, "float", 100, 0, 142307070922829L, null, null, null, "float" },
| { 142307070922862L, "decimal", null, null, null, false, "decimal", 100, 0, 142307070922829L, null, null, null, "decimal" },
| { 142307070922863L, "Guid", null, null, null, false, "Guid", 100, 0, 142307070922829L, null, null, null, "Guid" },
| { 142307070922864L, "DateTimeOffset", null, null, null, false, "DateTimeOffset", 100, 0, 142307070922829L, null, null, null, "DateTimeOffset" },
| { 142307070926943L, "0", null, null, null, false, "集团角色", 100, 0, 142307070926941L, null, null, null, "集团角色" },
| { 142307070926944L, "1", null, null, null, false, "加盟商角色", 100, 0, 142307070926941L, null, null, null, "加盟商角色" },
| { 142307070926945L, "2", null, null, null, false, "门店角色", 100, 0, 142307070926941L, null, null, null, "门店角色" },
| { 142307070926946L, "1", null, null, null, false, "一级", 100, 0, 142307070926942L, null, null, null, "一级" },
| { 142307070926947L, "2", null, null, null, false, "二级", 100, 0, 142307070926942L, null, null, null, "二级" },
| { 142307070926948L, "3", null, null, null, false, "三级", 100, 0, 142307070926942L, null, null, null, "三级" },
| { 142307070926949L, "4", null, null, null, false, "四级", 100, 0, 142307070926942L, null, null, null, "四级" },
| { 285605336563781L, "DefaultFormType", null, null, null, false, "默认表单分类", 100, 0, 285605149831237L, null, null, null, "默认表单分类" },
| { 285641495289925L, "DefaultGroup", null, null, null, false, "默认分类", 100, 0, 285641358889029L, null, null, null, "默认分类" },
| { 355697634480197L, "0", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "其他" },
| { 355697676427333L, "1", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "木质" },
| { 355697726726213L, "2", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "金属" },
| { 355697755361349L, "3", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "塑料" },
| { 355697944657989L, "0", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "禁用" },
| { 355697974415429L, "1", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "空闲" },
| { 355698005966917L, "2", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "组盘" },
| { 355698032828485L, "3", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "库位" },
| { 355698270015557L, "0", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "其他" },
| { 355698303508549L, "1", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "立体库" },
| { 355698328531013L, "2", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "普通库" },
| { 355698362712133L, "3", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "公共库" },
| { 355698476777541L, "1", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "空闲" },
| { 355698510786629L, "2", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "待入" },
| { 355698549424197L, "3", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "存货" },
| { 355698576941125L, "4", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "待出" },
| { 355698694561861L, "1", null, null, null, false, "", 100, 0, 355698661130309L, null, null, null, "低" },
| { 355698716401733L, "2", null, null, null, false, "", 100, 0, 355698661130309L, null, null, null, "中" },
| { 355698740326469L, "3", null, null, null, false, "", 100, 0, 355698661130309L, null, null, null, "高" },
| { 355698898735173L, "1", null, null, null, false, "", 100, 0, 355698855280709L, null, null, null, "免检" },
| { 355698924970053L, "2", null, null, null, false, "", 100, 0, 355698855280709L, null, null, null, "抽检" },
| { 355699041800261L, "1", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "原材料" },
| { 355699063255109L, "2", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "半成品" },
| { 355699088330821L, "3", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "成品" },
| { 355699113156677L, "4", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "空托" },
| { 355699219353669L, "1", null, null, null, false, "", 100, 0, 355699189051461L, null, null, null, "长度" },
| { 355699243540549L, "2", null, null, null, false, "", 100, 0, 355699189051461L, null, null, null, "重量" },
| { 355699345645637L, "1", null, null, null, false, "", 100, 0, 355699314061381L, null, null, null, "cm" }
| });
|
| migrationBuilder.InsertData(
| table: "sys_dict_data",
| columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Remark", "Sort", "Status", "TypeId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
| values: new object[,]
| {
| { 355699367575621L, "2", null, null, null, false, "", 100, 0, 355699314061381L, null, null, null, "t" },
| { 355699479236677L, "1", null, null, null, false, "", 100, 0, 355699447029829L, null, null, null, "手动" },
| { 355699505229893L, "2", null, null, null, false, "", 100, 0, 355699447029829L, null, null, null, "自动" },
| { 355699615133765L, "1", null, null, null, false, "", 100, 0, 355699576467525L, null, null, null, "入库" },
| { 355699638476869L, "2", null, null, null, false, "", 100, 0, 355699576467525L, null, null, null, "出库" },
| { 355699661889605L, "3", null, null, null, false, "", 100, 0, 355699576467525L, null, null, null, "移库" },
| { 355699760455749L, "1", null, null, null, false, "", 100, 0, 355699731099717L, null, null, null, "未执行" },
| { 355699784736837L, "2", null, null, null, false, "", 100, 0, 355699731099717L, null, null, null, "执行中" },
| { 355699813859397L, "3", null, null, null, false, "", 100, 0, 355699731099717L, null, null, null, "完成" }
| });
|
| migrationBuilder.InsertData(
| table: "sys_emp_ext_org_pos",
| columns: new[] { "SysEmpId", "SysOrgId", "SysPosId" },
| values: new object[,]
| {
| { 142307070910551L, 142307070910539L, 142307070910547L },
| { 142307070910551L, 142307070910540L, 142307070910548L },
| { 142307070910551L, 142307070910541L, 142307070910549L },
| { 142307070910551L, 142307070910542L, 142307070910550L },
| { 142307070910553L, 142307070910542L, 142307070910547L }
| });
|
| migrationBuilder.InsertData(
| table: "sys_emp_pos",
| columns: new[] { "SysEmpId", "SysPosId" },
| values: new object[,]
| {
| { 142307070910551L, 142307070910547L },
| { 142307070910551L, 142307070910548L },
| { 142307070910552L, 142307070910549L },
| { 142307070910553L, 142307070910547L },
| { 358533464608837L, 142307070910550L },
| { 358536045723717L, 142307070910550L }
| });
|
| migrationBuilder.InsertData(
| table: "sys_user_data_scope",
| columns: new[] { "SysOrgId", "SysUserId" },
| values: new object[] { 142307070910540L, 142307070910551L });
|
| migrationBuilder.InsertData(
| table: "sys_user_role",
| columns: new[] { "SysRoleId", "SysUserId" },
| values: new object[] { 142307070910554L, 142307070910552L });
|
| migrationBuilder.InsertData(
| table: "wms_materialcontainer",
| columns: new[] { "Id", "BindQuantity", "BindStatus", "ContainerCode", "ContainerId", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "MaterialBatch", "MaterialId", "MaterialName", "MaterialNo", "MaterialSpec", "OrderNo", "SampleQty", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
| values: new object[,]
| {
| { 358856845353031L, 100m, 2, "TM00002", 358852767887429L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358856845353029", 0m, null, null, null },
| { 358856980582469L, 100m, 1, "TM00002", 358852767887429L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358856980553798", 0m, null, null, null },
| { 358857030975557L, 100m, 0, "TM00002", 358852767887429L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358857030971461", 0m, null, null, null },
| { 358857618075719L, 100m, 0, "TM00004", 358853016055877L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358857618075717", 0m, null, null, null },
| { 358857618153542L, 100m, 0, "TM00004", 358853016055877L, null, null, null, false, "3110800160", 358847125188677L, "定位销", "3110800160", "YDL31-D8-P12-L18-B8-X", "358857618075717", 0m, null, null, null },
| { 358858261872714L, 10m, 0, "TM00005", 358853070798917L, null, null, null, false, "1222202451", 358851158249541L, "电机", "1222202451", "LA21038-020.01-01.10", "358858261872712", 0m, null, null, null },
| { 358858262044742L, 1m, 0, "TM00005", 358853070798917L, null, null, null, false, "2200074102", 358848226168901L, "传感器安装支架", "2200074102", "40488-020-D086", "358858261872712", 0m, null, null, null },
| { 358858262089798L, 10m, 0, "TM00005", 358853070798917L, null, null, null, false, "2200074125", 358847917588549L, "套筒收纳盒安装板", "2200074125", "4301015-40-110-04-01", "358858261872712", 0m, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_place",
| columns: new[] { "Id", "Aisle", "AreaId", "ColumnNo", "CreatedTime", "CreatedUserId", "CreatedUserName", "DeepcellNo", "EmptyContainer", "Height", "HeightLevel", "IsDeleted", "Islock", "LayerNo", "Length", "Line", "MaxWeight", "PlaceCode", "PlaceStatus", "PositionnoForSrm", "Priority", "RowNo", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Width", "Xzb", "Yzb", "Zzb" },
| values: new object[,]
| {
| { 358852152045637L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-1-1-1", 3, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152119365L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-1-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152131653L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-1-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152143941L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-1-4-1", 3, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152156229L, 1, 355701739634757L, 1, null, null, null, 1, 1, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-1-5-1", 3, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152164421L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-1-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152172613L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-2-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152180805L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-2-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152193093L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-2-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152205381L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-2-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152217669L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-2-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152229957L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-2-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }
| });
|
| migrationBuilder.InsertData(
| table: "wms_place",
| columns: new[] { "Id", "Aisle", "AreaId", "ColumnNo", "CreatedTime", "CreatedUserId", "CreatedUserName", "DeepcellNo", "EmptyContainer", "Height", "HeightLevel", "IsDeleted", "Islock", "LayerNo", "Length", "Line", "MaxWeight", "PlaceCode", "PlaceStatus", "PositionnoForSrm", "Priority", "RowNo", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Width", "Xzb", "Yzb", "Zzb" },
| values: new object[,]
| {
| { 358852152238149L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-3-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152246341L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 1, 2, 1.2m, 0, 2.8m, "1-1-3-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152258629L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-3-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152266821L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-3-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152283205L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-3-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152295493L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-3-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152307781L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-4-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152315973L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-4-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152328261L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-4-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152336453L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-4-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152344645L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-4-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152356933L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-4-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152365125L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-5-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152373317L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-5-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152381509L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-5-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152393797L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-5-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152401989L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-5-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152410181L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-5-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152422469L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-6-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152430661L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-6-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152442949L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-6-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152451141L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-6-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152463429L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-6-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152471621L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-6-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152479813L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-7-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152496197L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-7-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152504389L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-7-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152516677L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-7-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152524869L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-7-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152610885L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-7-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152623173L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-8-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152631365L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-8-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152639557L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-8-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152651845L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-8-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152660037L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-8-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null },
| { 358852152668229L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-8-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }
| });
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_dict_data_TypeId",
| table: "sys_dict_data",
| column: "TypeId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_emp_ext_org_pos_SysOrgId",
| table: "sys_emp_ext_org_pos",
| column: "SysOrgId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_emp_ext_org_pos_SysPosId",
| table: "sys_emp_ext_org_pos",
| column: "SysPosId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_emp_pos_SysPosId",
| table: "sys_emp_pos",
| column: "SysPosId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_low_code_module_database_SysLowCodeId",
| table: "sys_low_code_module_database",
| column: "SysLowCodeId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_role_data_scope_SysOrgId",
| table: "sys_role_data_scope",
| column: "SysOrgId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_role_menu_SysMenuId",
| table: "sys_role_menu",
| column: "SysMenuId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_user_data_scope_SysOrgId",
| table: "sys_user_data_scope",
| column: "SysOrgId");
|
| migrationBuilder.CreateIndex(
| name: "IX_sys_user_role_SysRoleId",
| table: "sys_user_role",
| column: "SysRoleId");
|
| migrationBuilder.CreateIndex(
| name: "IX_wms_containerplace_WmsContainerId",
| table: "wms_containerplace",
| column: "WmsContainerId");
|
| migrationBuilder.CreateIndex(
| name: "IX_wms_containerplace_WmsPlaceId",
| table: "wms_containerplace",
| column: "WmsPlaceId");
|
| migrationBuilder.CreateIndex(
| name: "IX_wms_materialcontainer_ContainerId",
| table: "wms_materialcontainer",
| column: "ContainerId");
|
| migrationBuilder.CreateIndex(
| name: "IX_wms_materialcontainer_MaterialId",
| table: "wms_materialcontainer",
| column: "MaterialId");
|
| migrationBuilder.CreateIndex(
| name: "IX_wms_place_AreaId",
| table: "wms_place",
| column: "AreaId");
| }
|
| protected override void Down(MigrationBuilder migrationBuilder)
| {
| migrationBuilder.DropTable(
| name: "sys_app");
|
| migrationBuilder.DropTable(
| name: "sys_code_gen");
|
| migrationBuilder.DropTable(
| name: "sys_code_gen_config");
|
| migrationBuilder.DropTable(
| name: "sys_code_modular");
|
| migrationBuilder.DropTable(
| name: "sys_config");
|
| migrationBuilder.DropTable(
| name: "sys_dict_data");
|
| migrationBuilder.DropTable(
| name: "sys_emp_ext_org_pos");
|
| migrationBuilder.DropTable(
| name: "sys_emp_pos");
|
| migrationBuilder.DropTable(
| name: "sys_file");
|
| migrationBuilder.DropTable(
| name: "sys_forms");
|
| migrationBuilder.DropTable(
| name: "sys_log_audit");
|
| migrationBuilder.DropTable(
| name: "sys_log_ex");
|
| migrationBuilder.DropTable(
| name: "sys_log_op");
|
| migrationBuilder.DropTable(
| name: "sys_log_vis");
|
| migrationBuilder.DropTable(
| name: "sys_low_code_module_database");
|
| migrationBuilder.DropTable(
| name: "sys_notice");
|
| migrationBuilder.DropTable(
| name: "sys_notice_user");
|
| migrationBuilder.DropTable(
| name: "sys_role_data_scope");
|
| migrationBuilder.DropTable(
| name: "sys_role_menu");
|
| migrationBuilder.DropTable(
| name: "sys_timer");
|
| migrationBuilder.DropTable(
| name: "sys_user_data_scope");
|
| migrationBuilder.DropTable(
| name: "sys_user_role");
|
| migrationBuilder.DropTable(
| name: "wms_containerplace");
|
| migrationBuilder.DropTable(
| name: "wms_materialcontainer");
|
| migrationBuilder.DropTable(
| name: "wms_materialstock");
|
| migrationBuilder.DropTable(
| name: "wms_task");
|
| migrationBuilder.DropTable(
| name: "sys_dict_type");
|
| migrationBuilder.DropTable(
| name: "sys_emp");
|
| migrationBuilder.DropTable(
| name: "sys_pos");
|
| migrationBuilder.DropTable(
| name: "sys_low_code_module");
|
| migrationBuilder.DropTable(
| name: "sys_menu");
|
| migrationBuilder.DropTable(
| name: "sys_org");
|
| migrationBuilder.DropTable(
| name: "sys_role");
|
| migrationBuilder.DropTable(
| name: "sys_user");
|
| migrationBuilder.DropTable(
| name: "wms_place");
|
| migrationBuilder.DropTable(
| name: "wms_container");
|
| migrationBuilder.DropTable(
| name: "wms_material");
|
| migrationBuilder.DropTable(
| name: "wms_area");
| }
| }
| }
|
|
