Viewing: p.contas.rcube.db
SQLite format 3 @ Z, � � � Z, .�� Q �������������������{oic]WQ��u��EEE''�tablecontactgroupscontactgroupsCREATE TABLE contactgroups ( contactgroup_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL default '0', changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '' )b3�indexix_contacts_user_idcontactsCREATE INDEX ix_contacts_user_id ON contacts(user_id, del)�D�[tablecontactscontactsCREATE TABLE contacts ( contact_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL, changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', ema �2 �. ρ* Á% ��! �� e�; b� �� c| f� � ��B� g�8 ��5 hz iv jr sd �[ �J 2 m: 0 lh kl o@ t_ �a �X � � , 3/O2024-07-10 19:46:05Imported Contacts � ���� �7�c 3/C �a O2018-03-06 14:47:23'Carlos Henrique'carlos.henrique@krattos.comBEGIN:VCARD VERSION:3.0 FN:'Carlos Henrique' EMAIL;TYPE=INTERNET:carlos.henrique@krattos.com END:VCARD�'�b 3/3 �Q O2018-03-06 14:47:22'RAILIS ROSÁRIO'railis@grupobig.comBEGIN:VCARD VERSION:3.0 FN:'RAILIS ROSÁRIO' EMAIL;TYPE=INTERNET:railis@grupobig.com END:VCARD�)�a 3/5 �S O2018-03-06 14:47:07Alexandre Remedioaremedio@krattos.comBEGIN:VCARD VERSION:3.0 FN:Alexandre Remedio EMAIL;TYPE=INTERNET:aremedio@krattos.com END:VCARD�-� 3'A �W O2017-06-21 10:16:36Ednaldobrasilednaldobrasil@yahoo.com.brBEGIN:VCARD VERSION:3.0 FN:Ednaldobrasil EMAIL;TYPE=INTERNET:ednaldobrasil@yahoo ��H ��e J�c � � O � � �� � � � � aO) indexsqlite_autoindex_cache_messages_1cache_messages) $))�tablecache_messagescache_m A&U/ indexsqlite_autoindex_cp_schema_version_1cp_schema_version/�_%//�mtablecp_schema_versioncp_schema_version.CREATE TABLE `cp_schema_version` ( version_id integer NOT NULL PRIMARY KEY, version varchar(128) NOT NULL UNIQUE, applied datetime NOT NULL default '0000-00-00 00:00:00')+$? indexsqlite_autoindex_system_1system,o#�9tablesystemsystem+CREATE TABLE system ( name varchar(64) NOT NULL PRIMARY KEY, value text NOT NULL ) x?)�indexix_cache_messages_expirescache_messages*CREATE INDEX ix_cache_messages_expires ON cache_messages (expires) ? ? �>2--�/tablecarddav_contactscarddav_contactsFCREATE TABLE carddav_contacts ( id integer NOT NULL PRIMARY KEY, abook_id integer NOT NULL, name VARCHAR(255) NOT NULL, -- display name email VARCHAR(255), -- ", " separated list of mail addresses firstname VARCHAR(255), surname VARCHAR(255), organization VARCHAR(255), showas VARCHAR(32) NOT NULL DEFAULT '', -- special display type (e.g., as a company) vcard TEXT NOT NULL, -- complete vcard etag VARCHAR(255) NOT NULL, -- entity tag, can be used to check if card changed on server uri VARCHAR(255) NOT NULL, -- path of the card on the server cuid VARCHAR(255) NOT NULL, -- unique identifier of the card within the collection UNIQUE(uri,abook_id), UNIQUE(cuid,abook_id), -- not enforced by sqlite < 3.6.19 FOREIGN KEY(abook_id) REFERENCES carddav_addressbooks(id) ON DELETE CASCADE ON UPDATE CASCADE ) >