sparklabuofu's picture
Update the demo
22de727 verified
Raw History Blame Contribute Delete
1.66 kB
"""Database schema for documentation-api-docs.
Auto-generated by src/miniweb/scripts/generate_schemas.py — edit freely.
"""
TABLES = {
"docs": {
"table_name": "documentation_api_docs_docs",
"columns": [
("id", "INTEGER PRIMARY KEY"),
("slug", "TEXT NOT NULL DEFAULT ''"),
("title", "TEXT NOT NULL DEFAULT ''"),
("section", "TEXT NOT NULL DEFAULT ''"),
("order_", "INTEGER NOT NULL DEFAULT 0"),
("content", "TEXT NOT NULL DEFAULT ''"),
("updated_at", "TEXT NOT NULL DEFAULT ''"),
("tags", "TEXT NOT NULL DEFAULT ''"),
],
"indexes": [
"updated_at",
],
},
"search_index": {
"table_name": "documentation_api_docs_search_index",
"columns": [
("row_id", "INTEGER PRIMARY KEY"),
("doc_id", "INTEGER NOT NULL DEFAULT 0"),
("keywords", "TEXT NOT NULL DEFAULT ''"),
],
},
"users": {
"table_name": "documentation_api_docs_users",
"columns": [
("id", "INTEGER PRIMARY KEY"),
("root_user_id", "INTEGER NOT NULL DEFAULT 0"),
("username", "TEXT NOT NULL DEFAULT ''"),
("password", "TEXT NOT NULL DEFAULT ''"),
("name", "TEXT NOT NULL DEFAULT ''"),
("email", "TEXT NOT NULL DEFAULT ''"),
("api_key", "TEXT NOT NULL DEFAULT ''"),
("bookmarked_pages", "TEXT NOT NULL DEFAULT ''"),
("role", "TEXT NOT NULL DEFAULT ''"),
],
"indexes": [
"role",
"root_user_id",
],
},
}