-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mar 25 Janvier 2011 à 11:57
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Doublure de structure pour la vue `get_users_files`
--
CREATE TABLE IF NOT EXISTS `get_users_files` (
`id` bigint(25)
,`name` varchar(90)
,`surname` varchar(90)
,`path` varchar(125)
,`mime` varchar(15)
,`comment` text
);
-- --------------------------------------------------------

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(25) NOT NULL AUTO_INCREMENT,
  `surname` varchar(90) NOT NULL,
  `name` varchar(90) NOT NULL,
  `password` varchar(45) NOT NULL,
  `birthday` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `surname`, `name`, `password`, `birthday`) VALUES
(1, 'Dubois', 'Charles', 'charles', '2011-01-25'),
(2, 'Dupont', 'Herbert', 'herbefolle', '2011-01-19'),
(3, 'Dutronc', 'Peter', 'peteroxxorz', '2011-01-16');

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

--
-- Structure de la table `users_files`
--

CREATE TABLE IF NOT EXISTS `users_files` (
  `id` bigint(25) NOT NULL AUTO_INCREMENT,
  `path` varchar(125) NOT NULL,
  `mime` varchar(15) DEFAULT NULL,
  `comment` text,
  `users_id` bigint(25) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_users_files_users` (`users_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `users_files`
--

INSERT INTO `users_files` (`id`, `path`, `mime`, `comment`, `users_id`) VALUES
(1, '/var/www/mon_site/upload/file1.jpg', 'image/jpeg', 'Un commentaire stupide', 1),
(2, '/var/www/mon_site/upload/file2.jpg', 'image/jpeg', 'Un autre commentaire stupide', 1),
(3, '/var/www/mon_site/upload/file3.png', 'image/png', 'Une image PNG', 3);

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

--
-- Structure de la vue `get_users_files`
--
DROP TABLE IF EXISTS `get_users_files`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `userfiles`.`get_users_files` AS select `u`.`id` AS `id`,`u`.`name` AS `name`,`u`.`surname` AS `surname`,`f`.`path` AS `path`,`f`.`mime` AS `mime`,`f`.`comment` AS `comment` from (`userfiles`.`users` `u` join `userfiles`.`users_files` `f` on((`f`.`users_id` = `u`.`id`)));

--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `users_files`
--
ALTER TABLE `users_files`
  ADD CONSTRAINT `fk_users_files_users` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;