Shortened names of default policy groups

diff --git a/src/libimcv/imv/data.sql b/src/libimcv/imv/data.sql
index fa0ec01..e52fa14 100644 (file)
--- a/src/libimcv/imv/data.sql
+++ b/src/libimcv/imv/data.sql
@@ -461,37 +461,37 @@ INSERT INTO versions (
 INSERT INTO groups (                   /*  1 */
   name, parent
 ) VALUES (
 INSERT INTO groups (                   /*  1 */
   name, parent
 ) VALUES (

-  'Default Debian i686', 6
+  'Debian i686', 6

 );
 
 INSERT INTO groups (                   /*  2 */
   name, parent
 ) VALUES (
 );
 
 INSERT INTO groups (                   /*  2 */
   name, parent
 ) VALUES (

-  'Default Debian x86_64', 6
+  'Debian x86_64', 6

 );
 
 INSERT INTO groups (                   /*  3 */
   name, parent
 ) VALUES (
 );
 
 INSERT INTO groups (                   /*  3 */
   name, parent
 ) VALUES (

-  'Default Ubuntu i686', 6
+  'Ubuntu i686', 6

 );
 
 INSERT INTO groups (                   /*  4 */
   name, parent
 ) VALUES (
 );
 
 INSERT INTO groups (                   /*  4 */
   name, parent
 ) VALUES (

-  'Default Ubuntu x86_64', 6
+  'Ubuntu x86_64', 6

 );
 
 INSERT INTO groups (                   /*  5 */
   name, parent
 ) VALUES (
 );
 
 INSERT INTO groups (                   /*  5 */
   name, parent
 ) VALUES (

-  'Default Android', 7
+  'Android', 7

 );
 
 INSERT INTO groups (                   /*  6 */
   name, parent
 ) VALUES (
 );
 
 INSERT INTO groups (                   /*  6 */
   name, parent
 ) VALUES (

-  'Default Linux', 7
+  'Linux', 7

 );
 
 INSERT INTO groups (                   /*  7 */
 );
 
 INSERT INTO groups (                   /*  7 */


@@ -726,7 +726,7 @@ INSERT INTO enforcements (
 INSERT INTO enforcements (
   policy, group_id, max_age
 ) VALUES (
 INSERT INTO enforcements (
   policy, group_id, max_age
 ) VALUES (

-  7, 2, 86400
+  7, 6, 86400

 );
 
 INSERT INTO enforcements (
 );
 
 INSERT INTO enforcements (


@@ -744,13 +744,13 @@ INSERT INTO enforcements (
 INSERT INTO enforcements (
   policy, group_id, max_age
 ) VALUES (
 INSERT INTO enforcements (
   policy, group_id, max_age
 ) VALUES (

-  10, 2, 60
+  10, 6, 60

 );
 
 INSERT INTO enforcements (
   policy, group_id, max_age
 ) VALUES (
 );
 
 INSERT INTO enforcements (
   policy, group_id, max_age
 ) VALUES (

-  11, 2, 86400
+  11, 6, 86400

 );
 
 INSERT INTO enforcements (
 );
 
 INSERT INTO enforcements (

diff --git a/src/libimcv/imv/tables.sql b/src/libimcv/imv/tables.sql
index 8e8d421..29d99ca 100644 (file)
--- a/src/libimcv/imv/tables.sql
+++ b/src/libimcv/imv/tables.sql
@@ -214,7 +214,7 @@ CREATE INDEX versions_package_product ON versions (
 DROP TABLE IF EXISTS devices;
 CREATE TABLE devices (
   id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 DROP TABLE IF EXISTS devices;
 CREATE TABLE devices (
   id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,

-  description TEXT,
+  description TEXT DEFAULT '',

   value BLOB NOT NULL,
   product INTEGER REFERENCES products(id),
   created INTEGER
   value BLOB NOT NULL,
   product INTEGER REFERENCES products(id),
   created INTEGER