[Openupload-svn-update] SF.net SVN: openupload:[322] trunk/sql

[<ts...@us...>]

Revision: 322
          http://openupload.svn.sourceforge.net/openupload/?rev=322&view=rev
Author:   tsdogs
Date:     2009-06-09 21:50:43 +0000 (Tue, 09 Jun 2009)

Log Message:
-----------
fix missing activitylog structure, bug #2803132

Modified Paths:
--------------
    trunk/sql/mysql/1_structure.sql
    trunk/sql/pgsql/1_structure.sql

Modified: trunk/sql/mysql/1_structure.sql
===================================================================
--- trunk/sql/mysql/1_structure.sql	2009-06-09 21:50:24 UTC (rev 321)
+++ trunk/sql/mysql/1_structure.sql	2009-06-09 21:50:43 UTC (rev 322)
@@ -155,3 +155,22 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `login` (`login`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
+
+--
+-- Table structure for `activitylog`
+--
+
+CREATE TABLE `activitylog` (
+  `id` int(20) NOT NULL auto_increment,
+  `level` varchar(20) NOT NULL,
+  `log_time` datetime NOT NULL,
+  `ip` varchar(20) NOT NULL,
+  `user_login` varchar(100) NOT NULL,
+  `module` varchar(50) NOT NULL,
+  `action` varchar(50) NOT NULL,
+  `realaction` varchar(50) default NULL,
+  `plugin` varchar(50) default NULL,
+  `result` varchar(100) default NULL,
+  `moreinfo` text,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

Modified: trunk/sql/pgsql/1_structure.sql
===================================================================
--- trunk/sql/pgsql/1_structure.sql	2009-06-09 21:50:24 UTC (rev 321)
+++ trunk/sql/pgsql/1_structure.sql	2009-06-09 21:50:43 UTC (rev 322)
@@ -143,7 +143,25 @@
 );
 
 
+--
+-- Name: activitylog; Type: TABLE; Schema: public; Owner: openupload; Tablespace: 
+--
 
+CREATE TABLE activitylog (
+    id integer NOT NULL,
+    level character varying(20) NOT NULL,
+    log_time timestamp without time zone NOT NULL,
+    ip character varying(20) NOT NULL,
+    user_login character varying(100) NOT NULL,
+    module character varying(50) NOT NULL,
+    action character varying(50) NOT NULL,
+    realaction character varying(50),
+    plugin character varying(50),
+    result character varying(100),
+    moreinfo text
+);
+
+
 --
 -- Name: acl_id_seq; Type: SEQUENCE; Schema: public; Owner: openupload
 --
@@ -257,8 +275,24 @@
 
 ALTER SEQUENCE users_id_seq OWNED BY users.id;
 
+--
+-- Name: activitylog_id_seq; Type: SEQUENCE; Schema: public; Owner: openupload
+--
 
+CREATE SEQUENCE activitylog_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
 --
+-- Name: activitylog_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openupload
+--
+
+ALTER SEQUENCE activitylog_id_seq OWNED BY activitylog.id;
+
+
+--
 -- Name: id; Type: DEFAULT; Schema: public; Owner: openupload
 --
 
@@ -301,6 +335,13 @@
 
 
 --
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openupload
+--
+
+ALTER TABLE activitylog ALTER COLUMN id SET DEFAULT nextval('activitylog_id_seq'::regclass);
+
+
+--
 -- Name: acl_pkey; Type: CONSTRAINT; Schema: public; Owner: openupload; Tablespace: 
 --
 
@@ -371,7 +412,14 @@
 ALTER TABLE ONLY users
     ADD CONSTRAINT users_pkey PRIMARY KEY (id);
 
+--
+-- Name: activitylog_pkey; Type: CONSTRAINT; Schema: public; Owner: openupload; Tablespace: 
+--
 
+ALTER TABLE ONLY activitylog
+    ADD CONSTRAINT activitylog_pkey PRIMARY KEY (id);
+
+
 --
 -- Name: file_id_idx; Type: INDEX; Schema: public; Owner: openupload; Tablespace: 
 --


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.