Changeset 3956

Timestamp:

04/04/11 17:30:18 (13 years ago)

Author:

alexandrecorreia

Message:

Ticket #1703 - Corrigido erro no filemanager na atualizacao para versao 2 2

Location:

branches/2.2/filemanager/setup

Files:

• default_records.inc.php (modified) (1 diff)
• setup.inc.php (modified) (1 diff)

branches/2.2/filemanager/setup/default_records.inc.php

@@ -10 +10 @@
   \**************************************************************************/
 
-        // ALTER TABLE
-        $oProc->query("ALTER TABLE phpgw_vfs ALTER COLUMN created TYPE timestamp;");
-        $oProc->query("ALTER TABLE phpgw_vfs ALTER COLUMN modified TYPE timestamp;");
+        // CREATE TABLE PHPGW_VFS
+        $oProc->query("CREATE TABLE phpgw_vfs ( file_id integer DEFAULT nextval(('seq_phpgw_vfs'::text)::regclass) NOT NULL,
+                                        owner_id integer NOT NULL,
+                                        createdby_id integer,
+                                        modifiedby_id integer,
+                                        created date DEFAULT '1970-01-01'::date NOT NULL,
+                                        modified date,
+                                        size integer,
+                                        mime_type character varying(64),
+                                        deleteable character(1) DEFAULT 'Y'::bpchar,
+                                        comment character varying(255),
+                                        app character varying(25),
+                                        directory character varying(255),
+                                        name character varying(128) NOT NULL,
+                                        link_directory character varying(255),
+                                        link_name character varying(128),
+                                        version character varying(30) DEFAULT '0.0.0.0'::character varying NOT NULL,
+                                        content text,
+                                        type integer DEFAULT 0,
+                                        summary bytea
+                                        );");
         
-        // CREATE TABLE
+        // CREATE TABLE PHPGW_VFS_QUOTA
         $oProc->query("CREATE TABLE phpgw_vfs_quota (directory VARCHAR(100), quota_size INT NOT NULL, PRIMARY KEY (directory));");
         
+        // CREATE SEQUENCE
+        $oProc->query("CREATE SEQUENCE seq_phpgw_vfs INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;");
+        
+        // SET VALUE SEQUENCE
+        $oProc->query("SELECT pg_catalog.setval('seq_phpgw_vfs', 4, true);");
+
         // DELETE
         $oProc->query("DELETE FROM phpgw_config WHERE config_app = 'filemanager';");

branches/2.2/filemanager/setup/setup.inc.php

@@ -28 +28 @@
     $setup_info['filemanager']['maintainer'] .= 'Coordenador do Projeto : Nilton Emilio Buhrer Neto<br/><br/>'; 
 
-        $setup_info['filemanager']['tables'][] = 'phpgw_vfs_quota';
+        $setup_info['filemanager']['tables'][] = 'phpgw_vfs';
+    $setup_info['filemanager']['tables'][] = 'phpgw_vfs_quota';
         $setup_info['filemanager']['tables'][] = 'phpgw_filemanager_notification';