Changeset 3618

Timestamp:

12/21/10 17:06:07 (13 years ago)

Author:

alexandrecorreia

Message:

Ticket #1467 - Erro na remocao e instalacao do FileManager? pelo Setup

Location:

branches/2.2/filemanager/setup

Files:

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

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

@@ -10 +10 @@
   \**************************************************************************/
 
-  /* $Id: default_records.inc.php 15588 2004-07-02 22:19:56Z ralfbecker $ */
-        $oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_quota_size',500)");
-        $oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_Max_file_size',20)");
-        $oProc->query('INSERT INTO phpgw_preferences VALUES (-2,\'filemanager\',\'a:19:{s:4:"name";s:1:"1";s:9:"mime_type";s:1:"1";s:4:"size";s:1:"1";s:7:"created";s:1:"1";s:8:"modified";s:1:"1";s:5:"owner";s:1:"1";s:12:"createdby_id";s:1:"1";s:13:"modifiedby_id";s:1:"1";s:3:"app";s:1:"0";s:7:"comment";s:1:"1";s:7:"version";s:1:"1";s:12:"viewinnewwin";s:1:"1";s:12:"viewonserver";s:1:"1";s:13:"viewtextplain";s:1:"1";s:6:"dotdot";s:1:"1";s:8:"dotfiles";s:1:"1";s:8:"pdf_type";s:8:"portrait";s:14:"pdf_paper_type";s:2:"a4";s:14:"files_per_page";s:3:"200";}\')');
-        $oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (1,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','', NULL, NULL)");
-        $oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (2,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','home', NULL, NULL)");
-
-
+        // 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
+        $oProc->query("CREATE TABLE phpgw_vfs_quota (directory VARCHAR(100), quota_size INT NOT NULL, PRIMARY KEY (directory));");
+        
+        // DELETE
+        $oProc->query("DELETE FROM phpgw_config WHERE config_app = 'filemanager';");
+        $oProc->query("DELETE FROM phpgw_preferences WHERE preference_app = 'filemanager';");
+        
+        // INSERT
+        $oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_quota_size',500);");
+        $oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_Max_file_size',20);");
+        $oProc->query('INSERT INTO phpgw_preferences VALUES (-2,\'filemanager\',\'a:19:{s:4:"name";s:1:"1";s:9:"mime_type";s:1:"1";s:4:"size";s:1:"1";s:7:"created";s:1:"1";s:8:"modified";s:1:"1";s:5:"owner";s:1:"1";s:12:"createdby_id";s:1:"1";s:13:"modifiedby_id";s:1:"1";s:3:"app";s:1:"0";s:7:"comment";s:1:"1";s:7:"version";s:1:"1";s:12:"viewinnewwin";s:1:"1";s:12:"viewonserver";s:1:"1";s:13:"viewtextplain";s:1:"1";s:6:"dotdot";s:1:"1";s:8:"dotfiles";s:1:"1";s:8:"pdf_type";s:8:"portrait";s:14:"pdf_paper_type";s:2:"a4";s:14:"files_per_page";s:3:"200";}\');');
+        $oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (1,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','', NULL, NULL);");
+        $oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (2,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','home', NULL, NULL);");
 
 ?>

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

@@ -23 +23 @@
         $setup_info['filemanager']['description'] = 'Great filemanager with good resources.';
         $setup_info['filemanager']['note'] = 'Bassed on egw filemanager 1.0 changes by Alexandre Felipe Muller de Souza';
-        $setup_info['filemanager']['maintainer'] = array(
-                'name'  => 'Alexandre Felipe Muller de Souza',
-                'email' => 'amuller@celepar.pr.gov.br'
-        );
+        $setup_info['filemanager']['maintainer'] =  'Alexandre Felipe Muller de Souza <br/>' .
+                                                                                            'Alexandre Luiz Correia <br/> ' .
+                                                                                            'Fernando Porto Correa <br/>' .
+                                                                                            'Rodrigo Souza';
 
-//      $setup_info['filemanager']['tables'][] = 'phpgw_vfs_fake';
-
+        $setup_info['filemanager']['tables'][] = 'phpgw_vfs_quota';
+        $setup_info['filemanager']['tables'][] = 'phpgw_filemanager_notification';
 
         /* The hooks this app includes, needed for hooks registration */