master

分支 (1)

管理

管理

master

woc
/
operation.sql

# Host: 127.0.0.1  (Version 5.6.17)
# Date: 2019-02-20 15:22:50
# Generator: MySQL-Front 6.1  (Build 1.26)


#
# Structure for table "data"
#

DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `provider` varchar(64) NOT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "data"
#


#
# Structure for table "domain"
#

DROP TABLE IF EXISTS `domain`;
CREATE TABLE `domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `provider` varchar(64) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "domain"
#


#
# Structure for table "email"
#

DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `provider` varchar(64) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "email"
#


#
# Structure for table "function"
#

DROP TABLE IF EXISTS `function`;
CREATE TABLE `function` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

#
# Data for table "function"
#

INSERT INTO `function` VALUES (1,'网站管理'),(2,'域名管理'),(3,'主机管理'),(4,'数据管理'),(5,'邮箱管理'),(6,'用户管理'),(7,'角色管理'),(8,'分类管理'),(9,'功能管理');

#
# Structure for table "host"
#

DROP TABLE IF EXISTS `host`;
CREATE TABLE `host` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `provider` varchar(64) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "host"
#


#
# Structure for table "permission"
#

DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `perm` longtext,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

#
# Data for table "permission"
#

INSERT INTO `permission` VALUES (16,363064,'0'),(17,293066,'邮箱管理,数据管理,主机管理,域名管理,网站管理');

#
# Structure for table "rnum"
#

DROP TABLE IF EXISTS `rnum`;
CREATE TABLE `rnum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(64) NOT NULL,
  `onum` int(11) DEFAULT NULL,
  `cnum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "rnum"
#


#
# Structure for table "role"
#

DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "role"
#

INSERT INTO `role` VALUES (1,363064,'管理员'),(2,293066,'普通用户');

#
# Structure for table "site"
#

DROP TABLE IF EXISTS `site`;
CREATE TABLE `site` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(30) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `method` varchar(30) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `dmid` int(11) NOT NULL,
  `hid` int(11) NOT NULL,
  `dbid` int(11) NOT NULL,
  `eid` int(11) NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "site"
#


#
# Structure for table "type"
#

DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "type"
#

/*!40000 ALTER TABLE `type` DISABLE KEYS */;
INSERT INTO `type` VALUES (2,24155,'商城');
/*!40000 ALTER TABLE `type` ENABLE KEYS */;

#
# Structure for table "users"
#

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL,
  `pass` varchar(32) NOT NULL,
  `email` varchar(64) DEFAULT NULL,
  `telphone` varchar(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` int(11) NOT NULL,
  `access` int(11) NOT NULL,
  `login` int(11) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `rid` int(11) NOT NULL,
  `rname` varchar(64) NOT NULL,
  `ptid` int(11) NOT NULL,
  `pname` varchar(64) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "users"
#

INSERT INTO `users` VALUES (1,'admin','123456','test@163.com','123456',1,1296646925,1296646925,1296646925,'127.0.0.1',363064,'管理员',0,'All Product'),(2,'test','123456','test@163.com','123456',1,1296647117,1296647117,1296647117,'127.0.0.1',293066,'普通用户',0,'All Product');

#
# Structure for table "wocdata"
#

DROP TABLE IF EXISTS `wocdata`;
CREATE TABLE `wocdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `provider` varchar(64) NOT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wocdata"
#


#
# Structure for table "wocdomain"
#

DROP TABLE IF EXISTS `wocdomain`;
CREATE TABLE `wocdomain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) DEFAULT NULL,
  `username` varchar(64) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `provider` varchar(64) DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wocdomain"
#


#
# Structure for table "wocemail"
#

DROP TABLE IF EXISTS `wocemail`;
CREATE TABLE `wocemail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) DEFAULT NULL,
  `username` varchar(64) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `provider` varchar(64) DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wocemail"
#


#
# Structure for table "wocfunction"
#

DROP TABLE IF EXISTS `wocfunction`;
CREATE TABLE `wocfunction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `controller` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

#
# Data for table "wocfunction"
#

