dda_dimp

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';

CREATE SCHEMA IF NOT EXISTS `default_schema` ;
USE `default_schema` ;

-- -----------------------------------------------------
-- Table `default_schema`.`ddaUsers`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`ddaUsers` (
  `id` INT(6) NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(10) CHARACTER SET 'cp1251' COLLATE 'cp1251_bulgarian_ci' NOT NULL ,
  `email` VARCHAR(30) CHARACTER SET 'cp1251' COLLATE 'cp1251_bulgarian_ci' NOT NULL ,
  `password` VARCHAR(20) CHARACTER SET 'cp1251' COLLATE 'cp1251_bulgarian_ci' NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB
AUTO_INCREMENT = 36
DEFAULT CHARACTER SET = cp1251
COLLATE = cp1251_bulgarian_ci;


-- -----------------------------------------------------
-- Table `default_schema`.`ddaRel`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`ddaRel` (
  `user_ID` INT(6) NOT NULL ,
  `Friend_ID` INT(6) NOT NULL ,
  `rel_status` TINYINT(4) NOT NULL DEFAULT '0' ,
  INDEX `user_ID` (`user_ID` ASC, `Friend_ID` ASC) ,
  CONSTRAINT `ddaRel_ibfk_2`
	FOREIGN KEY (`user_ID` )
	REFERENCES `default_schema`.`ddaUsers` (`id` )
	ON DELETE NO ACTION
	ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = cp1251
COLLATE = cp1251_bulgarian_ci;


-- -----------------------------------------------------
-- Table `default_schema`.`ddaSearch_log`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`ddaSearch_log` (
  `id` INT(6) NOT NULL ,
  `term` VARCHAR(100) NULL ,
  INDEX `id` (`id` ASC) ,
  INDEX `term` () ,
  CONSTRAINT `ddaSearch_log_ibfk_6`
	FOREIGN KEY (`id` )
	REFERENCES `default_schema`.`ddaUsers` (`id` )
	ON DELETE NO ACTION
	ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = cp1251
COLLATE = cp1251_bulgarian_ci;


-- -----------------------------------------------------
-- Table `default_schema`.`ddaTweets`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`ddaTweets` (
  `user_ID` INT(6) NOT NULL ,
  `tweet_text` VARCHAR(160) NOT NULL ,
  `tweet_ID` INT(6) NOT NULL ,
  `in_reply` VARCHAR(45) NULL ,
  `create_at` DATETIME NOT NULL ,
  `name` VARCHAR(60) NULL ,
  INDEX `user_ID` USING BTREE (`user_ID` ASC) ,
  INDEX `tweet_ID` () ,
  CONSTRAINT `ddalTweets_ibfk_3`
	FOREIGN KEY (`user_ID` )
	REFERENCES `default_schema`.`ddaUsers` (`id` )
	ON DELETE NO ACTION
	ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `default_schema`.`signal`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`signal` (
  `flag` TINYINT(1) NOT NULL ,
  PRIMARY KEY (`flag`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `default_schema`.`ddaTweets_terms`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`ddaTweets_terms` (
  `tweet_ID` INT(6) NOT NULL ,
  `term` VARCHAR(100) NULL ,
  INDEX `term` (`term` ASC) ,
  INDEX `tweet_ID` () ,
  CONSTRAINT `fk_ddaTweets_terms_ddaSearch_log1`
	FOREIGN KEY (`term` )
	REFERENCES `default_schema`.`ddaSearch_log` (`term` )
	ON DELETE NO ACTION
	ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `default_schema`.`JSONcache`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `default_schema`.`JSONcache` (
  `tweet_ID` INT(6) NOT NULL ,
  `cache_ID` INT NOT NULL DEFAULT current_timestamp ,
  `cache_date` DATETIME NOT NULL ,
  `raw_tweet` TEXT NOT NULL ,
  `parsen` INT NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`tweet_ID`) ,
  CONSTRAINT `fk_JSONcache_ddaTweets_terms1`
	FOREIGN KEY (`tweet_ID` )
	REFERENCES `default_schema`.`ddaTweets_terms` (`tweet_ID` )
	ON DELETE NO ACTION
	ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Placeholder table for view `default_schema`.`view1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `default_schema`.`view1` (`id` INT);

-- -----------------------------------------------------
-- View `default_schema`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `default_schema`.`view1`;
USE `default_schema`;
;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;