【绿叶结界】数据库表设计

drop table if exists setip;

create table setip(id int(22) NOT NULL AUTO_INCREMENT,PRIMARY KEY (id), name varchar(200), ip varchar(30), status varchar(9),details varchar(9999), setdate varchar(90))ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;      

insert into setip(name,ip,status,details,setdate) values('root','0.0.0.0','0','root','2021.11.24');

DROP TABLE IF EXISTS `login`;

CREATE TABLE `login` ( `id` int(11) DEFAULT NULL,`name` varchar(100) COLLATE utf8_bin DEFAULT NULL,`password` varchar(100) COLLATE utf8_bin DEFAULT NULL,`status` varchar(100) COLLATE utf8_bin DEFAULT NULL,`city` varchar(100) COLLATE utf8_bin DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

insert into login(id,name,password) values('1','root','eisc.cn');