Changeset 68 for trunk/docs/README.UPGRADE

Timestamp:

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

Author:

rainer

Message:

Update trunk to samhain 2.3

File:

• trunk/docs/README.UPGRADE (modified) (1 diff)

trunk/docs/README.UPGRADE

@@ +1 @@
+
+from lower to 2.3.x: database scheme has changed slightly
+
+  -- MySQL:
+        ALTER TABLE samhain.log ADD COLUMN acl_old BLOB;
+        ALTER TABLE samhain.log ADD COLUMN acl_new BLOB;
+
+  -- PostgreSQL:
+        ALTER TABLE samhain.log ADD COLUMN acl_old TEXT;
+        ALTER TABLE samhain.log ADD COLUMN acl_new TEXT;
+
+  -- Oracle:
+        ALTER TABLE samhain.log ADD COLUMN acl_old VARCHAR2(4000);
+        ALTER TABLE samhain.log ADD COLUMN acl_new VARCHAR2(4000);
+        DROP TRIGGER trigger_on_log;
+ 
+
 
 since 2.2.0: server-to-server relay is possible