# phpMyAdmin MySQL-Dump
# version 2.2.6
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Mar 24, 2003 at 10:51 PM
# Server version: 3.23.49
# PHP Version: 4.2.0
# Database : `kitesurf`
# --------------------------------------------------------

#
# Table structure for table `annotation`
#

DROP TABLE IF EXISTS `annotation`;
CREATE TABLE `annotation` (
  `CODEANNOTATION` varchar(4) NOT NULL default '',
  `TITREFIGURE` varchar(56) NOT NULL default '',
  `NOM` varchar(127) NOT NULL default '',
  `PRENOM` varchar(127) NOT NULL default '',
  `RESUME` text,
  PRIMARY KEY  (`CODEANNOTATION`)
) TYPE=MyISAM;

#
# Dumping data for table `annotation`
#

# --------------------------------------------------------

#
# Table structure for table `articleoupageweb`
#

DROP TABLE IF EXISTS `articleoupageweb`;
CREATE TABLE `articleoupageweb` (
  `CODEARTICLE` varchar(4) NOT NULL default '',
  `DATEPARUTION` date default NULL,
  `RESUMEARTICLE` text,
  `TITREARTICLE` varchar(255) default NULL,
  `URL` varchar(128) default NULL,
  PRIMARY KEY  (`CODEARTICLE`)
) TYPE=MyISAM;

#
# Dumping data for table `articleoupageweb`
#

INSERT INTO `articleoupageweb` (`CODEARTICLE`, `DATEPARUTION`, `RESUMEARTICLE`, `TITREARTICLE`, `URL`) VALUES ('sit1', NULL, 'Des figures de funboard avec videos et photos', 'Le musée des figures', 'http://www.continentseven.com/museum.html'),
('Art2', NULL, NULL, 'Surf Mag en allemand', 'http://www.surf-magazin.de/_events/kite/events_kite_koa.htm'),
('art3', NULL, NULL, 'Funboard Magazine', 'http://www.funboardmag.com/');
# --------------------------------------------------------

#
# Table structure for table `articleparlede`
#

DROP TABLE IF EXISTS `articleparlede`;
CREATE TABLE `articleparlede` (
  `CODEARTICLE` varchar(4) NOT NULL default '',
  `TITREFIGURE` varchar(56) NOT NULL default '',
  PRIMARY KEY  (`CODEARTICLE`,`TITREFIGURE`)
) TYPE=MyISAM;

#
# Dumping data for table `articleparlede`
#

# --------------------------------------------------------

#
# Table structure for table `ecritpar`
#

DROP TABLE IF EXISTS `ecritpar`;
CREATE TABLE `ecritpar` (
  `CODEARTICLE` varchar(4) NOT NULL default '',
  `NOM` varchar(127) NOT NULL default '',
  `PRENOM` varchar(127) NOT NULL default '',
  PRIMARY KEY  (`CODEARTICLE`,`NOM`,`PRENOM`)
) TYPE=MyISAM;

#
# Dumping data for table `ecritpar`
#

# --------------------------------------------------------

#
# Table structure for table `est_sur`
#

DROP TABLE IF EXISTS `est_sur`;
CREATE TABLE `est_sur` (
  `NOM` varchar(127) NOT NULL default '',
  `PRENOM` varchar(127) NOT NULL default '',
  `CODEPHOTO` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`NOM`,`PRENOM`,`CODEPHOTO`)
) TYPE=MyISAM;

#
# Dumping data for table `est_sur`
#

# --------------------------------------------------------

#
# Table structure for table `figure`
#

DROP TABLE IF EXISTS `figure`;
CREATE TABLE `figure` (
  `TITREFIGURE` varchar(56) NOT NULL default '',
  `NOMLONG` varchar(64) default NULL,
  `TYPEFIGURE` varchar(63) default NULL,
  PRIMARY KEY  (`TITREFIGURE`)
) TYPE=MyISAM;

#
# Dumping data for table `figure`
#

INSERT INTO `figure` (`TITREFIGURE`, `NOMLONG`, `TYPEFIGURE`) VALUES ('lolly pock', NULL, 'freestyle'),
('spock', NULL, 'freestyle'),
('duck jibe', NULL, 'freestyle'),
('helicopter', NULL, 'freestyle'),
('big mack tack', NULL, 'freestyle'),
('air jibe', NULL, 'freestyle'),
('360 une main', NULL, 'freestyle'),
('jibe', NULL, 'basiques'),
('virement de bord', NULL, 'basiques'),
('front loop', NULL, 'sauts'),
('push loop', NULL, 'sauts'),
('table front', NULL, 'sauts'),
('speed loop', NULL, 'sauts'),
('forward loop', NULL, 'sauts'),
('table top', NULL, 'sauts'),
('360 off the lip', NULL, 'surf'),
('surf frontside', NULL, 'surf'),
('crail', NULL, 'grabs'),
('method', NULL, 'grabs'),
('mute', NULL, 'grabs'),
('indy', NULL, 'grabs'),
('stalefish', NULL, 'grabs'),
('roast beef', NULL, 'grabs'),
('tailfish', NULL, 'grabs'),
('tindy', NULL, 'grabs'),
('one hand', NULL, 'sauts'),
('dead man', NULL, 'sauts'),
('360', NULL, 'sauts'),
('drumroll', 'drumroll', 'sauts'),
('aerialoffthelip', 'aerial off the lip', 'surf');
# --------------------------------------------------------

