Something went wrong. Try again.
Paper Mario mod hosting site - AT Protocol appview starhaven.dev
Something went wrong. Try again.
1.2 kB · 51 lines
SQL
at main
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051CREATE TABLE IF NOT EXISTS mods( mod_slug TEXT PRIMARY KEY NOT NULL, mod_name TEXT NOT NULL, tagline TEXT, description TEXT, -- TIMESTAMPS AS UNIX EPOCH. for simplicity release_date INTEGER NOT NULL, last_updated INTEGER NOT NULL, version TEXT NOT NULL, game TEXT NOT NULL, console_compat INTEGER, recommended_emulator TEXT, source_url TEXT, download_url TEXT NOT NULL, icon_url TEXT, mod_color TEXT);
CREATE TABLE IF NOT EXISTS authors( author_id INTEGER PRIMARY KEY NOT NULL, username TEXT NOT NULL);
-- For defining jams and whatnotCREATE TABLE IF NOT EXISTS mod_groups( mod_group_id INTEGER PRIMARY KEY NOT NULL, mod_group_name TEXT NOT NULL, mod_group_description TEXT);
CREATE TABLE IF NOT EXISTS mod_group_relations( mod_group_relation_id INTEGER PRIMARY KEY NOT NULL, mod_id TEXT REFERENCES mods(mod_slug), mod_group_id INTEGER REFERENCES mod_groups(mod_group_id));
CREATE TABLE IF NOT EXISTS mod_authors( mod_authors_id INTEGER PRIMARY KEY NOT NULL, mod_slug TEXT REFERENCES mods(mod_slug), author_id INTEGER REFERENCES authors(author_id));