steffen: server/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts/drivers mysql_create.sql, NONE, 1.1 oci8_create.sql, NONE, 1.1 pgsql_create.sql, NONE, 1.1 turba.sql, NONE, 1.1 wedding.sql, NONE, 1.1
cvs at intevation.de
cvs at intevation.de
Mon Oct 31 12:43:42 CET 2005
- Previous message: steffen: server/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts .htaccess, NONE, 1.1 Turba.reg, NONE, 1.1 create_default_history.php, NONE, 1.1
- Next message: steffen: server/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts/ldap addou, NONE, 1.1 addou.pl, NONE, 1.1 core.schema.patch, NONE, 1.1 rfc2739.schema, NONE, 1.1
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
Author: steffen
Update of /kolabrepository/server/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts/drivers
In directory doto:/tmp/cvs-serv18388/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts/drivers
Added Files:
mysql_create.sql oci8_create.sql pgsql_create.sql turba.sql
wedding.sql
Log Message:
Fbview in separate package
--- NEW FILE: mysql_create.sql ---
-- $Horde: turba/scripts/drivers/mysql_create.sql,v 1.10 2004/02/14 11:13:47 mdjukic Exp $
-- You can simply execute this file in your database.
--
-- Run as:
--
-- $ mysql --user=root --password=<MySQL-root-password> <db name> < mysql_create.sql
CREATE TABLE turba_objects (
object_id VARCHAR(32) NOT NULL,
owner_id VARCHAR(255) NOT NULL,
object_type VARCHAR(255) NOT NULL DEFAULT 'Object',
object_members BLOB,
object_name VARCHAR(255),
object_alias VARCHAR(32),
object_email VARCHAR(255),
object_homeaddress VARCHAR(255),
object_workaddress VARCHAR(255),
object_homephone VARCHAR(25),
object_workphone VARCHAR(25),
object_cellphone VARCHAR(25),
object_fax VARCHAR(25),
object_title VARCHAR(255),
object_company VARCHAR(255),
object_notes TEXT,
object_pgppublickey TEXT,
object_smimepublickey TEXT,
object_freebusyurl VARCHAR(255),
PRIMARY KEY(object_id)
);
CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde at localhost;
--- NEW FILE: oci8_create.sql ---
-- $Horde: turba/scripts/drivers/oci8_create.sql,v 1.2 2003/02/18 05:12:44 chuck Exp $
CREATE TABLE turba_objects (
object_id VARCHAR2(32) NOT NULL,
owner_id VARCHAR2(255) NOT NULL,
object_type VARCHAR2(255) NOT NULL DEFAULT 'Object',
object_members CLOB,
object_name VARCHAR2(255),
object_alias VARCHAR2(32),
object_email VARCHAR2(255),
object_homeaddress VARCHAR2(255),
object_workaddress VARCHAR2(255),
object_homephone VARCHAR2(25),
object_workphone VARCHAR2(25),
object_cellphone VARCHAR2(25),
object_fax VARCHAR2(25),
object_title VARCHAR2(255),
object_company VARCHAR2(255),
object_notes CLOB,
object_pgppublickey CLOB,
object_smimepublickey CLOB,
object_freebusyurl VARCHAR2(255),
PRIMARY KEY(object_id)
);
CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;
--- NEW FILE: pgsql_create.sql ---
-- $Horde: turba/scripts/drivers/pgsql_create.sql,v 1.8 2004/04/08 01:35:53 chuck Exp $
-- You can simply execute this file in your database.
--
-- Run as:
--
-- $ psql -d pgsql_create.sql
CREATE TABLE turba_objects (
object_id VARCHAR(32) NOT NULL,
owner_id VARCHAR(255) NOT NULL,
object_type VARCHAR(255) NOT NULL DEFAULT 'Object',
object_members VARCHAR(4096),
object_name VARCHAR(255),
object_alias VARCHAR(32),
object_email VARCHAR(255),
object_homeaddress VARCHAR(255),
object_workaddress VARCHAR(255),
object_homephone VARCHAR(25),
object_workphone VARCHAR(25),
object_cellphone VARCHAR(25),
object_fax VARCHAR(25),
object_title VARCHAR(255),
object_company VARCHAR(255),
object_notes TEXT,
object_pgppublickey TEXT,
object_smimepublickey TEXT,
object_freebusyurl VARCHAR(255),
PRIMARY KEY(object_id)
);
CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;
--- NEW FILE: turba.sql ---
-- $Horde: turba/scripts/drivers/turba.sql,v 1.17 2003/07/14 16:33:09 mdjukic Exp $
CREATE TABLE turba_objects (
object_id VARCHAR(32) NOT NULL,
owner_id VARCHAR(255) NOT NULL,
object_type VARCHAR(255) NOT NULL DEFAULT 'Object',
object_members BLOB,
object_name VARCHAR(255),
object_alias VARCHAR(32),
object_email VARCHAR(255),
object_homeaddress VARCHAR(255),
object_workaddress VARCHAR(255),
object_homephone VARCHAR(25),
object_workphone VARCHAR(25),
object_cellphone VARCHAR(25),
object_fax VARCHAR(25),
object_title VARCHAR(255),
object_company VARCHAR(255),
object_notes TEXT,
object_pgppublickey TEXT,
object_smimepublickey TEXT,
object_freebusyurl VARCHAR(255),
PRIMARY KEY(object_id)
);
CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;
--- NEW FILE: wedding.sql ---
-- $Horde: turba/scripts/drivers/wedding.sql,v 1.2 2003/04/27 00:28:07 chuck Exp $
CREATE TABLE turba_weddingguests (
object_id VARCHAR(32) NOT NULL DEFAULT '',
owner_id VARCHAR(255) NOT NULL DEFAULT '',
object_type VARCHAR(255) NOT NULL DEFAULT 'Object',
object_members BLOB,
object_name1 VARCHAR(255) DEFAULT NULL,
object_email1 VARCHAR(255) DEFAULT NULL,
object_homeaddress VARCHAR(255) DEFAULT NULL,
object_homephone VARCHAR(25) DEFAULT NULL,
object_meal1 VARCHAR(50) DEFAULT NULL,
object_table VARCHAR(50) DEFAULT NULL,
object_rsvp VARCHAR(50) DEFAULT NULL,
object_brunch_rsvp VARCHAR(50) DEFAULT NULL,
object_gift VARCHAR(100) DEFAULT NULL,
object_thankyou VARCHAR(50) DEFAULT NULL,
object_notes TEXT,
object_meal2 VARCHAR(50) DEFAULT NULL,
object_name2 VARCHAR(255) DEFAULT NULL,
object_email2 VARCHAR(255) DEFAULT NULL,
object_brunch_invited VARCHAR(10) DEFAULT NULL,
PRIMARY KEY (object_id)
);
CREATE INDEX turba_wedding_idx ON turba_weddingguests (owner_id);
GRANT SELECT, INSERT, UPDATE, DELETE ON turba_weddingguests TO horde;
- Previous message: steffen: server/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts .htaccess, NONE, 1.1 Turba.reg, NONE, 1.1 create_default_history.php, NONE, 1.1
- Next message: steffen: server/kolab-horde-fbview/kolab-horde-fbview/fbview/turba/scripts/ldap addou, NONE, 1.1 addou.pl, NONE, 1.1 core.schema.patch, NONE, 1.1 rfc2739.schema, NONE, 1.1
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
More information about the commits
mailing list