Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement