<?php
/*
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_studentzayavks'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`fio` varchar(255) NOT NULL,
		`pred_obraz` varchar(255) NOT NULL,
		`obraz_uchr` TEXT NOT NULL,
		`diplom_seriya` varchar(255) NOT NULL,
		`diplom_nomer` varchar(255) NOT NULL,
		`diplom_data` int(11) NOT NULL,
		`pret_naprav` varchar(255) NOT NULL,
		`pret_kurs` varchar(255) NOT NULL,
		`pret_fo` varchar(255) NOT NULL,
		`status` tinyint(4) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_studentzayavks_files'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`tipfile` varchar(255) NOT NULL,
		`file` varchar(255) NOT NULL,
		`status` tinyint(4) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_statuses'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`status_old` tinyint(4) NOT NULL,
		`status_new` tinyint(4) NOT NULL,
		`descrip` varchar(255) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_ocenki'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`ocenka` varchar(255) NOT NULL,
		`predmet` varchar(255) NOT NULL,
		`id_predmet` int(11) NOT NULL,
		`tip` tinyint(4) NOT NULL,
		`data_time` int(11) NOT NULL,
		`semestr` tinyint(4) NOT NULL,
		`comment` varchar(255) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_attkom'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`semestr` int(11) NOT NULL,
		`ocenka` varchar(255) NOT NULL,
		`predmet` varchar(255) NOT NULL,
		`id_predmet` int(11) NOT NULL,
		`data_time` int(11) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_kafedrs_files'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`tipfile` varchar(255) NOT NULL,
		`file` varchar(255) NOT NULL,
		`status` tinyint(4) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_kafumu_chat'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_user` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`fiouser` varchar(255) NOT NULL,
		`text` TEXT NOT NULL,
		`status` tinyint(4) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_shahtplans'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`file` varchar(255) NOT NULL,
		`user_id` int(11) NOT NULL,
		`napravlenie` varchar(255) NOT NULL,
		`godob` varchar(255) NOT NULL,
		`status` tinyint(4) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_zamdekan'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`user_id` int(11) NOT NULL,
		`id_studentzayavks` int(11) NOT NULL,
		`predmet_id` int(11) NOT NULL,
		`predmet_name` varchar(255) NOT NULL,
		`prepod_id` int(11) NOT NULL,
		`prepod_name` varchar(255) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_shahtplans_plans'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`data_c` int(11) NOT NULL,
		`id_file` int(11) NOT NULL,
		`obrpro` varchar(255) NOT NULL,
		`forobu` varchar(255) NOT NULL,
		`uroobr` varchar(255) NOT NULL,
		`kodkaf` varchar(255) NOT NULL,
		`fakult` varchar(255) NOT NULL,
		`shifr1` varchar(255) NOT NULL,
		`godnap` varchar(255) NOT NULL,
		`nappodgo` varchar(255) NOT NULL,
		`propodgo` varchar(255) NOT NULL,
		`kvalif_name` varchar(255) NOT NULL,
		`kvalif_srok` varchar(255) NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_shahtplans_stroki'].'` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
		`id_plans` int(11) NOT NULL,
		`discip` varchar(255) NOT NULL,
		`discid` varchar(255) NOT NULL,
		`kurs` varchar(255) NOT NULL,
		`nom` varchar(255) NOT NULL,
		`lek` varchar(255) NOT NULL,
		`lab` varchar(255) NOT NULL,
		`pr` varchar(255) NOT NULL,
		`srs` varchar(255) NOT NULL,
		`chasekz` varchar(255) NOT NULL,
		`zet` varchar(255) NOT NULL,
		`ekz` varchar(255) NOT NULL,
		`zach` varchar(255) NOT NULL,
		`vidkontr` varchar(255) NOT NULL,
		`kontrab` varchar(255) NOT NULL,
		`kontr` varchar(255) NOT NULL,
		`sessiya` TEXT NOT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);
}
{$sql = 'CREATE TABLE IF NOT EXISTS `'.$TB['iup_studkadr'].'` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`data_c` int(11) NOT NULL,
	`id_studentzayavks` int(11) NOT NULL,
	`user_id` int(11) NOT NULL,
	`nomer` varchar(255) NOT NULL,
	`data` varchar(255) NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
	$rez = $DB->QUR($sql);
}
*/