Advertisement
KetchupMonki

Schema planning

Feb 27th, 2020
382
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.00 KB | None | 0 0
  1. CREATE TABLE watch (
  2.     id INT(11) auto_increment,
  3.     dbHost VARCHAR(253),
  4.     dbUser VARCHAR(32),
  5.     dbPass VARCHAR(32),
  6.     dbName VARCHAR(64),
  7.     dbTable VARCHAR(64),
  8.     discordServerId INT(18),
  9.     discordChannelId INT(18),
  10.     stringTemplate VARCHAR(256),
  11.     PRIMARY KEY (id)
  12. );
  13.  
  14. CREATE TABLE postRecords (
  15.     id INT(11) auto_increment,
  16.     watchId INT(11),
  17.     watchSubjectId INT(11),
  18.     PRIMARY KEY (id)
  19. );
  20.  
  21. CREATE TABLE ketchupRssWatchList (
  22.     id INT(11) auto_increment,
  23.     ownerId INT(11),
  24.     status INT(2) DEFAULT 0,
  25.     maxProcessInterval INT(6) DEFAULT 120,
  26.     lastProcessed DATETIME DEFAULT 0,
  27.     lastItemDate DATETIME DEFAULT 0,
  28.     rssUrl VARCHAR(2048) NOT NULL,
  29.     discordServerId VARCHAR(18) NOT NULL,
  30.     discordChannelId VARCHAR(18) NOT NULL,
  31.     stringTemplate VARCHAR(256) NOT NULL DEFAULT "New post from !!t: !!it\n!!il",
  32.     PRIMARY KEY (id)
  33. );
  34.  
  35. CREATE TABLE ketchupRssServerClaims (
  36.     id INT(11) auto_increment,
  37.     ownerId INT(11),
  38.     discordServerId INT(18) NOT NULL
  39.     PRIMARY KEY (id)
  40. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement