remark.txt

##
sudo chmod 777 protected/runtime/
sudo chmod 777 protected/models/
sudo chmod 777 adminConfig/*.php
sudo chmod 777 upload
sudo chmod 777 uploadOfAdmin
sudo chmod 777 assets


##
Remove index.php line:
defined('YII_DEBUG') or define('YII_DEBUG', true)
for production mode

##
Configure Less/UglifyJS for source folder

##
Create database in utf8mb4 encoding

##
CREATE TABLE `user` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `nickname` VARCHAR(20) NOT NULL,
  `email` VARCHAR(45) NOT NULL,
  `is_male` TINYINT UNSIGNED NOT NULL DEFAULT 1,
  `password` CHAR(32) NOT NULL,
  `avatar_url` TEXT NOT NULL,
  `introduction` TEXT NULL,
  `reg_time` DATETIME NOT NULL,
  `last_login_time` DATETIME NOT NULL,
  `account_status` SMALLINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '1 for OK, 2 for disabled, 3 for need verification',
  `admin_status` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 for non-admin, 1 for super, 2 for limited',
  `admin_access_param` TEXT NULL,
  `extra_data` TEXT NULL COMMENT 'For admin remark',
  `mobile_data` TEXT NULL COMMENT 'For app remark',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `nickname_UNIQUE` (`nickname` ASC),
  UNIQUE INDEX `email_UNIQUE` (`email` ASC));


ALTER TABLE `user` AUTO_INCREMENT = 6808;


CREATE TABLE `log` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT UNSIGNED NOT NULL,
  `user_name` TEXT NULL,
  `user_agent` TEXT NOT NULL,
  `url` TEXT NOT NULL,
  `time` DATETIME NOT NULL,
  `ip` VARCHAR(30) NOT NULL,
  `log` TEXT NOT NULL,
  PRIMARY KEY (`id`));


CREATE TABLE `dynamic_page` (
  `key` VARCHAR(20) NOT NULL,
  `content` LONGTEXT NULL,
  `last_modified_time` DATETIME NOT NULL,
  PRIMARY KEY (`key`));

CREATE TABLE `user_notification` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT UNSIGNED NOT NULL,
  `has_read` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `content` TEXT NOT NULL,
  `create_time` DATETIME NOT NULL,
  `rel_link` TEXT NULL,
  PRIMARY KEY (`id`));

CREATE TABLE `mobile_session_token` (
  `token` CHAR(12) NOT NULL,
  `user_id` INT UNSIGNED NOT NULL,
  `create_client` TEXT NOT NULL,
  `create_time` DATETIME NOT NULL,
  `expire_time` DATETIME NOT NULL,
  PRIMARY KEY (`token`));

CREATE TABLE `mobile_notification_device` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT UNSIGNED NOT NULL,
  `token` VARCHAR(100) NOT NULL,
  `is_debug` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `reg_time` DATETIME NOT NULL,
  `device_type` SMALLINT NOT NULL COMMENT '1 for iOS',
  `param` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX `AppNotifIdx1` (`user_id` ASC),
  INDEX `AppNotifIdx2` (`token` ASC));

CREATE TABLE `tourway`.`user_auto_email` (
  `key` CHAR(20) NOT NULL,
  `user_id` INT UNSIGNED NOT NULL,
  `create_time` DATETIME NOT NULL,
  `type` SMALLINT UNSIGNED NOT NULL,
  PRIMARY KEY (`key`));