--matgraph_ally : ajout champ statut_fondateur varchar 255
--matgraph_mobil_vruines : ajout champ vruines3 varchar 255
--matgraph_users : ajout  champ postav_lvl varchar 255, _evolution, _destruction datetime 0000-00-00 00:00:00
--			  champ techhypernav_lvl varchar 255,techhypernav_evolution datetime
--			  champ defdrone varchar 255
--matgraph_vaisseauxruines : ajout champ vruines3 varchar 255

ALTER TABLE `matgraph_ally` ADD `statut_fondateur` VARCHAR( 255 ) DEFAULT 'Fondateur' NOT NULL AFTER `defcon`;
ALTER TABLE `matgraph_mobil_vruines` ADD `vruines3` VARCHAR( 255 ) DEFAULT '0' NOT NULL AFTER `vruines2`;
ALTER TABLE `matgraph_users` ADD `postav_lvl` VARCHAR( 255 ) DEFAULT '0' NOT NULL AFTER `chantier_destruction`;
ALTER TABLE `matgraph_users` ADD `postav_evolution` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL AFTER `postav_lvl`;
ALTER TABLE `matgraph_users` ADD `postav_destruction` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL AFTER `postav_evolution`;
ALTER TABLE `matgraph_users` ADD `techhypernav_lvl` VARCHAR( 255 ) DEFAULT '0' NOT NULL AFTER `techyperespace_evolution`;
ALTER TABLE `matgraph_users` ADD `techhypernav_evolution` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL AFTER `techhypernav_lvl`;
ALTER TABLE `matgraph_users` ADD `defdrone` VARCHAR( 255 ) NOT NULL AFTER `defanciens`;
ALTER TABLE `matgraph_vaisseauxruines` ADD `vruines3` VARCHAR( 255 ) DEFAULT '0' NOT NULL AFTER `vruines2`;
DROP TABLE IF EXISTS `pushing_systeme`;
CREATE TABLE `pushing_systeme` (
  `id` int(30) NOT NULL auto_increment,
  `id_fort` varchar(255) NOT NULL default '',
  `id_faible` varchar(255) NOT NULL default '',
  `fer_fort` text NOT NULL,
  `orr_fort` text NOT NULL,
  `cristal_fort` text NOT NULL,
  `naquadah_fort` text NOT NULL,
  `militaires_fort` text NOT NULL,
  `eppzs_fort` text NOT NULL,
  `malps_fort` text NOT NULL,
  `prs_fort` text NOT NULL,
  `grs_fort` text NOT NULL,
  `fer_faible` text NOT NULL,
  `orr_faible` text NOT NULL,
  `cristal_faible` text NOT NULL,
  `naquadah_faible` text NOT NULL,
  `militaires_faible` text NOT NULL,
  `eppzs_faible` text NOT NULL,
  `malps_faible` text NOT NULL,
  `prs_faible` text NOT NULL,
  `grs_faible` text NOT NULL,
  `dates_echanges` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;