java110-db/db/WebService/menu.sql · javaalpha/MicroCommunity

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 4.3K

javaalpha/MicroCommunity

forked from java110/MicroCommunity

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (15)

Tags (8)

Manage

master

shiyj01

duckweed

jonas

spring-cloud-1.4

shareDb

shiyj

dyaoming

wuxw

product

v0.3

v20190322

test

v0.2

add-license-1

v0.0.8

v0.0.7

v0.0.6

v0.0.5

v0.0.4

v0.0.3

v0.0.2

v0.0.1

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 15

Tags 8

MicroCommunity

java110-db

WebService

menu.sql

menu.sql 3.17 KB

-- 这里只做二级菜单
 -- 菜单组
create table m_menu_group(
 g_id varchar(12) not null comment '菜单组ID',
 name varchar(10) not null comment '菜单组名称',
 icon varchar(20) not null comment '菜单图片',
 label varchar(20) not null comment '菜单标签',
 seq INT NOT NULL COMMENT '列顺序',
 description VARCHAR(200) COMMENT '菜单描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (g_id)
);

-- 菜单
create table m_menu(
 m_id varchar(12) not null comment '菜单ID',
 name varchar(10) not null comment '菜单名称',
 g_id varchar(12) not null comment '菜单组ID',
 url VARCHAR(200) not null COMMENT '打开地址',
 seq INT NOT NULL COMMENT '列顺序',
 p_id varchar(12) not null comment '权限ID',
 description VARCHAR(200) COMMENT '菜单描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (m_id)
);

-- 权限组

create table p_privilege_group(
 pg_id varchar(12) not null comment '权限组ID',
 name varchar(10) not null comment '权限组名称',
 description VARCHAR(200) COMMENT '权限组描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 store_id varchar(30) not null comment '商户ID',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (pg_id)

);
-- 权限关系表
create table p_privilege_rel(
 rel_id INT NOT NULL AUTO_INCREMENT KEY comment '权限关系ID',
 p_id varchar(12) not null comment '权限ID',
 pg_id varchar(12) comment '权限组ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (rel_id)
);

-- 权限表
create table p_privilege(
 p_id varchar(12) not null comment '权限ID',
 name varchar(10) not null comment '权限名称',
 domain varchar(12) not null comment '权限域 商户详见store_type store_type_cd',
 description VARCHAR(200) COMMENT '权限描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (p_id)
);

-- 权限用户表
create table p_privilege_user(
 pu_id INT NOT NULL AUTO_INCREMENT KEY comment '权限用户ID',
 p_id varchar(12) not null comment '权限ID 或权限组ID',
 privilege_flag varchar(4) not null DEFAULT '0' comment '权限标志 是 1是权限组 0是权限',
 user_id varchar(30) not null comment '用户ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (pu_id)
);

Copy Edit Raw Blame History

java110 authored 2019年05月13日 18:01 +08:00 . 加入分片功能呢

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72


-- 这里只做二级菜单
 -- 菜单组
create table m_menu_group(
 g_id varchar(12) not null comment '菜单组ID',
 name varchar(10) not null comment '菜单组名称',
 icon varchar(20) not null comment '菜单图片',
 label varchar(20) not null comment '菜单标签',
 seq INT NOT NULL COMMENT '列顺序',
 description VARCHAR(200) COMMENT '菜单描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (g_id)
);

-- 菜单
create table m_menu(
 m_id varchar(12) not null comment '菜单ID',
 name varchar(10) not null comment '菜单名称',
 g_id varchar(12) not null comment '菜单组ID',
 url VARCHAR(200) not null COMMENT '打开地址',
 seq INT NOT NULL COMMENT '列顺序',
 p_id varchar(12) not null comment '权限ID',
 description VARCHAR(200) COMMENT '菜单描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (m_id)
);

-- 权限组

create table p_privilege_group(
 pg_id varchar(12) not null comment '权限组ID',
 name varchar(10) not null comment '权限组名称',
 description VARCHAR(200) COMMENT '权限组描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 store_id varchar(30) not null comment '商户ID',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (pg_id)

);
-- 权限关系表
create table p_privilege_rel(
 rel_id INT NOT NULL AUTO_INCREMENT KEY comment '权限关系ID',
 p_id varchar(12) not null comment '权限ID',
 pg_id varchar(12) comment '权限组ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (rel_id)
);

-- 权限表
create table p_privilege(
 p_id varchar(12) not null comment '权限ID',
 name varchar(10) not null comment '权限名称',
 domain varchar(12) not null comment '权限域 商户详见store_type store_type_cd',
 description VARCHAR(200) COMMENT '权限描述',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (p_id)
);

-- 权限用户表
create table p_privilege_user(
 pu_id INT NOT NULL AUTO_INCREMENT KEY comment '权限用户ID',
 p_id varchar(12) not null comment '权限ID 或权限组ID',
 privilege_flag varchar(4) not null DEFAULT '0' comment '权限标志 是 1是权限组 0是权限',
 user_id varchar(30) not null comment '用户ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,0在用,1失效',
 UNIQUE KEY (pu_id)
);