-----------------------------------------------------------------------------------------------------
DROP PROCEDURE IF EXISTS dbchange_zhuliang_20170817;
CREATE PROCEDURE dbchange_zhuliang_20170817() BEGIN
IF NOT EXISTS (SELECT * FROM information_schema.TABLES WHERE table_schema='yjp_else' AND table_name = 'applyjoin') THEN
create table yjp_else.applyjoin
(
Id int(11) not null AUTO_INCREMENT,
BizUser_Id int(11) not null comment '会员id',
ApplyName varchar(25) not null comment '申请人姓名',
ApplyCompany varchar(100) not null comment '申请人公司名称',
ApplyMobileNo varchar(20) not null comment '申请人联系电话',
ApplyAddress varchar(200) not null comment '申请人公司所在地址',
City_Id int(11) not null comment '会员所在城市',
State tinyint(4) not null comment '处理状态',
HandleMessage varchar(500) comment '处理信息',
HandleTime datetime comment '处理时间',
CreateTime datetime not null comment '创建时间',
CreateUser_Id int(11) not null comment '创建人ID',
LastUpdateTime datetime comment '最后修改时间',
LastUpdateUser_Id int(11) comment '最后修改人id',
primary key (Id)
);
END IF;
END;
CALL dbchange_zhuliang_20170817();
DROP PROCEDURE IF EXISTS dbchange_zhuliang_20170817;
---------------------------------------------------------------------------------------------------
在每个表中必须有CreateTime、CreateUser_Id、LastUpdateTime 、LastUpdateUser_Id 这4个字段,业务逻辑字段如果和其中字段内容一致,也必须建2个字段,逻辑字段不应该替代必须字段,不利于后期业务拓展
---------------------------------------------------------------------------------------------------
DROP PROCEDURE IF EXISTS dbchange_zhuliang_20170807;
CREATE PROCEDURE dbchange_zhuliang_20170807() BEGIN
IF NOT EXISTS (SELECT * FROM information_schema.TABLES WHERE table_schema='yjp_setting' AND table_name = 'bizuserlevel') THEN
create table yjp_setting.bizuserlevel
(
Id int(11) not null,
LevelName varchar(25) not null comment '会员等级名称',
MinGrowUpNumber int(11) not null comment '成长最小值',
MaxGrowUpNumber int(11) comment '成长最大值',
IsPrivateManager bit(1) comment '是否有专职客户经理',
IsPrecedence bit(1) comment '是否投诉找货优先',
ImageUrl varchar(500) not null comment '等级图标url',
CreateTime datetime not null comment '创建时间',
CreateUser_Id int(11) not null comment '创建人ID',
LastUpdateTime datetime comment '最后修改时间',
LastUpdateUser_Id int(11) comment '最后修改人ID',
primary key (Id)
);
END IF;
END;
CALL dbchange_zhuliang_20170807();
DROP PROCEDURE IF EXISTS dbchange_zhuliang_20170807;
------------------------------------------------------------------------------------------------------
* 是否有专职客户经理
*/
private Boolean privateManager = false;
/**
* 是否投诉找货优先
*/
private Boolean precedence = false;
表设计为bit类型的,模型持久化中字段最好设置为Boolean的,同时字段不要以is开头,反序列化过程中,字段名和方法名相同会找不到报错
------------------------------------------------------------------------------------------------------