class ErrorTracker(database.Table, table_name='error_tracker'): id = database.PrimaryKeyColumn() created = database.Column(database.Datetime, default="NOW() AT TIME ZONE 'utc'") error = database.Column(database.String) is_solved = database.Column(database.Boolean, default=False) message_id = database.Column(database.Integer(big=True), nullable=True)
class Reminders(database.Table): id = database.PrimaryKeyColumn() expires = database.Column(database.Datetime, index=True) created = database.Column(database.Datetime, default="NOW() AT TIME ZONE 'utc'") event = database.Column(database.String) extra = database.Column(database.Json, default="'{}'::jsonb")
class StarboardEntries(database.Table, table_name='starboard'): id = database.PrimaryKeyColumn() bot_message_id = database.Column(database.Integer(big=True), index=True, nullable=True) message_id = database.Column(database.Integer(big=True), index=True, unique=True) channel_id = database.Column(database.Integer(big=True)) author_id = database.Column(database.Integer(big=True))
class Starrers(database.Table): id = database.PrimaryKeyColumn() author_id = database.Column(database.Integer(big=True)) entry_id = database.Column(database.ForeignKey('starboard', 'id'), index=True) @classmethod def create_table(cls, *, exists_ok: bool = True) -> str: statement = super().create_table(exists_ok=exists_ok) sql = 'CREATE UNIQUE INDEX IF NOT EXISTS starrers_uniq_idx ON starrers (author_id, entry_id);' return statement + '\n' + sql
class Levels(database.Table): user_id = database.Column(database.Integer(big=True), primary_key=True) exp = database.Column(database.Integer, default=0)
class Currency(database.Table): user_id = database.Column(database.Integer(big=True), primary_key=True) coins = database.Column(database.Integer(big=True), default=0)
class Configurations(database.Table): user_id = database.Column(database.Integer(big=True), primary_key=True) prefix = database.Column(database.String)