"Fossies" - the Fresh Open Source Software Archive

Member "OCSNG_UNIX_SERVER_2.6/ocsreports/files/update/7017.sql" (17 Apr 2019, 7208 Bytes) of package /linux/privat/OCSNG_UNIX_SERVER_2.6.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 
    2 ALTER TABLE `accesslog`
    3   DROP PRIMARY KEY,
    4   DROP INDEX `ID`,
    5   ADD PRIMARY KEY (`ID`),
    6   ADD INDEX(`HARDWARE_ID`);
    7 
    8 ALTER TABLE `batteries`
    9   DROP PRIMARY KEY,
   10   ADD PRIMARY KEY (`ID`),
   11   ADD INDEX(`HARDWARE_ID`);
   12 
   13 ALTER TABLE `blacklist_macaddresses`
   14   DROP PRIMARY KEY,
   15   DROP INDEX `ID`,
   16   ADD PRIMARY KEY (`ID`),
   17   ADD UNIQUE KEY `MACADDRESS` (`MACADDRESS`);
   18 
   19 ALTER TABLE `blacklist_serials`
   20   DROP PRIMARY KEY,
   21   DROP INDEX `ID`,
   22   ADD PRIMARY KEY(`ID`),
   23   ADD UNIQUE KEY `SERIAL` (`SERIAL`);
   24 
   25 ALTER TABLE `blacklist_subnet`
   26   DROP PRIMARY KEY,
   27   DROP INDEX `ID`,
   28   ADD PRIMARY KEY (`ID`),
   29   ADD UNIQUE KEY `SUBNET` (`SUBNET`,`MASK`);
   30 
   31 ALTER TABLE `controllers`
   32   DROP PRIMARY KEY,
   33   DROP INDEX `ID`,
   34   ADD PRIMARY KEY (`ID`),
   35   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   36 
   37 ALTER TABLE `cpus`
   38   DROP PRIMARY KEY,
   39   ADD PRIMARY KEY (`ID`),
   40   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   41 
   42 ALTER TABLE `deleted_equiv`
   43   ADD KEY `DELETED` (`DELETED`);
   44 
   45 ALTER TABLE `drives`
   46   DROP PRIMARY KEY,
   47   DROP INDEX `ID`,
   48   ADD PRIMARY KEY (`ID`),
   49   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   50 
   51 ALTER TABLE `engine_mutex`
   52   ADD KEY `PID` (`PID`);
   53 
   54 ALTER TABLE `hardware`
   55   DROP PRIMARY KEY,
   56   DROP INDEX `ID`,
   57   ADD PRIMARY KEY (`ID`);
   58 
   59 ALTER TABLE `inputs`
   60   DROP PRIMARY KEY,
   61   DROP INDEX `ID`,
   62   ADD PRIMARY KEY (`ID`),
   63   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   64 
   65 ALTER TABLE `itmgmt_comments`
   66   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   67 
   68 ALTER TABLE `journallog`
   69   DROP PRIMARY KEY,
   70   ADD PRIMARY KEY (`ID`),
   71   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   72 
   73 ALTER TABLE `memories`
   74   DROP PRIMARY KEY,
   75   DROP INDEX `ID`,
   76   ADD PRIMARY KEY (`ID`),
   77   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   78 
   79 ALTER TABLE `modems`
   80   DROP PRIMARY KEY,
   81   DROP INDEX `ID`,
   82   ADD PRIMARY KEY (`ID`),
   83   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   84 
   85 ALTER TABLE `monitors`
   86   DROP PRIMARY KEY,
   87   DROP INDEX `ID`,
   88   ADD PRIMARY KEY (`ID`),
   89   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   90 
   91 ALTER TABLE `networks`
   92   DROP PRIMARY KEY,
   93   DROP INDEX `ID`,
   94   ADD PRIMARY KEY (`ID`),
   95   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
   96 
   97 ALTER TABLE `ports`
   98   DROP PRIMARY KEY,
   99   DROP INDEX `ID`,
  100   ADD PRIMARY KEY (`ID`),
  101   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  102 
  103 ALTER TABLE `printers`
  104   DROP PRIMARY KEY,
  105   DROP INDEX `ID`,
  106   ADD PRIMARY KEY (`ID`),
  107   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  108 
  109 ALTER TABLE `prolog_conntrack`
  110   DROP INDEX `ID`,
  111   ADD PRIMARY KEY (`ID`);
  112 
  113 ALTER TABLE `registry`
  114   DROP PRIMARY KEY,
  115   DROP INDEX `ID`,
  116   ADD PRIMARY KEY (`ID`),
  117   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  118 
  119 ALTER TABLE `repository`
  120   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  121 
  122 ALTER TABLE `sim`
  123   DROP PRIMARY KEY,
  124   ADD PRIMARY KEY (`ID`),
  125   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  126 
  127 ALTER TABLE `slots`
  128   DROP PRIMARY KEY,
  129   DROP INDEX `ID`,
  130   ADD PRIMARY KEY (`ID`),
  131   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  132 
  133 ALTER TABLE `snmp_cards`
  134   DROP PRIMARY KEY,
  135   ADD PRIMARY KEY (`ID`),
  136   ADD KEY `SNMP_ID` (`SNMP_ID`);
  137 
  138 ALTER TABLE `snmp_cartridges`
  139   DROP PRIMARY KEY,
  140   ADD PRIMARY KEY (`ID`),
  141   ADD KEY `SNMP_ID` (`SNMP_ID`);
  142 
  143 ALTER TABLE `snmp_cpus`
  144   DROP PRIMARY KEY,
  145   ADD PRIMARY KEY (`ID`),
  146   ADD KEY `SNMP_ID` (`SNMP_ID`);
  147 
  148 ALTER TABLE `snmp_drives`
  149   DROP PRIMARY KEY,
  150   ADD PRIMARY KEY (`ID`),
  151   ADD KEY `SNMP_ID` (`SNMP_ID`);
  152 
  153 ALTER TABLE `snmp_fans`
  154   DROP PRIMARY KEY,
  155   ADD PRIMARY KEY (`ID`),
  156   ADD KEY `SNMP_ID` (`SNMP_ID`);
  157 
  158 ALTER TABLE `snmp_inputs`
  159   DROP PRIMARY KEY,
  160   ADD PRIMARY KEY (`ID`),
  161   ADD KEY `SNMP_ID` (`SNMP_ID`);
  162 
  163 ALTER TABLE `snmp_localprinters`
  164   DROP PRIMARY KEY,
  165   ADD PRIMARY KEY (`ID`),
  166   ADD KEY `SNMP_ID` (`SNMP_ID`);
  167 
  168 ALTER TABLE `snmp_memories`
  169   DROP PRIMARY KEY,
  170   ADD PRIMARY KEY (`ID`),
  171   ADD KEY `SNMP_ID` (`SNMP_ID`);
  172 
  173 ALTER TABLE `snmp_modems`
  174   DROP PRIMARY KEY,
  175   ADD PRIMARY KEY (`ID`),
  176   ADD KEY `SNMP_ID` (`SNMP_ID`);
  177 
  178 ALTER TABLE `snmp_networks`
  179   DROP PRIMARY KEY,
  180   ADD PRIMARY KEY (`ID`),
  181   ADD KEY `SNMP_ID` (`SNMP_ID`);
  182 
  183 ALTER TABLE `snmp_ports`
  184   DROP PRIMARY KEY,
  185   ADD PRIMARY KEY (`ID`),
  186   ADD KEY `SNMP_ID` (`SNMP_ID`);
  187 
  188 ALTER TABLE `snmp_powersupplies`
  189   DROP PRIMARY KEY,
  190   ADD PRIMARY KEY (`ID`),
  191   ADD KEY `SNMP_ID` (`SNMP_ID`);
  192 
  193 ALTER TABLE `snmp_softwares`
  194   DROP PRIMARY KEY,
  195   ADD PRIMARY KEY (`ID`),
  196   ADD KEY `SNMP_ID` (`SNMP_ID`);
  197 
  198 ALTER TABLE `snmp_sounds`
  199   DROP PRIMARY KEY,
  200   ADD PRIMARY KEY (`ID`),
  201   ADD KEY `SNMP_ID` (`SNMP_ID`);
  202 
  203 ALTER TABLE `snmp_storages`
  204   DROP PRIMARY KEY,
  205   ADD PRIMARY KEY (`ID`),
  206   ADD KEY `SNMP_ID` (`SNMP_ID`);
  207 
  208 ALTER TABLE `snmp_switchs`
  209   DROP PRIMARY KEY,
  210   ADD PRIMARY KEY (`ID`),
  211   ADD KEY `SNMP_ID` (`SNMP_ID`);
  212 
  213 ALTER TABLE `snmp_trays`
  214   DROP PRIMARY KEY,
  215   ADD PRIMARY KEY (`ID`),
  216   ADD KEY `SNMP_ID` (`SNMP_ID`);
  217 
  218 ALTER TABLE `snmp_videos`
  219   DROP PRIMARY KEY,
  220   ADD PRIMARY KEY (`ID`),
  221   ADD KEY `SNMP_ID` (`SNMP_ID`);
  222 
  223 ALTER TABLE `snmp_virtualmachines`
  224   DROP PRIMARY KEY,
  225   ADD PRIMARY KEY (`ID`),
  226   ADD KEY `SNMP_ID` (`SNMP_ID`);
  227 
  228 ALTER TABLE `softwares`
  229   DROP PRIMARY KEY,
  230   DROP INDEX `ID`,
  231   ADD PRIMARY KEY (`ID`),
  232   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  233 
  234 ALTER TABLE `software_category_exp`
  235   ADD KEY `CATEGORY_ID` (`CATEGORY_ID`);
  236 
  237 ALTER TABLE `sounds`
  238   DROP PRIMARY KEY,
  239   DROP INDEX `ID`,
  240   ADD PRIMARY KEY (`ID`),
  241   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  242 
  243 ALTER TABLE `storages`
  244   DROP PRIMARY KEY,
  245   DROP INDEX `ID`,
  246   ADD PRIMARY KEY (`ID`),
  247   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  248 
  249 ALTER TABLE `usbdevices`
  250   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  251 
  252 ALTER TABLE `videos`
  253   DROP PRIMARY KEY,
  254   DROP INDEX `ID`,
  255   ADD PRIMARY KEY (`ID`),
  256   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  257 
  258 ALTER TABLE `virtualmachines`
  259   DROP PRIMARY KEY,
  260   ADD PRIMARY KEY (`ID`),
  261   ADD KEY `HARDWARE_ID` (`HARDWARE_ID`);
  262 
  263 ALTER TABLE `accountinfo_config` ENGINE = InnoDB;
  264 ALTER TABLE `blacklist_macaddresses` ENGINE = InnoDB;
  265 ALTER TABLE `blacklist_serials` ENGINE = InnoDB;
  266 ALTER TABLE `blacklist_subnet` ENGINE = InnoDB;
  267 ALTER TABLE `config` ENGINE = InnoDB;
  268 ALTER TABLE `deleted_equiv` ENGINE = InnoDB;
  269 ALTER TABLE `deploy` ENGINE = InnoDB;
  270 ALTER TABLE `devicetype` ENGINE = InnoDB;
  271 ALTER TABLE `dico_ignored` ENGINE = InnoDB;
  272 ALTER TABLE `dico_soft` ENGINE = InnoDB;
  273 ALTER TABLE `downloadwk_conf_values` ENGINE = InnoDB;
  274 ALTER TABLE `downloadwk_fields` ENGINE = InnoDB;
  275 ALTER TABLE `downloadwk_history` ENGINE = InnoDB;
  276 ALTER TABLE `downloadwk_pack` ENGINE = InnoDB;
  277 ALTER TABLE `downloadwk_statut_request` ENGINE = InnoDB;
  278 ALTER TABLE `downloadwk_tab_values` ENGINE = InnoDB;
  279 ALTER TABLE `download_affect_rules` ENGINE = InnoDB;
  280 ALTER TABLE `download_servers` ENGINE = InnoDB;
  281 ALTER TABLE `engine_persistent` ENGINE = InnoDB;
  282 ALTER TABLE `files` ENGINE = InnoDB;
  283 ALTER TABLE `groups` ENGINE = InnoDB;
  284 ALTER TABLE `groups_cache` ENGINE = InnoDB;
  285 ALTER TABLE `hardware_osname_cache` ENGINE = InnoDB;
  286 ALTER TABLE `itmgmt_comments` ENGINE = InnoDB;
  287 ALTER TABLE `languages` ENGINE = InnoDB;
  288 ALTER TABLE `network_devices` ENGINE = InnoDB;
  289 ALTER TABLE `operators` ENGINE = InnoDB;
  290 ALTER TABLE `regconfig` ENGINE = InnoDB;
  291 ALTER TABLE `registry_name_cache` ENGINE = InnoDB;
  292 ALTER TABLE `registry_regvalue_cache` ENGINE = InnoDB;
  293 ALTER TABLE `softwares_name_cache` ENGINE = InnoDB;
  294 ALTER TABLE `subnet` ENGINE = InnoDB;
  295 ALTER TABLE `tags` ENGINE = InnoDB;
  296 ALTER TABLE `temp_files` ENGINE = InnoDB;
  297