CPAN-Testers-WWW-Preferences
view release on metacpan or search on metacpan
vhost/cgi-bin/db/cpanprefs-schema.sql view on Meta::CPAN
-- MySQL dump 10.13 Distrib 5.5.41, for debian-linux-gnu (i686)
--
-- Host: localhost Database: cpanprefs
-- ------------------------------------------------------
-- Server version 5.5.41-0ubuntu0.14.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `access`
--
DROP TABLE IF EXISTS `access`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `access` (
`accessid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`accessname` varchar(255) DEFAULT NULL,
`accesslevel` int(4) DEFAULT NULL,
PRIMARY KEY (`accessid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `acls`
--
DROP TABLE IF EXISTS `acls`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acls` (
`aclid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`folderid` int(10) unsigned NOT NULL DEFAULT '0',
`groupid` int(10) unsigned DEFAULT '0',
`userid` int(10) unsigned DEFAULT '0',
`accessid` int(4) DEFAULT NULL,
PRIMARY KEY (`aclid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `folders`
--
DROP TABLE IF EXISTS `folders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folders` (
`folderid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`parent` int(10) DEFAULT NULL,
`accessid` int(10) NOT NULL DEFAULT '5',
PRIMARY KEY (`folderid`),
KEY `IXPATH` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
`groupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`groupname` varchar(255) DEFAULT NULL,
`master` int(2) DEFAULT '0',
`member` varchar(255) DEFAULT NULL,
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `hits`
--
DROP TABLE IF EXISTS `hits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hits` (
`pageid` int(11) NOT NULL DEFAULT '0',
`photoid` int(11) NOT NULL DEFAULT '0',
`counter` int(11) DEFAULT NULL,
`area` varchar(32) DEFAULT '',
`query` varchar(255) DEFAULT '',
`createdate` varchar(255) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `images`
--
DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images` (
`imageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tag` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`type` int(4) DEFAULT NULL,
`href` varchar(255) DEFAULT NULL,
`dimensions` varchar(255) DEFAULT NULL,
PRIMARY KEY (`imageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `imagestock`
--
DROP TABLE IF EXISTS `imagestock`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imagestock` (
`stockid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`path` varchar(255) DEFAULT NULL,
PRIMARY KEY (`stockid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `imetadata`
--
DROP TABLE IF EXISTS `imetadata`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imetadata` (
`imageid` int(10) unsigned NOT NULL DEFAULT '0',
`tag` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`imageid`,`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ipindex`
--
DROP TABLE IF EXISTS `ipindex`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipindex` (
`ipaddr` varchar(255) NOT NULL DEFAULT '',
`author` varchar(255) NOT NULL DEFAULT '',
`type` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`ipaddr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ixfolderrealm`
--
DROP TABLE IF EXISTS `ixfolderrealm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ixfolderrealm` (
`folderid` int(10) unsigned NOT NULL DEFAULT '0',
`realmid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`folderid`,`realmid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ixusergroup`
--
DROP TABLE IF EXISTS `ixusergroup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ixusergroup` (
`indexid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` int(1) unsigned NOT NULL DEFAULT '0',
`linkid` int(10) unsigned NOT NULL DEFAULT '0',
`groupid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`indexid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `menus`
--
DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menus` (
`menuid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`typeid` int(10) unsigned DEFAULT '1',
`realmid` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) DEFAULT NULL,
PRIMARY KEY (`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `optimages`
--
DROP TABLE IF EXISTS `optimages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `optimages` (
`optionid` int(10) unsigned NOT NULL DEFAULT '0',
`typeid` int(10) unsigned NOT NULL DEFAULT '1',
`imageid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`optionid`,`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `options`
--
DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
`optionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`menuid` int(10) unsigned NOT NULL DEFAULT '0',
`orderno` int(2) DEFAULT '0',
`text` varchar(255) DEFAULT NULL,
`href` varchar(255) DEFAULT NULL,
PRIMARY KEY (`optionid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `prefs_authors`
--
DROP TABLE IF EXISTS `prefs_authors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prefs_authors` (
`pauseid` varchar(255) NOT NULL,
`active` int(2) DEFAULT '0',
`lastlogin` varchar(255) DEFAULT NULL,
PRIMARY KEY (`pauseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `prefs_distributions`
--
DROP TABLE IF EXISTS `prefs_distributions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prefs_distributions` (
`pauseid` varchar(255) NOT NULL,
`distribution` varchar(255) NOT NULL,
`ignored` int(1) DEFAULT '0',
`report` int(2) DEFAULT '0',
`grade` varchar(32) DEFAULT 'FAIL',
`tuple` varchar(32) DEFAULT 'FIRST',
`version` varchar(1000) DEFAULT 'LATEST',
`patches` int(1) DEFAULT '0',
`perl` varchar(1000) DEFAULT 'ALL',
`platform` varchar(1000) DEFAULT 'ALL',
PRIMARY KEY (`pauseid`,`distribution`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `realms`
--
DROP TABLE IF EXISTS `realms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `realms` (
`realmid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`realm` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`command` varchar(255) DEFAULT NULL,
PRIMARY KEY (`realmid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
`sessionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`labyrinth` varchar(255) DEFAULT NULL,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`realm` varchar(255) DEFAULT NULL,
`folderid` int(10) unsigned NOT NULL DEFAULT '0',
`optionid` int(10) unsigned NOT NULL DEFAULT '0',
`timeout` int(11) unsigned NOT NULL DEFAULT '0',
`langcode` char(2) NOT NULL DEFAULT 'en',
`query` blob,
PRIMARY KEY (`sessionid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `updates`
--
DROP TABLE IF EXISTS `updates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `updates` (
`upid` int(11) NOT NULL AUTO_INCREMENT,
`area` varchar(8) DEFAULT '',
`pageid` int(11) DEFAULT NULL,
`now` int(11) DEFAULT NULL,
`pagets` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`upid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`accessid` int(10) unsigned NOT NULL DEFAULT '1',
`imageid` int(10) unsigned NOT NULL DEFAULT '1',
`nickname` varchar(255) DEFAULT NULL,
`realname` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`realm` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`aboutme` blob,
`search` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2015-02-08 20:15:46
( run in 0.849 second using v1.01-cache-2.11-cpan-ceb78f64989 )