DIR : /home/kozerus/.cphorde/horde.sqlite
/home/kozerus/.cphorde
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
"id_collection" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)n77}tablehorde_dav_schema_infohorde_dav_schema_infoCREATE TABLE "horde_dav_schema_info" (
"version" int
"user_name" varchar(255) NOT NULL,
"signup_date" int NOT NULL,
"signup_host" varchar(255) NOT NULL,
"signup_data" text NOT NULL,
PRIMARY KEY("user_name")
)9M' indexsqlite_autoindex_horde_signups_1horde_signupsq99tablehorde_core_schema_infohorde_core_schema_infoCREATE TABLE "horde_core_schema_info" (
"version" int
"cache_id" varchar(32) NOT NULL,
"cache_timestamp" int NOT NULL,
"cache_expiration" int NOT NULL,
"cache_data" blob
"version" int
"user_uid" varchar(255) NOT NULL,
"user_pass" varchar(255) NOT NULL,
"user_soft_expiration_date" int,
"user_hard_expiration_date" int,
PRIMARY KEY("user_uid")
)5I# indexsqlite_autoindex_horde_users_1horde_usersq99tablehorde_auth_schema_infohorde_auth_schema_infoCREATE TABLE "horde_auth_schema_info" (
"version" int
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"alarm_id" varchar(255) NOT NULL,
"alarm_uid" varchar(255),
"alarm_start" datetime NOT NULL,
"alarm_end" datetime,
"alarm_methods" varchar(255),
"alarm_params" text,
"alarm_title" varchar(255) NOT NULL,
"alarm_text" text,
"alarm_snooze" datetime,
"alarm_dismissed" int(1) NOT NULL DEFAULT 0,
"alarm_internal" text
"version" int
"user_id" int NOT NULL,
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("user_id", "tag_id")
CREATE TABLE "rampage_tag_stats" (
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("tag_id")
)A
"user_id" int NOT NULL,
"object_id" int NOT NULL,
"tag_id" int NOT NULL,
"created" datetime,
PRIMARY KEY("user_id", "object_id", "tag_id")
"tag_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"tag_name" varchar(255) NOT NULL
"user_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"user_name" varchar(255) NOT NULL
"object_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"object_name" varchar(255) NOT NULL,
"type_id" int NOT NULL
"type_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type_name" varchar(255) NOT NULL
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
"id_collection" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)n77}tablehorde_dav_schema_infohorde_dav_schema_infoCREATE TABLE "horde_dav_schema_info" (
"version" int
"user_name" varchar(255) NOT NULL,
"signup_date" int NOT NULL,
"signup_host" varchar(255) NOT NULL,
"signup_data" text NOT NULL,
PRIMARY KEY("user_name")
)q99tablehorde_core_schema_infohorde_core_schema_infoCREATE TABLE "horde_core_schema_info" (
"version" int
"cache_id" varchar(32) NOT NULL,
"cache_timestamp" int NOT NULL,
"cache_expiration" int NOT NULL,
"cache_data" blob
"version" int
"user_uid" varchar(255) NOT NULL,
"user_pass" varchar(255) NOT NULL,
"user_soft_expiration_date" int,
"user_hard_expiration_date" int,
PRIMARY KEY("user_uid")
)q99tablehorde_auth_schema_infohorde_auth_schema_infoCREATE TABLE "horde_auth_schema_info" (
"version" int
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"alarm_id" varchar(255) NOT NULL,
"alarm_uid" varchar(255),
"alarm_start" datetime NOT NULL,
"alarm_end" datetime,
"alarm_methods" varchar(255),
"alarm_params" text,
"alarm_title" varchar(255) NOT NULL,
"alarm_text" text,
"alarm_snooze" datetime,
"alarm_dismissed" int(1) NOT NULL DEFAULT 0,
"alarm_internal" text
"version" int
"user_id" int NOT NULL,
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("user_id", "tag_id")
CREATE TABLE "rampage_tag_stats" (
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("tag_id")
)A
"user_id" int NOT NULL,
"object_id" int NOT NULL,
"tag_id" int NOT NULL,
"created" datetime,
PRIMARY KEY("user_id", "object_id", "tag_id")
"tag_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"tag_name" varchar(255) NOT NULL
"user_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"user_name" varchar(255) NOT NULL
"object_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"object_name" varchar(255) NOT NULL,
"type_id" int NOT NULL
"type_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type_name" varchar(255) NOT NULL
)h33ytablecontent_schema_infocontent_schema_infoCREATE TABLE "content_schema_info" (
"version" int
"version" int
"task_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"task_queue" varchar(255) NOT NULL,
"task_fields" text NOT NULL
"version" int
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
"pref_uid" varchar(255) NOT NULL,
"pref_scope" varchar(16) NOT NULL DEFAULT '',
"pref_name" varchar(32) NOT NULL,
"pref_value" blob
"version" int
"perm_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"perm_name" varchar(255) NOT NULL,
"perm_parents" varchar(255),
"perm_data" text
"version" int
"lock_id" varchar(36) NOT NULL,
"lock_owner" varchar(255) NOT NULL,
"lock_scope" varchar(32) NOT NULL,
"lock_principal" varchar(255) NOT NULL,
"lock_origin_timestamp" int NOT NULL,
"lock_update_timestamp" int NOT NULL,
"lock_expiry_timestamp" int NOT NULL,
"lock_type" int NOT NULL
)q$99tablehorde_lock_schema_infohorde_lock_schema_info'CREATE TABLE "horde_lock_schema_info" (
"version" int
"data" blob,
"field" varchar(255) NOT NULL,
"messageid" bigint NOT NULL
"data" blob,
"msguid" varchar(255) NOT NULL,
"messageid" bigint NOT NULL
"messageid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"hostspec" varchar(255) NOT NULL,
"mailbox" varchar(255) NOT NULL,
"modified" bigint,
"port" int NOT NULL,
"username" varchar(255) NOT NULL
"version" int
"history_modseq" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL DEFAULT 0,
"history_modseqempty" int NOT NULL DEFAULT 0
"history_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"object_uid" varchar(255) NOT NULL,
"history_action" varchar(32) NOT NULL,
"history_ts" int NOT NULL,
"history_desc" text,
"history_who" varchar(255),
"history_extra" text
"version" int
"group_uid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"group_name" varchar(255) NOT NULL,
"group_parents" varchar(255) NOT NULL,
"group_email" varchar(255)
"group_uid" int NOT NULL,
"user_uid" varchar(255) NOT NULL
"version" int
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"spam_owner" varchar(255) NOT NULL,
"spam_level" int DEFAULT 5,
"spam_folder" varchar(255),
PRIMARY KEY("spam_owner")
"vacation_owner" varchar(255) NOT NULL,
"vacation_addresses" text,
"vacation_subject" varchar(255),
"vacation_reason" text,
"vacation_days" int DEFAULT 7,
"vacation_start" int,
"vacation_end" int,
"vacation_excludes" text,
"vacation_ignorelists" int DEFAULT 1,
PRIMARY KEY("vacation_owner")
"forward_owner" varchar(255) NOT NULL,
"forward_addresses" text,
"forward_keep" int NOT NULL DEFAULT 0
"list_owner" varchar(255) NOT NULL,
"list_blacklist" int DEFAULT 0,
"list_address" varchar(255) NOT NULL
)_9--stableingo_schema_infoingo_schema_info=CREATE TABLE "ingo_schema_info" (
"version" int
"sentmail_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"sentmail_who" varchar(255) NOT NULL,
"sentmail_ts" int NOT NULL,
"sentmail_messageid" varchar(255) NOT NULL,
"sentmail_action" varchar(32) NOT NULL,
"sentmail_recipient" varchar(255) NOT NULL,
"sentmail_success" int NOT NULL
)\7++qtableimp_schema_infoimp_schema_info;CREATE TABLE "imp_schema_info" (
"version" int
"vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"vfs_type" int NOT NULL,
"vfs_path" varchar(255),
"vfs_name" varchar(255) NOT NULL,
"vfs_modified" int NOT NULL,
"vfs_owner" varchar(255),
"vfs_perms" int NOT NULL,
"vfs_data" blob
"vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"vfs_type" int NOT NULL,
"vfs_path" varchar(255),
"vfs_name" varchar(255) NOT NULL,
"vfs_modified" int NOT NULL,
"vfs_owner" varchar(255),
"vfs_data" blob
)n477}tablehorde_vfs_schema_infohorde_vfs_schema_info8CREATE TABLE "horde_vfs_schema_info" (
"version" int
"token_address" varchar(100) NOT NULL,
"token_id" varchar(32) NOT NULL,
"token_timestamp" bigint NOT NULL,
PRIMARY KEY("token_address", "token_id")
"version" int
"syncml_syncpartner" varchar(255) NOT NULL,
"syncml_db" varchar(255) NOT NULL,
"syncml_uid" varchar(255) NOT NULL,
"syncml_clientanchor" varchar(255),
"syncml_serveranchor" varchar(255)
"syncml_syncpartner" varchar(255) NOT NULL,
"syncml_db" varchar(255) NOT NULL,
"syncml_uid" varchar(255) NOT NULL,
"syncml_cuid" varchar(255),
"syncml_suid" varchar(255),
"syncml_timestamp" int
"version" int
"session_id" varchar(32) NOT NULL,
"session_lastmodified" int NOT NULL,
"session_data" blob
"version" int
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"share_parents" varchar(4000)
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"share_parents" varchar(4000)
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"rule_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"rule_owner" varchar(255) NOT NULL,
"rule_name" varchar(255) NOT NULL,
"rule_action" int NOT NULL,
"rule_value" varchar(255),
"rule_flags" int,
"rule_conditions" text,
"rule_combine" int,
"rule_stop" int,
"rule_active" int NOT NULL DEFAULT 1,
"rule_order" int NOT NULL DEFAULT 0
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"vfb_owner" varchar(255),
"vfb_email" varchar(255) NOT NULL,
"vfb_serialized" text NOT NULL
)nG77}tablekronolith_schema_infokronolith_schema_infoLCREATE TABLE "kronolith_schema_info" (
"version" int
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_creator_1024" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_default_1024" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"perm_guest_1024" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7),
"share_parents" varchar(4000)
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7),
"share_parents" varchar(4000)
"event_id" varchar(32) NOT NULL,
"event_uid" varchar(255) NOT NULL,
"calendar_id" varchar(255) NOT NULL,
"event_creator_id" varchar(255) NOT NULL,
"event_description" text,
"event_location" text,
"event_status" int DEFAULT 0,
"event_attendees" text,
"event_keywords" text,
"event_exceptions" text,
"event_title" varchar(255),
"event_recurtype" int DEFAULT 0,
"event_recurinterval" int,
"event_recurdays" int,
"event_recurenddate" datetime,
"event_recurcount" int,
"event_start" datetime,
"event_end" datetime,
"event_alarm" int DEFAULT 0,
"event_modified" int DEFAULT 0,
"event_private" int NOT NULL DEFAULT 0,
"event_allday" int DEFAULT 0,
"event_alarm_methods" text,
"event_url" text,
"event_baseid" varchar(255) DEFAULT '',
"event_exceptionoriginaldate" datetime,
"event_resources" text
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0,
"perm_1024" boolean NOT NULL DEFAULT 0
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0,
"perm_1024" boolean NOT NULL DEFAULT 0
"event_id" varchar(32) NOT NULL,
"event_lat" varchar(32) NOT NULL,
"event_lon" varchar(32) NOT NULL, "event_zoom" int NOT NULL DEFAULT 0,
PRIMARY KEY("event_id")
"resource_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"resource_name" varchar(255),
"resource_calendar" varchar(255),
"resource_description" text,
"resource_response_type" int DEFAULT 0,
"resource_type" varchar(255) NOT NULL,
"resource_members" text
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"share_parents" varchar(4000)
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"share_parents" varchar(4000)
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
)bS//utablemnemo_schema_infomnemo_schema_infoYCREATE TABLE "mnemo_schema_info" (
"version" int
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int(2) NOT NULL
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int(2) NOT NULL
)\[++qtablenag_schema_infonag_schema_infobCREATE TABLE "nag_schema_info" (
"version" int
"memo_owner" varchar(255) NOT NULL,
"memo_id" varchar(32) NOT NULL,
"memo_uid" varchar(255) NOT NULL,
"memo_desc" varchar(255) NOT NULL,
"memo_body" text,
"memo_private" int NOT NULL DEFAULT 0
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int(2) NOT NULL DEFAULT 0,
"perm_creator" int(2) NOT NULL DEFAULT 0,
"perm_default" int(2) NOT NULL DEFAULT 0,
"perm_guest" int(2) NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7),
"share_parents" varchar(4000),
"attribute_issmart" int DEFAULT 0,
"attribute_search" varchar(4000)
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7),
"share_parents" varchar(4000),
"attribute_issmart" int DEFAULT 0,
"attribute_search" text
"task_id" varchar(32) NOT NULL,
"task_owner" varchar(255) NOT NULL,
"task_creator" varchar(255) NOT NULL,
"task_parent" varchar(255),
"task_assignee" varchar(255),
"task_name" varchar(255) NOT NULL,
"task_uid" varchar(255) NOT NULL,
"task_desc" text,
"task_start" int,
"task_due" int,
"task_priority" int NOT NULL DEFAULT 0,
"task_estimate" float,
"task_completed" int(1) NOT NULL DEFAULT 0,
"task_completed_date" int,
"task_alarm" int NOT NULL DEFAULT 0,
"task_alarm_methods" text,
"task_private" int(1) NOT NULL DEFAULT 0,
"task_recurtype" int DEFAULT 0,
"task_recurinterval" int,
"task_recurdays" int,
"task_recurenddate" datetime,
"task_recurcount" int,
"task_exceptions" text,
"task_completions" text
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
)be//utableturba_schema_infoturba_schema_infomCREATE TABLE "turba_schema_info" (
"version" int
"bookmark_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"bookmark_url" varchar(1024) NOT NULL,
"bookmark_title" varchar(255),
"bookmark_description" varchar(1024),
"bookmark_clicks" int DEFAULT 0,
"bookmark_http_status" varchar(5),
"bookmark_dt" datetime,
"user_id" int NOT NULL
, "favicon_url" varchar(255))bc//utabletrean_schema_infotrean_schema_infokCREATE TABLE "trean_schema_info" (
"version" int
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_params" text,
"share_parents" varchar(4000)
"object_id" varchar(32) NOT NULL,
"owner_id" varchar(255) NOT NULL,
"object_type" varchar(255) NOT NULL DEFAULT 'Object',
"object_uid" varchar(255),
"object_members" text,
"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_notes" text,
"object_url" varchar(255),
"object_freebusyurl" varchar(255),
"object_pgppublickey" text,
"object_smimepublickey" text,
"object_anniversary" varchar(10),
"object_department" varchar(255),
"object_spouse" varchar(255),
"object_homefax" varchar(25),
"object_nickname" varchar(255),
"object_assistantphone" varchar(25),
"object_imaddress" varchar(255),
"object_imaddress2" varchar(255),
"object_imaddress3" varchar(255),
"object_homephone2" varchar(25),
"object_carphone" varchar(25),
"object_workphone2" varchar(25),
"object_radiophone" varchar(25),
"object_companyphone" varchar(25),
"object_otherstreet" varchar(255),
"object_otherpob" varchar(10),
"object_othercity" varchar(255),
"object_otherprovince" varchar(255),
"object_otherpostalcode" varchar(10),
"object_othercountry" varchar(255),
"object_yomifirstname" varchar(255),
"object_yomilastname" varchar(255),
"object_manager" varchar(255),
"object_assistant" varchar(255),
"object_workemail" varchar(255),
"object_homeemail" varchar(255)
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_params" text,
"share_parents" varchar(4000)
kronolith
kronolith horde
kronolith
cpanel horde
cpanel horde horde
//