"""Database schema for forums.

Auto-generated by src/miniweb/scripts/generate_schemas.py — edit freely.
"""

TABLES = {
    "comments": {
        "table_name": "forums_comments",
        "columns": [
            ("id", "TEXT PRIMARY KEY"),
            ("post_id", "TEXT NOT NULL DEFAULT ''"),
            ("author_root_user_id", "INTEGER NOT NULL DEFAULT 0"),
            ("body", "TEXT NOT NULL DEFAULT ''"),
            ("score", "INTEGER NOT NULL DEFAULT 0"),
            ("parent_comment_id", "TEXT NOT NULL DEFAULT ''"),
            ("author", "TEXT NOT NULL DEFAULT ''"),
            ("created_utc", "TEXT NOT NULL DEFAULT ''"),
        ],
        "indexes": [
            "post_id",
            "author",
            "parent_comment_id",
        ],
    },
    "posts": {
        "table_name": "forums_posts",
        "columns": [
            ("id", "TEXT PRIMARY KEY"),
            ("author_root_user_id", "INTEGER NOT NULL DEFAULT 0"),
            ("subreddit", "TEXT NOT NULL DEFAULT ''"),
            ("title", "TEXT NOT NULL DEFAULT ''"),
            ("body", "TEXT NOT NULL DEFAULT ''"),
            ("score", "INTEGER NOT NULL DEFAULT 0"),
            ("num_comments", "INTEGER NOT NULL DEFAULT 0"),
            ("flair", "TEXT NOT NULL DEFAULT ''"),
            ("author", "TEXT NOT NULL DEFAULT ''"),
            ("created_utc", "TEXT NOT NULL DEFAULT ''"),
            ("url", "TEXT NOT NULL DEFAULT ''"),
            ("sticky", "TEXT NOT NULL DEFAULT ''"),
            ("locked", "TEXT NOT NULL DEFAULT ''"),
        ],
        "indexes": [
            "subreddit",
            "author",
        ],
    },
    "messages": {
        "table_name": "forums_messages",
        "columns": [
            ("id", "TEXT PRIMARY KEY"),
            ("from_username", "TEXT NOT NULL DEFAULT ''"),
            ("to_username", "TEXT NOT NULL DEFAULT ''"),
            ("subject", "TEXT NOT NULL DEFAULT ''"),
            ("body", "TEXT NOT NULL DEFAULT ''"),
            ("created_utc", "TEXT NOT NULL DEFAULT ''"),
            ("read", "INTEGER NOT NULL DEFAULT 0"),
        ],
        "indexes": [
            "to_username",
            "from_username",
        ],
    },
    "reddit_users": {
        "table_name": "forums_reddit_users",
        "columns": [
            ("id", "INTEGER PRIMARY KEY"),
            ("username", "TEXT NOT NULL DEFAULT ''"),
            ("created_at", "TEXT NOT NULL DEFAULT ''"),
            ("admin", "TEXT NOT NULL DEFAULT ''"),
            ("biography", "TEXT NOT NULL DEFAULT ''"),
        ],
        "indexes": [
            "created_at",
        ],
    },
    "subreddits": {
        "table_name": "forums_subreddits",
        "columns": [
            ("id", "INTEGER PRIMARY KEY"),
            ("name", "TEXT NOT NULL DEFAULT ''"),
            ("title", "TEXT NOT NULL DEFAULT ''"),
            ("description", "TEXT NOT NULL DEFAULT ''"),
            ("sidebar", "TEXT NOT NULL DEFAULT ''"),
            ("created_at", "TEXT NOT NULL DEFAULT ''"),
            ("post_count", "INTEGER NOT NULL DEFAULT 0"),
        ],
        "indexes": [
            "created_at",
        ],
    },
    "users": {
        "table_name": "forums_users",
        "columns": [
            ("root_user_id", "INTEGER NOT NULL DEFAULT 0"),
            ("karma", "INTEGER NOT NULL DEFAULT 0"),
            ("subscribed_subreddits", "TEXT NOT NULL DEFAULT ''"),
            ("cake_day", "TEXT NOT NULL DEFAULT ''"),
            ("username", "TEXT NOT NULL DEFAULT ''"),
            ("id", "INTEGER PRIMARY KEY"),
            ("admin", "TEXT NOT NULL DEFAULT ''"),
            ("biography", "TEXT NOT NULL DEFAULT ''"),
            ("created_at", "TEXT NOT NULL DEFAULT ''"),
        ],
        "indexes": [
            "created_at",
            "root_user_id",
        ],
    },
}