Biblioteca Java - Blame information for rev 9

Subversion Repositories:
Rev:
Rev Author Line No. Line
9 mihai 1 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4  
5 CREATE SCHEMA IF NOT EXISTS `registru_inventar_db` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ;
6 USE `registru_inventar_db` ;
7  
8  
9 -- -----------------------------------------------------
10 -- Table `registru_inventar_db`.`inventar`
11 -- -----------------------------------------------------
12 CREATE  TABLE IF NOT EXISTS `registru_inventar_db`.`Inventar` (
13   `id` INT NOT NULL AUTO_INCREMENT ,
14   `nrCrt` INT NOT NULL ,
15   `simbolClasaMijlocFix` VARCHAR(200) NULL ,
16   `mijlocFix` VARCHAR(200) NULL ,
17   `nrInventar` VARCHAR(20) NULL ,
18   `cont` VARCHAR(20) NULL ,
19   `cantitate` INT NOT NULL ,
20   `UM` VARCHAR(10) NOT NULL ,
21   `pret` DECIMAL(12,2) NOT NULL ,
22   `valoare` DECIMAL(12,2) NOT NULL ,
23   `amortizarePrecedenta` DECIMAL(12,2) NOT NULL ,
24   `amortizareCurenta` DECIMAL(12,2) NOT NULL ,
25   `amortizareTotala` DECIMAL(12,2) NOT NULL ,
26   `valoareRamasa` DECIMAL(12,2) NOT NULL ,
27   `durataNormala` INT(5) NOT NULL ,
28   `durataRamasa` INT(5) NOT NULL ,
29   `anLunaPrimaRata` VARCHAR(10) NULL ,
30   `anLunaAdaugare` VARCHAR(10) NULL ,
31   `deleted` TINYINT NOT NULL,
32   PRIMARY KEY (`id`))
33 ENGINE = InnoDB;
34  
35  
36 SET SQL_MODE=@OLD_SQL_MODE;
37 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
38 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;