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

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

--
-- Structure de la table `tbl_articles`
--

CREATE TABLE `tbl_articles` (
  `art_id` int(11) NOT NULL auto_increment,
  `art_usr_id` varchar(255) collate latin1_general_ci NOT NULL,
  `art_name` varchar(255) collate latin1_general_ci default NULL,
  `art_detail` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`art_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ;

--
-- Contenu de la table `tbl_articles`
--

INSERT INTO `tbl_articles` (`art_id`, `art_usr_id`, `art_name`, `art_detail`) VALUES
(1, '1', 'velo', 'à jean paul'),
(2, '1', 'moto', 'à jean paul'),
(3, '1', 'voiture', 'à jean paul'),
(4, '1', 'train', 'à jean paul'),
(5, '2', 'vase', 'à flor'),
(6, '2', 'couette', 'à flor'),
(7, '2', 'assiette', 'à flor'),
(8, '3', 'poupée', 'à steph'),
(9, '3', 'puzzle', 'à steph'),
(10, '4', 'serviette', 'à odete'),
(11, '5', 'roue', 'à victor');

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

--
-- Structure de la table `tbl_images`
--

CREATE TABLE `tbl_images` (
  `img_id` int(11) NOT NULL auto_increment,
  `img_art_id` varchar(255) collate latin1_general_ci default NULL,
  `img_usr_id` varchar(255) collate latin1_general_ci default NULL,
  `img_name` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`img_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=21 ;

--
-- Contenu de la table `tbl_images`
--

INSERT INTO `tbl_images` (`img_id`, `img_art_id`, `img_usr_id`, `img_name`) VALUES
(1, '1', '1', 'image1_art1_usr1'),
(2, '1', '1', 'image2_art1_usr1'),
(3, '1', '1', 'image3_art1_usr1'),
(4, '2', '1', 'image1_art2_usr1'),
(5, '2', '1', 'image2_art2_usr1'),
(6, '3', '1', 'image1_art3_usr1'),
(7, '4', '1', 'image1_art4_usr1'),
(8, '4', '1', 'image2_art4_usr1'),
(9, '5', '2', 'image1_art5_usr2'),
(10, '5', '2', 'image2_art5_usr2'),
(11, '5', '2', 'image3_art5_usr2'),
(12, '6', '2', 'image1_art6_usr2'),
(13, '7', '2', 'image1_art7_usr2'),
(14, '7', '2', 'image2_art7_usr2'),
(15, '8', '3', 'image1_art8_usr3'),
(16, '8', '3', 'image2_art8_usr3'),
(17, '9', '3', 'image1_art9_usr3'),
(18, '10', '4', 'image1_art10_usr4'),
(19, '10', '4', 'image2_art10_usr4'),
(20, '11', '5', 'image1_art11_usr5');

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

--
-- Structure de la table `tbl_utilisateurs`
--

CREATE TABLE `tbl_utilisateurs` (
  `usr_id` int(11) NOT NULL auto_increment,
  `usr_name` varchar(255) collate latin1_general_ci default NULL,
  `usr_status` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`usr_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

--
-- Contenu de la table `tbl_utilisateurs`
--

INSERT INTO `tbl_utilisateurs` (`usr_id`, `usr_name`, `usr_status`) VALUES
(1, 'jean paul', '1'),
(2, 'flor', '1'),
(3, 'steph', '1'),
(4, 'odete', '1'),
(5, 'victor', '0');