MySQL Table Structures

ws_comments

commentID int(10) unsigned NOT NULL auto_increment,
subject varchar(50) default NULL,
text text,
confrontationID int(10) unsigned NOT NULL default '0',
eventID int(10) unsigned NOT NULL default '0',
nationID int(10) unsigned NOT NULL default '0',
type varchar(6) default NULL,
show tinyint(4) NOT NULL default '1',
timeEntered datetime default NULL,
personEntered int(10) unsigned default NULL,
PRIMARY KEY (commentID),
UNIQUE KEY commentID (commentID),
KEY commentID_2 (commentID)

ws_confType

typeID smallint(5) unsigned NOT NULL auto_increment,
label varchar(50) NOT NULL default '',
PRIMARY KEY (typeID),
UNIQUE KEY typeID (typeID),
KEY typeID_2 (typeID)

ws_confrontations

confrontationID int(10) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
details text,
confType smallint(5) unsigned NOT NULL default '1',
startDate date NOT NULL default '0000-00-00',
startAD tinyint(3) unsigned NOT NULL default '1',
endDate date NOT NULL default '0000-00-00',
endAD tinyint(3) unsigned NOT NULL default '1',
personEntered int(10) unsigned default NULL,
timeEntered datetime default NULL,
reliability tinyint(4) NOT NULL default '1',
source text NOT NULL,
PRIMARY KEY (confrontationID),
UNIQUE KEY confrontationID (confrontationID),
KEY confrontationID_2 (confrontationID)

ws_eventType

typeID smallint(5) unsigned NOT NULL auto_increment,
label varchar(50) NOT NULL default '0',
PRIMARY KEY (typeID),
UNIQUE KEY typeID (typeID),
KEY typeID_2 (typeID)

ws_events

eventID int(10) unsigned NOT NULL auto_increment,
confrontationID int(10) unsigned default NULL,
name varchar(50) NOT NULL default '',
details text,
location text default NULL,
startDate date NOT NULL default '0000-00-00',
startAD tinyint(3) unsigned NOT NULL default '1',
endDate date NOT NULL default '0000-00-00',
endAD tinyint(3) unsigned NOT NULL default '1',
latDegrees smallint(6) default NULL,
latMinutes tinyint(4) default NULL,
latSeconds tinyint(4) default NULL,
latDirection enum('E','W') default NULL,
lonDegrees smallint(6) default NULL,
lonMinutes tinyint(4) default NULL,
lonSeconds tinyint(4) default NULL,
lonDirection enum('N','S') default NULL,
eventType smallint(5) unsigned NOT NULL default '1',
radius float default NULL,
timeEntered datetime default NULL,
personEntered int(10) unsigned default NULL,
reliability tinyint(4) unsigned NOT NULL default '1',
source text NOT NULL,
PRIMARY KEY (eventID),
UNIQUE KEY eventID (eventID),
KEY eventID_2 (eventID)

ws_nations

nationID int(10) unsigned NOT NULL auto_increment,
name varchar(50) default NULL,
latDegrees smallint(6) default NULL,
latMinutes tinyint(4) default NULL,
latSeconds tinyint(4) default NULL,
latDirection enum('E','W') default NULL,
lonDegrees smallint(6) default NULL,
lonMinutes tinyint(4) default NULL,
lonSeconds tinyint(4) default NULL,
lonDirection enum('N','S') default NULL,
radius float default NULL,
timeEntered datetime default NULL,
personEntered int(10) unsigned default NULL,
location text default NULL,
startDate date default NULL,
startAD tinyint(3) unsigned NOT NULL default '1',
endDate date default NULL,
endAD tinyint(3) unsigned NOT NULL default '1',
reliability tinyint(4) unsigned NOT NULL default '1',
PRIMARY KEY (nationID),
UNIQUE KEY nationID (nationID),
KEY nationID_2 (nationID)

ws_participation

participationID int(10) unsigned NOT NULL auto_increment,
nationID int(10) unsigned default NULL,
eventID int(10) unsigned default NULL,
PRIMARY KEY (participationID),
UNIQUE KEY participationID (participationID),
KEY participationID_2 (participationID)

ws_people

personID int(10) unsigned NOT NULL auto_increment,
fName varchar(50) default NULL,
lName varchar(50) default NULL,
email varchar(50) default NULL,
password varchar(50) default NULL,
nation varchar(50) default NULL,
reliability tinyint(4) unsigned NOT NULL default '1',
PRIMARY KEY (personID),
UNIQUE KEY personID (personID),
KEY personID_2 (personID)