drop database if exists `linuxam`;

create database if not exists `linuxam`;

use linuxam;

DROP TABLE IF EXISTS `machine`;

create table `machine`(
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID号',
`tag` varchar(32) DEFAULT NULL COMMENT '标签',
`ip` varchar(30) unique NOT NULL COMMENT 'IP地址',
`cpu` smallint(5) unsigned DEFAULT NULL COMMENT 'cpu数',
`mem` bigint(20) unsigned DEFAULT NULL COMMENT '内存',
`disk` bigint(20) unsigned DEFAULT NULL COMMENT '硬盘',
`status` tinyint(3) unsigned DEFAULT '0' COMMENT '状态',
`cdate` datetime DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY(`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `machine` VALUES (1,'test01','192.168.3.100',4,8,500,1,'2018-10-23 17:50:54'),(2,'test02','192.168.3.101',4,8,1000,1,'2018-10-23 17:50:54'),(3,'席位01','6.24.34.100',NULL,NULL,NULL,0,'2018-10-23 20:47:17'),(4,'席位02','6.24.34.101',NULL,NULL,NULL,0,'2018-10-23 20:47:33'),(5,'席位03','6.24.34.102',NULL,NULL,NULL,0,'2018-10-23 20:47:45'),(6,'席位04','6.24.34.103',NULL,NULL,NULL,0,'2018-10-23 20:47:53'),(7,'席位05','6.24.34.104',NULL,NULL,NULL,0,'2018-10-23 20:47:58'),(8,'席位06','6.24.34.105',NULL,NULL,NULL,0,'2018-10-23 20:48:06'),(9,'席位07','6.24.34.106',NULL,NULL,NULL,0,'2018-10-23 20:48:13'),(10,'席位08','6.24.34.107',NULL,NULL,NULL,0,'2018-10-23 20:48:20');

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID号',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `email` varchar(32) NOT NULL COMMENT '邮箱',
  `cdate` datetime DEFAULT NULL COMMENT '注册时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `user` VALUES (1,'admin','061c1da6af11de1d84374ce61d17ceaf','admin@csdn.net','2018-10-28 09:52:18');