cms.sql · fltcode/cms

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 1 Fork 0

fltcode/cms

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Manage

master

This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.

The license selected for the repository is subject to the license used by the main branch of the repository.

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 0

cms

cms.sql

cms.sql 4.60 KB

/*
SQLyog Ultimate v11.33 (64 bit)
MySQL - 5.0.67-community-log : Database - cmms
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`cmms` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `cmms`;

/*Table structure for table `courseinfo` */

DROP TABLE IF EXISTS `courseinfo`;

CREATE TABLE `courseinfo` (
 `cnum` varchar(10) default NULL,
 `cname` varchar(20) default NULL,
 `ctime` varchar(2) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `courseinfo` */

insert into `courseinfo`(`cnum`,`cname`,`ctime`) values ('c1001','大数据数据库系统','48'),('c1002','JavaWeb程序设计','36'),('c1003','JavaWeb','36'),('c1004','JavaWeb','36'),('c1005','JavaWeb','36');

/*Table structure for table `roominfo` */

DROP TABLE IF EXISTS `roominfo`;

CREATE TABLE `roominfo` (
 `rid` int(11) NOT NULL auto_increment,
 `rnum` varchar(4) default NULL,
 `location` varchar(10) default NULL,
 `state` varchar(10) default NULL,
 `renshu` int(11) default NULL,
 `devinfo` varchar(50) default NULL,
 KEY `rid` (`rid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `roominfo` */

insert into `roominfo`(`rid`,`rnum`,`location`,`state`,`renshu`,`devinfo`) values (1,'201','实验楼B','空闲',48,'XXX'),(2,'205','实验楼B','空闲',48,'XXX');

/*Table structure for table `scheduleinfo` */

DROP TABLE IF EXISTS `scheduleinfo`;

CREATE TABLE `scheduleinfo` (
 `sid` int(11) NOT NULL auto_increment,
 `classnos` varchar(20) default NULL,
 `cname` varchar(20) default NULL,
 `tname` varchar(8) default NULL,
 `weeks` varchar(2) default NULL,
 `week` varchar(2) default NULL,
 `jieci` varchar(4) default NULL,
 `location` varchar(10) default NULL,
 KEY `sid` (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `scheduleinfo` */

insert into `scheduleinfo`(`sid`,`classnos`,`cname`,`tname`,`weeks`,`week`,`jieci`,`location`) values (1,'Z180456/57','大数据数据库系统','李贤','13','一','1-2','B205/B208'),(2,'Z180451/52','JavaWeb程序设计','张三','13','一','1-2','B210/B212');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
 `num` varchar(20) NOT NULL,
 `name` varchar(10) default NULL,
 `password` varchar(20) default NULL,
 `type` varchar(4) default NULL,
 PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert into `user`(`num`,`name`,`password`,`type`) values ('m1001','admin','123456','管理员'),('t1001','张三','123456','教师'),('t1002','李四','123456','教师'),('t1003','王五','123456','教师'),('t1004','张梅','123456','教师'),('t1005','张利','123456','教师'),('t1006','张颖','123456','教师'),('t1007','李丽','123456','教师'),('t1008','张建','123456','教师'),('t1009','张伟','123456','教师');

/*Table structure for table `userinfo` */

DROP TABLE IF EXISTS `userinfo`;

CREATE TABLE `userinfo` (
 `num` varchar(20) NOT NULL,
 `name` varchar(10) default NULL,
 `sex` varchar(2) default NULL,
 `phone` varchar(11) default NULL,
 `address` varchar(20) default NULL,
 `major` varchar(10) default NULL,
 `department` varchar(20) default NULL,
 PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `userinfo` */

insert into `userinfo`(`num`,`name`,`sex`,`phone`,`address`,`major`,`department`) values ('t1001','张三','男','123456','河南省-洛阳市-老城区','计算机科学与技术','计算机与信息工程学院'),('t1002','李四','男','123456','河南省-郑州市-中原区','计算机科学与技术','计算机与信息工程学院'),('t1003','王五','男','123456','安徽省-合肥市-瑶海区','计算机科学与技术','计算机与信息工程学院'),('t1004','张梅','女','123456','北京市-北京城区-东城区','计算机科学与技术','计算机与信息工程学院'),('t1005','张利','男','123456','河南省-郑州市-中原区','计算机','计算机与信息工程');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Copy Edit Raw Blame History

fltcode authored 2020年07月06日 10:55 +08:00 . first commit

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109

/*
SQLyog Ultimate v11.33 (64 bit)
MySQL - 5.0.67-community-log : Database - cmms
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`cmms` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `cmms`;

/*Table structure for table `courseinfo` */

DROP TABLE IF EXISTS `courseinfo`;

CREATE TABLE `courseinfo` (
 `cnum` varchar(10) default NULL,
 `cname` varchar(20) default NULL,
 `ctime` varchar(2) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `courseinfo` */

insert into `courseinfo`(`cnum`,`cname`,`ctime`) values ('c1001','大数据数据库系统','48'),('c1002','JavaWeb程序设计','36'),('c1003','JavaWeb','36'),('c1004','JavaWeb','36'),('c1005','JavaWeb','36');

/*Table structure for table `roominfo` */

DROP TABLE IF EXISTS `roominfo`;

CREATE TABLE `roominfo` (
 `rid` int(11) NOT NULL auto_increment,
 `rnum` varchar(4) default NULL,
 `location` varchar(10) default NULL,
 `state` varchar(10) default NULL,
 `renshu` int(11) default NULL,
 `devinfo` varchar(50) default NULL,
 KEY `rid` (`rid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `roominfo` */

insert into `roominfo`(`rid`,`rnum`,`location`,`state`,`renshu`,`devinfo`) values (1,'201','实验楼B','空闲',48,'XXX'),(2,'205','实验楼B','空闲',48,'XXX');

/*Table structure for table `scheduleinfo` */

DROP TABLE IF EXISTS `scheduleinfo`;

CREATE TABLE `scheduleinfo` (
 `sid` int(11) NOT NULL auto_increment,
 `classnos` varchar(20) default NULL,
 `cname` varchar(20) default NULL,
 `tname` varchar(8) default NULL,
 `weeks` varchar(2) default NULL,
 `week` varchar(2) default NULL,
 `jieci` varchar(4) default NULL,
 `location` varchar(10) default NULL,
 KEY `sid` (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `scheduleinfo` */

insert into `scheduleinfo`(`sid`,`classnos`,`cname`,`tname`,`weeks`,`week`,`jieci`,`location`) values (1,'Z180456/57','大数据数据库系统','李贤','13','一','1-2','B205/B208'),(2,'Z180451/52','JavaWeb程序设计','张三','13','一','1-2','B210/B212');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
 `num` varchar(20) NOT NULL,
 `name` varchar(10) default NULL,
 `password` varchar(20) default NULL,
 `type` varchar(4) default NULL,
 PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert into `user`(`num`,`name`,`password`,`type`) values ('m1001','admin','123456','管理员'),('t1001','张三','123456','教师'),('t1002','李四','123456','教师'),('t1003','王五','123456','教师'),('t1004','张梅','123456','教师'),('t1005','张利','123456','教师'),('t1006','张颖','123456','教师'),('t1007','李丽','123456','教师'),('t1008','张建','123456','教师'),('t1009','张伟','123456','教师');

/*Table structure for table `userinfo` */

DROP TABLE IF EXISTS `userinfo`;

CREATE TABLE `userinfo` (
 `num` varchar(20) NOT NULL,
 `name` varchar(10) default NULL,
 `sex` varchar(2) default NULL,
 `phone` varchar(11) default NULL,
 `address` varchar(20) default NULL,
 `major` varchar(10) default NULL,
 `department` varchar(20) default NULL,
 PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `userinfo` */

insert into `userinfo`(`num`,`name`,`sex`,`phone`,`address`,`major`,`department`) values ('t1001','张三','男','123456','河南省-洛阳市-老城区','计算机科学与技术','计算机与信息工程学院'),('t1002','李四','男','123456','河南省-郑州市-中原区','计算机科学与技术','计算机与信息工程学院'),('t1003','王五','男','123456','安徽省-合肥市-瑶海区','计算机科学与技术','计算机与信息工程学院'),('t1004','张梅','女','123456','北京市-北京城区-东城区','计算机科学与技术','计算机与信息工程学院'),('t1005','张利','男','123456','河南省-郑州市-中原区','计算机','计算机与信息工程');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;