-- http://www.phpmyadmin.net
--
-- Serveur: ensabahnur.sql.free.fr
-- Généré le : Dim 05 Juin 2011 à 12:59
-- Version du serveur: 5.0.83
-- Version de PHP: 5.2.9


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

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

--
-- Structure de la table `3s_chars`
--

CREATE TABLE IF NOT EXISTS `3s_chars` (
  `id_char` int(11) NOT NULL auto_increment,
  `charName` varchar(30) collate utf8_unicode_ci NOT NULL,
  `charJapName` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id_char`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;

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

--
-- Structure de la table `3s_j_players`
--

CREATE TABLE IF NOT EXISTS `3s_j_players` (
  `id_player` int(11) NOT NULL auto_increment,
  `charPlayed` int(11) NOT NULL,
  `japName` varchar(255) collate utf8_unicode_ci default NULL,
  `occName` varchar(255) collate utf8_unicode_ci default NULL,
  `comment` varchar(8000) collate utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY  (`id_player`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=848 ;

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

--
-- Structure de la table `characters`
--

CREATE TABLE IF NOT EXISTS `characters` (
  `CharacterNum` int(4) NOT NULL auto_increment,
  `CharacterName` varchar(150) NOT NULL default '',
  `CharacterGameNum` int(4) NOT NULL default '0',
  `CharacterImage` varchar(50) NOT NULL default '',
  `CharacterFace` varchar(50) NOT NULL default '',
  `CharacterHeight` varchar(100) NOT NULL default '',
  `CharacterWeight` varchar(100) NOT NULL default '',
  `CharacterSex` enum('M','F','?') NOT NULL default 'M',
  PRIMARY KEY  (`CharacterNum`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

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

--
-- Structure de la table `combos`
--

CREATE TABLE IF NOT EXISTS `combos` (
  `numCombos` int(11) NOT NULL auto_increment,
  `numChar` varchar(255) NOT NULL default '0',
  `combo` text NOT NULL,
  `type` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`numCombos`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

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

--
-- Structure de la table `FLV_Viewer`
--

CREATE TABLE IF NOT EXISTS `FLV_Viewer` (
  `Id_view` int(11) NOT NULL auto_increment,
  `Video_Name` varchar(255) collate latin1_general_ci NOT NULL,
  `Date` datetime NOT NULL,
  `Ip` varchar(255) collate latin1_general_ci NOT NULL,
  `Ip_Origin` varchar(255) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`Id_view`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3758 ;

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

--
-- Structure de la table `game`
--

CREATE TABLE IF NOT EXISTS `game` (
  `GameNum` int(4) NOT NULL auto_increment,
  `GameName` varchar(150) NOT NULL default '',
  `gameActive` enum('0','1') NOT NULL default '0',
  `GameYear` year(4) NOT NULL default '0000',
  `GameSystem` varchar(50) NOT NULL default '',
  `GameEditor` varchar(100) NOT NULL default '',
  `GameImage` varchar(100) NOT NULL default '',
  `GameNumberChar` int(4) NOT NULL default '0',
  PRIMARY KEY  (`GameNum`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

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

--
-- Structure de la table `generalData`
--

CREATE TABLE IF NOT EXISTS `generalData` (
  `genData_Id` int(11) NOT NULL auto_increment,
  `characterName` varchar(50) NOT NULL,
  `dataType` varchar(50) NOT NULL,
  `col1` varchar(255) NOT NULL,
  `col2` varchar(255) NOT NULL,
  `col3` varchar(255) NOT NULL,
  `col4` varchar(255) NOT NULL,
  `col5` varchar(255) NOT NULL,
  `col6` varchar(255) NOT NULL,
  `col7` varchar(255) NOT NULL,
  PRIMARY KEY  (`genData_Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;

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

--
-- Structure de la table `matrix_colors_pixels`
--

CREATE TABLE IF NOT EXISTS `matrix_colors_pixels` (
  `idMatrix` int(11) NOT NULL auto_increment,
  `idrPalette` int(11) NOT NULL,
  `colorInt` int(11) NOT NULL,
  `colorRgb6o` varchar(6) NOT NULL,
  `colorRgb4o` varchar(4) NOT NULL,
  `nbPixelsForColor` int(11) NOT NULL,
  `referencePixels` varchar(50) NOT NULL,
  `serializedPixelsList` mediumtext NOT NULL,
  PRIMARY KEY  (`idMatrix`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=108517 ;

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

--
-- Structure de la table `movelibrary`
--

CREATE TABLE IF NOT EXISTS `movelibrary` (
  `MLPattern` varchar(255) NOT NULL default '',
  `MLCorrespondance` varchar(255) NOT NULL default '',
  `Texte` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`MLPattern`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `moves`
--

CREATE TABLE IF NOT EXISTS `moves` (
  `MovesNum` int(4) NOT NULL auto_increment,
  `MovesNumChar` int(4) NOT NULL default '0',
  `MovesName` varchar(200) NOT NULL default '',
  `MovesOtherName` varchar(100) NOT NULL default '',
  `MovesMove` varchar(200) NOT NULL default '',
  `MovesText` text NOT NULL,
  `MovesImage` varchar(255) NOT NULL,
  `MovesFLV` varchar(255) NOT NULL,
  `MoveTypeNum` varchar(4) NOT NULL default 'NM',
  `date_last_modif` datetime NOT NULL,
  `ip` varchar(15) NOT NULL,
  `ip_origine` varchar(255) NOT NULL,
  PRIMARY KEY  (`MovesNum`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=584 ;

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

--
-- Structure de la table `movetype`
--

CREATE TABLE IF NOT EXISTS `movetype` (
  `MoveTypeIndex` int(11) NOT NULL auto_increment,
  `MoveTypeNum` varchar(4) NOT NULL default '',
  `MoveTypeName` varchar(50) NOT NULL default '',
  `MoveTypeGame` int(4) NOT NULL default '0',
  PRIMARY KEY  (`MoveTypeIndex`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

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

--
-- Structure de la table `normals_frames_datas`
--

CREATE TABLE IF NOT EXISTS `normals_frames_datas` (
  `num` int(4) NOT NULL auto_increment,
  `charNum` int(4) NOT NULL default '0',
  `MoveName` varchar(255) NOT NULL default '',
  `StartUp` varchar(255) NOT NULL default '',
  `Hit` varchar(255) NOT NULL default '',
  `Recovery` varchar(255) NOT NULL default '',
  `BlockedAdvantage` varchar(255) NOT NULL default '',
  `HitAdvantage` varchar(255) NOT NULL default '',
  `CrouchingHitAdvantage` varchar(255) NOT NULL default '',
  `Damage` varchar(255) NOT NULL default '',
  `Parry` varchar(255) NOT NULL default '',
  `Stun` varchar(255) NOT NULL default '',
  `ChainsIntoItself` varchar(255) NOT NULL default '',
  `SpecialCancel` varchar(255) NOT NULL default '',
  `SuperCancel` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=616 ;

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

--
-- Structure de la table `notes`
--

CREATE TABLE IF NOT EXISTS `notes` (
  `numNote` int(11) NOT NULL auto_increment,
  `numCharacter` int(4) NOT NULL default '0',
  `titre` varchar(255) NOT NULL default '',
  `auteur` varchar(255) NOT NULL default '',
  `message` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `email` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `ip_origine` varchar(255) NOT NULL default '',
  `updatable` enum('YES','NO') NOT NULL default 'YES',
  PRIMARY KEY  (`numNote`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

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

--
-- Structure de la table `palettes`
--

CREATE TABLE IF NOT EXISTS `palettes` (
  `idPalette` int(11) NOT NULL auto_increment,
  `paletteOwner` varchar(255) NOT NULL,
  `paletteName` varchar(255) NOT NULL,
  `paletteBegin` varchar(6) NOT NULL,
  `paletteEnd` varchar(6) NOT NULL,
  `paletteImageForMatrix` varchar(255) NOT NULL,
  `otherImageMatrix` varchar(255) NOT NULL,
  `verified` enum('Y','N') NOT NULL default 'N',
  `disabled` enum('y','n') NOT NULL default 'n',
  `paletteSpecialType` varchar(255) NOT NULL,
  `paletteLastUpdate` datetime NOT NULL,
  PRIMARY KEY  (`idPalette`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=500 ;

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

--
-- Structure de la table `palettesdb`
--

CREATE TABLE IF NOT EXISTS `palettesdb` (
  `idPaletteColor` int(11) NOT NULL auto_increment,
  `pcCode` varchar(50000) NOT NULL,
  `pcName` varchar(255) NOT NULL,
  `pcChar` varchar(255) NOT NULL,
  `pcImage` varchar(255) NOT NULL,
  `paletteIdr` int(11) NOT NULL,
  `paletteUploader` varchar(255) NOT NULL,
  `previousVersionId` int(11) NOT NULL,
  `disabled` enum('y','n') NOT NULL default 'n',
  `ipUploader` varchar(15) NOT NULL,
  `date` datetime NOT NULL,
  `ipOriginUploader` varchar(255) NOT NULL,
  `comment` varchar(2000) NOT NULL,
  PRIMARY KEY  (`idPaletteColor`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1826 ;

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

--
-- Structure de la table `predefined_set`
--

CREATE TABLE IF NOT EXISTS `predefined_set` (
  `idSet` int(11) NOT NULL auto_increment,
  `ps_name` varchar(1000) NOT NULL,
  `ps_session` text NOT NULL,
  `ps_dateCreation` datetime NOT NULL,
  `ps_ipCreator` varchar(1000) NOT NULL,
  `ps_ipOrigin` varchar(255) NOT NULL,
  PRIMARY KEY  (`idSet`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

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

--
-- Structure de la table `rom51content`
--

CREATE TABLE IF NOT EXISTS `rom51content` (
  `idLine` int(11) NOT NULL auto_increment,
  `address` varchar(6) NOT NULL,
  `00` varchar(2) NOT NULL,
  `01` varchar(2) NOT NULL,
  `02` varchar(2) NOT NULL,
  `03` varchar(2) NOT NULL,
  `04` varchar(2) NOT NULL,
  `05` varchar(2) NOT NULL,
  `06` varchar(2) NOT NULL,
  `07` varchar(2) NOT NULL,
  `08` varchar(2) NOT NULL,
  `09` varchar(2) NOT NULL,
  `0A` varchar(2) NOT NULL,
  `0B` varchar(2) NOT NULL,
  `0C` varchar(2) NOT NULL,
  `0D` varchar(2) NOT NULL,
  `0E` varchar(2) NOT NULL,
  `0F` varchar(2) NOT NULL,
  PRIMARY KEY  (`idLine`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=495492 ;

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

--
-- Structure de la table `specials_frames_datas`
--

CREATE TABLE IF NOT EXISTS `specials_frames_datas` (
  `num` int(4) NOT NULL auto_increment,
  `charNum` int(4) NOT NULL default '0',
  `MoveName` varchar(255) NOT NULL default '',
  `Motion` varchar(255) NOT NULL default '',
  `StartUp` varchar(255) NOT NULL default '',
  `Hit` varchar(255) NOT NULL default '',
  `Recovery` varchar(255) NOT NULL default '',
  `BlockedAdvantage` varchar(255) NOT NULL default '',
  `Damage` varchar(255) NOT NULL default '',
  `Parry` varchar(255) NOT NULL default '',
  `Stun` varchar(255) NOT NULL default '',
  `SuperCancel` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=482 ;

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

--
-- Structure de la table `supers_frames_datas`
--

CREATE TABLE IF NOT EXISTS `supers_frames_datas` (
  `num` int(4) NOT NULL auto_increment,
  `charNum` int(4) NOT NULL default '0',
  `MoveName` varchar(255) NOT NULL default '',
  `Motion` varchar(255) NOT NULL default '',
  `StartUp` varchar(255) NOT NULL default '',
  `Hit` varchar(255) NOT NULL default '',
  `Recovery` varchar(255) NOT NULL default '',
  `BlockedAdvantage` varchar(255) NOT NULL default '',
  `Damage` varchar(255) NOT NULL default '',
  `Parry` varchar(255) NOT NULL default '',
  `Stun` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=336 ;

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

--
-- Structure de la table `turnaround`
--

CREATE TABLE IF NOT EXISTS `turnaround` (
  `idTurnaround` int(11) NOT NULL auto_increment,
  `ip` varchar(255) collate latin1_general_ci NOT NULL,
  `palette` int(11) NOT NULL,
  `paletteDb` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `palmodCode` varchar(20000) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`idTurnaround`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=153 ;

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

--
-- Structure de la table `yun_geneijin_normals_fd`
--

CREATE TABLE IF NOT EXISTS `yun_geneijin_normals_fd` (
  `num` int(4) NOT NULL auto_increment,
  `charNum` int(4) NOT NULL default '0',
  `MoveName` varchar(255) NOT NULL default '',
  `StartUp` varchar(255) NOT NULL default '',
  `Hit` varchar(255) NOT NULL default '',
  `Recovery` varchar(255) NOT NULL default '',
  `Damage` varchar(255) NOT NULL default '',
  `Parry` varchar(255) NOT NULL default '',
  `ChainsIntoItself` varchar(255) NOT NULL default '',
  `SpecialCancel` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=616 ;

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

--
-- Structure de la table `yun_geneijin_specials_fd`
--

CREATE TABLE IF NOT EXISTS `yun_geneijin_specials_fd` (
  `num` int(4) NOT NULL auto_increment,
  `charNum` int(4) NOT NULL default '0',
  `MoveName` varchar(255) NOT NULL default '',
  `Motion` varchar(255) NOT NULL default '',
  `StartUp` varchar(255) NOT NULL default '',
  `Hit` varchar(255) NOT NULL default '',
  `Recovery` varchar(255) NOT NULL default '',
  `Damage` varchar(255) NOT NULL default '',
  `Parry` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=482 ;
