From 917269a5d173b18110816592a5e309903bf5e972 Mon Sep 17 00:00:00 2001
From: Christian Bayle <cbayle@gmail.com>
Date: Tue, 30 Mar 2010 08:19:15 +0000
Subject: [PATCH] Add system event table

---
 .gitattributes                          |  1 +
 gforge/db/20100330-add-system-event.sql | 20 ++++++++++++++++++++
 gforge/deb-specific/db-upgrade.pl       |  2 ++
 3 files changed, 23 insertions(+)
 create mode 100644 gforge/db/20100330-add-system-event.sql

diff --git a/.gitattributes b/.gitattributes
index 4524ce9e3f..3ecf988b44 100644
--- a/.gitattributes
+++ b/.gitattributes
@@ -92,6 +92,7 @@ gforge/db/20090507-browse_list.sql -text
 gforge/db/20090507-install_workflow.php -text
 gforge/db/20100308-drop-forum-attachment-type.sql -text
 gforge/db/20100308-forum-attachment-types.sql -text
+gforge/db/20100330-add-system-event.sql -text
 gforge/db/FTI-20061025.sql -text
 gforge/db/gforge-data-mysql.sql -text
 gforge/db/gforge-struct-mysql.sql -text
diff --git a/gforge/db/20100330-add-system-event.sql b/gforge/db/20100330-add-system-event.sql
new file mode 100644
index 0000000000..ccce98e52f
--- /dev/null
+++ b/gforge/db/20100330-add-system-event.sql
@@ -0,0 +1,20 @@
+CREATE SEQUENCE system_event_pk_seq
+    START WITH 1
+    INCREMENT BY 1
+    MAXVALUE 2147483647
+    NO MINVALUE
+    CACHE 1;
+
+
+
+CREATE TABLE system_event (
+    id integer DEFAULT nextval('system_event_pk_seq'::text) NOT NULL,
+    type character varying(16),
+    parameters text,
+    priority integer DEFAULT 0 NOT NULL,
+    status integer DEFAULT 1 NOT NULL,
+    log text,
+    create_date integer DEFAULT 0,
+    process_date integer DEFAULT 0,
+    end_date integer DEFAULT 0,
+);
diff --git a/gforge/deb-specific/db-upgrade.pl b/gforge/deb-specific/db-upgrade.pl
index 631a63c9c6..787c817f38 100644
--- a/gforge/deb-specific/db-upgrade.pl
+++ b/gforge/deb-specific/db-upgrade.pl
@@ -2905,6 +2905,8 @@ eval {
 
     &update_with_sql("20100308-forum-attachment-types","4.8.99-6");
 
+    &update_with_sql("20100330-add-system-event","5.0.0-1");
+
     ########################### INSERT HERE #################################
 
     &debug ("It seems your database $action went well and smoothly. That's cool.") ;
-- 
2.30.2