[Sommaire] [Imprimer]

   1  <?php
   2  
   3      // new user management system
   4      // erase old tables
   5      // create new ones
   6      // add anonymous user
   7      // add basic groups
   8      
   9  $allQueries = array(
  10      'DROP TABLE IF EXISTS '.T_USERS,
  11      'DROP TABLE IF EXISTS '.T_GROUPS,
  12      'DROP TABLE IF EXISTS '.T_USERS_LINK_GROUPS,
  13      "CREATE TABLE ".T_USERS." (
  14            `login` varchar(20) NOT NULL default '',
  15            `password` varchar(255) default NULL,
  16            `alias` varchar(45) default NULL,
  17            `email` varchar(100) NOT NULL default '',
  18            `rss_hash` varchar(100) NOT NULL default '',
  19            `date_registered` int(11) default NULL,
  20            PRIMARY KEY  (`login`)
  21          ) TYPE=MyISAM
  22      ",
  23      "CREATE TABLE ".T_USERS_LINK_GROUPS." (
  24            `idsite` int(10) unsigned NOT NULL default '0',
  25            `idgroups` int(10) unsigned NOT NULL default '0',
  26            `login` varchar(20) NOT NULL default '0',
  27            PRIMARY KEY  (`idsite`,`idgroups`,`login`)
  28          ) TYPE=MyISAM
  29      ",
  30      "CREATE TABLE ".T_GROUPS." (
  31            `idgroups` int(10) unsigned NOT NULL auto_increment,
  32            `name` varchar(20) default NULL,
  33            `view` tinyint(1) unsigned default '0',
  34            `admin` tinyint(3) unsigned default '0',
  35            PRIMARY KEY  (`idgroups`)
  36          ) TYPE=MyISAM 
  37      ",
  38      "INSERT INTO ".T_GROUPS." VALUES (1, 'admin', 1, 1)",
  39      "INSERT INTO ".T_GROUPS." VALUES (2, 'view', 1, 0)",
  40      "INSERT INTO ".T_USERS." VALUES ('anonymous', NULL, 'Anonymous user', '', 'ffffffffffffff493e8d55a4a75de3f90a1', NULL)",
  41      
  42      );
  43  
  44  foreach($allQueries as $query)
  45  {
  46      query($query);
  47  }    
  48      
  49  
  50      
  51  ?>