CREATE TABLE IF NOT EXISTS `def_newsfeed` (
`Guid` CHAR(50) NOT NULL,
`Package` VARCHAR(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT 'ObjNewsFeed',
`ProfileName` VARCHAR(255) DEFAULT NULL,
`Prompt` TEXT DEFAULT NULL,
`Text` TEXT DEFAULT NULL,
PRIMARY KEY (`Guid`, `Package`),
UNIQUE KEY `uq_profile` (`ProfileName`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation}
CREATE TABLE IF NOT EXISTS `def_rss` (
`Channel` VARCHAR(255) NOT NULL,
`Package` VARCHAR(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT 'ObjNewsFeed',
`Url` VARCHAR(512) DEFAULT NULL,
`Description` TEXT DEFAULT NULL,
PRIMARY KEY (`Channel`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation}