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.
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.