-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Gazda: localhost
-- Timp de generare: 21 Mai 2013 la 16:37
-- Versiune server: 5.5.8
-- Versiune PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Baza de date: `lab_221_2`
--

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

--
-- Structura de tabel pentru tabelul `materii`
--

CREATE TABLE IF NOT EXISTS `materii` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `denumire` varchar(50) NOT NULL,
  `credite` int(50) NOT NULL,
  `profesor` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Salvarea datelor din tabel `materii`
--

INSERT INTO `materii` (`id`, `denumire`, `credite`, `profesor`) VALUES
(1, 'POO', 30, 'Breazu'),
(2, 'WEB', 5, 'Cretulescu'),
(3, 'IPC', 4, 'Morariu');

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

--
-- Structura de tabel pentru tabelul `note`
--

CREATE TABLE IF NOT EXISTS `note` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `id_student` int(50) NOT NULL,
  `id_materie` int(50) NOT NULL,
  `nota` int(50) NOT NULL,
  `data` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Salvarea datelor din tabel `note`
--

INSERT INTO `note` (`id`, `id_student`, `id_materie`, `nota`, `data`) VALUES
(2, 2, 2, 10, '2013-05-12'),
(3, 1, 2, 10, '2013-05-12'),
(4, 3, 3, 10, '2013-05-13');

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

--
-- Structura de tabel pentru tabelul `studenti`
--

CREATE TABLE IF NOT EXISTS `studenti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(50) NOT NULL,
  `prenume` varchar(50) NOT NULL,
  `sgrupa` varchar(5) NOT NULL,
  `email` varchar(100) NOT NULL,
  `data_n` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Salvarea datelor din tabel `studenti`
--

INSERT INTO `studenti` (`id`, `nume`, `prenume`, `sgrupa`, `email`, `data_n`) VALUES
(1, 'Popa', 'Florian', '221_2', 'popa@yahoo.com', '1992-02-16'),
(2, 'Gaja', 'Adina', '221_2', 'gaja@yahoo.com', '1992-04-14'),
(3, 'Popescu', 'Ion', '221_3', 'popescu@yahoo.com', '1993-05-11');
