| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Admin/Advising/ParseClasses/_backup/ |
Upload File : |
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.5.28
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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' */;
--
-- Create schema jimmarti_cst
--
CREATE DATABASE IF NOT EXISTS jimmarti_cst;
USE jimmarti_cst;
--
-- Definition of table `pclass`
--
DROP TABLE IF EXISTS `pclass`;
CREATE TABLE `pclass` (
`YRTR` char(5) NOT NULL,
`COU_ID` char(6) NOT NULL,
`SUBJ` varchar(4) DEFAULT NULL,
`NBR` char(4) DEFAULT NULL,
`SECT` varchar(3) DEFAULT NULL,
`TITLE` varchar(48) DEFAULT NULL,
`CRHR` tinyint(2) DEFAULT NULL,
`CRMAX` tinyint(2) DEFAULT '0',
`INSTR_TYPE` varchar(20) DEFAULT NULL,
`ENR` smallint(4) DEFAULT NULL,
`MAX` smallint(4) DEFAULT NULL,
`GRADE_METH` varchar(20) DEFAULT NULL,
`COU_START` date DEFAULT NULL,
`COU_END` date DEFAULT NULL,
`IsDropped` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`YRTR`,`COU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `pclass`
--
/*!40000 ALTER TABLE `pclass` DISABLE KEYS */;
INSERT INTO `pclass` (`YRTR`,`COU_ID`,`SUBJ`,`NBR`,`SECT`,`TITLE`,`CRHR`,`CRMAX`,`INSTR_TYPE`,`ENR`,`MAX`,`GRADE_METH`,`COU_START`,`COU_END`,`IsDropped`) VALUES
('20165','000534','ADR','1500','41','MEPAP 1:Basic Act Prog',1,0,'Dist Learng',5,25,'GR','2016-01-11','2016-05-13',1),
('20165','000538','ADR','1410','41','Agn/Org for Older Adults',2,0,'Dist Learng',3,25,'GR/PF/AU/PN','2016-01-11','2016-05-13',1),
('20165','000570','ADR','1015','41','Activity Ideas',3,0,'Dist Learng',3,25,'GR/PF/AU','2016-01-11','2016-05-13',0),
('20165','000571','ADR','1405','41','Act Prog Development',2,0,'Dist Learng',2,25,'GR/PF/AU/PN','2016-01-11','2016-05-13',1);
/*!40000 ALTER TABLE `pclass` ENABLE KEYS */;
--
-- Definition of table `pclassmeeting`
--
DROP TABLE IF EXISTS `pclassmeeting`;
CREATE TABLE `pclassmeeting` (
`YRTR` char(5) NOT NULL,
`COU_ID` char(6) NOT NULL,
`MTG_START` date DEFAULT NULL,
`MTG_END` date DEFAULT NULL,
`DAYS` char(8) DEFAULT NULL,
`BEGIN` date DEFAULT NULL,
`END` date DEFAULT NULL,
`BLDG` varchar(8) DEFAULT NULL,
`ROOM` varchar(4) DEFAULT NULL,
`INSTRUCTOR` varchar(128) DEFAULT NULL,
PRIMARY KEY (`YRTR`,`COU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Definition of table `pclassnote`
--
DROP TABLE IF EXISTS `pclassnote`;
CREATE TABLE `pclassnote` (
`YRTR` char(5) NOT NULL,
`COU_ID` char(6) NOT NULL,
`NOTE` varchar(8) DEFAULT NULL,
PRIMARY KEY (`YRTR`,`COU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;