/*!40000 ALTER TABLE `wocfunction` DISABLE KEYS */;
INSERT INTO `wocfunction` VALUES (1,'网站管理','site'),(2,'域名管理','domain'),(3,'主机管理','host'),(4,'数据管理','data'),(5,'邮箱管理','email'),(6,'SEO管理','seo'),(7,'用户管理','user'),(8,'角色管理','role'),(9,'分类管理','type'),(10,'功能管理','function'),(11,'缓存管理','caches');
/*!40000 ALTER TABLE `wocfunction` ENABLE KEYS */;

#
# Structure for table "wochost"
#

DROP TABLE IF EXISTS `wochost`;
CREATE TABLE `wochost` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `provider` varchar(64) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wochost"
#


#
# Structure for table "wocpermission"
#

DROP TABLE IF EXISTS `wocpermission`;
CREATE TABLE `wocpermission` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `perm` longtext,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

#
# Data for table "wocpermission"
#

/*!40000 ALTER TABLE `wocpermission` DISABLE KEYS */;
INSERT INTO `wocpermission` VALUES (16,363064,'0'),(17,158608,'site,domain,host,data,email,seo');
/*!40000 ALTER TABLE `wocpermission` ENABLE KEYS */;

#
# Structure for table "wocrnum"
#

DROP TABLE IF EXISTS `wocrnum`;
CREATE TABLE `wocrnum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(64) NOT NULL,
  `onum` int(11) DEFAULT NULL,
  `cnum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wocrnum"
#


#
# Structure for table "wocrole"
#

DROP TABLE IF EXISTS `wocrole`;
CREATE TABLE `wocrole` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "wocrole"
#

/*!40000 ALTER TABLE `wocrole` DISABLE KEYS */;
INSERT INTO `wocrole` VALUES (1,363064,'管理员'),(2,158608,'普通用户');
/*!40000 ALTER TABLE `wocrole` ENABLE KEYS */;

#
# Structure for table "wocseo"
#

DROP TABLE IF EXISTS `wocseo`;
CREATE TABLE `wocseo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) NOT NULL,
  `alexa` int(11) DEFAULT NULL,
  `baidu` int(11) DEFAULT NULL,
  `google` int(11) DEFAULT NULL,
  `pr` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wocseo"
#


#
# Structure for table "wocsite"
#

DROP TABLE IF EXISTS `wocsite`;
CREATE TABLE `wocsite` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `admin` varchar(64) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `method` varchar(30) NOT NULL,
  `status` int(11) NOT NULL,
  `tid` int(11) DEFAULT '0',
  `dmid` int(11) DEFAULT '0',
  `hid` int(11) DEFAULT '0',
  `dbid` int(11) DEFAULT '0',
  `eid` int(11) DEFAULT '0',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "wocsite"
#


#
# Structure for table "woctype"
#

DROP TABLE IF EXISTS `woctype`;
CREATE TABLE `woctype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Data for table "woctype"
#


#
# Structure for table "wocusers"
#

DROP TABLE IF EXISTS `wocusers`;
CREATE TABLE `wocusers` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL,
  `pass` varchar(32) NOT NULL,
  `email` varchar(64) DEFAULT NULL,
  `telphone` varchar(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` int(11) NOT NULL,
  `access` int(11) NOT NULL,
  `login` int(11) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `rid` int(11) NOT NULL,
  `rname` varchar(64) NOT NULL,
  `ptid` int(11) NOT NULL,
  `pname` varchar(64) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "wocusers"
#

/*!40000 ALTER TABLE `wocusers` DISABLE KEYS */;
INSERT INTO `wocusers` VALUES (1,'admin','e10adc3949ba59abbe56e057f20f883e','test@163.com','123456',1,1344911011,1344911011,1344911011,'127.0.0.1',363064,'管理员',0,'All Product'),(2,'demo','e10adc3949ba59abbe56e057f20f883e','test@163.com','123456',1,1345017983,1345017983,1345017983,'127.0.0.1',158608,'普通用户',0,'All Product');
/*!40000 ALTER TABLE `wocusers` ENABLE KEYS */;