16 lines
421 B
MySQL
16 lines
421 B
MySQL
|
SET NAMES utf8;
|
||
|
|
SET time_zone = '+00:00';
|
||
|
|
SET foreign_key_checks = 0;
|
||
|
|
|
||
|
|
DROP DATABASE IF EXISTS `gestionconges`;
|
||
|
|
CREATE DATABASE `gestionconges` /*!40100 DEFAULT CHARACTER SET utf8 */;
|
||
|
|
USE `gestionconges`;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `conges`;
|
||
|
|
CREATE TABLE `conges` (
|
||
|
|
`datedebut` date NOT NULL,
|
||
|
|
`datefin` date NOT NULL,
|
||
|
|
`nbjours` decimal(10,2) NOT NULL,
|
||
|
|
`type` varchar(10) NOT NULL
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|