CREATE TABLE watch (
    id INT(11) auto_increment,
    dbHost VARCHAR(253),
    dbUser VARCHAR(32),
    dbPass VARCHAR(32),
	dbName VARCHAR(64),
	dbTable VARCHAR(64),
	discordServerId INT(18),
	discordChannelId INT(18),
	stringTemplate VARCHAR(256),
    PRIMARY KEY (id)
);

CREATE TABLE postRecords (
    id INT(11) auto_increment,
    watchId INT(11),
    watchSubjectId INT(11),
    PRIMARY KEY (id)
);

CREATE TABLE ketchupRssWatchList (
    id INT(11) auto_increment,
	ownerId INT(11),
	status INT(2) DEFAULT 0,
	maxProcessInterval INT(6) DEFAULT 120,
	lastProcessed DATETIME DEFAULT 0,
	lastItemDate DATETIME DEFAULT 0,
	rssUrl VARCHAR(2048) NOT NULL,
	discordServerId VARCHAR(18) NOT NULL,
	discordChannelId VARCHAR(18) NOT NULL,
	stringTemplate VARCHAR(256) NOT NULL DEFAULT "New post from !!t: !!it\n!!il",
    PRIMARY KEY (id)
);

CREATE TABLE ketchupRssServerClaims (
    id INT(11) auto_increment,
	ownerId INT(11),
	discordServerId INT(18) NOT NULL
    PRIMARY KEY (id)
);