Changeset 68 for trunk/sql_init

Timestamp:

Oct 30, 2006, 12:03:44 AM (18 years ago)

Author:

rainer

Message:

Update trunk to samhain 2.3

Location:

trunk/sql_init

Files:

• samhain.mysql.init (modified) (1 diff)
• samhain.oracle.init (modified) (1 diff)
• samhain.postgres.init (modified) (1 diff)

trunk/sql_init/samhain.mysql.init

@@ -86 +86 @@
         iowner_new    BIGINT,
         igroup_old    BIGINT,
-        igroup_new    BIGINT
+        igroup_new    BIGINT,
         
 
+        acl_old       BLOB,
+        acl_new       BLOB
                  
         );

trunk/sql_init/samhain.oracle.init

@@ -73 +73 @@
         iowner_new    NUMBER(20),
         igroup_old    NUMBER(20),
-        igroup_new    NUMBER(20)
+        igroup_new    NUMBER(20),
+        acl_old       VARCHAR2(4000),
+        acl_new       VARCHAR2(4000)
         );
-
-CREATE OR REPLACE TRIGGER trigger_on_log
-before insert on log
-for each row
-declare
-log_index integer;
-begin
-select log_log_index_seq.NEXTVAL into :new.log_index from dual;
-end trigger_on_log;
-.
-run;
 
 CREATE UNIQUE INDEX log_log_index_key on log (log_index);

trunk/sql_init/samhain.postgres.init

@@ -80 +80 @@
         iowner_new    BIGINT,
         igroup_old    BIGINT,
-        igroup_new    BIGINT
+        igroup_new    BIGINT,
                  
+        acl_old       TEXT,
+        acl_new       TEXT
         );