EIOS/inc/iup_database.php

167 lines
5.8 KiB
PHP
Raw Permalink Normal View History

2023-12-28 15:39:22 +03:00
<?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);
}
*/