File: 1.2_to_2.0.sql

package info (click to toggle)
turba2 2.2.1-2
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 7,332 kB
  • ctags: 2,927
  • sloc: php: 11,046; xml: 1,690; sql: 507; makefile: 62; perl: 17; sh: 1
file content (15 lines) | stat: -rw-r--r-- 490 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
-- You can simply execute this file in your database.
--
-- For MySQL run:
--
-- $ mysql --user=root --password=<MySQL-root-password> <db name> < 1.2_to_2.0.sql
--
-- Or, for PostgreSQL:
--
-- $ psql <db name> -f 1.2_to_2.0.sql


ALTER TABLE turba_objects ADD COLUMN object_uid VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_freebusyurl VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_smimepublickey TEXT;
ALTER TABLE turba_objects ADD COLUMN object_pgppublickey TEXT;