#
# Table structure for table `parudans`
#

DROP TABLE IF EXISTS `parudans`;
CREATE TABLE `parudans` (
  `CODEARTICLE` varchar(4) NOT NULL default '',
  `EDITEUR` varchar(127) NOT NULL default '',
  PRIMARY KEY  (`CODEARTICLE`,`EDITEUR`)
) TYPE=MyISAM;

#
# Dumping data for table `parudans`
#

# --------------------------------------------------------

#
# Table structure for table `perespirituel`
#

DROP TABLE IF EXISTS `perespirituel`;
CREATE TABLE `perespirituel` (
  `TITREFIGURE` varchar(56) NOT NULL default '',
  `NOM` varchar(127) NOT NULL default '',
  `PRENOM` varchar(127) NOT NULL default '',
  PRIMARY KEY  (`TITREFIGURE`,`NOM`,`PRENOM`)
) TYPE=MyISAM;

#
# Dumping data for table `perespirituel`
#

# --------------------------------------------------------

#
# Table structure for table `personne`
#

DROP TABLE IF EXISTS `personne`;
CREATE TABLE `personne` (
  `PRENOM` varchar(127) NOT NULL default '',
  `NOM` varchar(127) NOT NULL default '',
  `EMAIL` varchar(255) default NULL,
  PRIMARY KEY  (`PRENOM`,`NOM`)
) TYPE=MyISAM;

#
# Dumping data for table `personne`
#

INSERT INTO `personne` (`PRENOM`, `NOM`, `EMAIL`) VALUES ('Jason', 'Polakow', ''),
('Pierre', 'Wattez', NULL),
('Robert', 'Teritehau', NULL),
('Raphael', 'Salles', NULL),
('Marcus Flash', 'Austin', NULL);
# --------------------------------------------------------

#
# Table structure for table `photo`
#

DROP TABLE IF EXISTS `photo`;
CREATE TABLE `photo` (
  `CODEPHOTO` varchar(4) NOT NULL default '',
  `FICHIER` varchar(255) default NULL,
  PRIMARY KEY  (`CODEPHOTO`)
) TYPE=MyISAM;

#
# Dumping data for table `photo`
#

INSERT INTO `photo` (`CODEPHOTO`, `FICHIER`) VALUES ('ksji', 'ksjibe.jpg'),
('ksst', 'ksstalefish.jpg'),
('kson', 'ksonehand.jpg'),
('ksde', 'ksdeadman.jpg'),
('ks36', 'ks360.jpg'),
('fbta', 'fbtabletop.jpg'),
('wind', 'wind_2.jpg'),
('watt', 'wattez1.jpg'),
('teri', 'teritehau.jpg'),
('kssa', 'kssalles.jpg'),
('ksfl', 'ksflash.jpg'),
('Rale', 'Raley-tabletop.jpg'),
('chib', 'chibtable.jpg'),
('ersh', 'ersh-table.jpg'),
('DJ01', 'DJ01.jpg'),
('vida', 'vidarduckjibe.jpg'),
('bern', 'berndforwardb.jpg'),
('drum', 'drumroll.jpg'),
('aeri', 'aerialOff.jpg'),
('loll', 'lollypop540.jpg'),
('spoc', 'spock.jpg'),
('josh', 'joshohspock.jpg');
# --------------------------------------------------------

#
# Table structure for table `photoparlede`
#

DROP TABLE IF EXISTS `photoparlede`;
CREATE TABLE `photoparlede` (
  `CODEPHOTO` varchar(4) NOT NULL default '',
  `TITREFIGURE` varchar(56) NOT NULL default '',
  PRIMARY KEY  (`CODEPHOTO`,`TITREFIGURE`)
) TYPE=MyISAM;

#
# Dumping data for table `photoparlede`
#

INSERT INTO `photoparlede` (`CODEPHOTO`, `TITREFIGURE`) VALUES ('aeri', 'aerialoffthelip'),
('bern', 'front loop'),
('chib', 'table top'),
('DJ01', 'duck jibe'),
('drum', 'drumroll'),
('ersh', 'table top'),
('fbta', 'table top'),
('josh', 'spock'),
('ks36', '360'),
('ksde', 'dead man'),
('ksji', 'jibe'),
('kson', 'one hand'),
('ksst', 'stalefish'),
('loll', 'lolly pock'),
('Rale', 'table top'),
('spoc', 'spock'),
('vida', 'duck jibe');
# --------------------------------------------------------

#
# Table structure for table `revue`
#

DROP TABLE IF EXISTS `revue`;
CREATE TABLE `revue` (
  `EDITEUR` varchar(127) NOT NULL default '',
  `TITREREVUE` varchar(255) default NULL,
  PRIMARY KEY  (`EDITEUR`)
) TYPE=MyISAM;

#
# Dumping data for table `revue`
#