* Stephen Ingram <[email protected]>: > Patrick- > > Patrick Ben Koetter wrote: > >How can I delete a calendar or user without sogo-tool? > > You can, but you have to pick through the database and then delete > your user LDAP or SQL entry too. Start with the sogo_folder_info and > sogo_user_profile tables to find the user/addressbook/calendar you > are wanting to delete and then delete the corresponding regular, > _acl and _quick tables.
Shaving a yak! Did I mention I crave for 1.3.6.a ;) Anyway, I deleted only the addressbook/calendar tables and recreated them with this: CREATE TABLE recreateduser ( c_name character varying(255) NOT NULL, c_content character varying(100000) NOT NULL, c_creationdate integer NOT NULL, c_lastmodified integer NOT NULL, c_version integer NOT NULL, c_deleted integer, CONSTRAINT recreateduser_pkey PRIMARY KEY (c_name) ) WITH ( OIDS=FALSE ); ALTER TABLE recreateduser OWNER TO sogo; CREATE TABLE recreateduser_acl ( c_uid character varying(255) NOT NULL, c_object character varying(255) NOT NULL, c_role character varying(80) NOT NULL ) WITH ( OIDS=FALSE ); ALTER TABLE recreateduser_acl OWNER TO sogo; CREATE TABLE recreateduser_quick ( c_name character varying(255) NOT NULL, c_uid character varying(255) NOT NULL, c_startdate integer, c_enddate integer, c_cycleenddate integer, c_title character varying(1000) NOT NULL, c_participants character varying(1000000), c_isallday integer, c_iscycle integer, c_cycleinfo character varying(1000000), c_classification integer NOT NULL, c_isopaque integer NOT NULL, c_status integer NOT NULL, c_priority integer, c_location character varying(255), c_orgmail character varying(255), c_partmails character varying(100000), c_partstates character varying(255), c_category character varying(255), c_sequence integer, c_component character varying(10) NOT NULL, c_nextalarm integer, CONSTRAINT recreateduser_quick_pkey PRIMARY KEY (c_name) ) WITH ( OIDS=FALSE ); ALTER TABLE recreateduser_quick OWNER TO sogo; > > Steve > -- > [email protected] > https://inverse.ca/sogo/lists -- state of mind Digitale Kommunikation http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht München Partnerschaftsregister PR 563 -- [email protected] https://inverse.ca/sogo/lists
