BL0HyHDh

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `the_league_webapp` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `the_league_webapp` ;
7
8-- -----------------------------------------------------
9-- Table `the_league_webapp`.`tl_brightcove`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `the_league_webapp`.`tl_brightcove` (
12  `id` BIGINT NOT NULL ,
13  `short_description` VARCHAR(256) NULL ,
14  `long_description` VARCHAR(256) NULL ,
15  `thumbnail_url` VARCHAR(256) NULL ,
16  `json_raw` VARCHAR(2048) NULL ,
17  PRIMARY KEY (`id`) )
18ENGINE = InnoDB;
19
20
21CREATE USER `league` IDENTIFIED BY 'league';
22
23grant DELETE on TABLE `the_league_webapp`.`tl_brightcove` to league;
24grant INSERT on TABLE `the_league_webapp`.`tl_brightcove` to league;
25grant SELECT on TABLE `the_league_webapp`.`tl_brightcove` to league;
26grant UPDATE on TABLE `the_league_webapp`.`tl_brightcove` to league;
27
28SET SQL_MODE=@OLD_SQL_MODE;
29SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
30SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;