/*

SQLyog Ultimate v12.09 (64 bit)

MySQL - 8.0.17 : Database - openeuler

*********************************************************************

*/




/*!40101 SET NAMES utf8 */;



/*!40101 SET SQL_MODE=''*/;



/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`openeuler` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;



USE `openeuler`;



/*Table structure for table `blog_visits` */



DROP TABLE IF EXISTS `blog_visits`;



CREATE TABLE `blog_visits` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(255) DEFAULT NULL,

  `date` varchar(32) DEFAULT NULL,

  `lang` varchar(12) DEFAULT NULL,

  `count` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `NOR_INDEX` (`title`,`date`,`lang`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `news_visits`;



CREATE TABLE `news_visits` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(255) DEFAULT NULL,

  `date` varchar(32) DEFAULT NULL,

  `lang` varchar(12) DEFAULT NULL,

  `count` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `NOR_INDEX` (`title`,`date`,`lang`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;