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)