sqlcommands

DROP TABLE "applications";
DROP TABLE "teams";
DROP TABLE "votes";
DROP TABLE "voters";
DROP TABLE "files";
DROP TABLE "checkins";
DROP TABLE "sponsors";
DROP TABLE "tickets";

CREATE TABLE "applications" (
	"application_id"	INTEGER UNIQUE,
	"application_status" TEXT,
	"application_progress" INTEGER,
	"team_id"	INTEGER,
	"mymlh_uid"	INTEGER UNIQUE,
	"reimbursement"	TEXT,
	"reimbursement_progress" TEXT,
	"travel_from"	TEXT,
	"visa"	TEXT,
	"diet"	TEXT,
	"tshirt"	TEXT,
	"job_preference"	TEXT,
	"cv_file_id"	INTEGER,
	"skills"	TEXT,
	"achievements" TEXT,
	"excited_hk22"	TEXT,
	"hear_hk22"	TEXT,
	"first_hack_hk22"	TEXT,
	"spirit_animal"	TEXT,
	"pizza"	TEXT,
	"site"	TEXT,
	"github"	TEXT,
	"devpost"	TEXT,
	"linkedin"	TEXT,
	"consent_hk_privacy"	TEXT,
	"consent_coc"	TEXT,
	"consent_cvs"	TEXT,
	"consent_mlh_privacy"	TEXT,
	"consent_photos"	TEXT,
	PRIMARY KEY("application_id" AUTOINCREMENT)
);
CREATE TABLE "teams" (
	"team_id"	INTEGER UNIQUE,
	"team_code"	TEXT UNIQUE,
	"team_name" TEXT UNIQUE,
	"owner" INTEGER,
	PRIMARY KEY("team_id" AUTOINCREMENT)
);
CREATE TABLE "votes" (
    "vote_id" INTEGER UNIQUE,
	"voter_uid"	INTEGER,
	"score"	REAL,
	"mymlh_uid"	INTEGER,
	PRIMARY KEY("vote_id" AUTOINCREMENT)
);
CREATE TABLE "files" (
	"file_id" INTEGER,
	"file_name" TEXT,
	"file_code" TEXT,
	PRIMARY KEY("file_id" AUTOINCREMENT)
);
CREATE TABLE "voters" (
	"voter_uid"	INTEGER UNIQUE,
	"username"	TEXT,
    "salt"  TEXT,
	"key"	TEXT
);
CREATE TABLE "checkins" (
	"mlh_uid"	INTEGER UNIQUE,
	"checker_uid"	INTEGER,
	"checkin_id"	INTEGER NOT NULL UNIQUE,
	PRIMARY KEY("checkin_id" AUTOINCREMENT)
);
CREATE TABLE "sponsors" (
	"sponsor_uid"	INTEGER UNIQUE,
	"username"	TEXT,
    "salt"  TEXT,
	"key"	TEXT
);
CREATE TABLE "tickets" (
	"mymlh_uid"	INTEGER,
	"file_id"	INTEGER,
    "date_added"  DATETIME
);