Spaces:
Running
Running
File size: 1,657 Bytes
22de727 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 | """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",
],
},
}
|