[Summary view] [Print] [Text view]

   1  #
   2  # Structure de la table `categories`
   3  #
   4  
   5  DROP TABLE IF EXISTS categories;
   6  CREATE TABLE categories (
   7    catID int(11) NOT NULL default '0',
   8    IntCat varchar(100) NOT NULL default '',
   9    CleID tinyint(4) NOT NULL default '0',
  10    PRIMARY KEY  (catID,CleID)
  11  ) ENGINE=MyISAM;
  12  
  13  #
  14  # Contenu de la table `categories`
  15  #
  16  
  17  INSERT INTO categories VALUES (100, 'Utilisateurs', 1);
  18  INSERT INTO categories VALUES (200, 'Ordinateurs', 2);
  19  # --------------------------------------------------------
  20  
  21  #
  22  # Structure de la table `configuration`
  23  #
  24  
  25  DROP TABLE IF EXISTS configuration;
  26  CREATE TABLE configuration (
  27    cheminvbsse3 varchar(50) NOT NULL default '',
  28    cheminreseau varchar(100) NOT NULL default ''
  29  ) ENGINE=MyISAM;
  30  
  31  #
  32  # Contenu de la table `configuration`
  33  #
  34  
  35  # --------------------------------------------------------
  36  
  37  #
  38  # Structure de la table `corresp`
  39  #
  40  
  41  DROP TABLE IF EXISTS corresp;
  42  CREATE TABLE corresp (
  43    CleID tinyint(4) NOT NULL auto_increment,
  44    Intitule varchar(100) NOT NULL default '',
  45    valeur varchar(100) NOT NULL default '',
  46    antidote varchar(30) default NULL,
  47    genre varchar(30) NOT NULL default '',
  48    OS varchar(20) NOT NULL default '98',
  49    chemin varchar(150) NOT NULL default '',
  50    comment longtext,
  51    type varchar(20) NOT NULL default 'restrict',
  52    PRIMARY KEY  (chemin),
  53    UNIQUE KEY CleID (CleID)
  54  ) ENGINE=MyISAM;
  55  
  56  #
  57  # Contenu de la table `corresp`
  58  #
  59  
  60  INSERT INTO corresp VALUES (18, 'Page de démarrage d\'Internet Explorer', 'www.ac-creteil.fr', 'www.ac-creteil.fr', 'REG_SZ', 'TOUS', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Internet Explorer\\Main\\Start Page', 'Sandrine Dangreville', 'config');
  61  INSERT INTO corresp VALUES (19, 'Don\'t show last user', '1', 'SUPPR', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Policies\\System\\DontDisplayLastUserName', 'J. BREYAULT', 'restrict');
  62  INSERT INTO corresp VALUES (3, 'Pas de menu fichier', '1', '0', 'REG_DWORD', 'Type9x', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoFileMenu', 'test de commentaire ok\r\n\r\nre', 'restrict');
  63  INSERT INTO corresp VALUES (17, 'Affichage note pré-login', 'Message perso bandeau fenêtre', 'SUPPR', 'REG_DWORD', 'Type9x', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Winlogon\\LegalNoticeCaption', 'J. BREYAULT', 'config');
  64  INSERT INTO corresp VALUES (20, 'Affiche message sur fenêtre login', 'Message personnalisé', 'SUPPR', 'REG_SZ', 'TypeXP', 'HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Winlogon\\LogonPrompt', 'J. BREYAULT', 'config');
  65  INSERT INTO corresp VALUES (22, 'Empêche changement MDP', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\System\\DisableChangePassword', 'J. BREYAULT', 'restrict');
  66  INSERT INTO corresp VALUES (23, 'Pas de panneau de config', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoControlPanel', 'J. BREYAULT', 'restrict');
  67  INSERT INTO corresp VALUES (24, 'Pas de map de lecteurs reseau', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoNetConnectDisconnect', 'J. BREYAULT', 'restrict');
  68  INSERT INTO corresp VALUES (25, 'Efface swap au shutdown', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\Session Manager\\Memory Management\\ClearPageFileAtShutdown', 'J. BREYAULT', 'config');
  69  INSERT INTO corresp VALUES (26, 'Affiche logoff sur menu démarrer', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\ForceStartMenuLogoff', 'J. BREYAULT', 'config');
  70  INSERT INTO corresp VALUES (27, 'Empêche accés icônes près horloge', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoTrayItemsDisplay', 'J. BREYAULT', 'restrict');
  71  INSERT INTO corresp VALUES (28, 'Empêche tollbars sur barre des tâches', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoToolbarsOnTaskbar', 'J. BREYAULT', 'restrict');
  72  INSERT INTO corresp VALUES (29, 'Bloque position barre des tâches', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\LockTaskbar', 'J. BREYAULT', 'restrict');
  73  INSERT INTO corresp VALUES (30, 'Force menu démarrer classique', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoSimpleStartMenu', 'J. BREYAULT', 'config');
  74  INSERT INTO corresp VALUES (31, 'Pas de restauration - clé1', '1', 'SUPPR', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\SOFTWARE\\Policies\\Microsoft\\Windows NT\\SystemRestore\\DisableConfig', 'J. BREYAULT', 'restrict');
  75  INSERT INTO corresp VALUES (32, 'Pas de restauration - clé2', '1', 'SUPPR', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\SOFTWARE\\Policies\\Microsoft\\Windows NT\\SystemRestore\\DisableSR', 'J. BREYAULT', 'restrict');
  76  INSERT INTO corresp VALUES (33, 'Autoreboot après crash', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\CrashControl\\AutoReboot', 'J. BREYAULT', 'config');
  77  INSERT INTO corresp VALUES (34, 'Login après resume', '1', '0', 'REG_DWORD', 'TypeXP', 'HKEY_LOCAL_MACHINE\\Software\\Policies\\Microsoft\\Windows\\System\\Power\\PromptPasswordOnResume', 'J. BREYAULT', 'config');
  78  INSERT INTO corresp VALUES (35, 'Empêche clic droit sur bureau', '1', '0', 'REG_DWORD', 'TOUS', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoViewContextMenu', 'J. BREYAULT', 'restrict');
  79  INSERT INTO corresp VALUES (36, 'Cacher une machine sur le réseau', '1', 'SUPPR', 'REG_DWORD', 'TOUS', 'HKEY_LOCAL_MACHINE\\System\\CurrentControlSet\\Services\\LanmanServer\\Parameters\\Hidden', 'J. BREYAULT', 'restrict');
  80  INSERT INTO corresp VALUES (37, 'Efface fichiers internet temporaires', '0', '1', 'REG_DWORD', 'TOUS', 'HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Persistent', 'J. BREYAULT', 'config');
  81  INSERT INTO corresp VALUES (38, 'Pas de windows update', '0', 'SUPPR', 'REG_DWORD', 'TOUS', 'HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoWindowsUpdate', 'J. BREYAULT', 'restrict');
  82  INSERT INTO corresp VALUES (39, 'Pas enregistrement MDP internet', '1', 'SUPPR', 'REG_DWORD', 'TOUS', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Internet Settings', 'J. BREYAULT', 'config');
  83  INSERT INTO corresp VALUES (40, 'Masque l\'icône Voisinage Réseau', '00000001', '00000000', 'REG_DWORD', 'Type9x', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoNetHood', 'Olivier.S', 'restrict');
  84  INSERT INTO corresp VALUES (41, 'Masque la commande "Executer" du menu démarrer', '00000001', '00000000', 'REG_DWORD', 'Type9x', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoRun', 'Olivier.S', 'restrict');
  85  INSERT INTO corresp VALUES (42, 'Masquage : panneau de configuration + imprimante', '00000001', '00000000', 'REG_DWORD', 'Type9x', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoSetFolders', 'Masquage du Panneau de Configuration et du dossier Imprimantes dans le poste de travail (j\'ai n\'ai pas essayer de rajouter ce dossier, mais au cas ou cela fonctionne...) Olivier.S', 'restrict');
  86  INSERT INTO corresp VALUES (43, 'Empèche la  suppression des imprimantes', '00000001', '00000000', 'REG_DWORD', 'Type9x', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoDeletePrinter', 'Olivier.S', 'restrict');
  87  INSERT INTO corresp VALUES (46, 'Empèche l\'ajout d\'imprimantes', '1', '0', 'REG_DWORD', 'Type9x', 'HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer\\NoAddPrinter', 'Olivier.S', 'restrict');
  88  # --------------------------------------------------------
  89  
  90  #
  91  # Structure de la table `modele`
  92  #
  93  
  94  DROP TABLE IF EXISTS modele;
  95  CREATE TABLE modele (
  96    modID int(10) NOT NULL auto_increment,
  97    cle tinyint(4) NOT NULL default '0',
  98    mod varchar(30) NOT NULL default 'fullrestrict',
  99    etat tinyint(4) default '1',
 100    PRIMARY KEY  (cle,mod),
 101    UNIQUE KEY modID (modID)
 102  ) ENGINE=MyISAM;
 103  
 104  #
 105  # Contenu de la table `modele`
 106  #
 107  
 108  INSERT INTO modele VALUES (1, 18, 'norestrict', 0);
 109  INSERT INTO modele VALUES (2, 18, 'fullrestrict', 1);
 110  
 111  # --------------------------------------------------------
 112  
 113  #
 114  # Structure de la table `restrictions`
 115  #
 116  
 117  DROP TABLE IF EXISTS restrictions;
 118  CREATE TABLE restrictions (
 119    resID tinyint(4) NOT NULL auto_increment,
 120    cleID int(11) NOT NULL default '0',
 121    groupe varchar(100) NOT NULL default '',
 122    valeur varchar(100) NOT NULL default '',
 123    PRIMARY KEY  (cleID,groupe),
 124    UNIQUE KEY resID (resID)
 125  ) ENGINE=MyISAM;
 126  
 127  #
 128  # Contenu de la table `restrictions`
 129  #
 130  
 131  
 132