Watch 19 Star 59 Fork 8

drycms / drycmsPHPMIT

Create your Gitee Account
Explore and code with more than 5 million developers,Free private repositories !:)
Sign up
基于php7(swoole)+mysql的智能内容管理系统,后台不需要写代码,支持docker部署。 spread retract

https://www.drycms.com

Clone or download
drycms.sql 92.66 KB
Copy Edit Web IDE Raw Blame History
xxfaxy authored 2020-06-20 20:33 . v1.0.2
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653
-- MySQL dump 10.13 Distrib 8.0.16, for osx10.14 (x86_64)
--
-- Host: 127.0.0.1 Database: drycms
-- ------------------------------------------------------
-- Server version 5.7.13
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
SET NAMES utf8mb4 ;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `dry_backend_tool`
--
DROP TABLE IF EXISTS `dry_backend_tool`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_backend_tool` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_title` varchar(255) DEFAULT NULL,
`dry_link` varchar(1024) DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` smallint(5) unsigned DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='主要用于执行一些生成文件的接口';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_backend_tool`
--
LOCK TABLES `dry_backend_tool` WRITE;
/*!40000 ALTER TABLE `dry_backend_tool` DISABLE KEYS */;
INSERT INTO `dry_backend_tool` VALUES (1,'更新菜单排序','/Api/Menu/setDataSort','',0,1,'2019-11-26 15:14:42'),(2,'选项数据生成文件','/Api/Tool/choice2file','',0,1,'2019-11-26 15:16:20'),(3,'常量数据生成文件','/Api/Tool/constant2file','',0,1,'2019-11-26 15:16:58'),(4,'模型推到语言','/Api/Tool/push2language','',0,1,'2019-11-26 15:18:57'),(5,'语言数据生成文件','/Api/Tool/language2file','',0,1,'2019-11-26 15:19:34'),(6,'menuList','/Api/DataPool/getData?name=menuList','测试',0,1,'2019-11-29 13:48:32'),(7,'userGroupList','/Api/DataPool/getData?name=userGroupList','测试',0,1,'2019-11-29 13:49:34');
/*!40000 ALTER TABLE `dry_backend_tool` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_button`
--
DROP TABLE IF EXISTS `dry_button`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_button` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_position` tinytext,
`dry_theme` tinytext,
`dry_text` varchar(32) DEFAULT NULL,
`dry_event` varchar(32) DEFAULT NULL,
`dry_code` text,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` smallint(5) unsigned DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='模型的操作按钮';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_button`
--
LOCK TABLES `dry_button` WRITE;
/*!40000 ALTER TABLE `dry_button` DISABLE KEYS */;
INSERT INTO `dry_button` VALUES (1,'dataRow','layui-btn-green','查看','show','dry.open(url.showUrl + \"&id=\" + id, isIframe);','',1,1,'2019-11-27 10:17:19'),(2,'dataRow','layui-btn-normal','编辑','edit','dry.open(url.editUrl + \"&id=\" + id, isIframe);','',2,1,'2019-11-27 10:18:50'),(3,'dataRow','layui-btn-danger','删除','delete','dry.delete(url.deleteUrl, id);','',3,1,'2019-11-27 10:19:15'),(4,'tableLeftTop','layui-btn-danger','批量删除','gDelete','dry.delete(url.deleteUrl, getIdsStringForDelete(checkStatus.data));','',0,1,'2019-11-27 20:18:45'),(5,'cardRightTop','layui-btn-green','添加','gAdd','dry.open(url.newUrl, isIframe);','',0,1,'2019-11-27 20:19:26'),(6,'dataRow','layui-btn-green','权限分配','permissionAssign','window.location.href = \"/Admin/Group/permissionAssign?id=\" + id;','用户组专属',0,1,'2019-11-28 12:36:50'),(7,'cardRightTop','layui-btn-normal','刷新','gRefresh','window.location.reload();','',0,1,'2019-11-28 15:18:38'),(8,'dataRow','layui-btn-warm','审核','withdrawAudit','dry.open(\"/Admin/Withdraw/audit?id=\" + id, isIframe);','提现审核',0,1,'2020-04-05 16:13:25');
/*!40000 ALTER TABLE `dry_button` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_choice`
--
DROP TABLE IF EXISTS `dry_choice`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_choice` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_key` varchar(255) DEFAULT NULL,
`dry_value` varchar(255) DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` smallint(5) unsigned DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
`dry_parent` int(11) unsigned DEFAULT NULL,
`dry_grade` tinyint(3) unsigned DEFAULT NULL,
`dry_data_sort` varchar(255) DEFAULT NULL,
`dry_class` tinytext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_choice`
--
LOCK TABLES `dry_choice` WRITE;
/*!40000 ALTER TABLE `dry_choice` DISABLE KEYS */;
INSERT INTO `dry_choice` VALUES (7,'status','','',1,1,'2019-10-29 14:55:44',0,1,'10011001100110011001100110011001',NULL),(8,'0','禁用','',1,1,'2019-10-29 14:56:20',7,2,'10011001100210011002100110021001','layui-bg-red'),(9,'1','启用','',2,1,'2019-10-29 14:56:43',7,2,'10011001100210021002100210021002','layui-bg-green'),(11,'sex','','',2,1,'2019-10-29 15:18:43',0,1,'10011002100110021001100210011002',NULL),(13,'1','男','',1,1,'2019-10-29 15:19:49',11,2,'10011002100210011002100110021001',NULL),(14,'2','女','',2,1,'2019-10-29 15:20:01',11,2,'10011002100210021002100210021002',NULL),(15,'languageGroup','','语言翻译的分组,方便管理数据,而不是中文、英文这样的分组',3,1,'2019-11-06 21:23:20',0,1,'10011003100110031001100310011003',''),(16,'common','通用','',1,1,'2019-11-06 21:30:25',15,2,'10011003100210011002100110021001',NULL),(17,'extension','拓展','',2,1,'2019-11-06 21:31:08',15,2,'10011003100210021002100210021002',NULL),(18,'model','模型','',3,1,'2019-11-07 10:46:40',15,2,'10011003100210031002100310021003',NULL),(19,'3','保密','',3,1,'2019-11-10 22:37:48',11,2,'10011002100210031002100310021003',''),(20,'yesNo','','',4,1,'2019-11-10 22:39:09',0,1,'10011004100110041001100410011004',''),(21,'0','否','',1,1,'2019-11-10 22:39:25',20,2,'10011004100210011002100110021001',''),(22,'1','是','',2,1,'2019-11-10 22:39:38',20,2,'10011004100210021002100210021002','layui-bg-green'),(23,'fieldDataSource','','',5,1,'2019-11-10 22:40:15',0,1,'10011005100110051001100510011005',''),(24,'0','无','',1,1,'2019-11-10 22:41:38',23,2,'10011005100210011002100110021001',''),(25,'1','变量','',2,1,'2019-11-10 22:41:59',23,2,'10011005100210021002100210021002',''),(26,'2','接口(不推荐)','',3,1,'2019-11-10 22:42:14',23,2,'10011005100210031002100310021003',''),(27,'3','模型(不推荐)','',4,1,'2019-11-10 22:42:30',23,2,'10011005100210041002100410021004',''),(28,'formType','','',6,1,'2019-11-10 22:54:27',0,1,'10011006100110061001100610011006',''),(29,'none','无','',0,1,'2019-11-10 22:55:33',28,2,'10011006100210001002100010021000',''),(30,'input','输入框','',2,1,'2019-11-10 22:55:57',28,2,'10011006100210021002100210021002',''),(31,'password','密码框','',3,1,'2019-11-10 22:56:20',28,2,'10011006100210031002100310021003',''),(32,'textarea','文本域','',4,1,'2019-11-10 22:56:43',28,2,'10011006100210041002100410021004',''),(33,'date','日期选择','',5,1,'2019-11-10 22:57:07',28,2,'10011006100210051002100510021005',''),(34,'time','时间选择','',6,1,'2019-11-10 22:57:30',28,2,'10011006100210061002100610021006',''),(35,'datetime','日期时间选择','',7,1,'2019-11-10 22:58:03',28,2,'10011006100210071002100710021007',''),(36,'radio','单选','',8,1,'2019-11-10 22:58:24',28,2,'10011006100210081002100810021008',''),(37,'checkbox','多选','',9,1,'2019-11-10 22:58:57',28,2,'10011006100210091002100910021009',''),(38,'checkboxBig','多选大号','',10,1,'2019-11-10 22:59:23',28,2,'10011006100210101002101010021010',''),(39,'select','下拉单选','',11,1,'2019-11-10 22:59:48',28,2,'10011006100210111002101110021011',''),(40,'transfer','穿梭机','',12,1,'2019-11-10 23:00:09',28,2,'10011006100210121002101210021012',''),(41,'switch','开关','',13,1,'2019-11-10 23:00:36',28,2,'10011006100210131002101310021013',''),(42,'fileSelect','文件选择','',14,1,'2019-11-10 23:01:01',28,2,'10011006100210141002101410021014',''),(43,'color','颜色选择','',15,1,'2019-11-10 23:01:23',28,2,'10011006100210151002101510021015',''),(44,'editor','富文本编辑器','',16,1,'2019-11-10 23:01:45',28,2,'10011006100210161002101610021016',''),(45,'variable','','',7,1,'2019-11-10 23:06:29',0,1,'10011007100110071001100710011007',''),(46,'domain','','',8,1,'2019-11-10 23:08:08',0,1,'10011008100110081001100810011008',''),(47,'fieldWidth','','',9,1,'2019-11-16 10:32:23',0,1,'10011009100110091001100910011009',''),(48,'ID_WIDTH','ID','',1,1,'2019-11-16 10:42:56',47,2,'10011009100210011002100110021001',''),(49,'SORT_WIDTH','排序','',2,1,'2019-11-16 10:43:26',47,2,'10011009100210021002100210021002',''),(50,'STATUS_WIDTH','状态','',3,1,'2019-11-16 10:43:47',47,2,'10011009100210031002100310021003',''),(51,'ADD_TIME_WIDTH','添加时间','',4,1,'2019-11-16 10:44:10',47,2,'10011009100210041002100410021004',''),(52,'OPERATE_WIDTH','操作','',5,1,'2019-11-16 10:44:49',47,2,'10011009100210051002100510021005',''),(53,'DATA_SORT_WIDTH','数据排序','',6,1,'2019-11-16 10:47:01',47,2,'10011009100210061002100610021006',''),(54,'yesNoData','是否','',1,1,'2019-11-16 11:19:42',45,2,'10011007100210011002100110021001',''),(55,'ICON_WIDTH','ICON','',7,1,'2019-11-16 11:59:23',47,2,'10011009100210071002100710021007',''),(56,'statusData','状态','',2,1,'2019-11-17 18:16:12',45,2,'10011007100210021002100210021002',''),(57,'*','自动判断','',1,1,'2019-11-17 18:17:07',46,2,'10011008100210011002100110021001',''),(58,'additionalColumn','','附加字段',10,1,'2019-11-17 18:22:34',0,1,'10011010100110101001101010011010',''),(59,'none','无','',1,1,'2019-11-17 18:22:56',58,2,'10011010100210011002100110021001',''),(60,'radio','单选','',2,1,'2019-11-17 18:23:17',58,2,'10011010100210021002100210021002',''),(61,'checkbox','多选','',3,1,'2019-11-17 18:23:41',58,2,'10011010100210031002100310021003',''),(62,'pageSize','分页','',11,1,'2019-11-17 18:46:09',0,1,'10011011100110111001101110011011',''),(63,'10','10','',10,1,'2019-11-17 18:46:30',62,2,'10011011100210101002101010021010',''),(64,'50','50','',50,1,'2019-11-17 18:46:46',62,2,'10011011100210501002105010021050',''),(65,'100','100','',100,1,'2019-11-17 18:46:59',62,2,'10011011100211001002110010021100',''),(66,'fieldTemplate','字段显示模板','',12,1,'2019-11-17 22:22:28',0,1,'10011012100110121001101210011012',''),(67,'none','无','',1,1,'2019-11-17 22:23:09',66,2,'10011012100210011002100110021001',''),(68,'htmlShow','HTML','',2,1,'2019-11-17 22:23:41',66,2,'10011012100210021002100210021002',''),(69,'mergeRequestTag','合并请求-标签','',3,1,'2019-11-19 21:55:53',66,2,'10011012100210031002100310021003',''),(70,'GRADE_WIDTH','等级','',8,1,'2019-11-19 22:53:27',47,2,'10011009100210081002100810021008',''),(71,'LINK_WIDTH','链接','',9,1,'2019-11-19 22:53:54',47,2,'10011009100210091002100910021009',''),(72,'PHONE_WIDTH','手机','',10,1,'2019-11-19 22:54:25',47,2,'10011009100210101002101010021010',''),(73,'WIDTH_100','100','',100,1,'2019-11-19 22:54:55',47,2,'10011009100211001002110010021100',''),(74,'WIDTH_150','150','',150,1,'2019-11-19 22:55:41',47,2,'10011009100211501002115010021150',''),(75,'WIDTH_200','200','',200,1,'2019-11-19 22:56:02',47,2,'10011009100212001002120010021200',''),(76,'WIDTH_250','250','',250,1,'2019-11-19 22:56:22',47,2,'10011009100212501002125010021250',''),(77,'none','无','',0,1,'2019-11-20 13:09:46',47,2,'10011009100210001002100010021000',''),(78,'WIDTH_110','110','',110,1,'2019-11-20 15:30:52',47,2,'10011009100211101002111010021110',''),(79,'WIDTH_120','120','',120,1,'2019-11-20 15:31:22',47,2,'10011009100211201002112010021120',''),(80,'WIDTH_130','130','',130,1,'2019-11-20 15:31:45',47,2,'10011009100211301002113010021130',''),(81,'WIDTH_140','140','',140,1,'2019-11-20 15:32:16',47,2,'10011009100211401002114010021140',''),(82,'WIDTH_160','160','',160,1,'2019-11-20 15:32:37',47,2,'10011009100211601002116010021160',''),(83,'WIDTH_170','170','',170,1,'2019-11-20 15:32:58',47,2,'10011009100211701002117010021170',''),(84,'WIDTH_180','180','',180,1,'2019-11-20 15:33:20',47,2,'10011009100211801002118010021180',''),(85,'WIDTH_190','190','',190,1,'2019-11-20 15:33:40',47,2,'10011009100211901002119010021190',''),(86,'WIDTH_210','210','',210,1,'2019-11-20 15:34:11',47,2,'10011009100212101002121010021210',''),(87,'WIDTH_220','220','',220,1,'2019-11-20 15:34:32',47,2,'10011009100212201002122010021220',''),(88,'WIDTH_230','230','',230,1,'2019-11-20 15:34:51',47,2,'10011009100212301002123010021230',''),(89,'WIDTH_240','240','',240,1,'2019-11-20 15:35:10',47,2,'10011009100212401002124010021240',''),(90,'indentShow','缩进','',7,1,'2019-11-20 16:01:41',66,2,'10011012100210071002100710021007',''),(91,'icon','ICON选择','',17,1,'2019-11-20 16:17:10',28,2,'10011006100210171002101710021017',''),(92,'iconShow','ICON','',5,1,'2019-11-20 16:18:35',66,2,'10011012100210051002100510021005',''),(93,'linkShow','链接','',6,1,'2019-11-20 16:18:58',66,2,'10011012100210061002100610021006',''),(94,'mergeRequestFile','合并请求-文件','',4,1,'2019-11-24 19:12:44',66,2,'10011012100210041002100410021004',''),(95,'FILE_POSTER_WIDTH','文件封面','',11,1,'2019-11-25 11:16:55',47,2,'10011009100210111002101110021011',''),(96,'colorShow','颜色','',8,1,'2019-11-25 21:01:39',66,2,'10011012100210081002100810021008',''),(97,'COLOR_WIDTH','颜色','',12,1,'2019-11-25 21:18:37',47,2,'10011009100210121002101210021012',''),(98,'buttonTheme','按钮主题','',18,1,'2019-11-27 09:55:09',28,2,'10011006100210181002101810021018',''),(99,'buttonPosition','按钮位置','在数据列表页面各操作按钮的位置',13,1,'2019-11-27 09:58:20',0,1,'10011013100110131001101310011013',''),(100,'tableLeftTop','表格左上角','',1,1,'2019-11-27 10:00:04',99,2,'10011013100210011002100110021001',''),(101,'cardRightTop','面板右上角','',2,1,'2019-11-27 10:00:52',99,2,'10011013100210021002100210021002',''),(102,'dataRow','数据行','',3,1,'2019-11-27 10:01:21',99,2,'10011013100210031002100310021003',''),(103,'buttonThemeShow','按钮主题','',9,1,'2019-11-27 10:23:31',66,2,'10011012100210091002100910021009',''),(104,'codeShow','CODE','',10,1,'2019-11-27 10:40:41',66,2,'10011012100210101002101010021010',''),(105,'modelConfig','模型配置','一些开关的管理',14,1,'2019-11-27 21:01:52',0,1,'10011014100110141001101410011014',''),(106,'none','无','',1,1,'2019-11-27 21:02:10',105,2,'10011014100210011002100110021001',''),(107,'new','新窗口打开','',2,1,'2019-11-27 21:03:35',105,2,'10011014100210021002100210021002',''),(108,'moreGrade','多级分类','',3,1,'2019-11-27 21:04:44',105,2,'10011014100210031002100310021003',''),(109,'dataPoolDataSource','数据池数据源','',15,1,'2019-11-29 12:05:15',0,1,'10011015100110151001101510011015',''),(110,'1','接口','',1,1,'2019-11-29 12:07:15',109,2,'10011015100210011002100110021001',''),(111,'2','模型','',2,1,'2019-11-29 12:07:32',109,2,'10011015100210021002100210021002',''),(112,'200','200','',200,1,'2019-11-29 12:09:12',62,2,'10011011100212001002120010021200',''),(113,'api','API地址','',16,1,'2019-11-29 12:52:13',0,1,'10011016100110161001101610011016',''),(114,'/Api/Menu/getList','[接口]菜单列表','',1,1,'2019-11-29 12:52:48',113,2,'10011016100210011002100110021001',''),(115,'/Api/Automate/getListForChoiceFromDataPool','[数据池]根据名称获取数据','',2,1,'2019-11-29 13:16:44',113,2,'10011016100210021002100210021002',''),(116,'/Api/Choice/getListByKey?key=status','[选项]状态','',3,1,'2019-11-29 14:18:12',113,2,'10011016100210031002100310021003',''),(117,'/Api/Choice/getListByKey?key=languageGroup','[选项]语言分组','',4,1,'2019-11-29 14:18:37',113,2,'10011016100210041002100410021004',''),(118,'/Api/Choice/getListByKey?key=yesNo','[选项]是否','',5,1,'2019-11-29 14:18:58',113,2,'10011016100210051002100510021005',''),(119,'/Api/Choice/getListByKey?key=buttonPosition','[选项]按钮位置','',6,1,'2019-11-29 14:19:27',113,2,'10011016100210061002100610021006',''),(120,'/Api/Choice/getListByKey?key=dataPoolDataSource','[选项]数据池数据源','',7,1,'2019-11-29 14:19:52',113,2,'10011016100210071002100710021007',''),(121,'/Api/Choice/getListByKey?key=domain','[选项]域名','',9,1,'2019-11-29 14:20:12',113,2,'10011016100210091002100910021009',''),(122,'/Api/Choice/getListByKey?key=api','[选项]API地址','',10,1,'2019-11-29 14:20:36',113,2,'10011016100210101002101010021010',''),(123,'/Api/Model/getAliasList','[接口]模型别名列表','',11,1,'2019-11-29 14:21:03',113,2,'10011016100210111002101110021011',''),(124,'/Api/Automate/getListForChoice','[表]动态表数据','',8,1,'2019-11-29 14:21:37',113,2,'10011016100210081002100810021008',''),(125,'4','数据池','',5,1,'2019-11-29 14:31:09',23,2,'10011005100210051002100510021005',''),(126,'/Api/File/getListByIds','[文件]文件查询接口','',12,1,'2020-01-14 15:12:44',113,2,'10011016100210121002101210021012',''),(127,'productRecommend','产品推荐','',17,1,'2020-01-15 17:59:38',0,1,'10011017100110171001101710011017',''),(128,'home','首页','',1,1,'2020-01-15 18:00:38',127,2,'10011017100210011002100110021001',''),(129,'/Api/Choice/getListByKey?key=productRecommend','[选项]产品推荐','',13,1,'2020-01-15 18:05:09',113,2,'10011016100210131002101310021013',''),(130,'downloadCategory','','',18,1,'2020-02-02 20:25:13',0,1,'10011018100110181001101810011018',''),(131,'golang','go语言程序','',1,1,'2020-02-02 20:26:44',130,2,'10011018100210011002100110021001',''),(132,'/Api/Choice/getListByKey?key=downloadCategory','[选项]下载分类','',14,1,'2020-02-02 20:28:26',113,2,'10011016100210141002101410021014',''),(133,'none','无','',0,1,'2020-02-07 16:12:24',113,2,'10011016100210001002100010021000',''),(134,'sqlOperate','','sql操作符',19,1,'2020-02-08 15:37:51',0,1,'10011019100110191001101910011019',''),(135,'lt','小于','',103,1,'2020-02-08 15:38:58',134,2,'10011019100211031002110310021103',''),(136,'lte','小于等于','',104,1,'2020-02-08 15:39:21',134,2,'10011019100211041002110410021104',''),(137,'equal','等于','',101,1,'2020-02-08 15:39:40',134,2,'10011019100211011002110110021101',''),(138,'gte','大于等于','',106,1,'2020-02-08 15:40:21',134,2,'10011019100211061002110610021106',''),(139,'gt','大于','',105,1,'2020-02-08 15:40:38',134,2,'10011019100211051002110510021105',''),(140,'not_equal','不等于','',102,1,'2020-02-08 15:41:32',134,2,'10011019100211021002110210021102',''),(141,'left_like_right','包含','',201,1,'2020-02-08 15:43:47',134,2,'10011019100212011002120110021201',''),(142,'left_not_like_right','不包含','',202,1,'2020-02-08 15:45:22',134,2,'10011019100212021002120210021202',''),(143,'like_right','开始以','',203,1,'2020-02-08 15:47:20',134,2,'10011019100212031002120310021203',''),(144,'not_like_right','开始不是以','',204,1,'2020-02-08 15:48:48',134,2,'10011019100212041002120410021204',''),(145,'left_like','结束以','',205,1,'2020-02-08 15:50:08',134,2,'10011019100212051002120510021205',''),(146,'left_not_like','结束不是以','',206,1,'2020-02-08 15:51:40',134,2,'10011019100212061002120610021206',''),(147,'is_null','是null','',301,1,'2020-02-08 15:52:31',134,2,'10011019100213011002130110021301',''),(148,'is_not_null','不是null','',302,1,'2020-02-08 15:53:01',134,2,'10011019100213021002130210021302',''),(149,'is_empty','是空的','',401,1,'2020-02-08 15:53:40',134,2,'10011019100214011002140110021401',''),(150,'is_not_empty','不是空的','',402,1,'2020-02-08 15:54:03',134,2,'10011019100214021002140210021402',''),(151,'between_and','介于','',501,1,'2020-02-08 15:54:35',134,2,'10011019100215011002150110021501',''),(152,'not_between_and','不介于','',502,1,'2020-02-08 15:55:12',134,2,'10011019100215021002150210021502',''),(153,'in','在列表','',601,1,'2020-02-08 15:55:39',134,2,'10011019100216011002160110021601',''),(154,'not_in','不在列表','',602,1,'2020-02-08 15:55:59',134,2,'10011019100216021002160210021602',''),(155,'contain','存在某项','',701,1,'2020-02-08 15:57:36',134,2,'10011019100217011002170110021701',''),(156,'not_contain','不存在某项','',702,1,'2020-02-08 15:58:04',134,2,'10011019100217021002170210021702',''),(157,'match_word','包含词','词独立或者被空格隔开',801,1,'2020-02-08 15:58:36',134,2,'10011019100218011002180110021801',''),(158,'/Api/Choice/getListByKey?key=sqlOperate','[选项]sql操作符','',15,1,'2020-02-08 16:40:19',113,2,'10011016100210151002101510021015',''),(159,'firstChoice','数据源的首个选项','',20,1,'2020-02-09 21:17:09',0,1,'10011020100110201001102010011020',''),(160,'none','无','',1,1,'2020-02-09 21:17:26',159,2,'10011020100210011002100110021001',''),(161,'top','作为顶级','',2,1,'2020-02-09 21:17:59',159,2,'10011020100210021002100210021002',''),(162,'all','全部','',3,1,'2020-02-09 21:18:16',159,2,'10011020100210031002100310021003',''),(163,'select','请选择','',4,1,'2020-02-09 21:18:37',159,2,'10011020100210041002100410021004',''),(164,'/Api/Choice/getListByKey?key=firstChoice','[选项]数据源的首个选项','',16,1,'2020-02-09 21:21:30',113,2,'10011016100210161002101610021016',''),(165,'id','ID','',1,1,'2020-02-10 16:35:30',28,2,'10011006100210011002100110021001',''),(166,'signPass','无需签名的接口','指Api应用',21,1,'2020-02-16 10:38:56',0,1,'10011021100110211001102110011021',''),(167,'/Api/Choice/getListByKey','选项获取数据','',1,1,'2020-02-16 10:43:42',166,2,'10011021100210011002100110021001',''),(168,'/Api/DataPool/getData','数据池获取数据','',2,1,'2020-02-16 10:44:37',166,2,'10011021100210021002100210021002',''),(169,'/Api/User/isLogin','检查用户是否登录','',3,1,'2020-02-16 15:43:54',166,2,'10011021100210031002100310021003',''),(170,'payType','','支付方式',22,1,'2020-02-22 11:59:36',0,1,'10011022100110221001102210011022',''),(171,'1','支付宝','',1,1,'2020-02-22 12:00:14',170,2,'10011022100210011002100110021001',''),(172,'2','微信','',2,1,'2020-02-22 12:00:31',170,2,'10011022100210021002100210021002',''),(173,'/Api/Choice/getListByKey?key=payType','[选项]支付方式','',17,1,'2020-02-22 12:04:34',113,2,'10011016100210171002101710021017',''),(174,'orderStatus','订单状态','',23,1,'2020-02-22 12:13:22',0,1,'10011023100110231001102310011023',''),(175,'1','待确认','',1,1,'2020-02-22 12:14:08',174,2,'10011023100210011002100110021001',''),(176,'2','已支付','',2,1,'2020-02-22 12:14:36',174,2,'10011023100210021002100210021002',''),(177,'3','已取消','',3,1,'2020-02-22 12:14:52',174,2,'10011023100210031002100310021003',''),(178,'constantGroup','常量分组','',24,1,'2020-02-22 18:53:58',0,1,'10011024100110241001102410011024',''),(179,'orderStatus','订单状态','',1,1,'2020-02-22 18:55:01',178,2,'10011024100210011002100110021001',''),(180,'/Api/Choice/getListByKey?key=constantGroup','[选项]常量分组','',18,1,'2020-02-22 18:58:16',113,2,'10011016100210181002101810021018',''),(181,'common','通用','',2,1,'2020-02-23 14:17:58',178,2,'10011024100210021002100210021002',''),(182,'4','已完成','',4,1,'2020-02-23 14:31:37',174,2,'10011023100210041002100410021004',''),(183,'payType','支付方式','',3,1,'2020-02-23 16:10:26',178,2,'10011024100210031002100310021003',''),(184,'3','微信小程序','',3,1,'2020-02-23 16:12:13',170,2,'10011022100210031002100310021003',''),(185,'/Api/Choice/getListByKey?key=orderStatus','[选项]订单状态','',19,1,'2020-02-23 16:15:45',113,2,'10011016100210191002101910021019',''),(186,'width','宽度','',4,1,'2020-02-23 21:42:45',178,2,'10011024100210041002100410021004',''),(187,'device','设备','',5,1,'2020-02-23 21:43:25',178,2,'10011024100210051002100510021005',''),(188,'jsonShow','JSON','',11,1,'2020-02-23 23:53:29',66,2,'10011012100210111002101110021011',''),(189,'ORDER_NO_WIDTH','订单号','',13,1,'2020-02-23 23:56:52',47,2,'10011009100210131002101310021013',''),(190,'mainProduct','主产品','',25,1,'2020-02-25 21:48:29',0,1,'10011025100110251001102510011025',''),(191,'mainProductSpec','主产品规格','',26,1,'2020-02-25 21:49:52',0,1,'10011026100110261001102610011026',''),(192,'drycms','DRYCMS软件','',1,1,'2020-02-25 21:50:17',190,2,'10011025100210011002100110021001',''),(193,'agent_t','铜牌代理','',1,1,'2020-02-25 21:51:23',191,2,'10011026100210011002100110021001',''),(194,'agent_y','银牌代理','',2,1,'2020-02-25 21:51:52',191,2,'10011026100210021002100210021002',''),(195,'agent_j','金牌代理','',3,1,'2020-02-25 21:52:17',191,2,'10011026100210031002100310021003',''),(196,'a','A套餐','',4,1,'2020-02-25 21:58:34',191,2,'10011026100210041002100410021004',''),(197,'b','B套餐','',5,1,'2020-02-25 21:58:58',191,2,'10011026100210051002100510021005',''),(198,'c','C套餐','',6,1,'2020-02-25 21:59:20',191,2,'10011026100210061002100610021006',''),(199,'/Api/Choice/getListByKey?key=mainProduct','[选项]主产品','',20,1,'2020-02-25 22:03:21',113,2,'10011016100210201002102010021020',''),(200,'/Api/Choice/getListByKey?key=mainProductSpec','[选项]主产品规格','',21,1,'2020-02-25 22:03:54',113,2,'10011016100210211002102110021021',''),(201,'accountLogType','金额日志类型','',6,1,'2020-03-06 23:58:18',178,2,'10011024100210061002100610021006',''),(202,'withdrawType','提现方式','',7,1,'2020-03-12 21:47:15',178,2,'10011024100210071002100710021007',''),(203,'withdrawStatus','提现状态','',8,1,'2020-03-12 21:50:37',178,2,'10011024100210081002100810021008',''),(204,'withdrawType','提现方式','',27,1,'2020-03-12 22:02:32',0,1,'10011027100110271001102710011027',''),(205,'withdrawStatus','提现状态','',28,1,'2020-03-12 22:03:41',0,1,'10011028100110281001102810011028',''),(206,'1','支付宝','',1,1,'2020-03-12 22:05:06',204,2,'10011027100210011002100110021001',''),(207,'2','微信','',2,1,'2020-03-12 22:05:29',204,2,'10011027100210021002100210021002',''),(208,'3','银行卡','',3,1,'2020-03-12 22:05:47',204,2,'10011027100210031002100310021003',''),(209,'1','待审核','',1,1,'2020-03-12 22:06:31',205,2,'10011028100210011002100110021001',''),(210,'2','已通过','',2,1,'2020-03-12 22:06:47',205,2,'10011028100210021002100210021002',''),(211,'3','已拒绝','',3,1,'2020-03-12 22:07:07',205,2,'10011028100210031002100310021003',''),(212,'4','已打款','',4,1,'2020-03-12 22:07:24',205,2,'10011028100210041002100410021004',''),(213,'5','已完成','',5,1,'2020-03-12 22:07:42',205,2,'10011028100210051002100510021005',''),(214,'/Api/Choice/getListByKey?key=withdrawType','[选项]提现方式','',22,1,'2020-03-12 22:11:17',113,2,'10011016100210221002102210021022',''),(215,'/Api/Choice/getListByKey?key=withdrawStatus','[选项]提现状态','',23,1,'2020-03-12 22:11:39',113,2,'10011016100210231002102310021023',''),(216,'feedbackType','意见反馈类型','',29,1,'2020-03-17 21:15:43',0,1,'10011029100110291001102910011029',''),(217,'1','BUG反馈','',1,1,'2020-03-17 21:16:07',216,2,'10011029100210011002100110021001',''),(218,'2','功能建议','',2,1,'2020-03-17 21:16:29',216,2,'10011029100210021002100210021002',''),(219,'99','其他问题','',99,1,'2020-03-17 21:16:48',216,2,'10011029100210991002109910021099',''),(220,'feedbackStatus','意见反馈状态','',30,1,'2020-03-17 21:17:43',0,1,'10011030100110301001103010011030',''),(221,'1','待回复','',1,1,'2020-03-17 21:18:03',220,2,'10011030100210011002100110021001',''),(222,'2','已回复','',2,1,'2020-03-17 21:18:23',220,2,'10011030100210021002100210021002',''),(223,'500','500','',500,1,'2020-03-17 21:19:39',62,2,'10011011100215001002150010021500',''),(224,'feedbackType','意见反馈类型','',9,1,'2020-03-17 21:25:42',178,2,'10011024100210091002100910021009',''),(225,'feedbackStatus','意见反馈状态','',10,1,'2020-03-17 21:26:24',178,2,'10011024100210101002101010021010',''),(226,'/Api/Choice/getListByKey?key=feedbackType','[选项]意见反馈类型','',25,1,'2020-03-17 21:34:02',113,2,'10011016100210251002102510021025',''),(227,'/Api/Choice/getListByKey?key=feedbackStatus','[选项]意见反馈状态','',26,1,'2020-03-17 21:34:33',113,2,'10011016100210261002102610021026',''),(228,'bannerPosition','banner位置','',31,1,'2020-03-21 09:37:21',0,1,'10011031100110311001103110011031',''),(229,'home_top','首页顶部','',1,1,'2020-03-21 09:56:18',228,2,'10011031100210011002100110021001',''),(230,'/Api/Choice/getListByKey?key=bannerPosition','[选项]banner位置','',24,1,'2020-03-21 10:05:27',113,2,'10011016100210241002102410021024','');
/*!40000 ALTER TABLE `dry_choice` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_constant`
--
DROP TABLE IF EXISTS `dry_constant`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_constant` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_constant_name` varchar(255) DEFAULT NULL,
`dry_constant_value` varchar(255) DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` int(11) unsigned DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
`dry_is_int` tinyint(3) unsigned DEFAULT NULL,
`dry_group` varchar(32) DEFAULT NULL,
`dry_text` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_constant`
--
LOCK TABLES `dry_constant` WRITE;
/*!40000 ALTER TABLE `dry_constant` DISABLE KEYS */;
INSERT INTO `dry_constant` VALUES (1,'ID_WIDTH','60','',1,1,'2019-11-16 11:30:06',1,'width',NULL),(2,'SORT_WIDTH','80','',2,1,'2019-11-16 11:30:27',1,'width',NULL),(3,'STATUS_WIDTH','80','',3,1,'2019-11-16 11:30:53',1,'width',NULL),(4,'ADD_TIME_WIDTH','165','',4,1,'2019-11-16 11:31:10',1,'width',NULL),(5,'OPERATE_WIDTH','160','',5,1,'2019-11-16 11:31:24',1,'width',NULL),(6,'DATA_SORT_WIDTH','260','',6,1,'2019-11-16 11:31:37',1,'width',NULL),(7,'ICON_WIDTH','100','',7,1,'2019-11-16 11:58:35',1,'width',NULL),(8,'GRADE_WIDTH','55','',8,1,'2019-11-19 21:49:23',1,'width',NULL),(9,'LINK_WIDTH','100','',9,1,'2019-11-19 22:46:12',1,'width',NULL),(10,'PHONE_WIDTH','150','',10,1,'2019-11-19 22:46:39',1,'width',NULL),(11,'WIDTH_100','100','',100,1,'2019-11-19 22:47:35',1,'width',NULL),(12,'WIDTH_150','150','',150,1,'2019-11-19 22:47:59',1,'width',NULL),(13,'WIDTH_200','200','',200,1,'2019-11-19 22:48:18',1,'width',NULL),(14,'WIDTH_250','250','',250,1,'2019-11-19 22:48:33',1,'width',NULL),(15,'WIDTH_110','110','',110,1,'2019-11-20 15:11:08',1,'width',NULL),(16,'WIDTH_120','120','',120,1,'2019-11-20 15:26:04',1,'width',NULL),(17,'WIDTH_130','130','',130,1,'2019-11-20 15:26:23',1,'width',NULL),(18,'WIDTH_140','140','',140,1,'2019-11-20 15:26:40',1,'width',NULL),(19,'WIDTH_160','160','',160,1,'2019-11-20 15:27:00',1,'width',NULL),(20,'WIDTH_170','170','',170,1,'2019-11-20 15:27:19',1,'width',NULL),(21,'WIDTH_180','180','',180,1,'2019-11-20 15:27:38',1,'width',NULL),(22,'WIDTH_190','190','',190,1,'2019-11-20 15:27:55',1,'width',NULL),(23,'WIDTH_210','210','',210,1,'2019-11-20 15:28:12',1,'width',NULL),(24,'WIDTH_220','220','',220,1,'2019-11-20 15:28:30',1,'width',NULL),(25,'WIDTH_230','230','',230,1,'2019-11-20 15:28:47',1,'width',NULL),(26,'WIDTH_240','240','',240,1,'2019-11-20 15:29:05',1,'width',NULL),(27,'FILE_POSTER_WIDTH','90','',11,1,'2019-11-25 11:18:25',1,'width',NULL),(28,'COLOR_WIDTH','60','',12,1,'2019-11-25 21:19:21',1,'width',NULL),(29,'ORDER_STATUS_NO_PAY','1','',1,1,'2020-02-23 14:23:05',1,'orderStatus','待确认'),(30,'ORDER_STATUS_PAY','2','',2,1,'2020-02-23 14:24:09',1,'orderStatus','已支付'),(31,'ORDER_STATUS_CANCEL','3','',3,1,'2020-02-23 14:26:25',1,'orderStatus','已取消'),(32,'ORDER_STATUS_FINISH','4','',4,1,'2020-02-23 14:27:15',1,'orderStatus','已完成'),(33,'PAY_TYPE_ALIPAY','1','',1,1,'2020-02-23 16:12:37',1,'payType','支付宝'),(34,'PAY_TYPE_WEIXIN','2','',2,1,'2020-02-23 16:13:06',1,'payType','微信'),(35,'PAY_TYPE_WEIXIN_SP','3','',3,1,'2020-02-23 16:13:30',1,'payType','微信小程序'),(36,'DEVICE_ADMIN','admin','',1,1,'2020-02-23 21:44:50',0,'device',''),(37,'DEVICE_WEIXIN_SP','sp','',2,1,'2020-02-23 21:45:19',0,'device',''),(38,'ORDER_NO_WIDTH','260','',13,1,'2020-02-23 23:48:18',1,'width',''),(39,'CSS_JS_VERSION','2020022401','',1,1,'2020-02-24 12:00:47',0,'common',''),(40,'ACCOUNT_LOG_TYPE_SYSTEM_ADD','1','',1,1,'2020-03-07 00:00:18',1,'accountLogType','系统增加'),(41,'ACCOUNT_LOG_TYPE_SYSTEM_SUB','2','',2,1,'2020-03-07 00:00:43',1,'accountLogType','系统减少'),(42,'ACCOUNT_LOG_TYPE_WITHDRAW','3','',3,1,'2020-03-07 15:29:19',1,'accountLogType','提现'),(43,'ACCOUNT_LOG_TYPE_WITHDRAW_RETURN','4','',4,1,'2020-03-07 15:30:11',1,'accountLogType','提现返回'),(44,'ACCOUNT_LOG_TYPE_SALE_INCOME','5','',5,1,'2020-03-07 22:23:44',1,'accountLogType','销售收益'),(45,'WITHDRAW_TYPE_ALIPAY','1','',1,1,'2020-03-12 21:48:03',1,'withdrawType','支付宝'),(46,'WITHDRAW_TYPE_WEI_XIN','2','',2,1,'2020-03-12 21:48:39',1,'withdrawType','微信'),(47,'WITHDRAW_TYPE_BANK_CARD','3','',3,1,'2020-03-12 21:49:16',1,'withdrawType','银行卡'),(48,'WITHDRAW_STATUS_APPLY','1','',1,1,'2020-03-12 21:52:20',1,'withdrawStatus','待审核'),(49,'WITHDRAW_STATUS_AGREE','2','',2,1,'2020-03-12 21:52:59',1,'withdrawStatus','已通过'),(50,'WITHDRAW_STATUS_REFUSE','3','',3,1,'2020-03-12 21:53:27',1,'withdrawStatus','已拒绝'),(51,'WITHDRAW_STATUS_PAY','4','',4,1,'2020-03-12 21:57:19',1,'withdrawStatus','已打款'),(52,'WITHDRAW_STATUS_FINISH','5','',5,1,'2020-03-12 21:58:18',1,'withdrawStatus','已完成'),(53,'FEEDBACK_TYPE_BUG','1','',1,1,'2020-03-17 21:30:18',1,'feedbackType',''),(54,'FEEDBACK_TYPE_SUGGEST','2','',2,1,'2020-03-17 21:30:36',1,'feedbackType',''),(55,'FEEDBACK_TYPE_OTHER','99','',99,1,'2020-03-17 21:30:52',1,'feedbackType',''),(56,'FEEDBACK_STATUS_NO_REPLY','1','',1,1,'2020-03-17 21:31:24',1,'feedbackStatus',''),(57,'FEEDBACK_STATUS_REPLY','2','',2,1,'2020-03-17 21:31:38',1,'feedbackStatus',''),(58,'OSS_DOMAIN','https://zhouchun-temp.oss-cn-hangzhou.aliyuncs.com','',2,1,'2020-05-01 23:05:28',0,'common','OSS的域名');
/*!40000 ALTER TABLE `dry_constant` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_data_pool`
--
DROP TABLE IF EXISTS `dry_data_pool`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_data_pool` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_name` tinytext,
`dry_data_source` tinyint(3) unsigned DEFAULT NULL,
`dry_domain` varchar(255) DEFAULT NULL,
`dry_api` varchar(255) DEFAULT NULL,
`dry_model_alias` varchar(255) DEFAULT NULL,
`dry_key_field` varchar(255) DEFAULT NULL,
`dry_value_field` varchar(255) DEFAULT NULL,
`dry_sql` varchar(255) DEFAULT NULL,
`dry_callback` varchar(255) DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` int(11) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_data_pool`
--
LOCK TABLES `dry_data_pool` WRITE;
/*!40000 ALTER TABLE `dry_data_pool` DISABLE KEYS */;
INSERT INTO `dry_data_pool` VALUES (1,'documentCategoryParent',2,'*','/Api/Automate/getListForChoiceFromDataPool','document_category','','','select id as k,dry_name as v from @table where dry_parent is null or dry_parent=0 order by dry_data_sort asc','choiceCallback',1,'',0,'2020-01-14 11:56:49'),(2,'menuList',1,'*','/Api/Menu/getList','none','','','','',1,'',0,'2019-11-29 12:57:08'),(3,'userGroupList',2,'*','/Api/Automate/getListForChoiceFromDataPool','group','id','dry_name','','',1,'',0,'2019-11-29 13:46:30'),(4,'status',1,'*','/Api/Choice/getListByKey?key=status','none','','','','',1,'',0,'2019-11-29 14:42:39'),(5,'yesNo',1,'*','/Api/Choice/getListByKey?key=yesNo','none','','','','',1,'',0,'2019-12-05 23:13:45'),(6,'mallCategoryParent',2,'*','/Api/Automate/getListForChoiceFromDataPool','mall_category','','','select id as k,dry_name as v from @table where dry_parent is null or dry_parent=0','choiceCallback',1,'',0,'2020-01-14 11:56:49'),(7,'productCategory',2,'*','/Api/Automate/getListForChoiceFromDataPool','mall_category','','','select *,id as k,dry_name as v from @table order by dry_data_sort asc','categoryCallback',1,'',0,'2020-01-15 17:20:08'),(8,'documentCategory',2,'*','/Api/Automate/getListForChoiceFromDataPool','document_category','','','select *,id as k,dry_name as v from @table order by dry_data_sort asc','categoryCallback',1,'',0,'2020-01-15 17:20:08'),(9,'downloadCategory',1,'*','/Api/Choice/getListByKey?key=downloadCategory','none','','','','',1,'',0,'2020-02-02 20:29:25'),(10,'sqlOperate',1,'*','/Api/Choice/getListByKey?key=sqlOperate','none','','','','',1,'',0,'2020-02-08 16:41:08'),(11,'firstChoice',1,'*','/Api/Choice/getListByKey?key=firstChoice','none','','','','',1,'',0,'2020-02-09 21:22:24'),(12,'payType',1,'*','/Api/Choice/getListByKey?key=payType','none','','','','',1,'',0,'2020-02-22 12:05:48'),(13,'constantGroup',1,'*','/Api/Choice/getListByKey?key=constantGroup','none','','','','',1,'',0,'2020-02-22 18:59:07'),(14,'orderStatus',1,'*','/Api/Choice/getListByKey?key=orderStatus','none','','','','',1,'',0,'2020-02-23 16:17:53'),(15,'mainProduct',1,'*','/Api/Choice/getListByKey?key=mainProduct','none','','','','',1,'',0,'2020-02-25 22:04:41'),(16,'mainProductSpec',1,'*','/Api/Choice/getListByKey?key=mainProductSpec','none','','','','',1,'',0,'2020-02-25 22:04:59'),(17,'withdrawType',1,'*','/Api/Choice/getListByKey?key=withdrawType','none','','','','',1,'',0,'2020-03-12 22:14:48'),(18,'withdrawStatus',1,'*','/Api/Choice/getListByKey?key=withdrawStatus','none','','','','',1,'',0,'2020-03-12 22:15:05'),(19,'feedbackType',1,'*','/Api/Choice/getListByKey?key=feedbackType','none','','','','',1,'',0,'2020-03-17 21:35:02'),(20,'feedbackStatus',1,'*','/Api/Choice/getListByKey?key=feedbackStatus','none','','','','',1,'',0,'2020-03-17 21:35:19'),(21,'bannerPosition',1,'*','/Api/Choice/getListByKey?key=bannerPosition','none','','','','',1,'',0,'2020-03-21 10:06:17'),(22,'classParent',2,'*','/Api/Automate/getListForChoiceFromDataPool','class','','','select *,id as k,dry_name as v from @table order by dry_data_sort asc','categoryCallback',1,'',0,'2020-06-08 22:46:42'),(23,'classParent',2,'*','/Api/Automate/getListForChoiceFromDataPool','class','','','select *,id as k,dry_name as v from @table order by dry_data_sort asc','categoryCallback',1,'',0,'2020-06-08 22:59:01');
/*!40000 ALTER TABLE `dry_data_pool` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_field`
--
DROP TABLE IF EXISTS `dry_field`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dry_name` varchar(64) NOT NULL COMMENT '名称',
`dry_field` varchar(32) NOT NULL COMMENT '字段',
`dry_field_type` int(11) NOT NULL COMMENT '字段类型',
`dry_is_primary` tinyint(4) DEFAULT NULL COMMENT '是否主键',
`dry_default` varchar(32) DEFAULT NULL COMMENT '默认值',
`dry_status` tinyint(4) NOT NULL COMMENT '状态',
`dry_note` varchar(64) NOT NULL COMMENT '备注',
`dry_sort` int(11) NOT NULL COMMENT '排序',
`dry_add_time` datetime NOT NULL COMMENT '添加时间',
`dry_is_update_date_time` tinyint(4) DEFAULT NULL COMMENT '是否更新日期时间字段',
`dry_form_type` varchar(32) DEFAULT NULL COMMENT '表单类型',
`dry_field_template` varchar(64) DEFAULT NULL COMMENT '字段模板',
`dry_field_width` varchar(64) DEFAULT NULL COMMENT '字段宽度',
`dry_help` varchar(255) DEFAULT NULL COMMENT '帮助文字',
`dry_tip` varchar(255) DEFAULT NULL COMMENT '提示文字',
`dry_data_source` tinyint(4) DEFAULT NULL COMMENT '数据源',
`dry_variable` varchar(64) DEFAULT NULL COMMENT '变量',
`dry_domain` varchar(255) DEFAULT NULL COMMENT '域名',
`dry_api` varchar(64) DEFAULT NULL COMMENT 'API',
`dry_is_add_date_time` tinyint(4) DEFAULT NULL COMMENT '是否添加日期时间字段',
`dry_form_default` varchar(32) DEFAULT NULL COMMENT '表单默认值',
`dry_placeholder` varchar(64) DEFAULT NULL COMMENT 'placeholder',
`dry_model_alias` varchar(64) DEFAULT NULL,
`dry_key_field` varchar(64) DEFAULT NULL,
`dry_value_field` varchar(64) DEFAULT NULL,
`dry_sql` varchar(255) DEFAULT NULL,
`dry_callback` varchar(64) DEFAULT NULL,
`dry_data_pool_name` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_field`
--
LOCK TABLES `dry_field` WRITE;
/*!40000 ALTER TABLE `dry_field` DISABLE KEYS */;
INSERT INTO `dry_field` VALUES (1,'标题','dry_title',5,0,'',1,'',3,'2017-07-24 13:38:15',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',NULL,'','','test','','','','',''),(2,'内容','dry_content',6,0,'',1,'',4,'2017-07-24 13:50:04',0,'textarea','htmlShow','none','','',0,'statusData','*','/Api/Menu/getList',0,'','','test','','','','',''),(3,'ID','id',4,1,'',1,'',1,'2017-07-25 22:16:20',0,'id','none','ID_WIDTH','','',0,'statusData','*','/Api/Menu/getList',0,'','','test','','','','',''),(4,'分类','dry_category',13,0,'',1,'',2,'2017-08-31 22:15:39',0,'checkbox','none','none','','',2,'statusData','*','/Api/Menu/getList',0,'','','test','','','','',''),(5,'排序','dry_sort',1,0,'0',1,'',5,'2017-08-31 22:17:30',0,'input','none','SORT_WIDTH','','',0,'statusData','*','/Api/Menu/getList',0,'0','请输入排序数字,数字小的排在前面','test','','','','',''),(6,'备注','dry_note',5,0,'',1,'',6,'2017-08-31 22:18:09',0,'textarea','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(7,'添加时间','dry_add_time',7,0,'',1,'',8,'2017-08-31 22:18:51',0,'datetime','none','ADD_TIME_WIDTH','','',0,'statusData','*','none',1,'','','none','','','','',''),(8,'状态','dry_status',12,0,'1',1,'',7,'2017-08-31 22:19:53',0,'radio','mergeRequestTag','STATUS_WIDTH','','',4,'statusData','*','/Api/Choice/getListByKey?key=status',0,'1','','test','','','','','status'),(9,'姓名','dry_name',9,0,'',1,'',9,'2019-08-01 22:30:07',0,'input',NULL,NULL,NULL,NULL,1,'sexData','http://127.0.0.1:30001','api',0,'','请输入姓名',NULL,NULL,NULL,NULL,NULL,NULL),(10,'性别','dry_sex',12,0,'3',1,'',0,'2019-08-23 11:34:31',0,'radio',NULL,NULL,NULL,NULL,1,'sexData','*','',0,'1','',NULL,NULL,NULL,NULL,NULL,NULL),(11,'年龄','dry_age',12,0,'0',1,'',0,'2019-08-23 11:36:05',0,'input',NULL,NULL,NULL,NULL,1,'statusData','*','',0,'0','请输入年龄',NULL,NULL,NULL,NULL,NULL,NULL),(12,'名称','dry_name',15,0,'',1,'',0,'2019-09-11 13:40:14',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(13,'LOGO','dry_logo',1,0,'',1,'',0,'2019-10-21 16:28:25',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'statusData','*','/Api/File/getListByIds',0,'','','','','','','',NULL),(14,'文件','dry_file',6,0,'',1,'',0,'2019-10-24 16:01:18',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'statusData','*','/Api/File/getListByIds',0,'','','','','','','',NULL),(15,'颜色','dry_color',10,0,'',1,'',0,'2019-10-26 14:30:31',0,'color','colorShow','COLOR_WIDTH','','',0,'statusData','*','',0,'','','','','','','',NULL),(16,'动态数据','dry_test',1,0,'',1,'',0,'2019-10-28 22:08:28',0,'select',NULL,NULL,NULL,NULL,3,'statusData','*','/Api/Automate/getListForChoice',0,'','','file_category','id','dry_name','','defaultCallback',NULL),(17,'键','dry_key',5,0,'',1,'',0,'2019-10-29 13:23:34',0,'input','indentShow','none','','',0,'statusData','*','',0,'','','','','','','',NULL),(18,'值','dry_value',5,0,'',1,'',0,'2019-10-29 13:24:01',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(19,'常量名','dry_constant_name',5,0,'',1,'',0,'2019-10-29 13:26:16',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(20,'父级','dry_parent',1,0,'',1,'选项模型专用',0,'2019-10-29 13:38:00',0,'select','mergeRequestTag','none','','',3,'statusData','*','/Api/Automate/getListForChoice',0,'','','choice','','','select id as k,dry_key as v from @table where dry_parent is null or dry_parent=0','choiceCallback',NULL),(21,'等级','dry_grade',12,0,'',1,'数据层级关系',0,'2019-10-29 14:07:32',0,'input','none','none','','',0,'statusData','*','none',0,'','','none','','','','',''),(22,'数据排序','dry_data_sort',5,0,'',1,'',0,'2019-10-29 14:08:14',0,'input','none','none','','',0,'statusData','*','none',0,'','','none','','','','',''),(23,'别名','dry_alias',15,0,'',1,'',0,'2019-10-29 20:00:44',0,'input','none','none','','',0,'statusData','*','/Api/Menu/getList',0,'','','test','','','','',''),(24,'用户名','dry_username',10,0,'',1,'',0,'2019-10-29 20:48:57',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(25,'手机','dry_phone',18,0,'',1,'',0,'2019-10-29 20:50:43',0,'input','none','PHONE_WIDTH','','',0,'statusData','*','',0,'','','','','','','',NULL),(26,'邮箱','dry_email',18,0,'',1,'',0,'2019-10-29 20:51:15',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(27,'密码','dry_password',18,0,'',1,'',0,'2019-10-29 20:52:51',0,'password',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(28,'添加日期','dry_add_date',2,0,'',1,'',0,'2019-10-29 20:53:45',0,'date','none','none','','',0,'statusData','*','none',0,'','','none','','','','',''),(29,'用户组','dry_group',5,0,'',1,'用户所属的用户组',0,'2019-10-29 21:10:29',0,'transfer','mergeRequestTag','none','','',3,'statusData','*','/Api/Automate/getListForChoice',0,'','','group','id','dry_name','','',NULL),(30,'控制器名称','dry_controller_name',5,0,'',1,'',0,'2019-11-04 22:38:11',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','如File','','','','','',NULL),(31,'分组','dry_group',15,0,'',1,'',0,'2019-11-06 21:33:35',0,'radio',NULL,NULL,NULL,NULL,2,'statusData','*','/Api/Choice/getListByKey?key=languageGroup',0,'','','','','','','',NULL),(32,'English','dry_en_us',5,0,'',1,'英文翻译',0,'2019-11-06 21:35:30',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(33,'简体中文','dry_zh_cn',5,0,'',1,'简体中文翻译',0,'2019-11-06 21:36:06',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(34,'css类名','dry_class',15,0,'',1,'',0,'2019-11-10 10:54:43',0,'input',NULL,NULL,NULL,NULL,0,'statusData','*','',0,'','','','','','','',NULL),(35,'常量值','dry_constant_value',5,0,'',1,'',0,'2019-11-16 10:41:26',0,'input',NULL,NULL,NULL,NULL,0,'','','',0,'','','','','','','',NULL),(36,'是否整数','dry_is_int',12,0,'',1,'',0,'2019-11-16 11:18:06',0,'radio','mergeRequestTag','WIDTH_110','','',2,'yesNoData','*','/Api/Choice/getListByKey?key=yesNo',0,'0','','','','','','',NULL),(37,'链接','dry_link',3,0,'',1,'',0,'2019-11-26 15:05:41',0,'input','linkShow','LINK_WIDTH','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(38,'按钮位置','dry_position',15,0,'',1,'',0,'2019-11-27 10:03:18',0,'radio','mergeRequestTag','none','','',2,'yesNoData','*','/Api/Choice/getListByKey?key=buttonPosition',0,'tableLeftTop','','','','','','',NULL),(39,'按钮主题','dry_theme',15,0,'',1,'',0,'2019-11-27 10:04:17',0,'buttonTheme','buttonThemeShow','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(40,'按钮文字','dry_text',10,0,'',1,'',0,'2019-11-27 10:06:00',0,'input','none','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(41,'按钮事件名','dry_event',10,0,'',1,'',0,'2019-11-27 10:06:53',0,'input','none','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(42,'按钮事件处理代码','dry_code',6,0,'',1,'',0,'2019-11-27 10:08:05',0,'textarea','codeShow','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(43,'模型按钮','dry_button',6,0,'',1,'手动写标签时需要该字段',0,'2019-11-27 21:11:36',0,'transfer','mergeRequestTag','none','','',3,'yesNoData','*','/Api/Automate/getListForChoice',0,'','','button','','','select id as k,concat(dry_position,\'-\',dry_text) as v from @table order by dry_position asc,dry_sort asc','',NULL),(44,'数据池数据源','dry_data_source',12,0,'',1,'',0,'2019-11-29 12:22:03',0,'radio','mergeRequestTag','none','','',2,'yesNoData','*','/Api/Choice/getListByKey?key=dataPoolDataSource',0,'1','','','','','','',NULL),(45,'域名','dry_domain',5,0,'',1,'',0,'2019-11-29 12:23:16',0,'select','mergeRequestTag','none','','',2,'yesNoData','*','/Api/Choice/getListByKey?key=domain',0,'','','','','','','',NULL),(46,'API地址','dry_api',5,0,'',1,'',0,'2019-11-29 12:24:30',0,'select','mergeRequestTag','none','','',2,'yesNoData','*','/Api/Choice/getListByKey?key=api',0,'','','','','','','',NULL),(47,'模型别名','dry_model_alias',5,0,'',1,'',0,'2019-11-29 12:26:08',0,'select','none','none','','',2,'yesNoData','*','/Api/Model/getAliasList',0,'','','model','','','','',NULL),(48,'key字段','dry_key_field',5,0,'',1,'',0,'2019-11-29 12:27:25',0,'input','none','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(49,'value字段','dry_value_field',5,0,'',1,'',0,'2019-11-29 12:28:01',0,'input','none','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(50,'SQL','dry_sql',5,0,'',1,'',0,'2019-11-29 12:28:35',0,'input','none','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(51,'回调函数','dry_callback',5,0,'',1,'',0,'2019-11-29 12:28:59',0,'input','none','none','','',0,'yesNoData','*','',0,'','','','','','','',NULL),(52,'拥有','dry_has',12,0,'',1,'',0,'2019-12-05 23:14:55',0,'radio','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'1','','test','','','','','yesNo'),(53,'主用户','dry_user',1,0,'',1,'',0,'2019-12-06 09:59:39',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(54,'子用户','dry_sub_user',1,0,'',1,'',0,'2019-12-06 10:00:27',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(55,'微信小程序用户openid','dry_wei_xin_sp_open_id',10,0,'',1,'',0,'2020-01-12 16:36:24',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(56,'微信小程序用户信息','dry_wei_xin_sp_user_info',6,0,'',1,'',0,'2020-01-12 16:37:28',0,'input','jsonShow','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(57,'图片','dry_image',1,0,'',1,'',0,'2020-01-14 11:04:21',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'yesNoData','*','/Api/File/getListByIds',0,'','','test','','','','',''),(58,'父级','dry_parent',1,0,'',1,'商城分类模型专用',0,'2020-01-14 11:54:57',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','','mallCategoryParent'),(59,'分类','dry_category',1,0,'',1,'产品',0,'2020-01-15 17:42:08',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','','productCategory'),(60,'描述','dry_description',5,0,'',1,'',0,'2020-01-15 17:43:17',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(61,'原价','dry_raw_price',28,0,'',1,'',0,'2020-01-15 17:44:48',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(62,'价格','dry_price',28,0,'',1,'',0,'2020-01-15 17:56:54',0,'input','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(63,'开始时间','dry_start_time',7,0,'',1,'',0,'2020-01-15 17:57:52',0,'datetime','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(64,'结束时间','dry_end_time',7,0,'',1,'',0,'2020-01-15 17:58:28',0,'datetime','none','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(65,'推荐','dry_recommend',5,0,'',1,'',0,'2020-01-15 18:03:02',0,'checkboxBig','mergeRequestTag','none','','',2,'yesNoData','*','/Api/Choice/getListByKey?key=productRecommend',0,'','','test','','','','',''),(66,'banner','dry_banner',5,0,'',1,'',0,'2020-01-17 23:27:16',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'yesNoData','*','/Api/File/getListByIds',0,'','','test','','','','',''),(67,'详情图','dry_detail_image',1,0,'',1,'',0,'2020-01-17 23:28:26',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'yesNoData','*','/Api/File/getListByIds',0,'','','test','','','','',''),(68,'虚拟商品','dry_is_virtual',12,0,'',1,'',0,'2020-01-17 23:32:18',0,'radio','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'0','','test','','','','','yesNo'),(69,'父级','dry_parent',1,0,'',1,'文档分类',0,'2020-01-18 12:43:48',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','','documentCategoryParent'),(70,'分类','dry_category',1,0,'',1,'文档',0,'2020-01-18 16:48:32',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','','documentCategory'),(71,'图片','dry_image',5,0,'',1,'文档',0,'2020-01-18 16:50:38',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'yesNoData','*','/Api/File/getListByIds',0,'','','test','','','','',''),(72,'视频','dry_video',5,0,'',1,'',0,'2020-01-18 16:52:04',0,'fileSelect','mergeRequestFile','FILE_POSTER_WIDTH','','',2,'yesNoData','*','/Api/File/getListByIds',0,'','','test','','','','',''),(73,'代码','dry_code',6,0,'',1,'文档',0,'2020-01-18 16:53:15',0,'textarea','codeShow','none','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(74,'URL','dry_url',5,0,'',1,'',0,'2020-02-02 20:22:53',0,'input','linkShow','LINK_WIDTH','','',0,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','',''),(75,'分类','dry_category',10,0,'',1,'下载',0,'2020-02-02 20:31:07',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','/Api/Menu/getList',0,'','','test','','','','','downloadCategory'),(76,'用户','dry_user',1,0,'',1,'订单',0,'2020-02-22 11:52:59',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(77,'订单号','dry_order_no',10,0,'',1,'订单',0,'2020-02-22 11:53:48',0,'input','none','ORDER_NO_WIDTH','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(78,'订单金额','dry_amount',28,0,'',1,'订单',0,'2020-02-22 11:54:53',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(79,'支付方式','dry_type',12,0,'',1,'订单',0,'2020-02-22 11:56:46',0,'radio','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','payType'),(80,'产品原始数据','dry_product_raw',6,0,'',1,'订单',0,'2020-02-22 11:57:46',0,'textarea','jsonShow','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(81,'支付原始数据','dry_pay_raw',6,0,'',1,'订单',0,'2020-02-22 11:58:16',0,'textarea','jsonShow','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(82,'分组','dry_group',10,0,'',1,'常量',0,'2020-02-22 19:01:01',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','constantGroup'),(83,'文字','dry_text',10,0,'',1,'常量',0,'2020-02-22 19:05:22',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(84,'状态','dry_status',12,0,'',1,'订单',0,'2020-02-23 16:18:59',0,'radio','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','orderStatus'),(85,'主产品','dry_main_product',10,0,'',1,'产品',0,'2020-02-25 22:06:49',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','mainProduct'),(86,'主产品规格','dry_main_product_spec',10,0,'',1,'产品',0,'2020-02-25 22:07:54',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','mainProductSpec'),(87,'允许优惠码','dry_is_use_code',12,0,'',1,'产品',0,'2020-02-27 14:54:03',0,'radio','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'0','','none','','','','','yesNo'),(88,'编码','dry_code',10,0,'',1,'银行',0,'2020-03-09 10:20:05',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(89,'ICON','dry_icon',5,0,'',1,'银行',0,'2020-03-09 10:37:50',0,'input','linkShow','LINK_WIDTH','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(90,'用户','dry_user',1,0,'',1,'提现',0,'2020-03-12 22:13:58',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(91,'提现方式','dry_type',12,0,'',1,'提现',0,'2020-03-12 22:16:45',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','withdrawType'),(92,'状态','dry_status',12,0,'',1,'提现',0,'2020-03-12 22:17:36',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','withdrawStatus'),(93,'提现金额','dry_amount',28,0,'',1,'提现',0,'2020-03-12 22:18:22',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(94,'手续费','dry_tax',28,0,'',1,'提现',0,'2020-03-12 22:19:16',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(95,'实际到账','dry_real_amount',28,0,'',1,'提现',0,'2020-03-12 22:19:44',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(96,'原始数据','dry_user_bank_raw',3,0,'',1,'提现',0,'2020-03-12 22:20:34',0,'textarea','jsonShow','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(97,'月份','dry_month',14,0,'',1,'提现',0,'2020-03-12 22:21:26',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(98,'用户','dry_user',1,0,'',1,'意见反馈',0,'2020-03-20 22:43:04',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(99,'类型','dry_feedback_type',12,0,'',1,'意见反馈',0,'2020-03-20 22:44:14',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','feedbackType'),(100,'处理状态','dry_feedback_status',12,0,'',1,'意见反馈',0,'2020-03-20 22:45:14',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','feedbackStatus'),(101,'文件','dry_file',5,0,'',1,'意见反馈',0,'2020-03-20 22:46:59',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(102,'内容','dry_content',29,0,'',1,'意见反馈',0,'2020-03-20 22:48:50',0,'textarea','htmlShow','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(103,'回复者','dry_reply_user',1,0,'',1,'意见反馈',0,'2020-03-20 22:49:32',0,'input','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(104,'回复内容','dry_reply_content',29,0,'',1,'意见反馈',0,'2020-03-20 22:50:26',0,'textarea','none','none','','',0,'yesNoData','*','none',0,'','','none','','','','',''),(105,'位置','dry_position',10,0,'',1,'banner',0,'2020-03-21 10:07:50',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','bannerPosition'),(106,'父级','dry_parent',1,0,'',1,'班级',0,'2020-06-08 22:48:35',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','classParent'),(107,'父级','dry_parent',1,0,'',1,'班级',0,'2020-06-08 23:00:40',0,'select','mergeRequestTag','none','','',4,'yesNoData','*','none',0,'','','none','','','','','classParent');
/*!40000 ALTER TABLE `dry_field` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_field_type`
--
DROP TABLE IF EXISTS `dry_field_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_field_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dry_name` varchar(64) NOT NULL,
`dry_type` varchar(32) NOT NULL,
`dry_start` varchar(32) NOT NULL,
`dry_end` varchar(32) NOT NULL,
`dry_status` tinyint(4) NOT NULL,
`dry_note` varchar(64) NOT NULL,
`dry_sort` int(11) NOT NULL,
`dry_add_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_field_type`
--
LOCK TABLES `dry_field_type` WRITE;
/*!40000 ALTER TABLE `dry_field_type` DISABLE KEYS */;
INSERT INTO `dry_field_type` VALUES (1,'0到4294967295的整数','int(11) unsigned','0','4294967295',1,'',1004,'2017-07-25 23:01:02'),(2,'日期(2017-01-02)','date','1000-01-01','9999-12-31',1,'',1301,'2017-07-25 23:14:33'),(3,'varchar(1024)','varchar(1024)','','',1,'',1204,'2017-07-25 23:15:47'),(4,'0到18446744073709551615的整数','bigint(20) unsigned','0','18446744073709551615',1,'id字段',1005,'2017-07-25 23:19:00'),(5,'varchar(255)','varchar(255)','','',1,'',1203,'2017-08-31 21:26:06'),(6,'1到65535个字符','text','1','65535',1,'内容',1402,'2017-08-31 21:26:44'),(7,'日期时间(2017-01-02 12:13:14)','datetime','','',1,'',1302,'2017-08-31 21:29:10'),(8,'char(32)','char(32)','','',1,'',1102,'2017-08-31 21:29:44'),(9,'varchar(4)','varchar(4)','','',1,'',1201,'2017-08-31 21:33:53'),(10,'varchar(32)','varchar(32)','','',1,'',1202,'2017-08-31 21:34:22'),(11,'char(17)','char(17)','','',1,'',1101,'2017-08-31 21:35:11'),(12,'0到255的整数','tinyint(3) unsigned','0','255',1,'状态',1001,'2017-08-31 21:39:57'),(13,'0到65535的整数','smallint(5) unsigned','0','65535',1,'排序',1002,'2017-08-31 21:42:16'),(14,'0到16777215的整数','mediumint(8) unsigned','0','16777215',1,'排序',1003,'2017-08-31 21:43:26'),(15,'1到255个字符','tinytext','1','255',1,'',1401,'2017-08-31 21:57:21'),(16,'1到16777215个字符','mediumtext','1','16777215',1,'',1403,'2017-08-31 21:59:13'),(17,'1到4294967295个字符','longtext','1','4294967295',1,'',1404,'2017-08-31 22:00:15'),(18,'varchar(128)','varchar(128)','','',1,'',0,'2019-10-29 21:01:45'),(27,'char(1)','char(1)','','',0,'',0,'2019-11-10 12:10:42'),(28,'decimal(7,2)','decimal(7,2)','','',1,'价格',0,'2020-01-15 17:55:13'),(29,'varchar(512)','varchar(512)','','',1,'',0,'2020-03-20 22:47:57');
/*!40000 ALTER TABLE `dry_field_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_file`
--
DROP TABLE IF EXISTS `dry_file`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_file` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_category` int(11) DEFAULT NULL,
`dry_oss_file` bigint(20) DEFAULT NULL,
`dry_prefix` varchar(16) DEFAULT NULL,
`dry_name` varchar(64) DEFAULT NULL,
`dry_object` varchar(255) DEFAULT NULL,
`dry_mime_type` varchar(64) DEFAULT NULL,
`dry_format` varchar(16) DEFAULT NULL,
`dry_width` int(11) DEFAULT '0' COMMENT '宽度',
`dry_height` int(11) DEFAULT '0' COMMENT '高度',
`dry_size` int(11) DEFAULT '0' COMMENT '大小',
`dry_add_date` date DEFAULT NULL COMMENT '添加日期',
`dry_add_time` datetime DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_file`
--
LOCK TABLES `dry_file` WRITE;
/*!40000 ALTER TABLE `dry_file` DISABLE KEYS */;
/*!40000 ALTER TABLE `dry_file` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_file_category`
--
DROP TABLE IF EXISTS `dry_file_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_file_category` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_name` tinytext,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` smallint(5) unsigned DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_file_category`
--
LOCK TABLES `dry_file_category` WRITE;
/*!40000 ALTER TABLE `dry_file_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `dry_file_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_group`
--
DROP TABLE IF EXISTS `dry_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_group` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_name` tinytext,
`dry_alias` tinytext,
`dry_note` varchar(255) DEFAULT NULL,
`dry_sort` smallint(5) unsigned DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_group`
--
LOCK TABLES `dry_group` WRITE;
/*!40000 ALTER TABLE `dry_group` DISABLE KEYS */;
INSERT INTO `dry_group` VALUES (1,'超级管理员','GROUP_SUPER_ADMIN','开发者专用',1,'2019-10-29 20:06:54'),(2,'管理员','GROUP_ADMIN','管理员',2,'2019-10-29 20:07:48'),(3,'普通用户','GROUP_USER','一般指消费者',3,'2019-10-29 20:08:47');
/*!40000 ALTER TABLE `dry_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_group_permission`
--
DROP TABLE IF EXISTS `dry_group_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_group_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`dry_group` int(11) DEFAULT NULL,
`dry_route_name` varchar(64) NOT NULL COMMENT '路由名称',
`dry_note` varchar(255) DEFAULT NULL COMMENT '备注',
`dry_add_time` datetime NOT NULL COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `group` (`dry_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户组权限';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_group_permission`
--
LOCK TABLES `dry_group_permission` WRITE;
/*!40000 ALTER TABLE `dry_group_permission` DISABLE KEYS */;
/*!40000 ALTER TABLE `dry_group_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_language`
--
DROP TABLE IF EXISTS `dry_language`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_language` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_group` tinytext,
`dry_key` varchar(255) DEFAULT NULL,
`dry_zh_cn` varchar(255) DEFAULT NULL,
`dry_en_us` varchar(255) DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='语言翻译';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_language`
--
LOCK TABLES `dry_language` WRITE;
/*!40000 ALTER TABLE `dry_language` DISABLE KEYS */;
INSERT INTO `dry_language` VALUES (1,'common','new','添加','','','2019-11-06 21:41:16'),(2,'common','index','列表','','','2019-11-06 21:41:32'),(3,'common','show','查看','','','2019-11-06 21:41:43'),(4,'common','delete','删除','','','2019-11-06 21:41:55'),(5,'common','edit','编辑','','','2019-11-06 21:42:15'),(6,'model','Test','测试下','测试','tool','2019-11-07 11:41:56'),(7,'model','User','用户','用户','tool','2019-11-07 11:41:56'),(8,'model','PhpConfigure','php编译配置','php编译配置','tool','2019-11-07 11:41:56'),(9,'model','FileCategory','文件分类','文件分类','tool','2019-11-07 11:41:56'),(10,'model','Student','学生','学生','tool','2019-11-07 11:41:56'),(11,'model','Choice','选项','选项','tool','2019-11-07 11:41:57'),(12,'model','Group','用户组','用户组','tool','2019-11-07 11:41:57'),(13,'model','Language','语言','语言','tool','2019-11-07 11:41:57'),(14,'model','File','文件','','','2019-11-07 13:39:57'),(15,'model','FieldType','字段类型','','','2019-11-07 13:40:25'),(16,'model','Model','模型','','','2019-11-07 13:40:49'),(17,'model','Field','字段','','','2019-11-07 13:41:10'),(18,'model','Menu','菜单','','','2019-11-07 13:41:27'),(19,'model','ModelField','模型字段','','','2019-11-07 13:41:45'),(20,'model','Demo','样例','','','2019-11-07 13:43:00'),(21,'extension','ExtensionGroupPermissionAssign','权限分配','','','2019-11-07 14:00:39'),(22,'extension','ExtensionFileGetUploadData','获取上传凭证','','','2019-11-07 14:00:59'),(23,'extension','ExtensionModelField','创建表及调整字段的iframe弹窗地址','','','2019-11-07 14:01:18'),(24,'extension','ExtensionModelCreateTable','创建表的具体执行','','','2019-11-07 14:01:33'),(25,'extension','ExtensionModelAdjustField','调整字段的具体执行','','','2019-11-07 14:01:46'),(26,'extension','ExtensionFileList','文件被引用时其他模型列表页面的iframe弹窗地址','','','2019-11-07 14:03:01'),(27,'model','Constant','常量','常量','tool','2019-11-26 15:18:25'),(28,'model','News','新闻','新闻','tool','2019-11-26 15:18:25'),(29,'model','BackendTool','后台工具','后台工具','tool','2019-11-26 15:18:25'),(30,'model','Button','按钮','按钮','tool','2019-11-28 13:22:56');
/*!40000 ALTER TABLE `dry_language` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_menu`
--
DROP TABLE IF EXISTS `dry_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`dry_parent` int(11) DEFAULT NULL COMMENT '父级',
`dry_grade` int(11) DEFAULT NULL COMMENT '等级',
`dry_icon` varchar(32) DEFAULT NULL COMMENT 'ICON',
`dry_title` varchar(255) DEFAULT NULL COMMENT '标题',
`dry_link` varchar(255) DEFAULT NULL COMMENT '链接',
`dry_note` varchar(255) DEFAULT NULL COMMENT '备注',
`dry_sort` int(11) DEFAULT NULL COMMENT '排序',
`dry_data_sort` varchar(32) DEFAULT NULL COMMENT '数据排序',
`dry_status` tinyint(4) DEFAULT NULL COMMENT '状态',
`dry_add_time` datetime DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COMMENT='菜单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_menu`
--
LOCK TABLES `dry_menu` WRITE;
/*!40000 ALTER TABLE `dry_menu` DISABLE KEYS */;
INSERT INTO `dry_menu` VALUES (1,0,1,'layui-icon-app','超管工具','','',1,'10011001100110011001100110011001',1,'2019-11-06 21:45:32'),(2,1,2,'','字段类型','/Admin/FieldType/index','',1,'10011001100210011002100110021001',1,'2019-11-06 21:46:30'),(3,1,2,'','字段','/Admin/Field/index','',2,'10011001100210021002100210021002',1,'2019-11-06 21:47:02'),(4,1,2,'','模型','/Admin/Model/index','',3,'10011001100210031002100310021003',1,'2019-11-06 21:47:43'),(5,1,2,'','模型字段','/Admin/ModelField/index','',4,'10011001100210041002100410021004',1,'2019-11-06 21:48:10'),(6,1,2,'','菜单','/Admin/Menu/index','',5,'10011001100210051002100510021005',1,'2019-11-06 21:49:22'),(11,0,1,'layui-icon-file','文件管理','','',3,'10011003100110031001100310011003',1,'2019-11-06 21:58:21'),(12,11,2,'','文件分类','/Admin/Automate/index?alias=file_category','',1,'10011003100210011002100110021001',1,'2019-11-06 21:58:51'),(13,11,2,'','文件','/Admin/File/index','',2,'10011003100210021002100210021002',1,'2019-11-06 21:59:19'),(14,0,1,'layui-icon-group','用户管理','','',4,'10011004100110041001100410011004',1,'2019-11-06 21:59:53'),(15,14,2,'','用户组','/Admin/Automate/index?alias=group','',1,'10011004100210011002100110021001',1,'2019-11-06 22:00:19'),(16,14,2,'','用户','/Admin/Automate/index?alias=user','',2,'10011004100210021002100210021002',1,'2019-11-06 22:00:44'),(17,0,1,'layui-icon-set-fill','设置','','',5,'10011005100110051001100510011005',1,'2019-11-06 22:01:05'),(18,17,2,'','选项','/Admin/Automate/index?alias=choice','',1,'10011005100210011002100110021001',1,'2019-11-06 22:02:06'),(19,17,2,'','语言','/Admin/Automate/index?alias=language','',2,'10011005100210021002100210021002',1,'2019-11-06 22:02:25'),(21,17,2,'','常量','/Admin/Automate/index?alias=constant','',3,'10011005100210031002100310021003',1,'2019-11-16 11:22:48'),(23,1,2,'','后台工具','/Admin/Automate/index?alias=backend_tool','',6,'10011001100210061002100610021006',1,'2019-11-26 15:13:35'),(24,1,2,'','按钮','/Admin/Automate/index?alias=button','',7,'10011001100210071002100710021007',1,'2019-11-27 10:12:57'),(25,1,2,'','数据池','/Admin/Automate/index?alias=data_pool','',8,'10011001100210081002100810021008',1,'2019-11-29 12:38:00'),(26,1,2,'','权限配置','/Admin/Automate/index?alias=permission_config','',9,'10011001100210091002100910021009',1,'2019-12-05 23:22:03'),(27,1,2,'','子用户','/Admin/Automate/index?alias=sub_user','',10,'10011001100210101002101010021010',1,'2019-12-06 10:05:55'),(42,14,2,'','更新密码','/Admin/User/updatePassword','',3,'10011004100210031002100310021003',1,'2020-05-18 22:21:18'),(43,39,2,'','发放代理','/Admin/X/sendAgent','',3,'10011008100210031002100310021003',1,'2020-05-18 23:32:16'),(44,31,2,'','班级','/Admin/Automate/index?alias=class','',3,'10011002100210031002100310021003',1,'2020-06-08 23:06:47');
/*!40000 ALTER TABLE `dry_menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_model`
--
DROP TABLE IF EXISTS `dry_model`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_model` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dry_database_config_key` varchar(32) DEFAULT NULL COMMENT '数据库配置键',
`dry_database` varchar(32) DEFAULT NULL COMMENT '数据库',
`dry_name` varchar(32) DEFAULT NULL COMMENT '名称',
`dry_table` varchar(64) DEFAULT NULL COMMENT '表名称',
`dry_alias` varchar(64) DEFAULT NULL COMMENT '别名',
`dry_controller_name` varchar(64) DEFAULT NULL COMMENT '控制器名称',
`dry_field` text COMMENT '字段列表',
`dry_note` varchar(64) DEFAULT NULL COMMENT '备注',
`dry_sort` int(11) DEFAULT NULL COMMENT '排序',
`dry_add_time` datetime DEFAULT NULL COMMENT '添加时间',
`dry_additional_column` varchar(16) DEFAULT NULL COMMENT '附加字段',
`dry_page_size` int(11) DEFAULT NULL COMMENT '分页数',
`dry_sort_sql` varchar(128) DEFAULT NULL COMMENT '排序sql',
`dry_add_edit_label_width` varchar(255) DEFAULT '' COMMENT '添加编辑时label宽度',
`dry_show_label_width` varchar(255) DEFAULT '' COMMENT '查看时label宽度',
`dry_index_operate_width` varchar(255) DEFAULT '' COMMENT '列表时操作按钮宽度',
`dry_button` varchar(255) DEFAULT '' COMMENT '按钮',
`dry_config` varchar(255) DEFAULT '' COMMENT '配置',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_model`
--
LOCK TABLES `dry_model` WRITE;
/*!40000 ALTER TABLE `dry_model` DISABLE KEYS */;
INSERT INTO `dry_model` VALUES (2,'default','drycms','用户','dry_user','user','User','3,6,7,8,24,25,26,27,28,29,55,56','',0,'2019-08-23 11:37:10','checkbox',100,'','none','WIDTH_250','OPERATE_WIDTH','5,1,2,3,4',''),(4,'default','drycms','文件分类','dry_file_category','file_category','FileCategory','3,12,6,5,8,7','',4,'2019-10-10 18:28:04','none',50,'','none','none','OPERATE_WIDTH','5,1,2,3,4',''),(6,'default','drycms','选项','dry_choice','choice','Choice','3,5,6,7,8,17,18,20,21,22,34','',0,'2019-10-29 13:28:17','none',500,'dry_data_sort asc','none','none','OPERATE_WIDTH','5,1,2,3,4','new,moreGrade'),(7,'default','drycms','用户组','dry_group','group','Group','3,12,23,6,5,7','',0,'2019-10-29 20:02:33','none',10,'dry_sort asc','none','none','WIDTH_250','5,6,2,4,1,3','none'),(8,'default','drycms','语言','dry_language','language','Language','3,31,17,33,32,6,7','语言翻译',0,'2019-11-06 21:38:14','none',100,'dry_group asc,dry_key asc','none','none','OPERATE_WIDTH','5,1,2,3,4',''),(9,'default','drycms','常量','dry_constant','constant','Constant','3,5,6,7,8,19,35,36,82,83','',0,'2019-11-16 11:14:13','none',100,'dry_group asc,dry_sort asc','none','none','OPERATE_WIDTH','5,1,2,3,4',''),(11,'default','drycms','后台工具','dry_backend_tool','backend_tool','BackendTool','3,1,37,6,5,8,7','主要用于执行一些生成文件的接口',0,'2019-11-26 15:01:14','none',100,'','none','none','OPERATE_WIDTH','5,1,2,3,4','none'),(12,'default','drycms','按钮','dry_button','button','Button','3,38,39,40,41,42,6,5,8,7','模型的操作按钮',0,'2019-11-27 10:10:59','none',50,'','WIDTH_120','none','OPERATE_WIDTH','5,1,2,3,4,7','none'),(13,'default','drycms','数据池','dry_data_pool','data_pool','DataPool','3,12,44,45,46,47,48,49,50,51,8,6,5,7','',0,'2019-11-29 12:34:42','none',200,'dry_name asc','WIDTH_100','none','OPERATE_WIDTH','5,7,1,2,3,4','none'),(14,'default','drycms','权限配置','dry_permission_config','permission_config','PermissionConfig','3,24,52,12,8,6,7','',0,'2019-12-05 23:20:20','none',200,'dry_has asc,dry_status desc','none','none','none','5,7,1,2,3,4','none'),(15,'default','drycms','子用户','dry_sub_user','sub_user','SubUser','3,53,54,8,6,7','',0,'2019-12-06 10:03:51','none',10,'','none','none','none','5,7,1,2,3,4','none'),(27,'default','drycms','班级','dry_class','class','Class','3,107,21,12,6,8,5,22,7','',0,'2020-06-08 22:57:30','checkbox',200,'dry_data_sort asc','none','none','OPERATE_WIDTH','5,7,1,2,3,4','none,moreGrade');
/*!40000 ALTER TABLE `dry_model` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_model_field`
--
DROP TABLE IF EXISTS `dry_model_field`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_model_field` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dry_model` int(11) DEFAULT NULL COMMENT '模型',
`dry_field` int(11) DEFAULT NULL COMMENT '字段',
`dry_sort` int(11) DEFAULT NULL COMMENT '排序',
`dry_add_time` datetime DEFAULT NULL COMMENT '添加时间',
`dry_field_list_sort` int(11) DEFAULT NULL COMMENT '字段列表排序',
`dry_is_init_hide` tinyint(4) DEFAULT NULL COMMENT '是否初始隐藏列',
`dry_is_list_edit` tinyint(4) DEFAULT NULL COMMENT '列表即时编辑',
`dry_is_list_click_sort` tinyint(4) DEFAULT NULL COMMENT '列表点击排序',
`dry_field_template` varchar(64) DEFAULT NULL COMMENT '字段模板',
`dry_field_width` varchar(64) DEFAULT NULL COMMENT '字段宽度',
`dry_field_search_sort` int(11) DEFAULT NULL,
`dry_is_search` tinyint(4) DEFAULT NULL,
`dry_sql_operate` varchar(32) DEFAULT NULL COMMENT 'SQL',
`dry_first_choice` varchar(16) DEFAULT 'none' COMMENT '||',
`dry_search_first_choice` varchar(16) DEFAULT 'all',
`dry_add_edit_is_show` tinyint(4) DEFAULT '1' COMMENT '|',
`dry_is_encrypt` tinyint(4) DEFAULT '0',
`dry_field_search_default` varchar(64) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=434 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_model_field`
--
LOCK TABLES `dry_model_field` WRITE;
/*!40000 ALTER TABLE `dry_model_field` DISABLE KEYS */;
INSERT INTO `dry_model_field` VALUES (187,2,3,1,'2019-08-23 11:37:10',1,0,0,1,'none','none',1,1,'equal','none','all',0,0,''),(191,2,6,7,'2019-08-23 11:37:10',7,0,0,1,'none','none',7,0,'equal','none','all',1,0,''),(192,2,8,8,'2019-08-23 11:37:10',8,0,0,1,'none','none',8,1,'equal','none','all',1,0,''),(193,2,7,10,'2019-08-23 11:37:10',10,0,0,1,'none','none',10,1,'between_and','none','all',0,0,'#date_time_start_long|*|#date_time_end_long'),(198,4,3,1,'2019-10-10 18:28:04',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(199,4,12,2,'2019-10-10 18:28:04',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(200,4,6,3,'2019-10-10 18:28:04',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(201,4,5,4,'2019-10-10 18:28:04',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(202,4,8,5,'2019-10-10 18:28:04',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(203,4,7,6,'2019-10-10 18:28:04',6,0,0,1,'none','none',6,0,'equal','none','all',0,0,''),(212,6,3,1,'2019-10-29 13:28:17',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(213,6,17,3,'2019-10-29 13:28:17',3,0,0,1,'none','none',3,1,'left_like_right','none','all',1,0,''),(214,6,18,4,'2019-10-29 13:28:17',4,0,1,1,'none','none',4,1,'left_like_right','none','all',1,0,''),(216,6,6,7,'2019-10-29 13:28:17',7,0,1,1,'none','none',7,0,'equal','none','all',1,0,''),(217,6,5,8,'2019-10-29 13:28:17',8,0,1,1,'none','none',8,0,'equal','none','all',1,0,''),(218,6,8,9,'2019-10-29 13:28:17',9,0,0,1,'none','none',9,1,'equal','none','all',1,0,''),(219,6,7,10,'2019-10-29 13:28:17',10,0,0,1,'none','none',10,1,'between_and','none','all',0,0,'#date_time_start_long|*|#date_time_end_long'),(220,6,20,2,'2019-10-29 13:38:28',2,0,0,1,'none','none',2,1,'equal','top','all',1,0,'7'),(221,6,21,11,'2019-10-29 14:08:37',11,1,0,1,'none','none',11,1,'equal','none','all',0,0,''),(222,6,22,12,'2019-10-29 14:08:37',12,1,0,1,'none','none',12,0,'equal','none','all',0,0,''),(223,7,3,1,'2019-10-29 20:02:33',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(224,7,12,2,'2019-10-29 20:02:33',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(225,7,23,3,'2019-10-29 20:02:33',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(226,7,6,4,'2019-10-29 20:02:33',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(227,7,5,5,'2019-10-29 20:02:33',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(228,7,7,6,'2019-10-29 20:02:33',6,0,0,1,'none','none',6,0,'equal','none','all',0,0,''),(229,2,24,3,'2019-10-29 20:56:48',3,0,0,1,'none','none',3,1,'left_like_right','none','all',1,0,''),(230,2,25,4,'2019-10-29 20:56:48',4,0,0,1,'none','none',4,1,'equal','none','all',1,1,''),(231,2,26,5,'2019-10-29 20:56:48',5,0,0,1,'none','none',5,1,'left_like_right','none','all',1,1,''),(232,2,27,6,'2019-10-29 20:56:48',6,1,0,1,'none','none',6,0,'equal','none','all',1,0,''),(233,2,28,9,'2019-10-29 20:56:48',9,1,0,1,'none','none',9,1,'between_and','none','all',0,0,'#date_start_long|*|#date_end_long'),(234,2,29,2,'2019-10-29 21:11:04',2,0,0,1,'none','none',2,1,'equal','none','all',1,0,''),(235,8,3,1,'2019-11-06 21:38:14',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(236,8,31,2,'2019-11-06 21:38:14',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(237,8,17,3,'2019-11-06 21:38:14',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(238,8,33,4,'2019-11-06 21:38:14',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(239,8,32,5,'2019-11-06 21:38:14',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(240,8,6,6,'2019-11-06 21:38:14',6,1,0,1,'none','none',6,0,'equal','none','all',1,0,''),(241,8,7,7,'2019-11-06 21:38:14',7,0,0,1,'none','none',7,0,'equal','none','all',0,0,''),(242,6,34,6,'2019-11-10 18:36:51',6,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(244,9,3,1,'2019-11-16 11:14:13',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(245,9,19,3,'2019-11-16 11:14:13',3,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(246,9,35,4,'2019-11-16 11:14:13',4,0,1,1,'none','none',3,0,'equal','none','all',1,0,''),(247,9,6,6,'2019-11-16 11:14:13',6,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(248,9,5,7,'2019-11-16 11:14:13',7,0,1,1,'none','none',5,0,'equal','none','all',1,0,''),(249,9,8,8,'2019-11-16 11:14:13',8,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(250,9,7,9,'2019-11-16 11:14:13',9,0,0,1,'none','none',7,0,'equal','none','all',0,0,''),(251,9,36,10,'2019-11-16 11:20:49',10,0,0,1,'none','none',8,0,'equal','none','all',1,0,''),(259,11,3,1,'2019-11-26 15:01:14',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(261,11,1,2,'2019-11-26 15:06:54',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(262,11,37,3,'2019-11-26 15:06:54',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(263,11,6,4,'2019-11-26 15:06:54',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(264,11,5,5,'2019-11-26 15:06:54',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(265,11,8,6,'2019-11-26 15:06:54',6,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(266,11,7,7,'2019-11-26 15:06:54',7,0,0,1,'none','none',7,0,'equal','none','all',0,0,''),(267,12,3,1,'2019-11-27 10:10:59',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(268,12,38,2,'2019-11-27 10:10:59',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(269,12,39,3,'2019-11-27 10:10:59',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(270,12,40,4,'2019-11-27 10:10:59',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(271,12,41,5,'2019-11-27 10:10:59',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(272,12,42,6,'2019-11-27 10:10:59',6,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(273,12,6,7,'2019-11-27 10:10:59',7,0,0,1,'none','none',7,0,'equal','none','all',1,0,''),(274,12,5,8,'2019-11-27 10:10:59',8,0,1,1,'none','none',8,0,'equal','none','all',1,0,''),(275,12,8,9,'2019-11-27 10:10:59',9,0,0,1,'none','none',9,0,'equal','none','all',1,0,''),(276,12,7,10,'2019-11-27 10:10:59',10,0,0,1,'none','none',10,0,'equal','none','all',0,0,''),(277,13,3,1,'2019-11-29 12:34:42',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(278,13,12,2,'2019-11-29 12:34:42',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(279,13,44,3,'2019-11-29 12:34:42',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(280,13,45,4,'2019-11-29 12:34:42',4,1,0,1,'none','none',4,0,'equal','none','all',1,0,''),(281,13,46,5,'2019-11-29 12:34:42',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(282,13,47,6,'2019-11-29 12:34:42',6,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(283,13,48,7,'2019-11-29 12:34:42',7,0,0,1,'none','none',7,0,'equal','none','all',1,0,''),(284,13,49,8,'2019-11-29 12:34:42',8,0,0,1,'none','none',8,0,'equal','none','all',1,0,''),(285,13,50,9,'2019-11-29 12:34:42',9,1,0,1,'none','none',9,0,'equal','none','all',1,0,''),(286,13,51,10,'2019-11-29 12:34:42',10,1,0,1,'none','none',10,0,'equal','none','all',1,0,''),(287,13,8,11,'2019-11-29 12:34:42',11,0,0,1,'none','none',11,0,'equal','none','all',1,0,''),(288,13,6,12,'2019-11-29 12:34:42',12,1,0,1,'none','none',12,0,'equal','none','all',1,0,''),(289,13,5,13,'2019-11-29 12:34:42',13,0,0,1,'none','none',13,0,'equal','none','all',1,0,''),(290,13,7,14,'2019-11-29 12:34:42',14,0,0,1,'none','none',14,0,'equal','none','all',0,0,''),(291,14,3,1,'2019-12-05 23:20:20',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(292,14,24,2,'2019-12-05 23:20:20',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(293,14,52,3,'2019-12-05 23:20:20',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(294,14,12,4,'2019-12-05 23:20:20',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(295,14,8,5,'2019-12-05 23:20:20',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(296,14,6,6,'2019-12-05 23:20:20',6,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(297,14,7,7,'2019-12-05 23:20:20',7,0,0,1,'none','none',7,0,'equal','none','all',0,0,''),(298,15,3,1,'2019-12-06 10:03:51',1,0,0,1,'none','none',1,0,'equal','none','all',0,0,''),(299,15,53,2,'2019-12-06 10:03:51',2,0,0,1,'none','none',2,0,'equal','none','all',1,0,''),(300,15,54,3,'2019-12-06 10:03:52',3,0,0,1,'none','none',3,0,'equal','none','all',1,0,''),(301,15,8,4,'2019-12-06 10:03:52',4,0,0,1,'none','none',4,0,'equal','none','all',1,0,''),(302,15,6,5,'2019-12-06 10:03:52',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(303,15,7,6,'2019-12-06 10:03:52',6,0,0,1,'none','none',6,0,'equal','none','all',0,0,''),(304,2,55,11,'2020-01-12 16:37:57',11,1,0,1,'none','none',11,0,'equal','none','all',0,0,''),(305,2,56,12,'2020-01-12 16:37:57',12,1,0,1,'none','none',12,0,'equal','none','all',0,0,''),(363,9,82,2,'2020-02-22 19:06:22',2,0,0,1,'none','none',9,1,'equal','none','all',1,0,'common'),(364,9,83,5,'2020-02-22 19:06:22',5,0,0,1,'none','none',10,0,'equal','none','all',1,0,''),(425,27,3,1,'2020-06-08 22:57:30',1,0,0,1,'none','none',1,0,'equal','none','all',1,0,''),(426,27,107,2,'2020-06-08 23:02:47',2,0,0,1,'none','none',2,0,'equal','top','all',1,0,''),(427,27,21,3,'2020-06-08 23:02:47',3,0,0,1,'none','none',3,0,'equal','none','all',0,0,''),(428,27,12,4,'2020-06-08 23:02:47',4,0,0,1,'indentShow','none',4,0,'equal','none','all',1,0,''),(429,27,6,5,'2020-06-08 23:02:47',5,0,0,1,'none','none',5,0,'equal','none','all',1,0,''),(430,27,8,6,'2020-06-08 23:02:47',6,0,0,1,'none','none',6,0,'equal','none','all',1,0,''),(431,27,5,7,'2020-06-08 23:02:47',7,0,0,1,'none','none',7,0,'equal','none','all',1,0,''),(432,27,22,8,'2020-06-08 23:02:47',8,1,0,1,'none','none',8,0,'equal','none','all',0,0,''),(433,27,7,9,'2020-06-08 23:02:47',9,0,0,1,'none','none',9,0,'equal','none','all',0,0,'');
/*!40000 ALTER TABLE `dry_model_field` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_oss_file`
--
DROP TABLE IF EXISTS `dry_oss_file`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_oss_file` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_prefix` varchar(16) DEFAULT NULL,
`dry_name` varchar(64) DEFAULT NULL,
`dry_object` varchar(255) DEFAULT NULL,
`dry_mime_type` varchar(64) DEFAULT NULL,
`dry_format` varchar(16) DEFAULT NULL,
`dry_width` int(11) DEFAULT '0' COMMENT '宽度',
`dry_height` int(11) DEFAULT '0' COMMENT '高度',
`dry_size` int(11) DEFAULT '0' COMMENT '大小',
`dry_add_date` date DEFAULT NULL COMMENT '添加日期',
`dry_add_time` datetime DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_oss_file`
--
LOCK TABLES `dry_oss_file` WRITE;
/*!40000 ALTER TABLE `dry_oss_file` DISABLE KEYS */;
/*!40000 ALTER TABLE `dry_oss_file` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_permission_config`
--
DROP TABLE IF EXISTS `dry_permission_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_permission_config` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_username` varchar(32) DEFAULT NULL,
`dry_has` tinyint(3) unsigned DEFAULT NULL,
`dry_name` tinytext,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_permission_config`
--
LOCK TABLES `dry_permission_config` WRITE;
/*!40000 ALTER TABLE `dry_permission_config` DISABLE KEYS */;
INSERT INTO `dry_permission_config` VALUES (1,'',1,'/Admin/Home/login',1,'任何人都拥有登录权限','2019-12-05 23:24:16'),(2,'',1,'/Admin/Home/index',1,'任何人都拥有首页权限','2019-12-05 23:27:06'),(3,'',1,'/Admin/Home/illegal',1,'任何人都拥有非法页面权限','2019-12-07 11:50:07'),(4,'',1,'/Admin/Home/selectUser',1,'任何人都拥有选择登录用户权限','2019-12-07 12:33:34'),(5,'',1,'/Admin/Home/selectGroup',1,'任何人都拥有选择登录用户组权限\n','2019-12-07 12:34:25'),(6,'',1,'/Admin/Qr/login',1,'任何人都拥有扫码登录权限','2020-04-05 21:27:22');
/*!40000 ALTER TABLE `dry_permission_config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_sub_user`
--
DROP TABLE IF EXISTS `dry_sub_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_sub_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_user` int(11) unsigned DEFAULT NULL,
`dry_sub_user` int(11) unsigned DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_sub_user`
--
LOCK TABLES `dry_sub_user` WRITE;
/*!40000 ALTER TABLE `dry_sub_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `dry_sub_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dry_user`
--
DROP TABLE IF EXISTS `dry_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dry_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dry_group` varchar(255) DEFAULT NULL,
`dry_username` varchar(32) DEFAULT NULL,
`dry_phone` varchar(128) DEFAULT NULL,
`dry_email` varchar(128) DEFAULT NULL,
`dry_password` varchar(128) DEFAULT NULL,
`dry_note` varchar(255) DEFAULT NULL,
`dry_status` tinyint(3) unsigned DEFAULT NULL,
`dry_add_date` date DEFAULT NULL,
`dry_add_time` datetime DEFAULT NULL,
`dry_wei_xin_sp_open_id` varchar(32) DEFAULT NULL,
`dry_wei_xin_sp_user_info` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dry_user`
--
LOCK TABLES `dry_user` WRITE;
/*!40000 ALTER TABLE `dry_user` DISABLE KEYS */;
INSERT INTO `dry_user` VALUES (5,'1','administrator',NULL,NULL,'$2y$10$SR5.ZlGF5a5T9UI7yIFtC.TNC3KymuCYEiccqeDPbPfKP8UTbsrCS','超管',1,'2019-10-29','2019-10-29 22:01:08',NULL,NULL);
/*!40000 ALTER TABLE `dry_user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2020-06-20 20:21:38

Comment ( 0 )

Sign in for post a comment

PHP
1
https://gitee.com/drycms/drycms.git
git@gitee.com:drycms/drycms.git
drycms
drycms
drycms
master

Search