pub const CREATE_CONCEPTS_TABLE: &str = "\nCREATE TABLE IF NOT EXISTS concepts (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n content TEXT NOT NULL DEFAULT \'\',\n embedding_model TEXT,\n valid_from TEXT NOT NULL,\n valid_to TEXT NOT NULL DEFAULT \'9999-12-31T23:59:59.999999Z\',\n recorded_at TEXT NOT NULL,\n retired INTEGER NOT NULL DEFAULT 0,\n CHECK (valid_from GLOB \'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]T[0-9][0-9]:[0-9][0-9]:[0-9][0-9].[0-9][0-9][0-9][0-9][0-9][0-9]Z\' AND valid_to GLOB \'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]T[0-9][0-9]:[0-9][0-9]:[0-9][0-9].[0-9][0-9][0-9][0-9][0-9][0-9]Z\' AND recorded_at GLOB \'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]T[0-9][0-9]:[0-9][0-9]:[0-9][0-9].[0-9][0-9][0-9][0-9][0-9][0-9]Z\' AND 1)\n);\n";