Beiträge von tom996

UPDATE cal_alarms
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_attachments
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_attendees
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_metadata
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_properties
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_recurrence
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_relations
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE item_id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');
UPDATE cal_events
SET cal_id ='d5ae769c-7624-4a65-8f90-c1ba5e69b7a2'
WHERE id IN (SELECT id FROM cal_events WHERE cal_events.title LIKE 'Bioabfall');

// Storage flags. These are used in the Database |flags| column to give
// information about the item's features. For example, if the item has
// attachments, the HAS_ATTACHMENTS flag is added to the flags column.
var CAL_ITEM_FLAG = {
  PRIVATE: 1,
  HAS_ATTENDEES: 2,
  HAS_PROPERTIES: 4,
  EVENT_ALLDAY: 8,
  HAS_RECURRENCE: 16,
  HAS_EXCEPTIONS: 32,
  HAS_ATTACHMENTS: 64,
  HAS_RELATIONS: 128,
  HAS_ALARMS: 256,
  RECURRENCE_ID_ALLDAY: 512,
};

ATTACH "C:\Users\tom\Kalender\Kalender\Rettung.sqlite" AS rettung; 
INSERT INTO rettung.cal_alarms
SELECT cal_alarms.cal_id,cal_alarms.item_id,cal_alarms.recurrence_id,cal_alarms.recurrence_id_tz,cal_alarms.icalString
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_alarms ON cal_events.id = cal_alarms.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_attachments
SELECT cal_attachments.item_id,cal_attachments.cal_id,cal_attachments.recurrence_id,
cal_attachments.recurrence_id_tz,cal_attachments.icalString
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_attachments ON cal_events.id = cal_attachments.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_attendees
SELECT cal_attendees.item_id,cal_attendees.recurrence_id,cal_attendees.recurrence_id_tz,cal_attendees.cal_id,cal_attendees.icalString
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_attendees ON cal_events.id = cal_attendees.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_events
SELECT cal_events.cal_id,cal_events.id,cal_events.time_created,cal_events.last_modified,cal_events.title,cal_events.priority,cal_events.privacy,cal_events.ical_status,cal_events.flags,
cal_events.event_start,cal_events.event_end,cal_events.event_stamp,cal_events.event_start_tz,cal_events.event_end_tz,cal_events.recurrence_id,cal_events.recurrence_id_tz,cal_events.alarm_last_ack,
cal_events.offline_journal
 
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_metadata
SELECT cal_metadata.cal_id,cal_metadata.item_id,cal_metadata.value
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_metadata ON cal_events.id = cal_metadata.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_properties
SELECT cal_properties.item_id,cal_properties.key,cal_properties.value,cal_properties.recurrence_id,
cal_properties.recurrence_id_tz,cal_properties.cal_id
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_properties ON cal_events.id = cal_properties.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_recurrence
SELECT cal_recurrence.item_id,cal_recurrence.cal_id,cal_recurrence.icalString
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_relations
SELECT cal_relations.cal_id,cal_relations.item_id,cal_relations.recurrence_id,cal_relations.recurrence_id_tz,
    cal_relations.icalString 
 from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_relations ON cal_events.id = cal_relations.item_id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;

INSERT INTO rettung.cal_todos
SELECT cal_todos.cal_id,cal_todos.id,cal_todos.time_created,cal_todos.last_modified,cal_todos.title,
cal_todos.priority,cal_todos.privacy,cal_todos.ical_status,cal_todos.flags,cal_todos.todo_entry,cal_todos.todo_due,
cal_todos.todo_completed,cal_todos.todo_complete,cal_todos.todo_entry_tz,cal_todos.todo_due_tz,
cal_todos.todo_completed_tz,cal_todos.recurrence_id,cal_todos.recurrence_id_tz,cal_todos.alarm_last_ack,
cal_todos.todo_stamp,cal_todos.offline_journal 
from cal_events 
INNER JOIN cal_recurrence ON cal_events.id = cal_recurrence.item_id
INNER JOIN cal_todos ON cal_events.id = cal_todos.id
WHERE cal_recurrence.icalString IS NOT NULL
group by cal_events.id;
DETACH DATABASE 'rettung';