[795] | 1 | <?php |
---|
| 2 | /**************************************************************************\ |
---|
| 3 | * eGroupWare - Setup * |
---|
| 4 | * http://www.egroupware.org * |
---|
| 5 | * -------------------------------------------- * |
---|
| 6 | * This program is free software; you can redistribute it and/or modify it * |
---|
| 7 | * under the terms of the GNU General Public License as published by the * |
---|
| 8 | * Free Software Foundation; either version 2 of the License, or (at your * |
---|
| 9 | * option) any later version. * |
---|
| 10 | \**************************************************************************/ |
---|
| 11 | |
---|
| 12 | function extractDatabaseParameters() |
---|
| 13 | { |
---|
| 14 | /* extract the database connection parameters */ |
---|
| 15 | |
---|
| 16 | $workflowHostInfo = array(); |
---|
| 17 | if (!empty($GLOBALS['phpgw']->ADOdb->database)) |
---|
| 18 | { |
---|
| 19 | $workflowHostInfo = array( |
---|
| 20 | 'dbname' => $GLOBALS['phpgw']->ADOdb->database, |
---|
| 21 | 'host' => $GLOBALS['phpgw']->ADOdb->host, |
---|
[1981] | 22 | 'port' => $GLOBALS['phpgw']->ADOdb->port, |
---|
[795] | 23 | 'user' => $GLOBALS['phpgw']->ADOdb->user, |
---|
| 24 | 'password' => $GLOBALS['phpgw']->ADOdb->password); |
---|
| 25 | } |
---|
| 26 | else |
---|
| 27 | { |
---|
| 28 | $hostInfo = "dbname= host= password= port= user= " . $GLOBALS['phpgw']->ADOdb->host; |
---|
| 29 | $hostInfo = explode(' ', $hostInfo); |
---|
| 30 | foreach ($hostInfo as $parameter) |
---|
| 31 | { |
---|
| 32 | $currentParameter = explode('=', $parameter); |
---|
| 33 | $workflowHostInfo[$currentParameter[0]] = isset($currentParameter[1]) ? $currentParameter[1] : ""; |
---|
| 34 | } |
---|
| 35 | } |
---|
| 36 | if (($workflowHostInfo['password']{0} == "'") && ($workflowHostInfo['password']{strlen($workflowHostInfo['password'])-1} == "'")) |
---|
| 37 | $workflowHostInfo['password'] = substr($workflowHostInfo['password'], 1, strlen($workflowHostInfo['password']) - 2); |
---|
| 38 | |
---|
| 39 | return $workflowHostInfo; |
---|
| 40 | } |
---|
[3167] | 41 | |
---|
[3031] | 42 | // Since Expresso 1.2 using Workflow 1.8.04.000 |
---|
[1229] | 43 | $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 | { |
---|
[1275] | 49 | $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)'); |
---|
[1229] | 50 | } |
---|
| 51 | |
---|
| 52 | #updating the current version |
---|
| 53 | $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.05.000'; |
---|
| 54 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 55 | } |
---|
[1275] | 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; |
---|
[1981] | 67 | if ($workflowDB->connect($workflowHostInfo['host'].":".$workflowHostInfo['port'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow')) |
---|
[1275] | 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 */ |
---|
[1981] | 93 | $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'].":".$workflowHostInfo['port'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']); |
---|
[1275] | 94 | } |
---|
| 95 | #updating the current version |
---|
[1328] | 96 | $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 version |
---|
[1324] | 104 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.000'; |
---|
[1275] | 105 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 106 | } |
---|
[1728] | 107 | $test[] = '2.0.000'; |
---|
| 108 | function workflow_upgrade2_0_000() |
---|
| 109 | { |
---|
| 110 | #updating the current version |
---|
[1835] | 111 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.001'; |
---|
| 112 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 113 | } |
---|
| 114 | $test[] = '2.0.001'; |
---|
| 115 | function workflow_upgrade2_0_001() |
---|
| 116 | { |
---|
| 117 | #updating the current version |
---|
[1979] | 118 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.002'; |
---|
| 119 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 120 | } |
---|
| 121 | $test[] = '2.0.002'; |
---|
| 122 | function workflow_upgrade2_0_002() |
---|
| 123 | { |
---|
| 124 | #updating the current version |
---|
[3031] | 125 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.003'; |
---|
| 126 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 127 | } |
---|
| 128 | $test[] = '2.0.003'; |
---|
| 129 | function workflow_upgrade2_0_003() |
---|
| 130 | { |
---|
| 131 | #updating the current version |
---|
| 132 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.004'; |
---|
| 133 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
[3167] | 134 | } |
---|
[3031] | 135 | $test[] = '2.0.004'; |
---|
| 136 | function workflow_upgrade2_0_004() |
---|
| 137 | { |
---|
| 138 | #updating the current version |
---|
[1728] | 139 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.1.000'; |
---|
| 140 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 141 | } |
---|
[3031] | 142 | $test[] = '2.1.000'; |
---|
| 143 | function workflow_upgrade2_1_000() |
---|
| 144 | { |
---|
[3167] | 145 | if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly) |
---|
| 146 | { |
---|
| 147 | /* updating log level */ |
---|
| 148 | $values = array('0', 'workflow', 'log_level'); |
---|
| 149 | $GLOBALS['phpgw']->ADOdb->query('UPDATE phpgw_config SET config_value=? WHERE config_app=? AND config_name=?', $values); |
---|
| 150 | |
---|
| 151 | $workflowHostInfo = extractDatabaseParameters(); |
---|
| 152 | |
---|
| 153 | /* connect to workflow database */ |
---|
| 154 | $workflowDB = $GLOBALS['phpgw']->ADOdb; |
---|
| 155 | if ($workflowDB->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow')) |
---|
| 156 | { |
---|
| 157 | /* creating table substitution */ |
---|
| 158 | $workflowDB->query('CREATE TABLE substituicao (substituicao_id serial NOT NULL, area_id integer NOT NULL, funcionario_id integer NOT NULL, data_inicio date NOT NULL, data_fim date NOT NULL)'); |
---|
| 159 | |
---|
| 160 | $workflowDB->query('ALTER TABLE ONLY public.substituicao ADD CONSTRAINT substituicao_pkey PRIMARY KEY (substituicao_id)'); |
---|
| 161 | $workflowDB->query('ALTER TABLE ONLY public.substituicao ADD CONSTRAINT "$1" FOREIGN KEY (area_id) REFERENCES area(area_id)'); |
---|
| 162 | $workflowDB->query('ALTER TABLE ONLY public.substituicao ADD CONSTRAINT "$2" FOREIGN KEY (funcionario_id) REFERENCES funcionario(funcionario_id)'); |
---|
| 163 | |
---|
| 164 | /* granting privilegies */ |
---|
| 165 | $workflowDB->query("GRANT ALL ON TABLE public.substituicao TO admin_workflow"); |
---|
| 166 | $workflowDB->query("GRANT ALL ON TABLE public.substituicao TO postgres"); |
---|
| 167 | $workflowDB->query("GRANT SELECT ON TABLE public.substituicao TO public"); |
---|
| 168 | $workflowDB->query("GRANT ALL ON TABLE public.substituicao_substituicao_id_seq TO admin_workflow"); |
---|
| 169 | $workflowDB->query("GRANT ALL ON TABLE public.substituicao_substituicao_id_seq TO postgres"); |
---|
| 170 | $workflowDB->query("GRANT SELECT ON TABLE public.substituicao_substituicao_id_seq TO public"); |
---|
| 171 | |
---|
| 172 | /* migrating records */ |
---|
| 173 | $result = $workflowDB->query('SELECT area_id, substituto_funcionario_id FROM area WHERE substituto_funcionario_id IS NOT NULL'); |
---|
| 174 | if ($result) |
---|
| 175 | while ($row = $result->fetchRow()) { |
---|
| 176 | $values = array($row['area_id'], $row['substituto_funcionario_id']); |
---|
| 177 | $workflowDB->query('INSERT INTO substituicao (area_id, funcionario_id, data_inicio, data_fim) VALUES (?, ?, CURRENT_DATE, CURRENT_DATE+integer \'7\')', $values); |
---|
| 178 | } |
---|
| 179 | |
---|
| 180 | |
---|
| 181 | /* erasing old atributes */ |
---|
| 182 | $workflowDB->query("ALTER TABLE area DROP COLUMN substituto_funcionario_id"); |
---|
| 183 | } |
---|
| 184 | |
---|
| 185 | /* reconnect to the previous database */ |
---|
| 186 | $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']); |
---|
| 187 | |
---|
| 188 | /* removing primary key of egw_wf_interinstance_relations */ |
---|
| 189 | $GLOBALS['phpgw']->ADOdb->query('ALTER TABLE egw_wf_interinstance_relations DROP CONSTRAINT egw_wf_interinstance_relations_pkey'); |
---|
| 190 | |
---|
| 191 | /* removing wf_parent_activity_id column from egw_wf_interinstance_relations table */ |
---|
| 192 | $GLOBALS['phpgw']->ADOdb->query('ALTER TABLE egw_wf_interinstance_relations DROP COLUMN wf_parent_activity_id'); |
---|
| 193 | |
---|
| 194 | /* adding primary key without the column removed */ |
---|
| 195 | $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)'); |
---|
[3255] | 196 | |
---|
| 197 | /* Update the organogram level of administration off all users from 0 to 1. */ |
---|
| 198 | $GLOBALS['phpgw']->ADOdb->query('UPDATE egw_wf_admin_access set nivel = 1 WHERE tipo = \'ORG\' and nivel = 0'); |
---|
[3167] | 199 | } |
---|
| 200 | |
---|
| 201 | #updating the current version |
---|
[3031] | 202 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.2.000'; |
---|
| 203 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
[3167] | 204 | } |
---|
[4186] | 205 | $test[] = '2.2.000'; |
---|
| 206 | function workflow_upgrade2_2_000() |
---|
| 207 | { |
---|
| 208 | #updating the current version |
---|
| 209 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.2.1'; |
---|
| 210 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 211 | } |
---|
[5311] | 212 | $test[] = '2.2.1'; |
---|
| 213 | function workflow_upgrade2_2_1() |
---|
[5307] | 214 | { |
---|
| 215 | #updating the current version |
---|
[5311] | 216 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.2.6'; |
---|
| 217 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 218 | } |
---|
| 219 | $test[] = '2.2.6'; |
---|
| 220 | function workflow_upgrade2_2_6() |
---|
| 221 | { |
---|
| 222 | #updating the current version |
---|
| 223 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.3.0'; |
---|
| 224 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 225 | } |
---|
| 226 | $test[] = '2.3.0'; |
---|
| 227 | function workflow_upgrade2_3_0() |
---|
| 228 | { |
---|
| 229 | #updating the current version |
---|
[5307] | 230 | |
---|
| 231 | $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 | |
---|
| 235 | $workflowHostInfo = extractDatabaseParameters(); |
---|
| 236 | |
---|
| 237 | /* connect to workflow database */ |
---|
| 238 | $workflowDB = $GLOBALS['phpgw']->ADOdb; |
---|
| 239 | if ($workflowDB->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow')) |
---|
| 240 | { |
---|
| 241 | /* creating table substitution */ |
---|
| 242 | $workflowDB->query('CREATE SCHEMA listagem AUTHORIZATION postgres; GRANT ALL ON SCHEMA listagem TO postgres; GRANT ALL ON SCHEMA listagem TO admin_workflow;'); |
---|
| 243 | |
---|
| 244 | $workflowDB->query("CREATE TABLE listagem.listagem |
---|
| 245 | ( |
---|
| 246 | lstoid serial NOT NULL, |
---|
| 247 | lstversao integer, |
---|
| 248 | lstidlistagem text NOT NULL, |
---|
| 249 | lstdescricao text, |
---|
| 250 | lstnome text NOT NULL, |
---|
| 251 | lsttitulo text NOT NULL, |
---|
| 252 | lstsql text, |
---|
| 253 | lstexibe_header boolean, |
---|
| 254 | lstexibe_totalizadores boolean, |
---|
| 255 | lstexibe_subtotais boolean, |
---|
| 256 | lstexibe_qtdregistros boolean, |
---|
| 257 | lstexibe_checkbox boolean, |
---|
| 258 | lstexibe_csv boolean, |
---|
| 259 | lstexibe_legendatopo boolean, |
---|
| 260 | lstexibe_legendarodape boolean, |
---|
| 261 | lstexibe_titagrupamento boolean, |
---|
| 262 | lstexibe_agrupamento_alfabetico boolean, |
---|
| 263 | lstagrupamento_campo text, |
---|
| 264 | lstagrupamento_titulo text, |
---|
| 265 | lstmsg_totalizador text DEFAULT 'TOTAL:'::text, |
---|
| 266 | lstmsg_subtotalizador text DEFAULT 'SUB-TOTAL:'::text, |
---|
| 267 | lstmsg_registrosencontrados text DEFAULT 'registro(s) encontrado(s).'::text, |
---|
| 268 | lstmsg_nenhumresultado text DEFAULT 'Nenhum resultado encontrado.'::text, |
---|
| 269 | lstexclusao timestamp without time zone, |
---|
| 270 | lstexibe_resultados boolean DEFAULT true, |
---|
| 271 | CONSTRAINT lstoid_pkey PRIMARY KEY (lstoid) |
---|
| 272 | ) |
---|
| 273 | WITHOUT OIDS; |
---|
| 274 | ALTER TABLE listagem.listagem OWNER TO postgres; |
---|
| 275 | GRANT ALL ON TABLE listagem.listagem TO postgres; |
---|
| 276 | GRANT ALL ON TABLE listagem.listagem TO admin_workflow;"); |
---|
| 277 | |
---|
| 278 | |
---|
| 279 | $workflowDB->query("CREATE TABLE listagem.listagem_coluna |
---|
| 280 | ( |
---|
| 281 | lslcoid serial NOT NULL, |
---|
| 282 | lslclstoid integer NOT NULL, |
---|
| 283 | lslcidcoluna text NOT NULL, |
---|
| 284 | lslcordem integer, |
---|
| 285 | lslctipo text, |
---|
| 286 | lslctitulo text, |
---|
| 287 | lslchtml text, |
---|
| 288 | lslcalign character varying(10), |
---|
| 289 | lslcwidth character varying(10), |
---|
| 290 | lslcnowrap boolean, |
---|
| 291 | lslcvisivel boolean, |
---|
| 292 | lslcexibe_csv boolean, |
---|
| 293 | lslccalculada boolean, |
---|
| 294 | lslccheckbox boolean, |
---|
| 295 | lslclink text, |
---|
| 296 | lslclink_blank boolean, |
---|
| 297 | lslclink_condicao text DEFAULT '1'::text, |
---|
| 298 | lslctotalizador_condicao text DEFAULT '1'::text, |
---|
| 299 | lslcsubtotalizador_condicao text DEFAULT '1'::text, |
---|
| 300 | lslccheckbox_condicao text DEFAULT '1'::text, |
---|
| 301 | CONSTRAINT lslcoid_pkey PRIMARY KEY (lslcoid), |
---|
| 302 | CONSTRAINT listagem_coluna_lslclstoid_fkey FOREIGN KEY (lslclstoid) |
---|
| 303 | REFERENCES listagem.listagem (lstoid) MATCH SIMPLE |
---|
| 304 | ON UPDATE NO ACTION ON DELETE NO ACTION |
---|
| 305 | ) |
---|
| 306 | WITHOUT OIDS; |
---|
| 307 | ALTER TABLE listagem.listagem_coluna OWNER TO postgres; |
---|
| 308 | GRANT ALL ON TABLE listagem.listagem_coluna TO postgres; |
---|
| 309 | GRANT ALL ON TABLE listagem.listagem_coluna TO admin_workflow;"); |
---|
| 310 | |
---|
| 311 | |
---|
| 312 | $workflowDB->query("CREATE TABLE listagem.listagem_indicador |
---|
| 313 | ( |
---|
| 314 | lsioid serial NOT NULL, |
---|
| 315 | lsilstoid integer NOT NULL, |
---|
| 316 | lsiidindicador text, |
---|
| 317 | lsitipo character(1), |
---|
| 318 | lsiimagem text, |
---|
| 319 | lsilegenda text, |
---|
| 320 | lsilegenda_csv text, |
---|
| 321 | lsicondicao text DEFAULT '1'::text, |
---|
| 322 | CONSTRAINT lsioid_pkey PRIMARY KEY (lsioid), |
---|
| 323 | CONSTRAINT listagem_indicador_lsilstoid_fkey FOREIGN KEY (lsilstoid) |
---|
| 324 | REFERENCES listagem.listagem (lstoid) MATCH SIMPLE |
---|
| 325 | ON UPDATE NO ACTION ON DELETE NO ACTION |
---|
| 326 | ) |
---|
| 327 | WITHOUT OIDS; |
---|
| 328 | ALTER TABLE listagem.listagem_indicador OWNER TO postgres; |
---|
| 329 | GRANT ALL ON TABLE listagem.listagem_indicador TO postgres; |
---|
| 330 | GRANT ALL ON TABLE listagem.listagem_indicador TO admin_workflow;"); |
---|
| 331 | |
---|
| 332 | |
---|
| 333 | $workflowDB->query("CREATE TABLE listagem.listagem_parametro |
---|
| 334 | ( |
---|
| 335 | lspoid serial NOT NULL, |
---|
| 336 | lsplstoid integer NOT NULL, |
---|
| 337 | lspidparametro text, |
---|
| 338 | lsptitulo text, |
---|
| 339 | lsptipo text, |
---|
| 340 | lspvalor_padrao text, |
---|
| 341 | lspobrigatorio boolean, |
---|
| 342 | CONSTRAINT lspoid_pkey PRIMARY KEY (lspoid), |
---|
| 343 | CONSTRAINT listagem_parametro_lsplstoid_fkey FOREIGN KEY (lsplstoid) |
---|
| 344 | REFERENCES listagem.listagem (lstoid) MATCH SIMPLE |
---|
| 345 | ON UPDATE NO ACTION ON DELETE NO ACTION |
---|
| 346 | ) |
---|
| 347 | WITHOUT OIDS; |
---|
| 348 | ALTER TABLE listagem.listagem_parametro OWNER TO postgres; |
---|
| 349 | GRANT ALL ON TABLE listagem.listagem_parametro TO postgres; |
---|
| 350 | GRANT ALL ON TABLE listagem.listagem_parametro TO admin_workflow;"); |
---|
| 351 | |
---|
| 352 | |
---|
| 353 | |
---|
| 354 | |
---|
| 355 | $workflowDB->query("CREATE SEQUENCE listagem.listagem_coluna_lslcoid_seq |
---|
| 356 | INCREMENT 1 |
---|
| 357 | MINVALUE 1 |
---|
| 358 | MAXVALUE 9223372036854775807 |
---|
| 359 | START 1 |
---|
| 360 | CACHE 1; |
---|
| 361 | ALTER TABLE listagem.listagem_coluna_lslcoid_seq OWNER TO postgres; |
---|
| 362 | |
---|
| 363 | |
---|
| 364 | CREATE SEQUENCE listagem.listagem_indicador_lsioid_seq |
---|
| 365 | INCREMENT 1 |
---|
| 366 | MINVALUE 1 |
---|
| 367 | MAXVALUE 9223372036854775807 |
---|
| 368 | START 1 |
---|
| 369 | CACHE 1; |
---|
| 370 | ALTER TABLE listagem.listagem_indicador_lsioid_seq OWNER TO postgres; |
---|
| 371 | |
---|
| 372 | |
---|
| 373 | CREATE SEQUENCE listagem.listagem_lstoid_seq |
---|
| 374 | INCREMENT 1 |
---|
| 375 | MINVALUE 1 |
---|
| 376 | MAXVALUE 9223372036854775807 |
---|
| 377 | START 1 |
---|
| 378 | CACHE 1; |
---|
| 379 | ALTER TABLE listagem.listagem_lstoid_seq OWNER TO postgres; |
---|
| 380 | |
---|
| 381 | |
---|
| 382 | CREATE SEQUENCE listagem.listagem_parametro_lspoid_seq |
---|
| 383 | INCREMENT 1 |
---|
| 384 | MINVALUE 1 |
---|
| 385 | MAXVALUE 9223372036854775807 |
---|
| 386 | START 1 |
---|
| 387 | CACHE 1; |
---|
| 388 | ALTER TABLE listagem.listagem_parametro_lspoid_seq OWNER TO postgres;"); |
---|
| 389 | |
---|
| 390 | |
---|
| 391 | } |
---|
| 392 | |
---|
| 393 | |
---|
| 394 | $GLOBALS['setup_info']['workflow']['currentver'] = '2.4.0'; |
---|
| 395 | return $GLOBALS['setup_info']['workflow']['currentver']; |
---|
| 396 | } |
---|
[5311] | 397 | ?> |
---|