1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| 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';
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `sol`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sol` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `sol` (
`idsol` INT NOT NULL ,
`per_sable` FLOAT NULL ,
`per_argile` FLOAT NULL ,
`per_calcaire` FLOAT NULL ,
`per_autre` FLOAT NULL ,
PRIMARY KEY (`idsol`) )
ENGINE = InnoDB;
SHOW WARNINGS; |