export declare const sqliteTables = "\nPRAGMA foreign_keys=OFF;\nBEGIN TRANSACTION;\n\n-- Table: accounts\nCREATE TABLE IF NOT EXISTS \"accounts\" (\n    \"id\" TEXT PRIMARY KEY,\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    \"name\" TEXT,\n    \"email\" TEXT NOT NULL UNIQUE,\n    \"avatar_url\" TEXT,\n    \"details\" TEXT DEFAULT '{}' CHECK(json_valid(\"details\")) -- Ensuring details is a valid JSON field\n);\n\n-- Table: memories\nCREATE TABLE IF NOT EXISTS \"memories\" (\n    \"id\" TEXT PRIMARY KEY,\n    \"type\" TEXT NOT NULL,\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    \"content\" TEXT NOT NULL,\n    \"embedding\" BLOB NOT NULL, -- TODO: EMBEDDING ARRAY, CONVERT TO BEST FORMAT FOR SQLITE-VSS (JSON?)\n    \"user_id\" TEXT,\n    \"room_id\" TEXT,\n    \"unique\" INTEGER DEFAULT 1 NOT NULL,\n    FOREIGN KEY (\"user_id\") REFERENCES \"accounts\"(\"id\"),\n    FOREIGN KEY (\"room_id\") REFERENCES \"rooms\"(\"id\")\n);\n\n-- Table: goals\nCREATE TABLE IF NOT EXISTS \"goals\" (\n    \"id\" TEXT PRIMARY KEY,\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    \"user_id\" TEXT,\n    \"name\" TEXT,\n    \"status\" TEXT,\n    \"description\" TEXT,\n    \"room_id\" TEXT,\n    \"objectives\" TEXT DEFAULT '[]' NOT NULL CHECK(json_valid(\"objectives\")) -- Ensuring objectives is a valid JSON array\n);\n\n-- Table: logs\nCREATE TABLE IF NOT EXISTS \"logs\" (\n    \"id\" TEXT PRIMARY KEY,\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    \"user_id\" TEXT NOT NULL,\n    \"body\" TEXT NOT NULL,\n    \"type\" TEXT NOT NULL,\n    \"room_id\" TEXT NOT NULL\n);\n\n-- Table: participants\nCREATE TABLE IF NOT EXISTS \"participants\" (\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    \"user_id\" TEXT,\n    \"room_id\" TEXT,\n    \"id\" TEXT PRIMARY KEY,\n    \"last_message_read\" TEXT,\n    FOREIGN KEY (\"user_id\") REFERENCES \"accounts\"(\"id\"),\n    FOREIGN KEY (\"room_id\") REFERENCES \"rooms\"(\"id\")\n);\n\n-- Table: relationships\nCREATE TABLE IF NOT EXISTS \"relationships\" (\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    \"user_a\" TEXT NOT NULL,\n    \"user_b\" TEXT NOT NULL,\n    \"status\" \"text\",\n    \"id\" TEXT PRIMARY KEY,\n    \"user_id\" TEXT NOT NULL,\n    FOREIGN KEY (\"user_a\") REFERENCES \"accounts\"(\"id\"),\n    FOREIGN KEY (\"user_b\") REFERENCES \"accounts\"(\"id\"),\n    FOREIGN KEY (\"user_id\") REFERENCES \"accounts\"(\"id\")\n);\n\n-- Table: rooms\nCREATE TABLE IF NOT EXISTS \"rooms\" (\n    \"id\" TEXT PRIMARY KEY,\n    \"created_at\" TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\n-- Index: relationships_id_key\nCREATE UNIQUE INDEX IF NOT EXISTS \"relationships_id_key\" ON \"relationships\" (\"id\");\n\n-- Index: memories_id_key\nCREATE UNIQUE INDEX IF NOT EXISTS \"memories_id_key\" ON \"memories\" (\"id\");\n\n-- Index: participants_id_key\nCREATE UNIQUE INDEX IF NOT EXISTS \"participants_id_key\" ON \"participants\" (\"id\");\n\nCOMMIT;";