增加全局变量表，演示demo

javamxd · javamxd · commit 34d2d7e08b68 · 2019-11-03T18:01:47.000+08:00
diff --git a/db/spiderflow.sql b/db/spiderflow.sql
@@ -30,4 +30,14 @@ CREATE TABLE `sp_datasource` (
   `password` varchar(32) DEFAULT NULL,
   `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+DROP TABLE IF EXISTS `sp_variable`;
+CREATE TABLE `sp_variable` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(32) DEFAULT NULL COMMENT '变量名',
+  `value` varchar(512) DEFAULT NULL COMMENT '变量值',
+  `description` varchar(255) DEFAULT NULL COMMENT '变量描述',
+  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
