{
  "version": "6",
  "dialect": "sqlite",
  "id": "e85ca6ac-0cd8-4aa2-8177-cc645e8276a0",
  "prevId": "12dfc2a7-6798-42c7-8771-a3d87111c2a5",
  "tables": {
    "address_changes": {
      "name": "address_changes",
      "columns": {
        "seq": {
          "name": "seq",
          "type": "integer",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": true
        },
        "addressbook_id": {
          "name": "addressbook_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": {
        "address_changes_book_seq_idx": {
          "name": "address_changes_book_seq_idx",
          "columns": [
            "addressbook_id",
            "seq"
          ],
          "isUnique": false
        },
        "address_changes_changed_idx": {
          "name": "address_changes_changed_idx",
          "columns": [
            "changed_at_ms"
          ],
          "isUnique": false
        },
        "address_changes_href_idx": {
          "name": "address_changes_href_idx",
          "columns": [
            "href"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "address_changes_addressbook_id_addressbooks_id_fk": {
          "name": "address_changes_addressbook_id_addressbooks_id_fk",
          "tableFrom": "address_changes",
          "tableTo": "addressbooks",
          "columnsFrom": [
            "addressbook_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {
        "address_changes_type_check": {
          "name": "address_changes_type_check",
          "value": "\"address_changes\".\"change_type\" in ('created', 'updated', 'deleted')"
        }
      }
    },
    "address_dead_props": {
      "name": "address_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": {
        "address_dead_props_resource_kind_resource_id_ns_uri_local_name_pk": {
          "columns": [
            "resource_kind",
            "resource_id",
            "ns_uri",
            "local_name"
          ],
          "name": "address_dead_props_resource_kind_resource_id_ns_uri_local_name_pk"
        }
      },
      "uniqueConstraints": {},
      "checkConstraints": {
        "address_dead_props_kind_check": {
          "name": "address_dead_props_kind_check",
          "value": "\"address_dead_props\".\"resource_kind\" in ('home', 'addressbook', 'object')"
        }
      }
    },
    "address_index": {
      "name": "address_index",
      "columns": {
        "object_id": {
          "name": "object_id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "addressbook_id": {
          "name": "addressbook_id",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "uid": {
          "name": "uid",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "fn": {
          "name": "fn",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "n_family": {
          "name": "n_family",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "n_given": {
          "name": "n_given",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "org": {
          "name": "org",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "emails_json": {
          "name": "emails_json",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "tels_json": {
          "name": "tels_json",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        }
      },
      "indexes": {
        "address_index_uid_idx": {
          "name": "address_index_uid_idx",
          "columns": [
            "addressbook_id",
            "uid"
          ],
          "isUnique": false
        },
        "address_index_fn_idx": {
          "name": "address_index_fn_idx",
          "columns": [
            "addressbook_id",
            "fn"
          ],
          "isUnique": false
        },
        "address_index_family_idx": {
          "name": "address_index_family_idx",
          "columns": [
            "addressbook_id",
            "n_family"
          ],
          "isUnique": false
        },
        "address_index_given_idx": {
          "name": "address_index_given_idx",
          "columns": [
            "addressbook_id",
            "n_given"
          ],
          "isUnique": false
        },
        "address_index_org_idx": {
          "name": "address_index_org_idx",
          "columns": [
            "addressbook_id",
            "org"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "address_index_object_id_address_objects_id_fk": {
          "name": "address_index_object_id_address_objects_id_fk",
          "tableFrom": "address_index",
          "tableTo": "address_objects",
          "columnsFrom": [
            "object_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        },
        "address_index_addressbook_id_addressbooks_id_fk": {
          "name": "address_index_addressbook_id_addressbooks_id_fk",
          "tableFrom": "address_index",
          "tableTo": "addressbooks",
          "columnsFrom": [
            "addressbook_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "address_objects": {
      "name": "address_objects",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "addressbook_id": {
          "name": "addressbook_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
        },
        "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": {
        "address_objects_book_name_unique": {
          "name": "address_objects_book_name_unique",
          "columns": [
            "addressbook_id",
            "name"
          ],
          "isUnique": true
        },
        "address_objects_book_uid_unique": {
          "name": "address_objects_book_uid_unique",
          "columns": [
            "addressbook_id",
            "uid"
          ],
          "isUnique": true
        },
        "address_objects_book_modified_idx": {
          "name": "address_objects_book_modified_idx",
          "columns": [
            "addressbook_id",
            "modified_at_ms"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "address_objects_addressbook_id_addressbooks_id_fk": {
          "name": "address_objects_addressbook_id_addressbooks_id_fk",
          "tableFrom": "address_objects",
          "tableTo": "addressbooks",
          "columnsFrom": [
            "addressbook_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "addressbooks": {
      "name": "addressbooks",
      "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
        },
        "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": {
        "addressbooks_name_unique": {
          "name": "addressbooks_name_unique",
          "columns": [
            "name"
          ],
          "isUnique": true
        },
        "addressbooks_modified_idx": {
          "name": "addressbooks_modified_idx",
          "columns": [
            "modified_at_ms"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {},
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "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": {}
    }
  },
  "views": {},
  "enums": {},
  "_meta": {
    "schemas": {},
    "tables": {},
    "columns": {}
  },
  "internal": {
    "indexes": {}
  }
}