<?php
spl_autoload_register(function ($class_name) {
    if(file_exists('inc/'.$class_name . '.php'))
        include_once 'inc/'.$class_name . '.php';
});
date_default_timezone_set('Europe/Moscow');
$WorkDIR = '/rabprog';
$ST['dbpf'] = 'acs';
$DB = new class_DB('admin_learn01','admin_learn01','FTgKQ6sRHW','localhost');
$DB->QUR('SET NAMES utf8');

/*
$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
  `data_c` int(11) NOT NULL,
  `id_file` int(11) NOT NULL,
  `program` varchar(255) NOT NULL,
  `shifr` varchar(255) NOT NULL,
  `naprav` varchar(255) NOT NULL,
  `profil` varchar(255) NOT NULL,
  `kafedra` varchar(255) NOT NULL,
  `fakultet` varchar(255) NOT NULL,
  `kvalif` varchar(255) NOT NULL,
  `god_nach_podgot` int(11) NOT NULL,
  `fo` varchar(255) NOT NULL,
  `obr_stabdart` varchar(255) NOT NULL,
  `srok_poluch_obr` varchar(255) NOT NULL,
  `json` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');

$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
  `data_c` int(11) NOT NULL,
  `file` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');

$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_uchebplans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
  `id_file` int(11) NOT NULL,
  `index1` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ekzamen` double NOT NULL,
  `zachet` double NOT NULL,
  `zachetsocenk` double NOT NULL,
  `kr` double NOT NULL,
  `kp` double NOT NULL,
  `kontrol` double NOT NULL,
  `json` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  `kaf_kod` varchar(255) NOT NULL,
  `kaf_name` varchar(255) NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');

$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_compet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_file` int(11) NOT NULL,
  `index` varchar(255) NOT NULL,
  `descrip` text NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');

$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_uchebplans_compet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_uchebplans` int(11) NOT NULL,
`id_compet` int(11) NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');

$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_disciplin_prepod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data_c` int(11) NOT NULL,
`id_uchebplans` int(11) NOT NULL,
`id_prepod` int(11) NOT NULL,
`descrip` VARCHAR(255) NOT NULL,
`status` TINYINT NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');

$DB->QUR('CREATE TABLE IF NOT EXISTS `'.$ST['dbpf'].'_fshp_rpd_save` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data_c` int(11) NOT NULL,
`id_discip` int(11) NOT NULL,
`id_prepod` int(11) NOT NULL,
`razdel1` text NOT NULL,
`razdel2` text NOT NULL,
`razdel3` text NOT NULL,
`razdel4` text NOT NULL,
`razdel5` text NOT NULL,
`razdel5_4` text NOT NULL,
`razdel5_5` text NOT NULL,
`razdel5_6` text NOT NULL,
`razdel5_7` text NOT NULL,
`razdel5_8` text NOT NULL,
`razdel5_9` text NOT NULL,
`razdel6` text NOT NULL,
`razdel7` text NOT NULL,
`razdel7_2` text NOT NULL,
`razdel7_3` text NOT NULL,
`razdel7_4` text NOT NULL,
`razdel8_1` text NOT NULL,
`razdel8_2` text NOT NULL,
`razdel8_3` text NOT NULL,
`razdel9` text NOT NULL,
`razdel10_1` text NOT NULL,
`razdel10_2` text NOT NULL,
`razdel11` text NOT NULL,
  primary key (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
*/