CPAN-Testers-WWW-Preferences
view release on metacpan or search on metacpan
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
--
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 */;
--
-- Dumping data for table `access`
--
INSERT INTO `access` VALUES (1,'reader',1);
INSERT INTO `access` VALUES (2,'editor',2);
INSERT INTO `access` VALUES (3,'publisher',3);
INSERT INTO `access` VALUES (4,'admin',4);
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
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 */;
--
-- Dumping data for table `acls`
--
INSERT INTO `acls` VALUES (1,1,9,0,5);
INSERT INTO `acls` VALUES (2,1,1,0,1);
INSERT INTO `acls` VALUES (3,1,0,5,4);
INSERT INTO `acls` VALUES (4,1,0,4,4);
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
--
-- 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 */;
--
-- Dumping data for table `folders`
--
INSERT INTO `folders` VALUES (1,'public',0,1);
--
-- Table structure for table `groups`
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
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 */;
--
-- Dumping data for table `groups`
--
INSERT INTO `groups` VALUES (1,'public',1,'Guest');
INSERT INTO `groups` VALUES (2,'testers',1,'Tester');
INSERT INTO `groups` VALUES (3,'authors',1,'Author');
INSERT INTO `groups` VALUES (5,'admins',1,'Admin');
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
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 */;
--
-- Dumping data for table `images`
--
INSERT INTO `images` VALUES (1,NULL,'images/blank.png',1,NULL,NULL);
--
-- 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 */;
--
-- Dumping data for table `imagestock`
--
INSERT INTO `imagestock` VALUES (1,'Public','images/public');
INSERT INTO `imagestock` VALUES (2,'Random','images/public');
INSERT INTO `imagestock` VALUES (3,'Advert','images/adverts');
INSERT INTO `imagestock` VALUES (4,'User','images/users');
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
-- 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 */;
--
-- Dumping data for table `imetadata`
--
--
-- 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 */;
--
-- Dumping data for table `ipindex`
--
--
-- 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 */;
--
-- Dumping data for table `ixfolderrealm`
--
INSERT INTO `ixfolderrealm` VALUES (1,1);
INSERT INTO `ixfolderrealm` VALUES (1,2);
--
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
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 */;
--
-- Dumping data for table `ixusergroup`
--
INSERT INTO `ixusergroup` VALUES (1,1,1,1);
INSERT INTO `ixusergroup` VALUES (2,1,1,9);
--
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
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 */;
--
-- Dumping data for table `menus`
--
INSERT INTO `menus` VALUES (1,2,1,'test');
--
-- 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 */;
--
-- Dumping data for table `optimages`
--
--
-- Table structure for table `options`
--
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
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 */;
--
-- Dumping data for table `options`
--
--
-- 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` (
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
`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 */;
--
-- Dumping data for table `realms`
--
INSERT INTO `realms` VALUES (1,'public','Public Interface','home-main');
INSERT INTO `realms` VALUES (2,'admin','Admin Interface','home-admin');
--
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
`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` (
vhost/cgi-bin/db/cpanprefs-master.sql view on Meta::CPAN
`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 */;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES (1,2,1,'','PAUSE','PAUSE','author','9935dfb5a4d397598918b95cafea8828afe115be','',0);
INSERT INTO `users` VALUES (2,1,1,'','Guest','GUEST','public','c8d6ea7f8e6850e9ed3b642900ca27683a257201','',0);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
vhost/cgi-bin/db/cpanprefs-schema.sql view on Meta::CPAN
--
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` (
vhost/cgi-bin/db/cpanprefs-schema.sql view on Meta::CPAN
`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` (
vhost/cgi-bin/db/cpanprefs-schema.sql view on Meta::CPAN
`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` (
vhost/cgi-bin/db/cpanprefs-schema.sql view on Meta::CPAN
`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 */;
( run in 0.389 second using v1.01-cache-2.11-cpan-88abd93f124 )