{
  "version": "6",
  "dialect": "sqlite",
  "id": "87ba3d49-c2a8-48d9-8e79-6b24da4cc1e9",
  "prevId": "4cea9c4b-8c0c-4b00-9379-206f0599859a",
  "tables": {
    "meta": {
      "name": "meta",
      "columns": {
        "key": {
          "name": "key",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "value": {
          "name": "value",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "updated_at_ms": {
          "name": "updated_at_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        }
      },
      "indexes": {},
      "foreignKeys": {},
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "calendar_changes": {
      "name": "calendar_changes",
      "columns": {
        "seq": {
          "name": "seq",
          "type": "integer",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": true
        },
        "calendar_id": {
          "name": "calendar_id",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "href": {
          "name": "href",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "change_type": {
          "name": "change_type",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "changed_at_ms": {
          "name": "changed_at_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        }
      },
      "indexes": {
        "calendar_changes_calendar_seq_idx": {
          "name": "calendar_changes_calendar_seq_idx",
          "columns": [
            "calendar_id",
            "seq"
          ],
          "isUnique": false
        },
        "calendar_changes_changed_idx": {
          "name": "calendar_changes_changed_idx",
          "columns": [
            "changed_at_ms"
          ],
          "isUnique": false
        },
        "calendar_changes_href_idx": {
          "name": "calendar_changes_href_idx",
          "columns": [
            "href"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "calendar_changes_calendar_id_calendars_id_fk": {
          "name": "calendar_changes_calendar_id_calendars_id_fk",
          "tableFrom": "calendar_changes",
          "tableTo": "calendars",
          "columnsFrom": [
            "calendar_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {
        "calendar_changes_type_check": {
          "name": "calendar_changes_type_check",
          "value": "\"calendar_changes\".\"change_type\" in ('created', 'updated', 'deleted')"
        }
      }
    },
    "calendar_dead_props": {
      "name": "calendar_dead_props",
      "columns": {
        "resource_kind": {
          "name": "resource_kind",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "resource_id": {
          "name": "resource_id",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "ns_uri": {
          "name": "ns_uri",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "local_name": {
          "name": "local_name",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "xml_value": {
          "name": "xml_value",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        }
      },
      "indexes": {},
      "foreignKeys": {},
      "compositePrimaryKeys": {
        "calendar_dead_props_resource_kind_resource_id_ns_uri_local_name_pk": {
          "columns": [
            "resource_kind",
            "resource_id",
            "ns_uri",
            "local_name"
          ],
          "name": "calendar_dead_props_resource_kind_resource_id_ns_uri_local_name_pk"
        }
      },
      "uniqueConstraints": {},
      "checkConstraints": {
        "calendar_dead_props_kind_check": {
          "name": "calendar_dead_props_kind_check",
          "value": "\"calendar_dead_props\".\"resource_kind\" in ('home', 'calendar', 'object')"
        }
      }
    },
    "calendar_index": {
      "name": "calendar_index",
      "columns": {
        "object_id": {
          "name": "object_id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "calendar_id": {
          "name": "calendar_id",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "uid": {
          "name": "uid",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "component_type": {
          "name": "component_type",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "dtstart_ms": {
          "name": "dtstart_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "dtend_ms": {
          "name": "dtend_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "due_ms": {
          "name": "due_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "completed_ms": {
          "name": "completed_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "summary": {
          "name": "summary",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "has_recurrence": {
          "name": "has_recurrence",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": false
        },
        "recurrence_min_ms": {
          "name": "recurrence_min_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "recurrence_max_ms": {
          "name": "recurrence_max_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        }
      },
      "indexes": {
        "calendar_index_timerange_idx": {
          "name": "calendar_index_timerange_idx",
          "columns": [
            "calendar_id",
            "component_type",
            "dtstart_ms",
            "dtend_ms"
          ],
          "isUnique": false
        },
        "calendar_index_due_idx": {
          "name": "calendar_index_due_idx",
          "columns": [
            "calendar_id",
            "due_ms"
          ],
          "isUnique": false
        },
        "calendar_index_completed_idx": {
          "name": "calendar_index_completed_idx",
          "columns": [
            "calendar_id",
            "completed_ms"
          ],
          "isUnique": false
        },
        "calendar_index_uid_idx": {
          "name": "calendar_index_uid_idx",
          "columns": [
            "calendar_id",
            "uid"
          ],
          "isUnique": false
        },
        "calendar_index_recurrence_idx": {
          "name": "calendar_index_recurrence_idx",
          "columns": [
            "calendar_id",
            "has_recurrence",
            "recurrence_min_ms",
            "recurrence_max_ms"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "calendar_index_object_id_calendar_objects_id_fk": {
          "name": "calendar_index_object_id_calendar_objects_id_fk",
          "tableFrom": "calendar_index",
          "tableTo": "calendar_objects",
          "columnsFrom": [
            "object_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        },
        "calendar_index_calendar_id_calendars_id_fk": {
          "name": "calendar_index_calendar_id_calendars_id_fk",
          "tableFrom": "calendar_index",
          "tableTo": "calendars",
          "columnsFrom": [
            "calendar_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {
        "calendar_index_component_check": {
          "name": "calendar_index_component_check",
          "value": "\"calendar_index\".\"component_type\" in ('VEVENT', 'VTODO', 'VJOURNAL')"
        }
      }
    },
    "calendar_objects": {
      "name": "calendar_objects",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "calendar_id": {
          "name": "calendar_id",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "name": {
          "name": "name",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "uid": {
          "name": "uid",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "component_type": {
          "name": "component_type",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "body": {
          "name": "body",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "etag": {
          "name": "etag",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "size": {
          "name": "size",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "created_at_ms": {
          "name": "created_at_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "modified_at_ms": {
          "name": "modified_at_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "version": {
          "name": "version",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": 1
        }
      },
      "indexes": {
        "calendar_objects_calendar_name_unique": {
          "name": "calendar_objects_calendar_name_unique",
          "columns": [
            "calendar_id",
            "name"
          ],
          "isUnique": true
        },
        "calendar_objects_calendar_uid_unique": {
          "name": "calendar_objects_calendar_uid_unique",
          "columns": [
            "calendar_id",
            "uid"
          ],
          "isUnique": true
        },
        "calendar_objects_calendar_modified_idx": {
          "name": "calendar_objects_calendar_modified_idx",
          "columns": [
            "calendar_id",
            "modified_at_ms"
          ],
          "isUnique": false
        },
        "calendar_objects_component_idx": {
          "name": "calendar_objects_component_idx",
          "columns": [
            "calendar_id",
            "component_type"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "calendar_objects_calendar_id_calendars_id_fk": {
          "name": "calendar_objects_calendar_id_calendars_id_fk",
          "tableFrom": "calendar_objects",
          "tableTo": "calendars",
          "columnsFrom": [
            "calendar_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {
        "calendar_objects_component_check": {
          "name": "calendar_objects_component_check",
          "value": "\"calendar_objects\".\"component_type\" in ('VEVENT', 'VTODO', 'VJOURNAL')"
        }
      }
    },
    "calendars": {
      "name": "calendars",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "name": {
          "name": "name",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "display_name": {
          "name": "display_name",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "description": {
          "name": "description",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "timezone_ical": {
          "name": "timezone_ical",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "color": {
          "name": "color",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "order_index": {
          "name": "order_index",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": 0
        },
        "created_at_ms": {
          "name": "created_at_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "modified_at_ms": {
          "name": "modified_at_ms",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "sync_seq": {
          "name": "sync_seq",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": 0
        }
      },
      "indexes": {
        "calendars_name_unique": {
          "name": "calendars_name_unique",
          "columns": [
            "name"
          ],
          "isUnique": true
        },
        "calendars_order_idx": {
          "name": "calendars_order_idx",
          "columns": [
            "order_index"
          ],
          "isUnique": false
        },
        "calendars_modified_idx": {
          "name": "calendars_modified_idx",
          "columns": [
            "modified_at_ms"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {},
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    }
  },
  "views": {},
  "enums": {},
  "_meta": {
    "schemas": {},
    "tables": {},
    "columns": {}
  },
  "internal": {
    "indexes": {}
  }
}