[Lsb-messages] /var/www/bzr/lsb/devel/dbadmin r301: Fix Aid fetching in reports for applications with incorrect license and UI fields

[Denis Silakov]

------------------------------------------------------------
revno: 301
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: dbadmin
timestamp: Tue 2014-07-15 15:37:53 +0400
message:
  Fix Aid fetching in reports for applications with incorrect license and UI fields
modified:
  consistency/foreign_keys.php
  consistency/queries.php
-------------- next part --------------
=== modified file 'consistency/foreign_keys.php'
--- a/consistency/foreign_keys.php	2013-01-16 11:10:11 +0000
+++ b/consistency/foreign_keys.php	2014-07-15 11:37:53 +0000
@@ -98,6 +98,9 @@
     array('RawInterface', 'RIrcid', 'RawClass', 'RCid'),
     array('RawInterface', 'RIlibrary', 'RawLibrary', 'RLname'),
     array('RawLibrary', 'RLcomponent', 'Component', 'Cid'),
+    array('RawVtable', 'RVrcid', 'RawClass', 'RCid'),
+    array('RawVtable', 'RVriid', 'RawInterface', 'RIid'),
+    array('RawVtable', 'RVrlid', 'RawLibrary', 'RLid'),
     array('SectionTypes', 'STstandard', 'Standard', 'Sid'),
     array('TestCaseSource', 'TCStsid', 'TestSuite', 'TSid'),
     array('TestCmd', 'TSCcmd', 'Command', 'Cid'),

=== modified file 'consistency/queries.php'
--- a/consistency/queries.php	2013-02-22 17:50:40 +0000
+++ b/consistency/queries.php	2014-07-15 11:37:53 +0000
@@ -2815,31 +2815,31 @@
         output_inc_atbasetype();
         break;
     case "app-ui":
-        $select = "SELECT Aname, Aversion, Aarch FROM Application
+        $select = "SELECT Aid, Aname, Aversion, Aarch FROM Application
                     LEFT JOIN AppCategory ON Aid=ACaid
                     WHERE ACui='Unknown'";
         output_incorrect_apps("Applications with Unknown UI", "", $select);
         break;
     case "app-size":
-        $select = "SELECT Aname, Aversion, Aarch FROM Application
+        $select = "SELECT Aid, Aname, Aversion, Aarch FROM Application
                     LEFT JOIN AppCategory ON Aid=ACaid
                     WHERE ACsize='Unknown'";
         output_incorrect_apps("Applications with Unknown Size", "", $select);
         break;
     case "app-no-info":
-        $select = "SELECT Aname, Aversion, Aarch FROM Application
+        $select = "SELECT Aid, Aname, Aversion, Aarch FROM Application
                     LEFT JOIN AppInfo ON AIname=Aname
                     WHERE AIurl IS NULL";
         output_incorrect_apps("Applications Without AppInfo Records", "", $select);
         break;
     case "app-lic":
-        $select = "SELECT Aname, Aversion, Aarch FROM Application
+        $select = "SELECT Aid, Aname, Aversion, Aarch FROM Application
                     LEFT JOIN AppCategory ON Aid=ACaid
                     WHERE AClicense='Unknown'";
         output_incorrect_apps("Applications with Unknown License", "", $select);
         break;
     case "app-cat":
-        $select = "SELECT Aname, Aversion, Aarch FROM Application
+        $select = "SELECT Aid, Aname, Aversion, Aarch FROM Application
                     LEFT JOIN AppCategory ON Aid=ACaid
                     WHERE ACcategory='Unknown'";
         output_incorrect_apps("Applications with Unknown Category", "", $select);