Changeset 5726 for trunk/workflow/setup/tables_update.inc.php
- Timestamp:
- 03/14/12 18:40:04 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/workflow/setup/tables_update.inc.php
r5311 r5726 40 40 } 41 41 42 // Since Expresso 1.2 using Workflow 1.8.04.00043 $test[] = '1.8.04.000';44 function workflow_upgrade1_8_04_000()45 {46 /* Create index for table egw_wf_workitems */47 if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)48 {49 $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)');50 }51 52 #updating the current version53 $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.05.000';54 return $GLOBALS['setup_info']['workflow']['currentver'];55 }56 57 $test[] = '1.8.05.000';58 function workflow_upgrade1_8_05_000()59 {60 /* Alter tables of orgchart */61 if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)62 {63 $workflowHostInfo = extractDatabaseParameters();64 65 /* connect to workflow database */66 $workflowDB = $GLOBALS['phpgw']->ADOdb;67 if ($workflowDB->connect($workflowHostInfo['host'].":".$workflowHostInfo['port'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow'))68 {69 /* add the new columns */70 $workflowDB->query('ALTER TABLE public.funcionario ADD COLUMN titulo CHARACTER VARYING(30)');71 $workflowDB->query('ALTER TABLE public.organizacao ADD COLUMN sitio CHARACTER VARYING(100)');72 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN empresa CHARACTER VARYING(100)');73 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN endereco CHARACTER VARYING(100)');74 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN complemento CHARACTER VARYING(50)');75 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cep CHARACTER VARYING(9)');76 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN bairro CHARACTER VARYING(30)');77 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cidade CHARACTER VARYING(50)');78 $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN uf CHARACTER(2)');79 80 /* create table telefone */81 $workflowDB->query('CREATE TABLE public.telefone (telefone_id serial NOT NULL, descricao character varying(50) NOT NULL, numero character varying(50) NOT NULL, organizacao_id integer NOT NULL)');82 $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT telefone_pkey PRIMARY KEY (telefone_id)');83 $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id)');84 $workflowDB->query("GRANT ALL ON TABLE public.telefone TO admin_workflow");85 $workflowDB->query("GRANT ALL ON TABLE public.telefone TO postgres");86 $workflowDB->query("GRANT SELECT ON TABLE public.telefone TO public");87 $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO admin_workflow");88 $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO postgres");89 $workflowDB->query("GRANT SELECT ON TABLE public.telefone_telefone_id_seq TO public");90 }91 92 /* reconnect to the previous database */93 $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'].":".$workflowHostInfo['port'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']);94 }95 #updating the current version96 $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.06.000';97 return $GLOBALS['setup_info']['workflow']['currentver'];98 }99 100 $test[] = '1.8.06.000';101 function workflow_upgrade1_8_06_000()102 {103 #updating the current version104 $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.000';105 return $GLOBALS['setup_info']['workflow']['currentver'];106 }107 42 $test[] = '2.0.000'; 108 43 function workflow_upgrade2_0_000() … … 194 129 /* adding primary key without the column removed */ 195 130 $GLOBALS['phpgw']->ADOdb->query('ALTER TABLE egw_wf_interinstance_relations ADD CONSTRAINT egw_wf_interinstance_relations_pkey PRIMARY KEY (wf_parent_instance_id, wf_child_instance_id)'); 196 131 197 132 /* Update the organogram level of administration off all users from 0 to 1. */ 198 133 $GLOBALS['phpgw']->ADOdb->query('UPDATE egw_wf_admin_access set nivel = 1 WHERE tipo = \'ORG\' and nivel = 0'); … … 228 163 { 229 164 #updating the current version 230 165 231 166 $GLOBALS['phpgw']->ADOdb->query("INSERT into phpgw_lang values ('en','workflow','Reports','Reports') "); 232 233 $GLOBALS['phpgw']->ADOdb->query("INSERT into phpgw_lang values ('pt-br','workflow','Reports','Relatórios') "); 234 167 168 $GLOBALS['phpgw']->ADOdb->query("INSERT into phpgw_lang values ('pt-br','workflow','Reports','Relatórios') "); 169 235 170 $workflowHostInfo = extractDatabaseParameters(); 236 171 … … 241 176 /* creating table substitution */ 242 177 $workflowDB->query('CREATE SCHEMA listagem AUTHORIZATION postgres; GRANT ALL ON SCHEMA listagem TO postgres; GRANT ALL ON SCHEMA listagem TO admin_workflow;'); 243 178 244 179 $workflowDB->query("CREATE TABLE listagem.listagem 245 180 ( … … 309 244 GRANT ALL ON TABLE listagem.listagem_coluna TO admin_workflow;"); 310 245 311 246 312 247 $workflowDB->query("CREATE TABLE listagem.listagem_indicador 313 248 ( … … 330 265 GRANT ALL ON TABLE listagem.listagem_indicador TO admin_workflow;"); 331 266 332 267 333 268 $workflowDB->query("CREATE TABLE listagem.listagem_parametro 334 269 ( … … 349 284 GRANT ALL ON TABLE listagem.listagem_parametro TO postgres; 350 285 GRANT ALL ON TABLE listagem.listagem_parametro TO admin_workflow;"); 351 352 353 354 355 286 287 288 289 290 $workflowDB->query("CREATE SEQUENCE listagem.listagem_coluna_lslcoid_seq 356 291 INCREMENT 1 357 292 MINVALUE 1 … … 360 295 CACHE 1; 361 296 ALTER TABLE listagem.listagem_coluna_lslcoid_seq OWNER TO postgres; 362 363 297 298 364 299 CREATE SEQUENCE listagem.listagem_indicador_lsioid_seq 365 300 INCREMENT 1 … … 369 304 CACHE 1; 370 305 ALTER TABLE listagem.listagem_indicador_lsioid_seq OWNER TO postgres; 371 372 306 307 373 308 CREATE SEQUENCE listagem.listagem_lstoid_seq 374 309 INCREMENT 1 … … 378 313 CACHE 1; 379 314 ALTER TABLE listagem.listagem_lstoid_seq OWNER TO postgres; 380 381 315 316 382 317 CREATE SEQUENCE listagem.listagem_parametro_lspoid_seq 383 318 INCREMENT 1 … … 390 325 391 326 } 392 327 393 328 394 329 $GLOBALS['setup_info']['workflow']['currentver'] = '2.4.0';
Note: See TracChangeset
for help on using the changeset viewer.