source:
branches/2.2.0.1/calendar/setup/default_records.inc.php
@
3557
Revision 3557, 1.5 KB checked in by alexandrecorreia, 14 years ago (diff) | |
---|---|
|
Line | |
---|---|
1 | <?php |
2 | /**************************************************************************\ |
3 | * eGroupWare - Setup / Calendar * |
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 | // 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);"); |
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);"); |
Note: See TracBrowser
for help on using the repository browser.