-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Sam 09 Juillet 2016 à 02:03
-- Version du serveur :  5.6.17
-- Version de PHP :  5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données :  `astrologbdd`
--

-- --------------------------------------------------------

--
-- Structure de la table `bases`
--

CREATE TABLE IF NOT EXISTS `bases` (
  `idz` smallint(6) NOT NULL DEFAULT '0',
  `nom` tinytext NOT NULL,
  `refbase` tinytext NOT NULL,
  `masque` tinytext NOT NULL,
  `ordre` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idz`),
  KEY `ordre` (`ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `bases`
--

INSERT INTO `bases` (`idz`, `nom`, `refbase`, `masque`, `ordre`) VALUES
(1, 'modepass', 'MOTS DE PASSE', '', 1),
(3, 'rubriques', 'MENU', '', 6),
(2, 'structures', 'STRUCTURE CHAMPS', '', 3),
(4, 'bases', 'BASES', '', 2),
(5, 'genrechamps', 'CHAMPS FORMULAIRE', '', 4),
(6, 'niveau', 'NIVEAU MENU', '', 7),
(7, 'typechamps', 'VERIFICATION', '', 5),
(8, 'bibliotheque', 'MEDIATHEQUE', '', 8),
(9, 'elements', 'ELEMENTS', '	', 9),
(10, 'series', 'SERIES', '', 10);

-- --------------------------------------------------------

--
-- Structure de la table `bibliotheque`
--

CREATE TABLE IF NOT EXISTS `bibliotheque` (
  `idz` smallint(6) NOT NULL DEFAULT '0',
  `nom` tinytext NOT NULL,
  `imagemedia` tinytext NOT NULL,
  PRIMARY KEY (`idz`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `idz` tinyint(4) NOT NULL,
  `nom` tinytext NOT NULL,
  PRIMARY KEY (`idz`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `categories`
--

INSERT INTO `categories` (`idz`, `nom`) VALUES
(1, 'Dîner conférence'),
(2, 'Cours'),
(3, 'Conférence'),
(4, 'Ateliers');

-- --------------------------------------------------------

--
-- Structure de la table `elements`
--

CREATE TABLE IF NOT EXISTS `elements` (
  `idz` int(11) NOT NULL,
  `nom` tinytext NOT NULL,
  `image` tinytext NOT NULL,
  `serie` smallint(6) NOT NULL,
  `largeur` smallint(6) NOT NULL,
  `hauteur` smallint(6) NOT NULL,
  `adresse` text NOT NULL,
  `ordre` int(11) NOT NULL,
  `nouveau` tinyint(4) NOT NULL,
  PRIMARY KEY (`idz`),
  KEY `nouveau` (`nouveau`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `elements`
--

INSERT INTO `elements` (`idz`, `nom`, `image`, `serie`, `largeur`, `hauteur`, `adresse`, `ordre`, `nouveau`) VALUES
(1, '4', 'cartes-janvier-15-132_670.jpg', 1, 0, 0, '', 4, 0),
(2, '2', 'diapos184b_670.jpg', 1, 0, 0, '', 2, 0),
(3, '1', 'cartes-janvier-15-130_670.jpg', 1, 0, 0, '', 1, 1),
(4, '3', 'cartes-janvier-15-115_670.jpg', 1, 0, 0, '', 3, 0),
(5, 'a', 'carte-janvier-15163_670.jpg', 2, 0, 0, '', 5, 0),
(6, 'b', 'carte-janvier-15164_670.jpg', 2, 0, 0, '', 6, 0),
(7, 'c', 'carte-janvier-15166_670.jpg', 2, 0, 0, '', 7, 1),
(8, 'd', 'carte-janvier-15167_670.jpg', 2, 0, 0, '', 8, 0),
(9, 'e', 'carte-janvier-15168_670.jpg', 2, 0, 0, '', 9, 0),
(10, 'f', 'carte-janvier-15169_670.jpg', 2, 0, 0, '', 10, 0),
(11, 'planche01', 'Planche1.jpg', 3, 0, 0, '', 11, 1),
(12, 'planche02', 'Planche2.jpg', 3, 0, 0, '', 12, 0),
(13, 'planche03', 'Planche3.jpg', 3, 0, 0, '', 13, 0),
(14, 'planche14', 'Planche14.jpg', 3, 0, 0, '', 14, 1);

-- --------------------------------------------------------

--
-- Structure de la table `genrechamps`
--

CREATE TABLE IF NOT EXISTS `genrechamps` (
  `idz` smallint(6) NOT NULL DEFAULT '0',
  `nom` tinytext NOT NULL,
  `ordre` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idz`),
  KEY `ordre` (`ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `genrechamps`
--

INSERT INTO `genrechamps` (`idz`, `nom`, `ordre`) VALUES
(2, 'Texte normal', 1),
(6, 'Mot de passe', 6),
(1, 'Menu déroulant', 4),
(3, 'Texte avancé', 2),
(8, 'Champs multiples', 8),
(7, 'Fichier', 7),
(9, 'Menu oui/non', 5),
(4, 'Date maj', 11),
(11, 'Champ masqué', 9),
(5, 'Auteur', 14),
(10, 'Numéro d''ordre', 13),
(12, 'Date jour', 10),
(13, 'Date à saisir', 12),
(14, 'Texte htlm', 3);

-- --------------------------------------------------------

--
-- Structure de la table `masque`
--

CREATE TABLE IF NOT EXISTS `masque` (
  `idz` smallint(6) NOT NULL,
  `nom` tinytext NOT NULL,
  `ordre` smallint(6) NOT NULL,
  PRIMARY KEY (`idz`),
  KEY `ordre` (`ordre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `masque`
--

INSERT INTO `masque` (`idz`, `nom`, `ordre`) VALUES
(1, 'Classique', 1);

-- --------------------------------------------------------

--
-- Structure de la table `modepass`
--

CREATE TABLE IF NOT EXISTS `modepass` (
  `idz` smallint(6) NOT NULL DEFAULT '0',
  `identifiant` tinytext NOT NULL,
  `modepass` tinytext NOT NULL,
  `codepass` tinytext NOT NULL,
  `ordrepass` tinyint(4) NOT NULL DEFAULT '0',
  `nommodif` tinytext NOT NULL,
  PRIMARY KEY (`idz`),
  KEY `ordrepass` (`ordrepass`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `modepass`
--

INSERT INTO `modepass` (`idz`, `identifiant`, `modepass`, `codepass`, `ordrepass`, `nommodif`) VALUES
(2, 'noemielothe', 'pinceau28!', '577a8bb05c0a2', 0, 'adminz'),
(1, 'adminz', 'ub40b52s', '578021f13f015', 1, 'adminz');

-- --------------------------------------------------------

--
-- Structure de la table `niveau`
--

CREATE TABLE IF NOT EXISTS `niveau` (
  `idz` tinyint(4) NOT NULL DEFAULT '0',
  `nom` tinytext NOT NULL,
  `ordre` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idz`),
  KEY `ordre` (`ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `niveau`
--

INSERT INTO `niveau` (`idz`, `nom`, `ordre`) VALUES
(1, 'Bouton', 1),
(2, 'Niveau 1', 2),
(3, 'Niveau 2', 3),
(4, 'Niveau 3', 4);

-- --------------------------------------------------------

--
-- Structure de la table `parcours`
--

CREATE TABLE IF NOT EXISTS `parcours` (
  `idparcours` bigint(20) NOT NULL,
  `element` int(11) NOT NULL,
  `serie` smallint(6) NOT NULL,
  KEY `idparcours` (`idparcours`),
  KEY `element` (`element`),
  KEY `serie` (`serie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `parcours`
--

INSERT INTO `parcours` (`idparcours`, `element`, `serie`) VALUES
(234399717, 5, 2),
(234399717, 9, 2),
(234399717, 10, 2),
(234399717, 6, 2),
(57072923, 6, 2),
(57072923, 7, 2),
(57072923, 8, 2),
(57072923, 1, 1),
(57072923, 9, 2),
(75903191, 9, 2),
(75903191, 3, 1),
(75903191, 4, 1),
(75903191, 2, 1),
(75903191, 1, 1),
(75903191, 14, 3);

-- --------------------------------------------------------

--
-- Structure de la table `parcourseries`
--

CREATE TABLE IF NOT EXISTS `parcourseries` (
  `parcours` bigint(20) NOT NULL,
  `serie` smallint(6) NOT NULL,
  KEY `parcours` (`parcours`),
  KEY `serie` (`serie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `parcourseries`
--

INSERT INTO `parcourseries` (`parcours`, `serie`) VALUES
(1, 2),
(226275367, 1),
(193524874, 1),
(265285743, 1),
(215476647, 1),
(215476647, 2),
(106375829, 1),
(22989463, 1),
(22989463, 2),
(156353655, 1),
(215940655, 2),
(215940655, 1),
(234838415, 1),
(260865017, 1),
(260865017, 2),
(118414715, 2),
(131744385, 1),
(14325178, 3),
(11144617, 2),
(11144617, 1),
(11144617, 2),
(52812491, 3),
(73186638, 2),
(73186638, 3),
(73186638, 1),
(86136666, 1),
(80956655, 1),
(264973593, 2),
(264973593, 2),
(256832370, 3),
(256832370, 2),
(172830140, 3),
(195364031, 3),
(171269387, 1),
(171269387, 2),
(171269387, 3),
(59139866, 2),
(142197208, 1),
(142197208, 3),
(77607364, 1),
(77607364, 3),
(152371627, 2),
(226832176, 1),
(29848338, 1),
(80661377, 2),
(80661377, 1),
(80661377, 1),
(207301679, 2),
(133516050, 3),
(81640011, 1),
(81640011, 2),
(11363966, 1),
(263404404, 1),
(189399426, 1),
(189399426, 3),
(189399426, 3),
(252124803, 1),
(252124803, 2),
(252124803, 3),
(190842067, 1),
(190842067, 3),
(209250510, 2),
(209250510, 3),
(234399717, 2),
(57072923, 2),
(57072923, 3),
(57072923, 3),
(75903191, 3);

-- --------------------------------------------------------

--
-- Structure de la table `rubriques`
--

CREATE TABLE IF NOT EXISTS `rubriques` (
  `idz` smallint(6) NOT NULL DEFAULT '0',
  `nom` tinytext NOT NULL,
  `ordre` smallint(6) NOT NULL DEFAULT '0',
  `niveau` tinyint(4) NOT NULL DEFAULT '0',
  `refparent` smallint(6) NOT NULL DEFAULT '0',
  `nombase` smallint(6) NOT NULL DEFAULT '0',
  `nompage` tinytext NOT NULL,
  `nivauto` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idz`),
  KEY `ordre` (`ordre`),
  KEY `niveau` (`niveau`),
  KEY `refparent` (`refparent`),
  KEY `nombase` (`nombase`),
  KEY `nivauto` (`nivauto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `rubriques`
--

INSERT INTO `rubriques` (`idz`, `nom`, `ordre`, `niveau`, `refparent`, `nombase`, `nompage`, `nivauto`) VALUES
(1, 'ADMINISTRATION', 1004, 1, 0, 0, '#', 0),
(3, 'Mot de passe', 1005, 2, 1, 1, 'base.php', 0),
(4, 'Structure', 1006, 2, 1, 0, '#', 1),
(7, 'Menu', 1009, 3, 4, 3, 'base.php', 1),
(6, 'Champs', 1008, 3, 4, 2, 'base.php', 1),
(5, 'Bases', 1007, 3, 4, 4, 'base.php', 1),
(8, 'Tables liées', 1010, 3, 4, 0, '#', 1),
(9, 'Champs form', 1011, 4, 8, 5, 'base.php', 1),
(10, 'Verification', 1012, 4, 8, 7, 'base.php', 1),
(11, 'Niveau menu', 1013, 4, 8, 6, 'base.php', 1),
(104, 'Series', 2, 2, 102, 10, 'base.php', 0),
(102, 'SERIES', 1, 1, 0, 0, '#	', 0),
(103, 'Eléments', 3, 2, 102, 9, 'base.php	', 0);

-- --------------------------------------------------------

--
-- Structure de la table `series`
--

CREATE TABLE IF NOT EXISTS `series` (
  `idz` smallint(6) NOT NULL,
  `nom` tinytext NOT NULL,
  `lien1` tinytext NOT NULL,
  `lien2` tinytext NOT NULL,
  `masque` smallint(6) NOT NULL,
  `ordre` smallint(6) NOT NULL,
  PRIMARY KEY (`idz`),
  KEY `masque` (`masque`),
  KEY `ordre` (`ordre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `series`
--

INSERT INTO `series` (`idz`, `nom`, `lien1`, `lien2`, `masque`, `ordre`) VALUES
(1, 'Diapos', 'AUTRE ELEMENT', 'AUTRE SERIE', 1, 2),
(2, 'Imago', 'AUTRE ELEMENT', 'AUTRE SERIE', 1, 3),
(3, 'Lascaux', 'AUTRE ELEMENT', 'AUTRE SERIE', 1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `structures`
--

CREATE TABLE IF NOT EXISTS `structures` (
  `idz` mediumint(9) NOT NULL DEFAULT '0',
  `rubriquechamp` smallint(6) NOT NULL DEFAULT '0',
  `nomchamp` tinytext NOT NULL,
  `refchamp` tinytext NOT NULL,
  `typechamp` smallint(6) NOT NULL DEFAULT '0',
  `genrechamp` smallint(6) NOT NULL DEFAULT '0',
  `tablechamp` tinytext NOT NULL,
  `tableciblechamp` tinytext NOT NULL,
  `defautchamp` tinytext NOT NULL,
  `acceschamp` tinytext NOT NULL,
  `textesep` tinytext NOT NULL,
  `taillelistechamp` smallint(6) NOT NULL DEFAULT '0',
  `listechamp` smallint(6) NOT NULL DEFAULT '0',
  `classchamp` smallint(6) NOT NULL DEFAULT '0',
  `ordrechamp` smallint(6) NOT NULL DEFAULT '0',
  `obligchamp` tinyint(4) NOT NULL DEFAULT '0',
  `separchamp` tinyint(4) NOT NULL DEFAULT '0',
  `moteur` tinyint(4) NOT NULL DEFAULT '0',
  `commentaires` tinyint(4) NOT NULL DEFAULT '0',
  `explications` text NOT NULL,
  PRIMARY KEY (`idz`),
  KEY `rubriquechamp` (`rubriquechamp`),
  KEY `typechamp` (`typechamp`),
  KEY `genrechamp` (`genrechamp`),
  KEY `taillelistechamp` (`taillelistechamp`),
  KEY `listechamp` (`listechamp`),
  KEY `classchamp` (`classchamp`),
  KEY `ordrechamp` (`ordrechamp`),
  KEY `obligchamp` (`obligchamp`),
  KEY `separchamp` (`separchamp`),
  KEY `moteur` (`moteur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `structures`
--

INSERT INTO `structures` (`idz`, `rubriquechamp`, `nomchamp`, `refchamp`, `typechamp`, `genrechamp`, `tablechamp`, `tableciblechamp`, `defautchamp`, `acceschamp`, `textesep`, `taillelistechamp`, `listechamp`, `classchamp`, `ordrechamp`, `obligchamp`, `separchamp`, `moteur`, `commentaires`, `explications`) VALUES
(1, 1, 'identifiant', 'IDENTIFIANT', 2, 2, '', '', '', '', 'REFERENCES MOT DE PASSE', 400, 1, 1, 1, 1, 1, 0, 0, ''),
(2, 1, 'modepass', 'MOT DE PASSE', 7, 6, '', '', '', '', '50', 0, 0, 2, 2, 1, 0, 0, 0, ''),
(3, 1, 'codepass', 'CODE D\\''ACCES', 1, 11, '', '', '0', '', '0', 0, 0, 3, 3, 0, 0, 0, 0, ''),
(4, 1, 'ordrepass', 'AUTO', 1, 11, '', '', '0', '', '0', 0, 0, 4, 4, 0, 0, 0, 0, ''),
(5, 1, 'nommodif', 'AUTEUR MODIF.', 1, 5, '', '', '', '', '0', 0, 0, 5, 5, 0, 0, 0, 0, ''),
(45, 9, 'nom', 'NOM', 1, 2, '', '', '', '', '', 150, 1, 2, 44, 1, 0, 0, 0, '	'),
(11, 2, 'tablechamp', 'TABLE SOURCE', 2, 2, '', '', '', '', 'TABLES LIEES', 0, 0, 7, 15, 0, 1, 0, 0, ''),
(7, 2, 'nomchamp', 'NOM CHAMP', 2, 2, '', '', '', '', 'REFERENCES CHAMP', 120, 0, 2, 11, 1, 1, 0, 0, ''),
(8, 2, 'typechamp', 'VERIFICATION', 1, 1, 'typechamps', '', '', '', '0', 130, 3, 5, 13, 1, 0, 0, 0, ''),
(9, 2, 'genrechamp', 'CHAMP ECRAN', 1, 1, 'genrechamps', '', '', '', '0', 130, 2, 4, 14, 1, 0, 0, 0, ''),
(10, 2, 'refchamp', 'TEXTE ECRAN', 1, 2, '', '', '', '', '50', 150, 1, 3, 12, 1, 0, 0, 0, ''),
(12, 2, 'defautchamp', 'VALEUR INITIALE', 1, 2, '', '', '', '', 'DONNEES CONNEXES', 0, 0, 9, 17, 0, 1, 0, 0, ''),
(13, 2, 'acceschamp', 'REPERTOIRE STOCK', 1, 2, '', '', '', '', '50', 0, 0, 10, 18, 0, 0, 0, 0, ''),
(14, 2, 'textesep', 'TEXTE SEPARATEUR', 1, 2, '', '', '', '', '5', 0, 0, 17, 19, 0, 0, 0, 0, ''),
(15, 2, 'taillelistechamp', 'TAILLE LISTE', 3, 2, '', '', '', '', '5', 0, 0, 14, 20, 0, 0, 0, 0, ''),
(16, 2, 'listechamp', 'LISTE', 3, 2, '', '', '', '', '5', 50, 6, 13, 21, 0, 0, 0, 0, ''),
(17, 2, 'classchamp', 'FICHE', 3, 2, '', '', '', '', '5', 50, 5, 12, 22, 1, 0, 0, 0, ''),
(18, 2, 'ordrechamp', 'ORDRE', 3, 10, '', '', '0', '', 'CLASSEMENT', 60, 4, 11, 23, 1, 1, 0, 0, ''),
(19, 2, 'obligchamp', 'OBLIG', 1, 9, '', '', '', '', '0', 50, 7, 6, 24, 0, 0, 0, 0, ''),
(20, 2, 'separchamp', 'SEPARATEUR', 1, 9, '', '', '', '', '0', 0, 0, 16, 26, 0, 0, 0, 0, ''),
(21, 2, 'rubriquechamp', 'BASE LIEE', 1, 1, 'bases', '', '', '', 'BASE DE DONNEES', 0, 0, 1, 10, 1, 1, 1, 0, ''),
(24, 3, 'nom', 'NOM', 1, 2, 'rubriques', '', '', '', 'TEXTE AFFICHE', 150, 1, 1, 33, 1, 1, 0, 0, ''),
(25, 3, 'ordre', 'ORDRE', 3, 10, '', '', '0', '', 'CLASSEMENT', 60, 2, 7, 34, 1, 1, 0, 0, ''),
(26, 3, 'niveau', 'NIVEAU', 1, 1, 'niveau', '', '', '', 'ORGANISATION', 80, 3, 2, 35, 1, 1, 1, 0, ''),
(27, 3, 'refparent', 'PARENT', 1, 1, 'rubriques', '', '', '', '0', 0, 0, 3, 36, 0, 0, 0, 0, ''),
(28, 3, 'nombase', 'BASE LIEE', 1, 1, 'bases', '', '', '', 'INFORMATIONS CONNEXES', 0, 0, 4, 37, 0, 1, 0, 0, ''),
(31, 4, 'nom', 'NOM', 2, 2, '', '', '', '', 'REFERENCES BASE', 150, 1, 1, 6, 1, 1, 0, 0, ''),
(29, 3, 'nompage', 'PAGE LIEE', 1, 2, '', '', '#', '', '50', 100, 0, 5, 38, 1, 0, 0, 0, ''),
(32, 4, 'refbase', 'TITRE', 1, 2, '', '', '', '', '50', 180, 2, 2, 7, 1, 0, 0, 0, ''),
(30, 3, 'nivauto', 'AUTO', 1, 9, '', '', '', '', 'AUTORISATION NECESSAIRE', 50, 6, 6, 39, 0, 1, 0, 0, ''),
(33, 4, 'ordre', 'ORDRE', 3, 10, '', '', '', '', '10', 60, 3, 4, 9, 1, 0, 0, 0, ''),
(34, 5, 'nom', 'NOM', 1, 2, '', '', '', '', 'REFERENCES CHAMP', 250, 1, 1, 29, 1, 1, 0, 0, ''),
(35, 5, 'ordre', 'ORDRE', 3, 10, '', '', '', '', '10', 60, 2, 2, 30, 1, 0, 0, 0, ''),
(36, 6, 'nom', 'NOM', 1, 2, '', '', '', '', 'REFERENCES NIVEAU', 250, 1, 1, 40, 1, 1, 0, 0, ''),
(37, 6, 'ordre', 'ORDRE', 3, 10, '', '', '', '', '10', 60, 2, 2, 41, 1, 0, 0, 0, ''),
(38, 7, 'nom', 'NOM', 1, 2, '', '', '', '', 'REFERENCES VERIFICATION', 250, 1, 1, 31, 1, 1, 0, 0, ''),
(39, 7, 'ordre', 'ORDRE', 3, 10, '', '', '', '', '10', 60, 2, 2, 32, 1, 0, 0, 0, ''),
(22, 2, 'moteur', 'MOTEUR', 1, 9, '', '', '', '', 'INFORMATIONS COMPLEMENTAIRES', 120, 0, 15, 27, 0, 1, 0, 0, ''),
(41, 8, 'nom', 'NOM', 1, 2, '', '', '', '', 'REFERENCES MEDIA', 300, 1, 1, 42, 1, 1, 0, 0, ''),
(42, 8, 'imagemedia', 'IMAGE', 1, 7, '', '', '', '../repmedias/', '', 60, 2, 2, 43, 1, 0, 0, 0, ''),
(23, 2, 'tableciblechamp', 'TABLE CIBLE', 1, 2, '', '', '', '', '0', 0, 0, 8, 16, 0, 0, 0, 0, ''),
(40, 4, 'masque', 'MASQUE', 1, 2, '', '', '', '', '', 0, 0, 3, 8, 0, 0, 0, 0, ''),
(43, 2, 'commentaires', 'VALIDATION', 1, 9, '', '', '', '', 'PAGE COMMENTAIRES', 0, 0, 19, 25, 0, 1, 0, 0, ''),
(44, 2, 'explications', 'TEXTE AIDE', 1, 2, '', '', '', '', '', 0, 0, 18, 28, 0, 0, 0, 0, ''),
(46, 9, 'image', 'PHOTO', 1, 7, '', '', '', '../repmedias/', 'INFOS IMAGE (JPG, PNG)', 80, 3, 5, 45, 0, 1, 0, 0, ''),
(47, 9, 'serie', 'SERIE', 1, 1, 'series', '', '', '', 'INFOS GENERALES', 150, 2, 1, 46, 1, 1, 1, 1, ''),
(48, 10, 'nom', 'NOM', 1, 2, '', '', '', '', 'INFOS SERIE', 300, 1, 1, 47, 1, 1, 0, 0, ''),
(49, 10, 'lien1', 'LIEN ELEMENT', 1, 11, '', '', 'AUTRE ELEMENT', '', '', 0, 0, 3, 48, 1, 0, 0, 0, ''),
(50, 10, 'lien2', 'LIEN PARCOURS', 1, 11, '', '', 'AUTRE SERIE', '', '', 0, 0, 4, 49, 1, 0, 0, 0, ''),
(51, 10, 'masque', 'MASQUE', 1, 1, 'masque', '', '', '', '', 100, 2, 2, 50, 1, 0, 0, 0, ''),
(52, 9, 'largeur', 'LARGEUR', 3, 2, '', '', '', '', 'INFOS VIMEO', 0, 0, 6, 52, 0, 1, 0, 0, ''),
(53, 9, 'hauteur', 'HAUTEUR', 3, 2, '', '', '', '', '', 0, 0, 7, 53, 0, 0, 0, 0, ''),
(54, 9, 'adresse', 'LIEN', 1, 2, '', '', '', '', '', 0, 0, 8, 54, 0, 0, 0, 0, ''),
(55, 10, 'ordre', 'CLASSEMENT', 3, 10, '', '', '', '', '', 110, 3, 5, 51, 1, 0, 0, 0, ''),
(56, 9, 'ordre', 'CLASSEMENT', 3, 10, '', '', '', '', '', 110, 4, 3, 55, 1, 0, 0, 0, ''),
(57, 9, 'nouveau', 'NOUVEAU', 1, 9, '', '', '', '', '', 80, 5, 4, 56, 1, 0, 0, 0, '');

-- --------------------------------------------------------

--
-- Structure de la table `typechamps`
--

CREATE TABLE IF NOT EXISTS `typechamps` (
  `idz` smallint(6) NOT NULL DEFAULT '0',
  `nom` tinytext NOT NULL,
  `ordre` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idz`),
  KEY `ordre` (`ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `typechamps`
--

INSERT INTO `typechamps` (`idz`, `nom`, `ordre`) VALUES
(1, 'Sans', 1),
(4, 'Date', 4),
(3, 'Nombre', 3),
(5, 'Adresse e-mail', 5),
(6, 'Téléphone', 6),
(2, 'Sans Car. Spec.', 2),
(7, 'Mot de passe', 7);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
