| File was renamed from sql/ry_config_20210228.sql |
| | |
| | | `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间', |
| | | `src_user` text COMMENT 'source user', |
| | | `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip', |
| | | `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip', |
| | | `app_name` varchar(128) DEFAULT NULL, |
| | | `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段', |
| | | `c_desc` varchar(256) DEFAULT NULL, |
| | |
| | | `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间', |
| | | `src_user` text COMMENT 'source user', |
| | | `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip', |
| | | `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip', |
| | | `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段', |
| | | PRIMARY KEY (`id`), |
| | | UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`) |
| | |
| | | `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间', |
| | | `src_user` text COMMENT 'source user', |
| | | `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip', |
| | | `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip', |
| | | PRIMARY KEY (`id`), |
| | | UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag'; |
| | |
| | | `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| | | `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| | | `src_user` text, |
| | | `src_ip` varchar(20) DEFAULT NULL, |
| | | `src_ip` varchar(50) DEFAULT NULL, |
| | | `op_type` char(10) DEFAULT NULL, |
| | | `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段', |
| | | PRIMARY KEY (`nid`), |
| | |
| | | |
| | | CREATE TABLE `permissions` ( |
| | | `role` varchar(50) NOT NULL, |
| | | `resource` varchar(512) NOT NULL, |
| | | `resource` varchar(255) NOT NULL, |
| | | `action` varchar(8) NOT NULL, |
| | | UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE |
| | | ); |