You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
43 lines
1.4 KiB
MySQL
43 lines
1.4 KiB
MySQL
5 years ago
|
-- MySQL Script generated by MySQL Workbench
|
||
|
-- Mon 11 Feb 2019 05:11:47 PM MST
|
||
|
-- Model: New Model Version: 1.0
|
||
|
-- MySQL Workbench Forward Engineering
|
||
|
|
||
|
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
|
||
|
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
|
||
|
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
|
||
|
|
||
|
-- -----------------------------------------------------
|
||
|
-- Schema todaystream
|
||
|
-- -----------------------------------------------------
|
||
|
|
||
|
-- -----------------------------------------------------
|
||
|
-- Table `requestcache`
|
||
|
-- -----------------------------------------------------
|
||
|
CREATE TABLE IF NOT EXISTS `requestcache` (
|
||
|
`reqid` INT NOT NULL AUTO_INCREMENT,
|
||
|
`url` VARCHAR(255) NOT NULL,
|
||
|
`expires` DATETIME NOT NULL,
|
||
|
`content` LONGTEXT NOT NULL,
|
||
|
PRIMARY KEY (`reqid`, `url`),
|
||
|
UNIQUE INDEX `reqid_UNIQUE` (`reqid` ASC))
|
||
|
ENGINE = InnoDB;
|
||
|
|
||
|
|
||
|
-- -----------------------------------------------------
|
||
|
-- Table `imagecache`
|
||
|
-- -----------------------------------------------------
|
||
|
CREATE TABLE IF NOT EXISTS `imagecache` (
|
||
|
`imgid` INT NOT NULL AUTO_INCREMENT,
|
||
|
`url` TEXT NOT NULL,
|
||
|
`hash` VARCHAR(60) NOT NULL,
|
||
|
`created` DATETIME NOT NULL,
|
||
|
PRIMARY KEY (`imgid`),
|
||
|
UNIQUE INDEX `imgid_UNIQUE` (`imgid` ASC))
|
||
|
ENGINE = InnoDB;
|
||
|
|
||
|
|
||
|
SET SQL_MODE=@OLD_SQL_MODE;
|
||
|
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
|
||
|
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
|