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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
| --
-- Database: `simon`
--
-- --------------------------------------------------------
--
-- Table structure for table `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`numMenu` tinyint(4) NOT NULL auto_increment,
`tText` longtext NOT NULL,
`tHref` longtext NOT NULL,
`nordre` tinyint(4) NOT NULL,
PRIMARY KEY (`numMenu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `menu`
--
INSERT INTO `menu` (`numMenu`, `tText`, `tHref`, `nordre`) VALUES
(1, 'acceuil', 'http://127.0.0.1/lamsinfo/', 0),
(2, 'textadmin', 'http://127.0.0.1/lamsinfo/textadmin.php', 0);
-- --------------------------------------------------------
--
-- Table structure for table `metadonne`
--
CREATE TABLE IF NOT EXISTS `metadonne` (
`nummd` tinyint(4) NOT NULL auto_increment,
`nPage` tinyint(4) NOT NULL,
`tKeyword` longtext NOT NULL,
`tDescription` longtext NOT NULL,
`tTitle` longtext NOT NULL,
PRIMARY KEY (`nummd`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `metadonne`
--
INSERT INTO `metadonne` (`nummd`, `nPage`, `tKeyword`, `tDescription`, `tTitle`) VALUES
(1, 1, 'test, 'la page daccuil', 'Bienvenue a lamsinfo'),
(2, 2, 'fsdfsdfsd,fdsf,sdfsd,fsd,f', 'page2', 'page 2');
-- --------------------------------------------------------
--
-- Table structure for table `page`
--
CREATE TABLE IF NOT EXISTS `page` (
`numPage` tinyint(4) NOT NULL auto_increment,
`nText` text NOT NULL,
`nMenu` text NOT NULL,
`nordre` tinyint(4) NOT NULL,
`tDescription` longtext NOT NULL,
PRIMARY KEY (`numPage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `page`
--
INSERT INTO `page` (`numPage`, `nText`, `nMenu`, `nordre`, `tDescription`) VALUES
(1, '1,2,3', '1,2,3', 0, 'acceuil'),
(2, '4', '1,2,3', 0, 'simon');
-- --------------------------------------------------------
--
-- Table structure for table `text`
--
CREATE TABLE IF NOT EXISTS `text` (
`numtext` tinyint(4) NOT NULL auto_increment,
`tText` longtext NOT NULL,
`tDescription` longtext NOT NULL,
PRIMARY KEY (`numtext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
--
-- Dumping data for table `text`
--
INSERT INTO `text` (`numtext`, `tText`, `tDescription`) VALUES
(1, 'ceci est lentre 1', 'entre1'),
(2, 'entres 2 2 2 2 2 2 2', 'entre2'),
(3, 'cejkfdahfklfhsdk entre3', 'entre 3'), |
Partager