| 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 | |