-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Ven 26 Septembre 2008 à 17:09
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Structure de la table `guestbook`
--

CREATE TABLE IF NOT EXISTS `guestbook` (
  `guestbookID` bigint(20) NOT NULL auto_increment,
  `title` varchar(256) NOT NULL,
  `content` text NOT NULL,
  `author` bigint(20) NOT NULL,
  `dest` bigint(20) NOT NULL COMMENT 'The destinator of the message (0 means anybody)',
  PRIMARY KEY  (`guestbookID`),
  FULLTEXT KEY `title` (`title`,`content`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='The table contains all the comments of the visitors of the s' AUTO_INCREMENT=58 ;

--
-- Contenu de la table `guestbook`
--

INSERT INTO `guestbook` (`guestbookID`, `title`, `content`, `author`, `dest`) VALUES
(1, 'test', 'This is a test', 1, 0),
(2, 'Hello', 'Message Test Test Test', 1, 0),
(3, 'Hi', 'Hi emmanuel', 1, 2),
(4, 'Hie everybody', 'This is a test', 2, 2),
(9, 'emmanuel', 'fdfdfdfd', 2, 2),
(10, 'test', 'test', 1, 2),
(55, 'Hello Benoist', 'Hello User named benoist', 1, 2),
(56, 'Hi Emmanuel', 'Hi', 2, 1),
(57, 'Hi Emmanuel', 'Hi', 2, 1);

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

--
-- Structure de la table `test`
--

CREATE TABLE IF NOT EXISTS `test` (
  `testid` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `content` varchar(200) NOT NULL,
  PRIMARY KEY  (`testid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `test`
--


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

--
-- Structure de la table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `userID` bigint(20) NOT NULL auto_increment COMMENT 'primary key',
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `user`
--

INSERT INTO `user` (`userID`, `username`, `password`) VALUES
(1, 'emmanuel', 'emmanuel'),
(2, 'benoist', 'bcde');
