78 lines
2.3 KiB
SQL
78 lines
2.3 KiB
SQL
-- $Horde: turba/scripts/sql/turba.sql,v 1.1.2.9 2009-10-20 21:44:34 jan Exp $
|
|
|
|
CREATE TABLE IF NOT EXISTS turba_objects (
|
|
object_id VARCHAR(32) NOT NULL,
|
|
owner_id VARCHAR(255) NOT NULL,
|
|
object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
|
|
object_uid VARCHAR(255),
|
|
object_members BLOB,
|
|
object_firstname VARCHAR(255),
|
|
object_lastname VARCHAR(255),
|
|
object_middlenames VARCHAR(255),
|
|
object_nameprefix VARCHAR(32),
|
|
object_namesuffix VARCHAR(32),
|
|
object_alias VARCHAR(32),
|
|
object_photo BLOB,
|
|
object_phototype VARCHAR(10),
|
|
object_bday VARCHAR(10),
|
|
object_homestreet VARCHAR(255),
|
|
object_homepob VARCHAR(10),
|
|
object_homecity VARCHAR(255),
|
|
object_homeprovince VARCHAR(255),
|
|
object_homepostalcode VARCHAR(10),
|
|
object_homecountry VARCHAR(255),
|
|
object_workstreet VARCHAR(255),
|
|
object_workpob VARCHAR(10),
|
|
object_workcity VARCHAR(255),
|
|
object_workprovince VARCHAR(255),
|
|
object_workpostalcode VARCHAR(10),
|
|
object_workcountry VARCHAR(255),
|
|
object_tz VARCHAR(32),
|
|
object_geo VARCHAR(255),
|
|
object_email VARCHAR(255),
|
|
object_homephone VARCHAR(25),
|
|
object_workphone VARCHAR(25),
|
|
object_cellphone VARCHAR(25),
|
|
object_fax VARCHAR(25),
|
|
object_pager VARCHAR(25),
|
|
object_title VARCHAR(255),
|
|
object_role VARCHAR(255),
|
|
object_logo BLOB,
|
|
object_logotype VARCHAR(10),
|
|
object_company VARCHAR(255),
|
|
object_category VARCHAR(80),
|
|
object_notes TEXT,
|
|
object_url VARCHAR(255),
|
|
object_freebusyurl VARCHAR(255),
|
|
object_pgppublickey TEXT,
|
|
object_smimepublickey TEXT,
|
|
PRIMARY KEY(object_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS turba_shares (
|
|
share_id INT NOT NULL,
|
|
share_name VARCHAR(255) NOT NULL,
|
|
share_owner VARCHAR(255) NOT NULL,
|
|
share_flags SMALLINT DEFAULT 0 NOT NULL,
|
|
perm_creator SMALLINT DEFAULT 0 NOT NULL,
|
|
perm_default SMALLINT DEFAULT 0 NOT NULL,
|
|
perm_guest SMALLINT DEFAULT 0 NOT NULL,
|
|
attribute_name VARCHAR(255) NOT NULL,
|
|
attribute_desc VARCHAR(255),
|
|
attribute_params TEXT,
|
|
PRIMARY KEY (share_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS turba_shares_groups (
|
|
share_id INT NOT NULL,
|
|
group_uid VARCHAR(255) NOT NULL,
|
|
perm SMALLINT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS turba_shares_users (
|
|
share_id INT NOT NULL,
|
|
user_uid VARCHAR(255) NOT NULL,
|
|
perm SMALLINT NOT NULL
|
|
);
|
|
|