1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
|
Structure de la table `inscription`
--
CREATE TABLE IF NOT EXISTS `inscription` (
`firstname` varchar(25) NOT NULL,
`lastname` varchar(25) NOT NULL,
`pseudo` varchar(15) NOT NULL,
`email` varchar(50) NOT NULL,
`password` text NOT NULL,
`phone` varchar(50) NOT NULL,
`skype` varchar(25) NOT NULL,
`category` varchar(20) NOT NULL,
`birthday` date NOT NULL,
`inscription` datetime NOT NULL,
`actif` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Structure de la table `project`
--
CREATE TABLE IF NOT EXISTS `project` (
`name` varchar(20) NOT NULL,
`encoDate` date NOT NULL,
`dateStart` date NOT NULL,
`nbrDay` int(5) NOT NULL,
`dateEnd` date NOT NULL,
`depassement` int(5) NOT NULL,
`description` text NOT NULL,
`priority` int(5) NOT NULL,
`affectation` varchar(20) NOT NULL,
`clientName` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Structure de la table `prestation`
--
CREATE TABLE IF NOT EXISTS `prestation` (
`date` date NOT NULL,
`client` varchar(50) COLLATE utf8_bin NOT NULL,
`name` varchar(20) COLLATE utf8_bin NOT NULL,
`tache` varchar(20) COLLATE utf8_bin NOT NULL,
`debut` time NOT NULL,
`fin` time NOT NULL,
`rapport` text COLLATE utf8_bin NOT NULL,
`selection` varchar(50) COLLATE utf8_bin NOT NULL,
`note` varchar(5) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
Partager