Changeset 5132 for trunk/calendar/setup/default_records.inc.php
- Timestamp:
- 11/03/11 13:21:19 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/calendar/setup/default_records.inc.php
r3557 r5132 10 10 \**************************************************************************/ 11 11 12 // Alterando dois campos da tabela phpgw_cal e phpgw_cal_holidays13 $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 12 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);"); 18 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);"); 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')");
Note: See TracChangeset
for help on using the changeset viewer.