Comment 1 for bug 605121

Revision history for this message
George (george-archive) wrote :

From Chris:
Attached is a mysqldump of our database. I've excluded one table,
because it includes email addresses of our volunteers; that table has
the form:

CREATE TABLE `People` (
  `PeopleID` int(8) NOT NULL auto_increment,
  `Name` char(80) character set utf8 default NULL,
  `Nickname` char(80) character set utf8 default NULL,
  `EMail` char(80) default NULL,
  `URL` char(150) default NULL,
  `MaxMC` int(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`PeopleID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=3334 DEFAULT CHARSET=latin1;

If you want any help interpreting the data, let me know! One unobvious
bit of information which will help: in the Files table, a FileNumber
of 0 is used to hold project level information. You'll also find
duplication or near-duplication between the Projects table and the
Files table; this is an artifact of the way the system has developed.
The Files table is probably generally to be preferred.