Форум

CRE ATE   TABLE `b_blog_smile` (
   `ID` SMALLINT(3) NOT NULL AUTO_INCREMENT,
   `SMILE_TYPE` CHAR(1) NOT NULL DEFAULT 'S' COLLATE 'utf8_unicode_ci',
   `TYPING` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
   `IMAGE` VARCHAR(128) NOT NULL COLLATE 'utf8_unicode_ci',
   `DESCRIPTION` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
   `CLICKABLE` CHAR(1) NOT NULL DEFAULT 'Y' COLLATE 'utf8_unicode_ci',
   `SORT` INT(10) NOT NULL DEFAULT '150',
   `IMAGE_WIDTH` INT(11) NOT NULL DEFAULT '0',
   `IMAGE_HEIGHT` INT(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=15
;

-- -----------------------------------
-- Dumping table b_blog_site_path
-- -----------------------------------
DR OP   TABLE IF EXISTS `b_blog_site_path`;
CRE ATE   TABLE `b_blog_site_path` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SITE_ID` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `PATH` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `TYPE` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `IX_BLOG_SITE_PATH_2` (`SITE_ID`,`TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;