View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000415Main CAcert Websitesource codepublic2007-02-19 20:292013-01-14 21:26
Reporterroverwolf Assigned ToSourcerer  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version2008 
Summary0000415: cacert.sql file in current source download file (20070207) is out of date
DescriptionThe includes/cacert.sql file in the cacert-20070207.tar.bz2 source download version is out of date.

A fix for Bug 414 would probably make use of an existing table called tverify which does not have a definition in the sql file in the tarball.
TagsNo tags attached.
Attached Files
cacert.sql (21,050 bytes)    
# CAcert SQL Dump
# version 0.0.2
#
# Generation Time: Tue, 20 Feb 2007 10:13:55 +1100#
# Database: `cacert`
#
# --------------------------------------------------------

#
# Table structure for table `abusereports`
#

DROP TABLE IF EXISTS `abusereports`;
CREATE TABLE `abusereports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `when` datetime NOT NULL,
  `IP` int(11) default NULL,
  `url` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `reason` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `addlang`
#

DROP TABLE IF EXISTS `addlang`;
CREATE TABLE `addlang` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `lang` varchar(5) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userid` (`userid`,`lang`)
) ENGINE=MyISAM AUTO_INCREMENT=2559 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `adminlog`
#

DROP TABLE IF EXISTS `adminlog`;
CREATE TABLE `adminlog` (
  `when` datetime NOT NULL,
  `old-lname` varchar(255) NOT NULL,
  `old-dob` date NOT NULL,
  `new-lname` varchar(255) NOT NULL,
  `new-dob` date NOT NULL,
  `uid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `advertising`
#

DROP TABLE IF EXISTS `advertising`;
CREATE TABLE `advertising` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `replaceid` int(10) unsigned NOT NULL,
  `replaced` tinyint(3) unsigned NOT NULL,
  `orderid` tinyint(3) unsigned NOT NULL,
  `link` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `months` tinyint(3) unsigned NOT NULL,
  `who` int(10) unsigned NOT NULL,
  `when` datetime NOT NULL,
  `active` tinyint(3) unsigned NOT NULL,
  `approvedby` int(10) unsigned NOT NULL,
  `expires` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `alerts`
#

DROP TABLE IF EXISTS `alerts`;
CREATE TABLE `alerts` (
  `memid` int(11) NOT NULL default '0',
  `general` tinyint(1) NOT NULL default '0',
  `country` tinyint(1) NOT NULL default '0',
  `regional` tinyint(1) NOT NULL default '0',
  `radius` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`memid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `baddomains`
#

DROP TABLE IF EXISTS `baddomains`;
CREATE TABLE `baddomains` (
  `domain` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `countries`
#

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `id` int(3) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `disputedomain`
#

DROP TABLE IF EXISTS `disputedomain`;
CREATE TABLE `disputedomain` (
  `id` int(11) NOT NULL default '0',
  `memid` int(11) NOT NULL default '0',
  `oldmemid` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `hash` varchar(50) NOT NULL default '',
  `attempts` int(1) NOT NULL default '0',
  `action` enum('accept','reject','failed') NOT NULL default 'accept'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `disputeemail`
#

DROP TABLE IF EXISTS `disputeemail`;
CREATE TABLE `disputeemail` (
  `id` int(11) NOT NULL default '0',
  `memid` int(11) NOT NULL default '0',
  `oldmemid` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `hash` varchar(50) NOT NULL default '',
  `attempts` int(1) NOT NULL default '0',
  `action` enum('accept','reject','failed') NOT NULL default 'accept',
  `IP` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `domaincerts`
#

DROP TABLE IF EXISTS `domaincerts`;
CREATE TABLE `domaincerts` (
  `id` int(11) NOT NULL auto_increment,
  `domid` int(11) NOT NULL default '0',
  `serial` varchar(50) NOT NULL default '',
  `CN` varchar(255) NOT NULL default '',
  `subject` text NOT NULL,
  `csr_name` varchar(255) NOT NULL default '',
  `crt_name` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `revoked` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `warning` tinyint(1) NOT NULL default '0',
  `renewed` tinyint(1) NOT NULL default '0',
  `rootcert` int(2) NOT NULL default '1',
  `md` enum('md5','sha1','sha256','sha512') NOT NULL default 'sha1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108015 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `domains`
#

DROP TABLE IF EXISTS `domains`;
CREATE TABLE `domains` (
  `id` int(11) NOT NULL auto_increment,
  `memid` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `deleted` datetime NOT NULL default '0000-00-00 00:00:00',
  `hash` varchar(50) NOT NULL default '',
  `attempts` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `memid` (`memid`)
) ENGINE=MyISAM AUTO_INCREMENT=85757 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `domlink`
#

DROP TABLE IF EXISTS `domlink`;
CREATE TABLE `domlink` (
  `certid` int(11) NOT NULL default '0',
  `domid` int(11) NOT NULL default '0',
  UNIQUE KEY `index` (`certid`,`domid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `email`
#

DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
  `id` int(11) NOT NULL auto_increment,
  `memid` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `deleted` datetime NOT NULL default '0000-00-00 00:00:00',
  `hash` varchar(50) NOT NULL default '',
  `attempts` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `memid` (`memid`)
) ENGINE=MyISAM AUTO_INCREMENT=121770 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `emailcerts`
#

DROP TABLE IF EXISTS `emailcerts`;
CREATE TABLE `emailcerts` (
  `id` int(11) NOT NULL auto_increment,
  `memid` int(11) NOT NULL default '0',
  `serial` varchar(50) NOT NULL default '',
  `CN` varchar(255) NOT NULL default '',
  `subject` text NOT NULL,
  `keytype` char(2) NOT NULL default 'NS',
  `codesign` tinyint(1) NOT NULL default '0',
  `csr_name` varchar(255) NOT NULL default '',
  `crt_name` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `revoked` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `warning` tinyint(1) NOT NULL default '0',
  `renewed` tinyint(1) NOT NULL default '0',
  `rootcert` int(2) NOT NULL default '1',
  `md` enum('md5','sha1','sha256','sha512') NOT NULL default 'sha1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=109556 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `emaillink`
#

DROP TABLE IF EXISTS `emaillink`;
CREATE TABLE `emaillink` (
  `emailcertsid` int(11) NOT NULL default '0',
  `emailid` int(11) NOT NULL default '0',
  KEY `index` (`emailcertsid`,`emailid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `gpg`
#

DROP TABLE IF EXISTS `gpg`;
CREATE TABLE `gpg` (
  `id` int(11) NOT NULL auto_increment,
  `memid` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `level` int(1) NOT NULL default '0',
  `multiple` tinyint(1) NOT NULL default '0',
  `expires` tinyint(1) NOT NULL default '0',
  `csr` varchar(255) NOT NULL default '',
  `crt` varchar(255) NOT NULL default '',
  `issued` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5074 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `languages`
#

DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
  `locale` varchar(5) NOT NULL,
  `en_co` varchar(255) NOT NULL,
  `en_lang` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `lang` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `localias`
#

DROP TABLE IF EXISTS `localias`;
CREATE TABLE `localias` (
  `locid` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  KEY `locid` (`locid`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `locations`
#

DROP TABLE IF EXISTS `locations`;
CREATE TABLE `locations` (
  `id` int(7) NOT NULL auto_increment,
  `regid` int(4) NOT NULL default '0',
  `ccid` int(3) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `lat` double(6,3) NOT NULL default '0.000',
  `long` double(6,3) NOT NULL default '0.000',
  `acount` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ccid` (`ccid`),
  KEY `regid` (`regid`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2337663 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `news`
#

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `when` datetime NOT NULL default '0000-00-00 00:00:00',
  `who` varchar(255) NOT NULL default '',
  `short` varchar(255) NOT NULL default '',
  `story` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `notary`
#

DROP TABLE IF EXISTS `notary`;
CREATE TABLE `notary` (
  `id` int(11) NOT NULL auto_increment,
  `from` int(11) NOT NULL default '0',
  `to` int(11) NOT NULL default '0',
  `awarded` int(3) NOT NULL default '0',
  `points` int(3) NOT NULL default '0',
  `method` enum('Face to Face Meeting','Trusted Third Parties','Thawte Points Transfer','Administrative Increase','CT Magazine - Germany','Temporary Increase','Unknown') NOT NULL default 'Face to Face Meeting',
  `location` varchar(255) NOT NULL default '',
  `date` varchar(255) NOT NULL default '',
  `when` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `sponsor` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `from` (`from`),
  KEY `to` (`to`)
) ENGINE=MyISAM AUTO_INCREMENT=53190 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `org`
#

DROP TABLE IF EXISTS `org`;
CREATE TABLE `org` (
  `orgid` int(11) NOT NULL default '0',
  `memid` int(11) NOT NULL default '0',
  `OU` varchar(255) NOT NULL default '',
  `masteracc` int(1) NOT NULL default '0',
  `comments` text NOT NULL,
  UNIQUE KEY `orgid` (`orgid`,`memid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `orgdomaincerts`
#

DROP TABLE IF EXISTS `orgdomaincerts`;
CREATE TABLE `orgdomaincerts` (
  `id` int(11) NOT NULL auto_increment,
  `orgid` int(11) NOT NULL default '0',
  `subject` text NOT NULL,
  `serial` varchar(50) NOT NULL default '',
  `CN` varchar(255) NOT NULL default '',
  `csr_name` varchar(255) NOT NULL default '',
  `crt_name` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `revoked` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `renewed` tinyint(1) NOT NULL default '0',
  `rootcert` int(2) NOT NULL default '1',
  `md` enum('md5','sha1','sha256','sha512') NOT NULL default 'sha1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=897 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `orgdomains`
#

DROP TABLE IF EXISTS `orgdomains`;
CREATE TABLE `orgdomains` (
  `id` int(11) NOT NULL auto_increment,
  `orgid` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=339 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `orgdomlink`
#

DROP TABLE IF EXISTS `orgdomlink`;
CREATE TABLE `orgdomlink` (
  `orgcertid` int(11) NOT NULL default '0',
  `orgdomid` int(11) NOT NULL default '0',
  UNIQUE KEY `index` (`orgcertid`,`orgdomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `orgemailcerts`
#

DROP TABLE IF EXISTS `orgemailcerts`;
CREATE TABLE `orgemailcerts` (
  `id` int(11) NOT NULL auto_increment,
  `orgid` int(11) NOT NULL default '0',
  `serial` varchar(50) NOT NULL default '',
  `CN` varchar(255) NOT NULL default '',
  `subject` text NOT NULL,
  `keytype` char(2) NOT NULL default 'NS',
  `csr_name` varchar(255) NOT NULL default '',
  `crt_name` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `revoked` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire` datetime NOT NULL default '0000-00-00 00:00:00',
  `renewed` tinyint(1) NOT NULL default '0',
  `rootcert` int(2) NOT NULL default '1',
  `md` enum('md5','sha1','sha256','sha512') NOT NULL default 'sha1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `orgemaillink`
#

DROP TABLE IF EXISTS `orgemaillink`;
CREATE TABLE `orgemaillink` (
  `emailcertsid` int(11) NOT NULL default '0',
  `domid` int(11) NOT NULL default '0',
  KEY `index` (`emailcertsid`,`domid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `orginfo`
#

DROP TABLE IF EXISTS `orginfo`;
CREATE TABLE `orginfo` (
  `id` int(11) NOT NULL auto_increment,
  `contact` varchar(255) NOT NULL default '',
  `O` varchar(255) NOT NULL default '',
  `L` varchar(255) NOT NULL default '',
  `ST` varchar(255) NOT NULL default '',
  `C` char(2) NOT NULL default '',
  `comments` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `otphashes`
#

DROP TABLE IF EXISTS `otphashes`;
CREATE TABLE `otphashes` (
  `when` datetime NOT NULL,
  `username` varchar(255) NOT NULL,
  `otp` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `pinglog`
#

DROP TABLE IF EXISTS `pinglog`;
CREATE TABLE `pinglog` (
  `when` datetime NOT NULL,
  `uid` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `result` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `regions`
#

DROP TABLE IF EXISTS `regions`;
CREATE TABLE `regions` (
  `id` int(5) NOT NULL auto_increment,
  `ccid` int(3) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `ccid` (`ccid`)
) ENGINE=MyISAM AUTO_INCREMENT=4790 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `stampcache`
#

DROP TABLE IF EXISTS `stampcache`;
CREATE TABLE `stampcache` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `certid` int(10) unsigned default NULL,
  `cacheexpire` bigint(20) unsigned default NULL,
  `issued` datetime NOT NULL,
  `expire` datetime NOT NULL,
  `subject` varchar(255) NOT NULL,
  `hostname` varchar(255) NOT NULL,
  `org` tinyint(1) NOT NULL,
  `points` tinyint(3) unsigned NOT NULL,
  `O` varchar(255) NOT NULL,
  `L` varchar(255) NOT NULL,
  `ST` varchar(255) NOT NULL,
  `C` varchar(255) NOT NULL,
  `valid` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `hostname` (`hostname`)
) ENGINE=MyISAM AUTO_INCREMENT=169 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `tverify-vote`
#

DROP TABLE IF EXISTS `tverify-vote`;
CREATE TABLE `tverify-vote` (
  `tverify` int(11) NOT NULL default '0',
  `memid` int(11) NOT NULL default '0',
  `when` datetime NOT NULL default '0000-00-00 00:00:00',
  `vote` tinyint(1) NOT NULL default '0',
  `comment` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `tverify`
#

DROP TABLE IF EXISTS `tverify`;
CREATE TABLE `tverify` (
  `id` int(11) NOT NULL auto_increment,
  `memid` int(11) NOT NULL default '0',
  `photoid` varchar(255) NOT NULL default '',
  `URL` text NOT NULL,
  `CN` text NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=400 DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `userlocations`
#

DROP TABLE IF EXISTS `userlocations`;
CREATE TABLE `userlocations` (
  `id` int(11) NOT NULL auto_increment,
  `memid` int(11) NOT NULL default '0',
  `ccid` int(11) NOT NULL default '0',
  `regid` int(11) NOT NULL default '0',
  `locid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `users`
#

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `fname` varchar(255) NOT NULL default '',
  `mname` varchar(255) NOT NULL default '',
  `lname` varchar(255) NOT NULL default '',
  `suffix` varchar(50) NOT NULL default '',
  `dob` date NOT NULL default '0000-00-00',
  `verified` int(1) NOT NULL default '0',
  `ccid` int(3) NOT NULL default '0',
  `regid` int(5) NOT NULL default '0',
  `locid` int(7) NOT NULL default '0',
  `listme` int(1) NOT NULL default '0',
  `codesign` int(1) NOT NULL default '0',
  `1024bit` tinyint(1) NOT NULL default '0',
  `contactinfo` varchar(255) NOT NULL default '',
  `admin` tinyint(1) NOT NULL default '0',
  `orgadmin` tinyint(1) NOT NULL,
  `ttpadmin` tinyint(1) NOT NULL default '0',
  `adadmin` tinyint(1) unsigned NOT NULL,
  `board` tinyint(1) NOT NULL default '0',
  `tverify` tinyint(1) NOT NULL default '0',
  `locadmin` tinyint(1) NOT NULL default '0',
  `language` varchar(5) NOT NULL default '',
  `Q1` varchar(255) NOT NULL default '',
  `Q2` varchar(255) NOT NULL default '',
  `Q3` varchar(255) NOT NULL default '',
  `Q4` varchar(255) NOT NULL default '',
  `Q5` varchar(255) NOT NULL default '',
  `A1` varchar(255) NOT NULL default '',
  `A2` varchar(255) NOT NULL default '',
  `A3` varchar(255) NOT NULL default '',
  `A4` varchar(255) NOT NULL default '',
  `A5` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `deleted` datetime NOT NULL default '0000-00-00 00:00:00',
  `locked` tinyint(1) NOT NULL,
  `uniqueID` varchar(255) NOT NULL,
  `otphash` varchar(16) NOT NULL,
  `otppin` smallint(4) unsigned zerofill NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ccid` (`ccid`),
  KEY `regid` (`regid`),
  KEY `locid` (`locid`)
) ENGINE=MyISAM AUTO_INCREMENT=85317 DEFAULT CHARSET=latin1;
cacert.sql (21,050 bytes)   
Reviewed by
Test Instructions

Relationships

related to 0000414 closedSourcerer [Tverify] Need a list of still pending request 
related to 0000412 closedSourcerer please remove sqldump.php 

Activities

homer

2007-02-20 00:21

reporter   ~0000796

We have a security issue that let users grab the sql structure

I've attached the sql database schema

Sourcerer

2008-03-18 18:13

administrator   ~0001041

You can always get the current SQL structure through http://www.cacert.org/sqldump.php

Sourcerer

2008-11-17 19:47

administrator   ~0001256

The old SQL script has been removed from the tarball now.

Issue History

Date Modified Username Field Change
2007-02-19 20:29 roverwolf New Issue
2007-02-19 20:30 roverwolf Relationship added related to 0000414
2007-02-20 00:18 homer Relationship added related to 0000412
2007-02-20 00:20 homer File Added: cacert.sql
2007-02-20 00:21 homer Note Added: 0000796
2008-03-18 18:13 Sourcerer Status new => solved?
2008-03-18 18:13 Sourcerer Resolution open => fixed
2008-03-18 18:13 Sourcerer Assigned To => Sourcerer
2008-03-18 18:13 Sourcerer Note Added: 0001041
2008-11-17 19:47 Sourcerer Note Added: 0001256
2008-11-17 19:47 Sourcerer Status solved? => closed
2008-11-17 19:47 Sourcerer Fixed in Version => production
2013-01-14 21:26 Werner Dworak Fixed in Version => 2008