Changeset 3557


Ignore:
Timestamp:
12/02/10 15:04:03 (13 years ago)
Author:
alexandrecorreia
Message:

Ticket #1016 - Corrigi a instalacao do banco para o modulo Calendario

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.2/calendar/setup/default_records.inc.php

    r2 r3557  
    1010        \**************************************************************************/ 
    1111 
     12    // Alterando dois campos da tabela phpgw_cal e phpgw_cal_holidays 
     13        $oProc->query("ALTER TABLE phpgw_cal ALTER COLUMN cal_id set default nextval(('seq_phpgw_cal'::text)::regclass);"); 
     14        $oProc->query("ALTER TABLE phpgw_cal_holidays ALTER COLUMN hol_id set default nextval(('seq_phpgw_cal_holidays'::text)::regclass);"); 
     15         
     16        $oProc->query("SELECT pg_catalog.setval('seq_phpgw_cal', 1, false);"); 
     17        $oProc->query("SELECT pg_catalog.setval('seq_phpgw_cal_holidays', 1, false);"); 
    1218 
    13         // enable auto-loading of holidays from localhost by default 
    14         $oProc->query("INSERT INTO phpgw_config (config_app, config_name, config_value) VALUES ('phpgwapi','auto_load_holidays','True')"); 
    15         $oProc->query("INSERT INTO phpgw_config (config_app, config_name, config_value) VALUES ('phpgwapi','holidays_url_path','localhost')"); 
     19        // Adicionando dois campos a tabela phpgw_cal 
     20        $oProc->query("ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar;"); 
     21        $oProc->query("ALTER TABLE phpgw_cal ADD COLUMN last_update bigint DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision);"); 
Note: See TracChangeset for help on using the changeset viewer.