StRbXDjG

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `mydb` ;
7
8-- -----------------------------------------------------
9-- Table `mydb`.`elev`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `mydb`.`elev` (
12  `id` INT(11) NOT NULL AUTO_INCREMENT ,
13  `nume` TEXT NOT NULL ,
14  `parola` TEXT NOT NULL ,
15  `cnp` INT(11) NOT NULL ,
16  `clasa` TEXT NOT NULL ,
17  PRIMARY KEY (`id`) )
18ENGINE = InnoDB
19AUTO_INCREMENT = 4
20DEFAULT CHARACTER SET = latin1;
21
22
23-- -----------------------------------------------------
24-- Table `mydb`.`materie`
25-- -----------------------------------------------------
26CREATE  TABLE IF NOT EXISTS `mydb`.`materie` (
27  `id` INT NOT NULL AUTO_INCREMENT ,
28  `nume` VARCHAR(255) NULL ,
29  PRIMARY KEY (`id`) )
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`elev_has_materie`
35-- -----------------------------------------------------
36CREATE  TABLE IF NOT EXISTS `mydb`.`elev_has_materie` (
37  `elev_id` INT(11) NOT NULL ,
38  `materie_id` INT NOT NULL ,
39  `abs` VARCHAR(45) NULL ,
40  PRIMARY KEY (`elev_id`, `materie_id`) ,
41  INDEX `fk_elev_has_materie_materie1` (`materie_id` ASC) ,
42  INDEX `fk_elev_has_materie_elev` (`elev_id` ASC) ,
43  CONSTRAINT `fk_elev_has_materie_elev`
44    FOREIGN KEY (`elev_id` )
45    REFERENCES `mydb`.`elev` (`id` )
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION,
48  CONSTRAINT `fk_elev_has_materie_materie1`
49    FOREIGN KEY (`materie_id` )
50    REFERENCES `mydb`.`materie` (`id` )
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION)
53ENGINE = InnoDB
54DEFAULT CHARACTER SET = latin1;
55
56
57
58SET SQL_MODE=@OLD_SQL_MODE;
59SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
60SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;