Spaces:
Running
Running
Download src/miniweb/sites/multimedia-posting/schema.py from sparklabuofu/MiniWeb-demo: direct link, hf CLI and curl.
- Browser
- Download file 3.62 kB
-
https://huggingface.co/spaces/sparklabuofu/MiniWeb-demo/resolve/main/src/miniweb/sites/multimedia-posting/schema.py
- Command line
-
hf download hf://spaces/sparklabuofu/MiniWeb-demo/src/miniweb/sites/multimedia-posting/schema.py
-
curl -L -o schema.py https://huggingface.co/spaces/sparklabuofu/MiniWeb-demo/resolve/main/src/miniweb/sites/multimedia-posting/schema.py
3.62 kB
| """Database schema for multimedia-posting. | |
| Auto-generated by src/miniweb/scripts/generate_schemas.py — edit freely. | |
| """ | |
| TABLES = { | |
| "comments": { | |
| "table_name": "multimedia_posting_comments", | |
| "columns": [ | |
| ("id", "TEXT PRIMARY KEY"), | |
| ("post_id", "TEXT NOT NULL DEFAULT ''"), | |
| ("author_id", "TEXT NOT NULL DEFAULT ''"), | |
| ("text", "TEXT NOT NULL DEFAULT ''"), | |
| ("likes_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("created_at", "TEXT NOT NULL DEFAULT ''"), | |
| ("reply_to", "TEXT NOT NULL DEFAULT ''"), | |
| ], | |
| "indexes": [ | |
| "author_id", | |
| "created_at", | |
| "post_id", | |
| ], | |
| }, | |
| "follows": { | |
| "table_name": "multimedia_posting_follows", | |
| "columns": [ | |
| ("id", "TEXT PRIMARY KEY"), | |
| ("follower_id", "TEXT NOT NULL DEFAULT ''"), | |
| ("following_id", "TEXT NOT NULL DEFAULT ''"), | |
| ("created_at", "TEXT NOT NULL DEFAULT ''"), | |
| ], | |
| "indexes": [ | |
| "created_at", | |
| ], | |
| }, | |
| "posts": { | |
| "table_name": "multimedia_posting_posts", | |
| "columns": [ | |
| ("id", "TEXT PRIMARY KEY"), | |
| ("author_id", "TEXT NOT NULL DEFAULT ''"), | |
| ("type", "TEXT NOT NULL DEFAULT ''"), | |
| ("image_url", "TEXT NOT NULL DEFAULT ''"), | |
| ("caption", "TEXT NOT NULL DEFAULT ''"), | |
| ("location", "TEXT NOT NULL DEFAULT ''"), | |
| ("likes_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("comments_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("created_at", "TEXT NOT NULL DEFAULT ''"), | |
| ("tags", "TEXT NOT NULL DEFAULT ''"), | |
| ("additional_images", "TEXT NOT NULL DEFAULT ''"), | |
| ("video_url", "TEXT NOT NULL DEFAULT ''"), | |
| ], | |
| "indexes": [ | |
| "author_id", | |
| "created_at", | |
| "type", | |
| ], | |
| }, | |
| "stories": { | |
| "table_name": "multimedia_posting_stories", | |
| "columns": [ | |
| ("id", "TEXT PRIMARY KEY"), | |
| ("author_id", "TEXT NOT NULL DEFAULT ''"), | |
| ("type", "TEXT NOT NULL DEFAULT ''"), | |
| ("media_url", "TEXT NOT NULL DEFAULT ''"), | |
| ("caption", "TEXT NOT NULL DEFAULT ''"), | |
| ("views_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("created_at", "TEXT NOT NULL DEFAULT ''"), | |
| ("expires_at", "TEXT NOT NULL DEFAULT ''"), | |
| ("is_active", "INTEGER NOT NULL DEFAULT 0"), | |
| ], | |
| "indexes": [ | |
| "author_id", | |
| "created_at", | |
| "type", | |
| ], | |
| }, | |
| "users": { | |
| "table_name": "multimedia_posting_users", | |
| "columns": [ | |
| ("id", "TEXT PRIMARY KEY"), | |
| ("root_user_id", "INTEGER NOT NULL DEFAULT 0"), | |
| ("username", "TEXT NOT NULL DEFAULT ''"), | |
| ("handle", "TEXT NOT NULL DEFAULT ''"), | |
| ("display_name", "TEXT NOT NULL DEFAULT ''"), | |
| ("bio", "TEXT NOT NULL DEFAULT ''"), | |
| ("avatar_url", "TEXT NOT NULL DEFAULT ''"), | |
| ("followers_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("following_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("posts_count", "INTEGER NOT NULL DEFAULT 0"), | |
| ("is_verified", "INTEGER NOT NULL DEFAULT 0"), | |
| ("is_private", "INTEGER NOT NULL DEFAULT 0"), | |
| ("created_at", "TEXT NOT NULL DEFAULT ''"), | |
| ("last_active", "TEXT NOT NULL DEFAULT ''"), | |
| ], | |
| "indexes": [ | |
| "created_at", | |
| "root_user_id", | |
| ], | |
| }, | |
| } | |