forked from AlphaYu/adnc
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathadnc_maint_dev.sql
100 lines (81 loc) · 4.43 KB
/
adnc_maint_dev.sql
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
/*
SQLyog Community v13.1.6 (64 bit)
MySQL - 10.5.8-MariaDB-1:10.5.8+maria~focal : Database - adnc_maint_dev
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`adnc_maint_dev` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `adnc_maint_dev`;
/*Table structure for table `SysCfg` */
DROP TABLE IF EXISTS `SysCfg`;
CREATE TABLE `SysCfg` (
`Id` bigint(20) NOT NULL,
`CreateBy` bigint(20) NOT NULL,
`CreateTime` datetime(6) NOT NULL,
`ModifyBy` bigint(20) DEFAULT NULL,
`ModifyTime` datetime(6) DEFAULT NULL,
`Name` varchar(64) NOT NULL,
`Value` varchar(128) NOT NULL,
`Description` varchar(256) DEFAULT NULL,
`IsDeleted` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `SysCfg` */
insert into `SysCfg`(`Id`,`CreateBy`,`CreateTime`,`ModifyBy`,`ModifyTime`,`Name`,`Value`,`Description`,`IsDeleted`) values
(1612799408001,1600000000000,'2021-02-08 23:50:09.297676',1600000000000,'2021-02-09 00:03:25.805429','app','adnc','.NET微服务开发框架',0),
(1612800372001,1600000000000,'2021-02-09 00:06:13.005999',NULL,NULL,'tst','test','1',1);
/*Table structure for table `SysDict` */
DROP TABLE IF EXISTS `SysDict`;
CREATE TABLE `SysDict` (
`Id` bigint(20) NOT NULL,
`CreateBy` bigint(20) NOT NULL,
`CreateTime` datetime(6) NOT NULL,
`ModifyBy` bigint(20) DEFAULT NULL,
`ModifyTime` datetime(6) DEFAULT NULL,
`Name` varchar(64) NOT NULL,
`Ordinal` int(11) NOT NULL,
`Pid` bigint(20) NOT NULL,
`IsDeleted` tinyint(1) NOT NULL DEFAULT 0,
`Value` varchar(16) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `SysDict` */
insert into `SysDict`(`Id`,`CreateBy`,`CreateTime`,`ModifyBy`,`ModifyTime`,`Name`,`Ordinal`,`Pid`,`IsDeleted`,`Value`) values
(1600000008500,1600000000000,'2021-02-09 01:14:13.888000',1600000000000,'2021-02-09 13:39:25.888000','商品状态',0,0,0,NULL),
(1600000008501,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'未知',0,1600000008500,0,'1000'),
(1600000008502,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'下架中',0,1600000008500,0,'1008'),
(1600000008503,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'销售中',0,1600000008500,0,'1016'),
(1600000008600,1600000000000,'2021-02-09 01:14:13.888000',1600000000000,'2021-02-09 13:39:25.888000','订单状态',0,0,0,NULL),
(1600000008601,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'创建中',0,1600000008600,0,'1000'),
(1600000008602,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'待付款',0,1600000008600,0,'1008'),
(1600000008603,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'付款中',0,1600000008600,0,'1016'),
(1600000008604,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'待发货',0,1600000008600,0,'1040'),
(1600000008605,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'待确认',0,1600000008600,0,'1048'),
(1600000008606,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'待评价',0,1600000008600,0,'1056'),
(1600000008607,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'完成',0,1600000008600,0,'1064'),
(1600000008608,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'取消中',0,1600000008600,0,'1023'),
(1600000008609,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'已取消',0,1600000008600,0,'1024'),
(1600000008610,1600000000000,'2021-02-09 01:14:13.888000',NULL,NULL,'已删除',0,1600000008600,0,'1032');
/*Table structure for table `SysNotice` */
DROP TABLE IF EXISTS `SysNotice`;
CREATE TABLE `SysNotice` (
`Id` bigint(20) NOT NULL,
`CreateBy` bigint(20) NOT NULL,
`CreateTime` datetime(6) NOT NULL,
`ModifyBy` bigint(20) DEFAULT NULL,
`ModifyTime` datetime(6) DEFAULT NULL,
`Content` varchar(255) NOT NULL,
`Title` varchar(64) DEFAULT NULL,
`Type` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*Data for the table `SysNotice` */
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;