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