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
|
-- Adminer 4.1.0 MySQL dump
SET NAMES utf8;
SET time_zone = '+00:00';
CREATE DATABASE `touslesport.v2` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `touslesport.v2`;
DROP TABLE IF EXISTS `sorties`;
CREATE TABLE `sorties` (
`id_sorties` int(17) NOT NULL AUTO_INCREMENT,
`date_sorties` date NOT NULL,
`HHHtemps_sorties` tinyint(3) unsigned DEFAULT NULL,
`MMtemps_sorties` tinyint(3) unsigned DEFAULT NULL,
`SStemps_sorties` tinyint(3) unsigned DEFAULT NULL,
`moyenne_sorties` decimal(10,0) unsigned DEFAULT NULL,
`poids_sorties` decimal(10,0) unsigned DEFAULT NULL,
`forme_sorties` varchar(45) DEFAULT NULL,
`commentaire_court_sorties` varchar(100) DEFAULT NULL,
`commentaire_long_sorties` text,
`denivsup_sorties` smallint(5) unsigned DEFAULT NULL,
`distsup_sorties` decimal(10,0) unsigned DEFAULT NULL,
`HHsup_sorties` tinyint(3) unsigned DEFAULT NULL,
`MMsup_sorties` tinyint(3) unsigned DEFAULT NULL,
`SSsup_sorties` tinyint(3) unsigned DEFAULT NULL,
`parcours_id_parcours` int(11) DEFAULT NULL,
`velos_id_velos` int(11) DEFAULT NULL,
`multisports_id_multisports` int(11) DEFAULT NULL,
`ordre_sorties` int(11) NOT NULL DEFAULT '1',
`HHHapres_sorties` tinyint(3) unsigned DEFAULT NULL,
`MMapres_sorties` tinyint(3) unsigned DEFAULT NULL,
`SSapres_sorties` tinyint(3) unsigned DEFAULT NULL,
PRIMARY KEY (`id_sorties`),
KEY `id_parcours_idx` (`parcours_id_parcours`),
KEY `iid_velos_idx` (`velos_id_velos`),
KEY `id_multisports_idx` (`multisports_id_multisports`),
CONSTRAINT `sorties_ibfk_1` FOREIGN KEY (`multisports_id_multisports`) REFERENCES `multisports` (`id_multisports`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `sorties_ibfk_2` FOREIGN KEY (`parcours_id_parcours`) REFERENCES `parcours` (`id_parcours`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `sorties_ibfk_3` FOREIGN KEY (`velos_id_velos`) REFERENCES `velos` (`id_velos`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 2017-06-09 12:41:27 |
Partager