-- DBA create the database and give access permissions.
--
-- $Log: create.sql,v $
--- Revision 1.5 2003-01-18 08:46:48 arjen
+-- Revision 1.6 2003-01-20 07:29:48 arjen
+-- Added new tables to the database: parameter_class and parameter_notification
+--
+-- Revision 1.5 2003/01/18 08:46:48 arjen
-- Added new records to the 'type_of_issue' table.
-- Changed semantics of actionid 9 in the 'action' table.
--
COPY "db_value" FROM stdin;
-db_version 20
+db_version 21
gcm_daemon_version 1
log_processing 0
\.
--
--
+CREATE TABLE "parameter_class"
+(
+ "name" text, -- Name of the class: see parameter.class
+ "property_name" text,
+ "description" text,
+ "property_type" text, -- STATIC or DYNAMIC
+ "min" float, -- Default minimum value
+ "max" float, -- Default maximum value
+ "notify" boolean, -- Notify if something changes ?
+
+ primary key (name, property_name)
+);
+
+INSERT INTO parameter_class (name, property_name, description, property_type, notify)
+ VALUES ('package', 'version', 'The installed version of the package', 'STATIC', 't');
+
+--
+--
+
+CREATE TABLE "parameter_notification"
+(
+ "notificationid" bigint,
+ "paramid" bigint,
+
+ primary key (notificationid, paramid)
+);
+
+--
+--
+
CREATE TABLE "priority"
(
"priority" integer,
DROP TABLE "parameter";
+DROP TABLE "parameter_class";
+
+DROP TABLE "parameter_notification";
+
DROP TABLE "priority";
DROP TABLE "property";
$local_sql .= " values ('parameter removed',3,'A parameter was removed') ";
$dbms->query($local_sql);
+ case 20:
+ $local_sql = "CREATE TABLE 'parameter_notification' ('notificationid' bigint, 'paramid' bigint, primary key (notificationid, paramid))";
+ $dbms->query($local_sql);
+
+ $local_sql = "CREATE TABLE 'parameter_class' ('name' text, 'property_name' text, 'description' text, 'property_type' text, ";
+ $local_sql .= "'min' float, 'max' float, 'notify' boolean, primary key (name, property_name));";
+ $dbms->query($local_sql);
+
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+ $local_sql .= "VALUES ('package', 'version', 'The installed version of the package', 'STATIC', 't')";
+ $dbms->query($local_sql);
+
+
/*
//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
$local_sql = "ALTER TABLE log DROP COLUMN recognized";
$project_name = "gnucomo"; //name of the entire project
$app_name = "gcm_daemon"; //name of the application running
$developrelease = "FALSE"; //Indicates if special debug settings are needed
-$db_version = 20; //The db_version indicates what the level of
+$db_version = 21; //The db_version indicates what the level of
//the database should be. If the database is
//old an update will be generated.
$gcmd_version = 3; //This value indicates the active version of the gcm_daemon,