Web-based Calendar Aggregator https://ticker.c3d2.de/
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

schema.sql 523B

12345678910111213141516171819202122232425
  1. CREATE TABLE calendars (
  2. id TEXT PRIMARY KEY,
  3. url TEXT NOT NULL,
  4. last_fetch TIMESTAMP,
  5. last_success TIMESTAMP,
  6. error_message TEXT,
  7. etag TEXT,
  8. last_modified TEXT
  9. );
  10. CREATE TABLE events (
  11. calendar TEXT NOT NULL,
  12. id TEXT NOT NULL,
  13. PRIMARY KEY (calendar, id),
  14. dtstart TIMESTAMP NOT NULL,
  15. dtend TIMESTAMP,
  16. summary TEXT NOT NULL,
  17. location TEXT,
  18. url TEXT
  19. );
  20. CREATE index events_dtstart_dtend ON events (dtstart, dtend);