---------------------------- -- 创建日程表 -- ---------------------------- 
CREATE DATABASE schedule_system;
DROP TABLE IF EXISTS `sys_schedule`; 
CREATE TABLE `sys_schedule` ( `sid` int NOT NULL AUTO_INCREMENT,
 `uid` int NULL DEFAULT NULL, 
 `title` varchar(20) NULL DEFAULT NULL, 
 `completed` int(1) NULL, PRIMARY KEY (`sid`) USING BTREE ) ; 
 DROP TABLE IF EXISTS `sys_user`; 
CREATE TABLE `sys_user` ( `uid` int NOT NULL AUTO_INCREMENT, `username` varchar(10) NULL DEFAULT NULL, 
  `user_pwd` varchar(100) NULL DEFAULT NULL, 
  PRIMARY KEY (`uid`) USING BTREE, 
UNIQUE INDEX `username`(`username`) USING BTREE ); 
INSERT INTO `sys_user` VALUES (1, 'zhangsan', 'e10adc3949ba59abbe56e057f20f883e'); 
INSERT INTO `sys_user` VALUES (2, 'lisi', 'e10adc3949ba59abbe56e057f20f883e');