create table designer

(

id int(10),

designer varchar(32) collate utf8_general_ci comment '设计师账号',

networkstatus int(1) comment '网络状况(网络时长在10s内为1,在10s外为2,离线是3)',

networkduration varchar(16) collate utf8_general_ci comment '网络时长',

online int(1) default 1 comment '是否在线(0表示在线,1表示未在线)',

loadexceptionpercent varchar(10) collate utf8_general_ci comment '加载异常占比',

backnumber int(10) comment '备份数量',

createdate varchar(20) collate utf8_general_ci comment '所属的业务时间'

);

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (48840, 'baluosongbo@300.cn', 2, '46546', 0, '0.0%', 0, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (19956, 'baxudongxiang@300.cn', null, null, 1, '0.0%', 0, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (3454, 'bdcuiyanan@300.cn', null, null, 1, '0.0%', 0, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (55786, 'bdcuiyanwei@300.cn', null, null, 0, '0.0%', 0, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (64414, 'bdmazicong@300.cn', 2, '21315', 0, '0.0%', 1, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (69054, 'bdnieyifan@300.cn', null, null, 0, '0.0%', 2, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (35647, 'bdwangxiaoyu@300.cn', null, null, 0, '0.0%', 1, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (47096, 'bdwangzhanpeng@300.cn', null, null, 0, '0.0%', 1, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (3310, 'bdzhanglian@300.cn', null, null, 0, '0.0%', 1, '2018-08-01');

insert into designer (id, designer, networkstatus, networkduration, online, loadexceptionpercent, backnumber, createdate) values (66929, 'bj2gexuan@300.cn', null, null, 1, '0.0%', 0, '2018-08-01');