Biblioteca Java - Rev 9

Subversion Repositories:
Rev:
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

CREATE SCHEMA IF NOT EXISTS `registru_inventar_db` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ;
USE `registru_inventar_db` ;


-- -----------------------------------------------------
-- Table `registru_inventar_db`.`inventar`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `registru_inventar_db`.`Inventar` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `nrCrt` INT NOT NULL ,
  `simbolClasaMijlocFix` VARCHAR(200) NULL ,
  `mijlocFix` VARCHAR(200) NULL ,
  `nrInventar` VARCHAR(20) NULL ,
  `cont` VARCHAR(20) NULL ,
  `cantitate` INT NOT NULL ,
  `UM` VARCHAR(10) NOT NULL ,
  `pret` DECIMAL(12,2) NOT NULL ,
  `valoare` DECIMAL(12,2) NOT NULL ,
  `amortizarePrecedenta` DECIMAL(12,2) NOT NULL ,
  `amortizareCurenta` DECIMAL(12,2) NOT NULL ,
  `amortizareTotala` DECIMAL(12,2) NOT NULL ,
  `valoareRamasa` DECIMAL(12,2) NOT NULL ,
  `durataNormala` INT(5) NOT NULL ,
  `durataRamasa` INT(5) NOT NULL ,
  `anLunaPrimaRata` VARCHAR(10) NULL ,
  `anLunaAdaugare` VARCHAR(10) NULL ,
  `deleted` TINYINT NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;