Spaces:
Running
Running
File size: 1,337 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 | """Database schema for code-editor-execution.
Auto-generated by src/miniweb/scripts/generate_schemas.py — edit freely.
"""
TABLES = {
"snippets": {
"table_name": "code_editor_execution_snippets",
"columns": [
("id", "INTEGER PRIMARY KEY"),
("title", "TEXT NOT NULL DEFAULT ''"),
("language", "TEXT NOT NULL DEFAULT ''"),
("code", "TEXT NOT NULL DEFAULT ''"),
("description", "TEXT NOT NULL DEFAULT ''"),
("category", "TEXT NOT NULL DEFAULT ''"),
("difficulty", "TEXT NOT NULL DEFAULT ''"),
("expected_output", "TEXT NOT NULL DEFAULT ''"),
],
"indexes": [
"category",
],
},
"users": {
"table_name": "code_editor_execution_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 ''"),
("saved_snippets", "TEXT NOT NULL DEFAULT ''"),
("execution_history", "TEXT NOT NULL DEFAULT ''"),
],
"indexes": [
"root_user_id",
],
},
}
|