This probably isn't the best way to pass across a calendar database schema for
Postgresql, and for that I apologise. However for anyone who wants it, here
is a simple conversion of the MySQL schema that addresses the definition of
the two auto update fields. (I used the daily tar.gz download from
25-april-2000).
Hope someone finds this useful.
Julian.
-- This is a schema for Postgresql for the calendar objects in Jetspeed
--
-- This schema creates the tables needed for the calendar objects and
-- initializes them.
--
-- This schema is imported into Postgresql with the folowing command
-- psql Turbine < Postgres_calendar_v1.0.sql
drop table JETSPEED_VEVENT_OBJECTS;
DROP SEQUENCE vevent_seq;
CREATE SEQUENCE vevent_seq;
create table JETSPEED_VEVENT_OBJECTS (
VEVENT_ID integer DEFAULT nextval('vevent_seq') PRIMARY KEY,
OWNER integer,
READ_PERMISSION integer,
WRITE_PERMISSION integer,
CLASSIFICATION varchar(15),
DATE_CREATED datetime,
DESCRIPTION text,
DTSTART_DATE_TIME datetime,
DTSTART_DATE date,
GEO_LATITUDE float,
GEO_LONGITUDE float,
LAST_MODIFIED datetime,
LOCATION text,
ORGANIZER varchar(80),
PRIORITY integer,
DTSTAMP datetime,
SEQUENCE integer,
STATUS varchar(15),
SUMMARY varchar(80),
TRANSPARENCY varchar(14),
UNIQUE_ID varchar(100),
URL varchar(80),
RECUR_ID_DT datetime,
RECUR_ID_D date,
DTEND_DT datetime,
DTEND_D date,
DURATION integer,
DESC_ALT_REP varchar(80),
DESC_LANG varchar(10),
LOCATION_ALT_REP varchar(80),
LOCATION_LANG varchar(10),
DTSTART_TZID varchar(80),
ORGANIZER_NAME varchar(80),
ORGANIZER_DIR varchar(80),
ORGANIZER_SENTBY varchar(80),
ORGANIZER_LANG varchar(10),
SUMMARY_ALT_REP varchar(80),
SUMMARY_LANG varchar(10),
RECUR_ID_TZID varchar(80),
RECUR_ID_RANGE varchar(16),
DTEND_TZID varchar(80));
drop table JETSPEED_VTODO_OBJECTS;
DROP SEQUENCE vtodo_seq;
CREATE SEQUENCE vtodo_seq;
create table JETSPEED_VTODO_OBJECTS (
VEVENT_ID integer DEFAULT nextval('vtodo_seq') PRIMARY KEY,
OWNER integer,
READ_PERMISSION integer,
WRITE_PERMISSION integer,
CLASSIFICATION varchar(15),
DATE_CREATED datetime,
DESCRIPTION text,
DTSTART_DATE_TIME datetime,
DTSTART_DATE date,
GEO_LATITUDE float,
GEO_LONGITUDE float,
LAST_MODIFIED datetime,
LOCATION text,
ORGANIZER varchar(80),
PRIORITY integer,
DTSTAMP datetime,
SEQUENCE integer,
STATUS varchar(15),
SUMMARY varchar(80),
UNIQUE_ID varchar(100),
URL varchar(80),
RECUR_ID_DT datetime,
RECUR_ID_D date,
DUE_DATE_TIME datetime,
DUE_DATE date,
DURATION integer,
DESC_ALT_REP varchar(80),
DESC_LANG varchar(10),
LOCATION_ALT_REP varchar(80),
LOCATION_LANG varchar(10),
DTSTART_TZID varchar(80),
ORGANIZER_NAME varchar(80),
ORGANIZER_DIR varchar(80),
ORGANIZER_SENTBY varchar(80),
ORGANIZER_LANG varchar(10),
SUMMARY_ALT_REP varchar(80),
SUMMARY_LANG varchar(10),
RECUR_ID_TZID varchar(80),
RECUR_ID_RANGE varchar(16),
DUE_TZID varchar(80),
PERCENT integer,
DATE_COMPLETED datetime
);
-- END --
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
