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
| CREATE TABLE IF NOT EXISTS `site1_accueil` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`titre` varchar(128) COLLATE latin1_german2_ci NOT NULL,
`texte_titre_gras` varchar(4) COLLATE latin1_german2_ci NOT NULL,
`texte_titre_souligne` varchar(4) COLLATE latin1_german2_ci NOT NULL,
`couleur_texte_titre` varchar(20) COLLATE latin1_german2_ci NOT NULL,
`taille_texte_titre` varchar(2) COLLATE latin1_german2_ci NOT NULL,
`police_texte_titre` varchar(30) COLLATE latin1_german2_ci NOT NULL,
`article` longtext COLLATE latin1_german2_ci NOT NULL,
`couleur_texte_article` varchar(20) COLLATE latin1_german2_ci NOT NULL,
`taille_texte_article` varchar(2) COLLATE latin1_german2_ci NOT NULL,
`police_texte_article` varchar(30) COLLATE latin1_german2_ci NOT NULL,
`type_cadre` varchar(3) COLLATE latin1_german2_ci NOT NULL,
`type_separateur` varchar(3) COLLATE latin1_german2_ci NOT NULL,
`lien_titre` varchar(128) COLLATE latin1_german2_ci NOT NULL,
`lien_image` varchar(128) COLLATE latin1_german2_ci NOT NULL,
`espace` varchar(16) COLLATE latin1_german2_ci NOT NULL,
`affiche_titre` enum('yes','no') COLLATE latin1_german2_ci NOT NULL DEFAULT 'yes',
`taille_cadre` varchar(20) COLLATE latin1_german2_ci NOT NULL,
`en_bas` enum('yes','no') COLLATE latin1_german2_ci NOT NULL DEFAULT 'no',
`en_haut` enum('yes','no') COLLATE latin1_german2_ci NOT NULL DEFAULT 'no',
`type_lien_titre` varchar(15) COLLATE latin1_german2_ci NOT NULL DEFAULT '_blank',
`type_lien_image` varchar(15) COLLATE latin1_german2_ci NOT NULL DEFAULT '_blank',
`valid_article` enum('yes','no') COLLATE latin1_german2_ci NOT NULL DEFAULT 'no',
`date_creation` char(40) COLLATE latin1_german2_ci NOT NULL,
`date_modification` char(40) COLLATE latin1_german2_ci NOT NULL,
`centre_titre` char(10) COLLATE latin1_german2_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=1000 ; |
Partager