lccsw
29 lines
1.4 KiB
SQL
29 lines
1.4 KiB
SQL
-- ----------------------------
|
|
-- Title:服务表
|
|
-- Author:lcc
|
|
-- Table:lc_receiver_services
|
|
-- ---------------------------
|
|
create table lc_receiver_services (
|
|
id int(10) unsigned not null auto_increment comment '自增id',
|
|
title varchar(50) not null default '' comment '服务名称',
|
|
field_name varchar(50) not null default '' comment '表名.字段名',
|
|
c_time int(10) unsigned not null default '0' comment '创建时间',
|
|
u_time timestamp not null default current_timestamp on update current_timestamp,
|
|
primary key (id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='服务表';
|
|
|
|
|
|
-- ----------------------------
|
|
-- Title:服务包表
|
|
-- Author:lcc
|
|
-- Table:lc_receiver_service_package
|
|
-- ---------------------------
|
|
create table lc_receiver_service_package (
|
|
id int(10) unsigned not null auto_increment comment '自增id',
|
|
srv_ids varchar(50) not null default '' comment '服务包组合id',
|
|
status tinyint(2) not null default '1' comment '状态(-1删除 0禁用 1正常)',
|
|
c_time int(10) unsigned not null default '0' comment '创建时间',
|
|
u_time timestamp not null default current_timestamp on update current_timestamp,
|
|
primary key (id)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='服务包表'
|