upgrade/0.9.3/50_admin.sql

   1 --
   2 -- Table structure for table `admin_h1`
   3 --
   4
   5 CREATE TABLE `admin_h1` (
   6   `h1id` tinyint(4) NOT NULL default '0',
   7   `h1` varchar(64) NOT NULL default '',
   8   `prio` tinyint(4) NOT NULL default '0',
   9   PRIMARY KEY (h1id),
  10   KEY `prio` (`prio`)
  11 ) TYPE=MyISAM;
  12
  13 insert into admin_h1 values(1, 'Système',               0);
  14 insert into admin_h1 values(2, 'Contenu du site',      10);
  15 insert into admin_h1 values(3, 'Gestion et entretien', 30);
  16
  17 --
  18 -- Table structure for table `admin_h2`
  19 --
  20
  21 CREATE TABLE `admin_h2` (
  22   `h1id` tinyint(4) NOT NULL default '0',
  23   `h2id` tinyint(4) NOT NULL default '0',
  24   `h2` varchar(64) NOT NULL default '',
  25   `prio` tinyint(4) NOT NULL default '0',
  26   PRIMARY KEY (h2id),
  27   KEY `prio` (`prio`)
  28 ) TYPE=MyISAM;
  29
  30 insert into admin_h2 values(1,  1, 'Postfix',                 0);
  31 insert into admin_h2 values(1,  2, 'Sécurité',               20);
  32
  33 insert into admin_h2 values(2,  3, 'Utilisateurs',            0);
  34 insert into admin_h2 values(2,  4, 'Infos dynamiques',       10);
  35 insert into admin_h2 values(2,  5, 'Champs profil',          20);
  36 insert into admin_h2 values(2,  6, 'Newsletter',             30);
  37 insert into admin_h2 values(2,  7, 'Administrer',            40);
  38 insert into admin_h2 values(2,  8, 'Valider demandes',       50);
  39 insert into admin_h2 values(2,  9, 'Trésorerie',             60);
  40
  41 insert into admin_h2 values(3, 10, 'Reformatage Prenom NOM',  0);
  42
  43 --
  44 -- Table structure for table `admin_a`
  45 --
  46
  47 CREATE TABLE `admin_a` (
  48   `h2id` tinyint(4) NOT NULL default '0',
  49   `texte` varchar(64) NOT NULL default '',
  50   `url` varchar(64) NOT NULL default '',
  51   `prio` tinyint(4) NOT NULL default '0',
  52   KEY `prio` (`prio`)
  53
  54 ) TYPE=MyISAM;
  55
  56 insert into admin_a values(1, 'Blacklist', 'admin/postfix_blacklist.php',  0);
  57 insert into admin_a values(1, 'Whitelist', 'admin/postfix_whitelist.php', 10);
  58 insert into admin_a values(1, 'Retardés',  'admin/postfix_delayed.php',   20);
  59
  60 insert into admin_a values(2, 'Logs des sessions', 'admin/logger.php', 0);
  61 insert into admin_a values(2, 'Actions', 'admin/logger_actions.php', 10);
  62
  63 insert into admin_a values(3, 'Edit/Su/Logs', 'admin/utilisateurs.php',  0);
  64 insert into admin_a values(3, 'Homonymes', 'admin/homonymes.php', 10);
  65 insert into admin_a values(3, 'AX/X.org', 'admin/ax-xorg.php', 20);
  66 insert into admin_a values(3, 'Décès', 'admin/deces_promo.php', 30);
  67
  68 insert into admin_a values(4, 'Coupures', 'admin/gerer_coupure.php',  0);
  69 insert into admin_a values(4, 'Événements', 'admin/evenements.php', 10);
  70
  71 insert into admin_a values(5, 'Formations', 'admin/gerer_applis.php',  0);
  72 insert into admin_a values(5, 'Binets', 'admin/gerer_binets.php', 10);
  73 insert into admin_a values(5, 'Groupes X', 'admin/gerer_groupesx.php', 20);
  74 insert into admin_a values(5, 'Skins', 'admin/gerer_skins.php', 30);
  75
  76 insert into admin_a values(6, 'Liste', 'admin/newsletter.php',  0);
  77 insert into admin_a values(6, 'Catégories', 'admin/newsletter_cats.php', 10);
  78 insert into admin_a values(6, 'Adresses en panne', 'admin/newsletter_pattecassee.php', 20);
  79
  80 insert into admin_a values(7, 'Auth Groupes X', 'admin/gerer_auth-groupex.php',  0);
  81 insert into admin_a values(7, 'Listes', 'admin/lists.php', 10);
  82
  83 insert into admin_a values(8, 'Valider', 'admin/valider.php',  0);
  84 insert into admin_a values(8, 'Événements', 'admin/evenements.php', 10);
  85
  86 insert into admin_a values(9, 'Comptes', 'trezo/gere_operations.php', 0);
  87 insert into admin_a values(9, 'Paiements', 'admin/gerer_paiement.php', 10);
  88
  89 insert into admin_a values(10, 'Table auth_user_md5', 'admin/FormatePrenomNOM.php', 0);
  90