Changeset 4181
- Timestamp:
- 04/29/11 10:53:14 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.2.0.1/filemanager/setup/default_records.inc.php
r3956 r4181 11 11 12 12 // CREATE TABLE PHPGW_VFS 13 $oProc->query("CREATE TABLE phpgw_vfs ( file_id integer DEFAULT nextval(('seq_phpgw_vfs'::text)::regclass) NOT NULL, 13 $res_exists = $oProc->query("select count(*) from information_schema.tables where table_name = 'phpgw_vfs'"); 14 $oProc->next_record(); 15 if(!$oProc->f(0)) { 16 $oProc->query("CREATE TABLE phpgw_vfs ( file_id integer DEFAULT nextval(('seq_phpgw_vfs'::text)::regclass) NOT NULL, 14 17 owner_id integer NOT NULL, 15 18 createdby_id integer, … … 32 35 );"); 33 36 37 // CREATE SEQUENCE 38 $oProc->query("CREATE SEQUENCE seq_phpgw_vfs INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;"); 39 40 // SET VALUE SEQUENCE 41 $oProc->query("SELECT pg_catalog.setval('seq_phpgw_vfs', 4, true);"); 42 } 43 34 44 // CREATE TABLE PHPGW_VFS_QUOTA 35 45 $oProc->query("CREATE TABLE phpgw_vfs_quota (directory VARCHAR(100), quota_size INT NOT NULL, PRIMARY KEY (directory));"); 36 46 37 // CREATE SEQUENCE38 $oProc->query("CREATE SEQUENCE seq_phpgw_vfs INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;");39 40 // SET VALUE SEQUENCE41 $oProc->query("SELECT pg_catalog.setval('seq_phpgw_vfs', 4, true);");42 43 47 // DELETE 44 48 $oProc->query("DELETE FROM phpgw_config WHERE config_app = 'filemanager';");
Note: See TracChangeset
for help on using the changeset viewer.