-- http://www.phpmyadmin.net
--




--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `ani_studiu`
--

CREATE TABLE IF NOT EXISTS `ani_studiu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `anul` enum('I','II','III','IV') COLLATE utf8_unicode_ci NOT NULL,
  `profil_id` int(11) NOT NULL,
  `alias` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `profil-id` (`profil_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `ani_studiu`
--

INSERT INTO `ani_studiu` (`id`, `anul`, `profil_id`, `alias`) VALUES
(5, 'I', 3, 5);

-- --------------------------------------------------------

--
-- Table structure for table `ani_universitari`
--

CREATE TABLE IF NOT EXISTS `ani_universitari` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `an` int(4) NOT NULL,
  `interval` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `facultate_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index-facultati` (`facultate_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ani_universitari`
--

INSERT INTO `ani_universitari` (`id`, `an`, `interval`, `facultate_id`) VALUES
(2, 2015, '2015-2016', 1);

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `problema_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  `filename` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `discipline`
--

CREATE TABLE IF NOT EXISTS `discipline` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `an_studiu_id` int(11) NOT NULL,
  `sem` int(11) NOT NULL,
  `disc_detalii_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `an_studiu` (`an_studiu_id`),
  KEY `disc_detalii_id` (`disc_detalii_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=150 ;

--
-- Dumping data for table `discipline`
--

INSERT INTO `discipline` (`id`, `nume`, `slug`, `an_studiu_id`, `sem`, `disc_detalii_id`) VALUES
(144, 'Microprocesoare I', 'microprocesoare-i', 5, 1, 144),
(145, 'Microprocesoare II     ', 'microprocesoare-ii', 5, 1, 145),
(146, 'Microprocesoare II eng      ', 'microprocesoare-ii-eng', 5, 1, 146),
(147, 'Procesoare de semnal', 'procesoare-de-semnal', 5, 1, 147),
(148, 'Digital signal processors', 'digital-signal-processors', 5, 1, 148),
(149, 'Analiza, sinteza si recunoasterea semnalului vocal', 'analiza-sinteza-si-recunoasterea-semnalului-vocal', 5, 1, 149);

-- --------------------------------------------------------

--
-- Table structure for table `discipline_detalii`
--

CREATE TABLE IF NOT EXISTS `discipline_detalii` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ore_curs` int(5) NOT NULL,
  `ore_seminar` int(5) NOT NULL,
  `ore_laborator` int(5) NOT NULL,
  `ore_proiect` int(5) NOT NULL,
  `ore_practica` int(5) NOT NULL,
  `credite` int(5) NOT NULL,
  `verificare` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `descriere` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=156 ;

--
-- Dumping data for table `discipline_detalii`
--

INSERT INTO `discipline_detalii` (`id`, `ore_curs`, `ore_seminar`, `ore_laborator`, `ore_proiect`, `ore_practica`, `credite`, `verificare`, `descriere`) VALUES
(144, 28, 0, 0, 0, 0, 5, 'E', 'O mica descrieredsadsadsadsadsadsadsadsa'),
(145, 28, 0, 0, 0, 0, 0, 'E', 'O mica descriere'),
(146, 0, 0, 0, 0, 0, 0, 'E', ''),
(147, 28, 12, 15, 21, 0, 0, 'E', ''),
(148, 0, 0, 0, 0, 0, 0, 'E', ''),
(149, 0, 0, 0, 0, 0, 0, 'E', ''),
(150, 25, 25, 25, 2, 525, 5, 'C', 'dsadsadsadsadas'),
(151, 0, 0, 0, 0, 0, 0, '', ''),
(152, 0, 0, 0, 0, 0, 0, '', ''),
(153, 0, 0, 0, 0, 0, 0, '', ''),
(154, 0, 0, 0, 0, 0, 0, 'C', ''),
(155, 0, 0, 0, 0, 0, 0, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `discipline_files`
--

CREATE TABLE IF NOT EXISTS `discipline_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `disciplina_tip_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=49 ;

--
-- Dumping data for table `discipline_files`
--

INSERT INTO `discipline_files` (`id`, `filename`, `disciplina_tip_id`) VALUES
(46, '133CJ-001-kooxt (1).pdf', 66),
(47, 'C1.pdf', 1),
(48, 'C1.pdf', 75);

-- --------------------------------------------------------

--
-- Table structure for table `discipline_tipuri`
--

CREATE TABLE IF NOT EXISTS `discipline_tipuri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tip` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `folder` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `profesor_id` int(11) NOT NULL,
  `disciplina_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=86 ;

--
-- Dumping data for table `discipline_tipuri`
--

INSERT INTO `discipline_tipuri` (`id`, `tip`, `folder`, `profesor_id`, `disciplina_id`) VALUES
(1, 'curs', 'microprocesoare-i', 123, 144),
(2, 'laborator', 'microprocesoare-i', 123, 144),
(3, 'proiect', 'microprocesoare-i', 123, 144),
(4, 'curs', 'microprocesoare-ii-eng', 123, 146),
(5, 'laborator', 'microprocesoare-ii-eng', 123, 146),
(6, 'proiect', 'microprocesoare-ii-eng', 123, 146),
(63, 'curs', 'microprocesoare-ii', 123, 145),
(64, 'laborator', 'microprocesoare-ii', 123, 145),
(65, 'proiect', 'microprocesoare-ii', 123, 145),
(66, 'curs', 'procesoare-de-semnal', 123, 147),
(67, 'laborator', 'procesoare-de-semnal', 123, 147),
(68, 'proiect', 'procesoare-de-semnal', 123, 147),
(69, 'curs', 'digital-signal-processors', 123, 148),
(70, 'laborator', 'digital-signal-processors', 123, 148),
(71, 'proiect', 'digital-signal-processors', 123, 148),
(72, 'curs', 'analiza-sinteza-si-recunoasterea-semnalului-vocal', 123, 149),
(73, 'laborator', 'analiza-sinteza-si-recunoasterea-semnalului-vocal', 123, 149),
(74, 'proiect', 'analiza-sinteza-si-recunoasterea-semnalului-vocal', 123, 149),
(75, 'curs', 'dsadsadsadsadsadasdsadsa', 123, 150),
(76, 'laborator', 'dsadsadsadsadsadasdsadsa', 123, 150),
(77, 'proiect', 'dsadsadsadsadsadasdsadsa', 123, 150),
(78, 'curs', '', 123, 152),
(79, 'laborator', '', 123, 152),
(80, 'proiect', '', 123, 152),
(81, 'curs', 'microprocesoare-i', 123, 151),
(82, 'laborator', 'microprocesoare-i', 0, 151),
(83, 'proiect', 'microprocesoare-i', 123, 151),
(84, 'curs', 'test', 123, 150),
(85, 'laborator', 'test', 123, 150);

-- --------------------------------------------------------

--
-- Table structure for table `downloads`
--

CREATE TABLE IF NOT EXISTS `downloads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uploader_id` int(11) NOT NULL,
  `discipline_files_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` (`id`, `uploader_id`, `discipline_files_id`, `count`) VALUES
(1, 96, 13, 6),
(2, 96, 12, 8),
(3, 90, 13, 6),
(4, 90, 12, 4),
(5, 7, 12, 2),
(6, 7, 13, 2),
(7, 96, 14, 4),
(8, 3, 14, 3),
(9, 3, 13, 2),
(10, 96, 18, 2),
(11, 96, 21, 2),
(12, 90, 21, 3),
(13, 96, 19, 2),
(14, 90, 22, 2),
(15, 96, 22, 4),
(16, 96, 28, 1),
(17, 97, 28, 2),
(18, 97, 29, 1),
(19, 98, 33, 2),
(20, 96, 37, 1),
(21, 98, 40, 1),
(22, 123, 42, 1),
(23, 123, 45, 1);

-- --------------------------------------------------------

--
-- Table structure for table `facultati`
--

CREATE TABLE IF NOT EXISTS `facultati` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `facultati`
--

INSERT INTO `facultati` (`id`, `nume`, `slug`, `logo`) VALUES
(1, 'Facultatea de Electronica si Telecomunicatii', 'facultatea-de-electronica-si-telecomunicatii', 'ut_logo1.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `fisa_disciplinei`
--

CREATE TABLE IF NOT EXISTS `fisa_disciplinei` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `disciplina_id` int(11) NOT NULL,
  `params` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `fisa_disciplinei`
--

INSERT INTO `fisa_disciplinei` (`id`, `disciplina_id`, `params`) VALUES
(5, 144, '{"instituatia":"UTCN Centru Universitar Nord Baia Mare","facultatea":"Inginerie","departamentul":"Calculatoare","domeniul":"Calculatoare si Tehnologia Informatiei","ciclul":"Licenta","program_studii":"Calculatoare si Tehnologia Informatiei \\/ Inginer\\u00a0","forma_invatamant":"IF \\u2013 invatamant cu frecventa","cod_disciplina":"","dem_disci":"Structuri de date","aria":"Calculatoare si Tehnologia Informatiei","resp_curs":"Sef lucrari dr. ing. Costea Cristinel","resp_lab":"Sef lucrari dr. ing. Costea Cristinel","anul_stud":"I","semes":"2","eval":"Examen","regim":"D","nr_sapt":"14","ore_curs_sapt":"2","ore_aplic_sapt":"2","ore_curs_sem":"28","ore_aplic_sem":"28","stud_ind":"130","total":"130","credite":"5","ore_sapt":"4","ore_aplic_sapt_total":"","ore_aplic_sem_total":"","studiu_curs":"28","documentare":"15","preg_seminarii":"21","tutoriat":"5","examinari":"5","alte_activ":"0","de_curric":"N\\/A","de_compet":"Programarea calculatoarelor (limbajul C)\\u00a0","de_desf_curs":"Tabla, retroproiector\\n\\n            \\n\\n            \\n\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\n          \\n          ","de_desf_aplic":"Calculatoare, Software specific (mediu de programare C)\\u00a0\\n\\n            \\n\\n            \\n\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\n          \\n          ","comp_prof":"Operarea cu fundamente matematice, ingineresti \\u015fi ale informaticii\\u00a0","comp_trans":"N\\/A","obc_gen":"","obc_spec":"","curs1":"","curs2":"","curs3":"","curs4":"","curs5":"","curs6":"","curs7":"","curs8":"","curs9":"","curs10":"","curs11":"","curs12":"","curs13":"","curs14":"","biblio_1":"                        \\n                                            \\n                    ","curs1_2":"","curs2_2":"","curs3_2":"","curs4_2":"","curs5_2":"","curs6_2":"","curs7_2":"","curs8_2":"","curs9_2":"","curs10_2":"","curs11_2":"","curs12_2":"","curs13_2":"","curs14_2":"","biblio_2":"                        \\n                                            \\n                    ","coroborarea":"                       \\n                                             ","criteri_c":"","metode_c":"","ponderea_c":"","criteri_l":"","metode_l":"","ponderea_l":"","standard_perf":""}');

-- --------------------------------------------------------

--
-- Table structure for table `probleme`
--

CREATE TABLE IF NOT EXISTS `probleme` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `disciplina_tip` int(11) NOT NULL,
  `cerinta` text COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `nume` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `probleme`
--

INSERT INTO `probleme` (`id`, `disciplina_tip`, `cerinta`, `file_name`, `nume`) VALUES
(1, 3, 'dadadada', '', 'Analiza, sinteza si recunoasterea semnalului vocal');

-- --------------------------------------------------------

--
-- Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `an_universitar_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `an-universitar` (`an_universitar_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` (`id`, `nume`, `slug`, `an_universitar_id`) VALUES
(3, 'Electronica', 'electronica', 2);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ani_studiu`
--
ALTER TABLE `ani_studiu`
  ADD CONSTRAINT `ani_studiu_ibfk_1` FOREIGN KEY (`profil_id`) REFERENCES `profile` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `ani_universitari`
--
ALTER TABLE `ani_universitari`
  ADD CONSTRAINT `ani_universitari_ibfk_1` FOREIGN KEY (`facultate_id`) REFERENCES `facultati` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `discipline`
--
ALTER TABLE `discipline`
  ADD CONSTRAINT `discipline_ibfk_1` FOREIGN KEY (`an_studiu_id`) REFERENCES `ani_studiu` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `profile`
--
ALTER TABLE `profile`
  ADD CONSTRAINT `profile_ibfk_1` FOREIGN KEY (`an_universitar_id`) REFERENCES `ani_universitari` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

