Miscellany

CREATE TABLE `triggers` (
`id` MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`channel_id` MEDIUMINT NOT NULL,
`admin_id` MEDIUMINT NOT NULL,
`question` VARCHAR(32) NOT NULL,
`answer` TEXT NOT NULL
);

CREATE TABLE `admins` (
`id` MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`login` VARCHAR(30) NOT NULL,
`hashed_password` TEXT NOT NULL,
`access` MEDIUMNINT NOT NULL
);
 
CREATE TABLE `channels` (
`id` MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`channel` VARCHAR(32) NOT NULL,
`channel_wins` BOOLEAN NOT NULL,
`public` BOOLEAN NOT NULL
);

CREATE TABLE `admins_channels` (
`admin_id` MEDIUMINT NOT NULL,
`channel_id` MEDIUMINT NOT NULL
);