167 lines
5.8 KiB
PHP
167 lines
5.8 KiB
PHP
<?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);
|
|
}
|
|
*/ |