Site inachevé // MaNGOS
|
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(100) NOT NULL auto_increment,
`title` text,
`text` text,
`author` text,
`date` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of ip_banned
-- ----------------------------
INSERT INTO `news` VALUES ('1', 'Test', 'Bonjour, si vosu voyez se message cela ve dire que votre site fonctionne bien', 'Quarante-deux', '21/07/2010');
-- ----------------------------
-- Table structure for `vote`
-- ----------------------------
DROP TABLE IF EXISTS `vote`;
CREATE TABLE `vote` (
`id` int(100) NOT NULL auto_increment,
`account` varchar(255) DEFAULT NULL,
`ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
`timestamp0` varchar(255) DEFAULT NULL,
`timestamp1` varchar(255) DEFAULT NULL,
`points` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `suport`
-- ----------------------------
DROP TABLE IF EXISTS `suport`;
CREATE TABLE `suport` (
`id` int(100) NOT NULL auto_increment,
`account_name` varchar(255) DEFAULT NULL,
`perso_name` varchar(255) DEFAULT NULL,
`support_title` varchar(255) DEFAULT NULL,
`support_text` varchar(255) DEFAULT NULL,
`support_etat` varchar(255) DEFAULT NULL,
`time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `suport_answer`
-- ----------------------------
DROP TABLE IF EXISTS `suport_answer`;
CREATE TABLE `suport_answer` (
`id` int(100) NOT NULL auto_increment,
`id_suport` varchar(255) DEFAULT NULL,
`answer` varchar(255) DEFAULT NULL,
`answerby` varchar(255) DEFAULT NULL,
`date` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `account_parain
-- ----------------------------
DROP TABLE IF EXISTS `account_parrain`;
CREATE TABLE `account_parrain` (
`id` int(100) NOT NULL auto_increment,
`account_name` varchar(255) DEFAULT NULL,
`used` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `recup`
-- ----------------------------
DROP TABLE IF EXISTS `recup`;
CREATE TABLE `recup` (
`id` int(100) NOT NULL auto_increment,
`recup_account` varchar(255) DEFAULT NULL,
`recup_serveur` varchar(255) DEFAULT NULL,
`recup_version` varchar(255) DEFAULT NULL,
`recup_name` varchar(255) DEFAULT NULL,
`recup_level` varchar(255) DEFAULT NULL,
`recup_class` varchar(255) DEFAULT NULL,
`recup_race` varchar(255) DEFAULT NULL,
`recup_gender` varchar(255) DEFAULT NULL,
`recup_money` varchar(255) DEFAULT NULL,
`recup_honor` varchar(255) DEFAULT NULL,
`recup_tete` varchar(255) DEFAULT NULL,
`recup_cou` varchar(255) DEFAULT NULL,
`recup_epaule` varchar(255) DEFAULT NULL,
`recup_torse` varchar(255) DEFAULT NULL,
`recup_dos` varchar(255) DEFAULT NULL,
`recup_chemise` varchar(255) DEFAULT NULL,
`recup_tabard` varchar(255) DEFAULT NULL,
`recup_poignet` varchar(255) DEFAULT NULL,
`recup_mains` varchar(255) DEFAULT NULL,
`recup_taille` varchar(255) DEFAULT NULL,
`recup_jambes` varchar(255) DEFAULT NULL,
`recup_pieds` varchar(255) DEFAULT NULL,
`recup_doigt1` varchar(255) DEFAULT NULL,
`recup_doigt2` varchar(255) DEFAULT NULL,
`recup_bijou1` varchar(255) DEFAULT NULL,
`recup_bijou2` varchar(255) DEFAULT NULL,
`recup_maingauche` varchar(255) DEFAULT NULL,
`recup_maindroite` varchar(255) DEFAULT NULL,
`recup_idole` varchar(255) DEFAULT NULL,
`recup_munition` varchar(255) DEFAULT NULL,
`recup_bag1` varchar(255) DEFAULT NULL,
`recup_bag2` varchar(255) DEFAULT NULL,
`recup_bag3` varchar(255) DEFAULT NULL,
`recup_bag4` varchar(255) DEFAULT NULL,
`recup_mount` varchar(255) DEFAULT NULL,
`recup_screen_connect` varchar(255) DEFAULT NULL,
`recup_screen_ingame` varchar(255) DEFAULT NULL,
`recup_screen_stuff` varchar(255) DEFAULT NULL,
`recup_screen_tradeskill` varchar(255) DEFAULT NULL,
`recup_screen_weapskill` varchar(255) DEFAULT NULL,
`recup_screen_jcj` varchar(255) DEFAULT NULL,
`recup_screen_volpartempsfroid` varchar(255) DEFAULT NULL,
`recup_screen_mount` varchar(255) DEFAULT NULL,
`recup_screen_talent` varchar(255) DEFAULT NULL,
`recup_note` varchar(255) DEFAULT NULL,
`recup_date` varchar(255) DEFAULT NULL,
`recup_etat` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `boutique_stuff`
-- ----------------------------
DROP TABLE IF EXISTS `boutique_stuff`;
CREATE TABLE `boutique_stuff` (
`id` int(100) NOT NULL auto_increment,
`quality` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`level` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`class` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;