/*
SQLyog v10.2 
MySQL - 5.5.36-log : Database - edgesrv
*********************************************************************
*/


/*!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*/`edgesrv` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `edgesrv`;

/*Table structure for table `media_meta` */

CREATE TABLE `media_meta` (
  `seqno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fid` varchar(32) NOT NULL DEFAULT '',
  `msize` bigint(20) unsigned NOT NULL DEFAULT '0',
  `mimeid` int(10) unsigned NOT NULL DEFAULT '0',
  `mlife` int(10) unsigned NOT NULL DEFAULT '0',
  `mctime` datetime DEFAULT '0000-00-00 00:00:00',
  `mmtime` datetime DEFAULT '0000-00-00 00:00:00',
  `minode` int(10) unsigned NOT NULL DEFAULT '0',
  `width` smallint(5) unsigned NOT NULL DEFAULT '0',
  `height` smallint(5) unsigned NOT NULL DEFAULT '0',
  `vfps` int(10) unsigned NOT NULL DEFAULT '0',
  `duration` int(10) unsigned NOT NULL DEFAULT '0',
  `mtitle` varchar(64) NOT NULL DEFAULT '',
  `ctime` datetime DEFAULT '0000-00-00 00:00:00',
  `mtime` datetime DEFAULT '0000-00-00 00:00:00',
  `nodeid` int(10) unsigned NOT NULL DEFAULT '0',
  `subid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `partid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `packtotal` int(10) unsigned NOT NULL DEFAULT '0',
  `integral` tinyint(4) NOT NULL DEFAULT '0',
  `packnum` int(10) unsigned NOT NULL DEFAULT '0',
  `storagetype` tinyint(4) NOT NULL DEFAULT '0',
  `lastvisit` datetime DEFAULT '0000-00-00 00:00:00',
  `divert` tinyint(4) NOT NULL DEFAULT '0',
  `sync2ind` datetime DEFAULT '0000-00-00 00:00:00',
  `sync2core` datetime DEFAULT '0000-00-00 00:00:00',
  `sync2track` datetime DEFAULT '0000-00-00 00:00:00',
  `mftype` tinyint(4) NOT NULL DEFAULT '0',
  `auxtype` tinyint(4) NOT NULL DEFAULT '0',
  `pictype` tinyint(4) NOT NULL DEFAULT '0',
  `auxfid` varchar(32) NOT NULL DEFAULT '',
  `picfid` varchar(32) NOT NULL DEFAULT '',
  `moovsize` bigint(20) NOT NULL DEFAULT '0',
  `moovoff` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`seqno`),
  KEY `fidindex` (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=1148 DEFAULT CHARSET=utf8;

/*Table structure for table `media_store` */

CREATE TABLE `media_store` (
  `seqno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `url` varchar(1024) NOT NULL DEFAULT '',
  `urlid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `subid` int(10) unsigned NOT NULL DEFAULT '0',
  `path` varchar(512) NOT NULL DEFAULT '',
  `mctime` datetime DEFAULT '0000-00-00 00:00:00',
  `mmtime` datetime DEFAULT '0000-00-00 00:00:00',
  `filelife` int(10) unsigned NOT NULL DEFAULT '0',
  `mimeid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`seqno`),
  KEY `fidindex` (`urlid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `url_meta` */

CREATE TABLE `url_meta` (
  `seqno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `url` varchar(1024) NOT NULL DEFAULT '',
  `urlid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `subid` int(10) unsigned NOT NULL DEFAULT '0',
  `path` varchar(512) NOT NULL DEFAULT '',
  `mctime` datetime DEFAULT '0000-00-00 00:00:00',
  `mmtime` datetime DEFAULT '0000-00-00 00:00:00',
  `filelife` int(10) unsigned NOT NULL DEFAULT '0',
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  `mimeid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`seqno`),
  KEY `fidindex` (`urlid`)
) ENGINE=InnoDB AUTO_INCREMENT=19342 DEFAULT CHARSET=utf8;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;