[Sommaire] [Imprimer]

   1  <?php
   2      
   3  $allQueries = array(
   4  'DROP TABLE IF EXISTS '.T_PDF_CONFIG,
   5  "CREATE TABLE ".T_PDF_CONFIG." (
   6    idpdf int(10) unsigned NOT NULL auto_increment,
   7    name_pdf varchar(90) default NULL,
   8    params_pdf longblob,
   9    PRIMARY KEY  (idpdf)
  10  ) TYPE=MyISAM
  11  ",
  12  'DROP TABLE IF EXISTS '.T_PDF_SITE_USER,
  13  "CREATE TABLE ".T_PDF_SITE_USER." (
  14    `idsite` int(10) unsigned NOT NULL default '0',
  15    `login` varchar(20) NOT NULL default '0',
  16    `idpdf` int(10) unsigned NOT NULL,
  17    PRIMARY KEY  (`idsite`,`login`,`idpdf`)
  18  ) TYPE=MyISAM
  19  ",
  20  //"ALTER TABLE ".T_SITE." DROP `idpdf`",

  21  "ALTER TABLE ".T_SITE."  ADD `idpdf` INT( 10 ) DEFAULT '-1' NOT NULL AFTER `params_names`",
  22  //"ALTER TABLE ".T_SITE." DROP `path_theme`",

  23  "ALTER TABLE ".T_SITE."  ADD `path_theme` varchar(255) default 'default' NOT NULL AFTER `idpdf`",
  24  //"ALTER TABLE ".T_VISIT."  DROP `javascript",

  25  "ALTER TABLE ".T_VISIT."  ADD `javascript` tinyint(1) DEFAULT '0' NOT NULL AFTER `java`",
  26  //"ALTER TABLE ".T_VISIT."  DROP `cookie`",

  27  "ALTER TABLE ".T_VISIT."  ADD `cookie` tinyint(1) DEFAULT '0' NOT NULL AFTER `windowsmedia`"
  28  );
  29  
  30  foreach($allQueries as $query)
  31  {
  32      query($query);
  33  }    
  34      
  35      
  36  ?>