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


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

USE `indsrv`;

/*Table structure for table `file_part` */

CREATE TABLE `file_part` (
  `seqno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `subid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `partid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `path` varchar(64) NOT NULL DEFAULT '',
  `mntdir` varchar(32) NOT NULL DEFAULT '',
  `fsid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `part_bsize` bigint(20) unsigned NOT NULL DEFAULT '0',
  `part_size` bigint(20) unsigned NOT NULL DEFAULT '0',
  `part_used` bigint(20) unsigned NOT NULL DEFAULT '0',
  `part_avail` bigint(20) unsigned NOT NULL DEFAULT '0',
  `updatetime` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`seqno`),
  KEY `partidindex` (`partid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Table structure for table `file_part_id` */

CREATE TABLE `file_part_id` (
  `seqid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stub` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`seqid`),
  UNIQUE KEY `stub` (`stub`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*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',
  `lastvisit` datetime DEFAULT '0000-00-00 00:00:00',
  `divert` tinyint(4) NOT NULL DEFAULT '0',
  `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 '',
  PRIMARY KEY (`seqno`),
  KEY `fidindex` (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=28592 DEFAULT CHARSET=utf8;

/*Table structure for table `media_store` */

CREATE TABLE `media_store` (
  `seqno` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fid` varchar(32) NOT NULL DEFAULT '',
  `nodeid` int(10) unsigned NOT NULL DEFAULT '0',
  `subid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `partid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `integral` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `packnum` int(10) unsigned NOT NULL DEFAULT '0',
  `updatetime` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`seqno`),
  KEY `fidindex` (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=29733 DEFAULT CHARSET=utf8;

/*Table structure for table `nodeinfo` */

CREATE TABLE `nodeinfo` (
  `seqno` bigint(20) NOT NULL AUTO_INCREMENT,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `nodeid` int(11) DEFAULT '0',
  `subid` int(11) DEFAULT '0',
  `nodename` text,
  `nodetype` tinyint(3) DEFAULT '0',
  `edgenum` int(11) NOT NULL DEFAULT '0',
  `onlinetime` bigint(20) NOT NULL DEFAULT '0',
  `fidnum` bigint(20) NOT NULL DEFAULT '0',
  `totalstore` int(11) NOT NULL DEFAULT '0',
  `freestore` int(11) NOT NULL DEFAULT '0',
  `nodecon` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '节点并发数',
  `ipnum` int(11) NOT NULL DEFAULT '1',
  `iotare` int(11) NOT NULL DEFAULT '0',
  `udpport` int(11) NOT NULL COMMENT '对外提供服务的端口',
  `tcpport` int(11) NOT NULL,
  `httpport` int(11) NOT NULL,
  `ip1` char(16) NOT NULL DEFAULT '',
  `port1` int(11) NOT NULL DEFAULT '0',
  `ispid1` int(11) NOT NULL DEFAULT '0',
  `countyid1` int(11) NOT NULL DEFAULT '0',
  `provid1` int(11) NOT NULL DEFAULT '0',
  `cityid1` int(11) NOT NULL DEFAULT '0',
  `countryid1` int(11) NOT NULL DEFAULT '0',
  `corpid1` int(11) NOT NULL DEFAULT '0',
  `organid1` int(11) NOT NULL DEFAULT '0',
  `netband1` int(11) NOT NULL DEFAULT '0',
  `ip2` char(16) NOT NULL DEFAULT '',
  `port2` int(11) NOT NULL DEFAULT '0',
  `ispid2` int(11) NOT NULL DEFAULT '0',
  `countyid2` int(11) NOT NULL DEFAULT '0',
  `provid2` int(11) NOT NULL DEFAULT '0',
  `cityid2` int(11) NOT NULL DEFAULT '0',
  `countryid2` int(11) NOT NULL DEFAULT '0',
  `corpid2` int(11) NOT NULL DEFAULT '0',
  `organid2` int(11) NOT NULL DEFAULT '0',
  `netband2` int(11) NOT NULL DEFAULT '0',
  `ip3` char(16) NOT NULL DEFAULT '',
  `port3` int(11) NOT NULL DEFAULT '0',
  `ispid3` int(11) NOT NULL DEFAULT '0',
  `countyid3` int(11) NOT NULL DEFAULT '0',
  `provid3` int(11) NOT NULL DEFAULT '0',
  `cityid3` int(11) NOT NULL DEFAULT '0',
  `countryid3` int(11) NOT NULL DEFAULT '0',
  `corpid3` int(11) NOT NULL DEFAULT '0',
  `organid3` int(11) NOT NULL DEFAULT '0',
  `netband3` int(11) NOT NULL DEFAULT '0',
  `ip4` char(16) NOT NULL DEFAULT '',
  `port4` int(11) NOT NULL DEFAULT '0',
  `ispid4` int(11) NOT NULL DEFAULT '0',
  `countyid4` int(11) NOT NULL DEFAULT '0',
  `provid4` int(11) NOT NULL DEFAULT '0',
  `cityid4` int(11) NOT NULL DEFAULT '0',
  `countryid4` int(11) NOT NULL DEFAULT '0',
  `corpid4` int(11) NOT NULL DEFAULT '0',
  `organid4` int(11) NOT NULL DEFAULT '0',
  `netband4` int(11) NOT NULL DEFAULT '0',
  `onlinestate` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '在线状态',
  `inuse` tinyint(4) NOT NULL DEFAULT '1' COMMENT '启用',
  PRIMARY KEY (`seqno`)
) ENGINE=InnoDB AUTO_INCREMENT=32 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 */;