Changes between Version 8 and Version 9 of Raw_Images_Files_in_Nebulous

Timestamp:

Feb 29, 2012, 1:08:37 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Raw_Images_Files_in_Nebulous

@@ -61 +61 @@
  * Table based on RawImagesSimple without the maximum ota counts is named: {{{RawImagesWithoutMaximumOta}}}
 {{{
-CREATE TABLE RawImagesWithoutMaximumOta (host CHAR(7), INDEX(host), ota CHAR(6), INDEX(ota), ota_count INT, INDEX(ota_count));
-INSERT INTO RawImagesWithoutMaximumOta SELECT host, ota, ota_count FROM RawImagesSimple WHERE (SELECT COUNT(*) FROM RawImagesMaximaByOta WHERE RawImagesMaximaByOta.host = RawImagesSimple.host AND RawImagesMaximaByOta.ota = RawImagesSimple.ota) = 0 AND host != 'ipp026' AND host != 'ipp045' AND host != 'ipp064' AND host != 'ipp066';
+CREATE TABLE RawImagesWithoutMaximumOta (host CHAR(7), INDEX(host), 
+             ota CHAR(6), INDEX(ota), ota_count INT, INDEX(ota_count));
+INSERT INTO RawImagesWithoutMaximumOta SELECT host, ota, ota_count FROM RawImagesSimple 
+            WHERE (SELECT COUNT(*) FROM RawImagesMaximaByOta WHERE RawImagesMaximaByOta.host = RawImagesSimple.host
+            AND RawImagesMaximaByOta.ota = RawImagesSimple.ota) = 0 
+            AND host != 'ipp026' AND host != 'ipp045' AND host != 'ipp064' AND host != 'ipp066';
 }}}