• Home
• net.neoforged.camelot
• camelot
• 1.0.158
• source code
• V11__quotes.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.main.V11__quotes.sql Maven / Gradle / Ivy

create table quote_authors
(
    -- alias for rowid --
    id      integer primary key,
    guild   unsigned big int not null,
    name    text             not null,
    uid     unsigned big int,
    recheck tinyint          not null default 1
);

create table quotes
(
    -- alias for rowid --
    id      integer primary key,
    guild   unsigned big int not null,
    author  integer          not null,
    quote   text             not null,
    context text,
    quoter  unsigned big int,

    foreign key (author) references quote_authors (id) on delete cascade
);