[Hampshire] [OT] BaB Soton Uni register MySQL script

Hi

I have just put together a MySQL script as I'm about to start filling in
the BaB meeting register DB for my own use (printed copy for security).
Here is the script for the DB, I'm about to add a PHP front end to it and
add data. Any thoughts? I'll make the front end available Saturday for
further discussion. I use XAMPP so it is network visible from within ECS
(with an htaccess password).

#------------------------------------------------------------
# Written by Damian Brasher 13 Jan 2009
# Vim sql editor on FC8
# Executed once to define database and tables with constraints
#------------------------------------------------------------
#DROP DATABASE bab_register;
CREATE DATABASE bab_register;

USE bab_register;

DROP TABLE IF EXISTS attendee;
CREATE TABLE attendee (
        forename        VARCHAR(50) NOT NULL,
        surname         VARCHAR(50) NOT NULL,
        email           VARCHAR(50),
        member          ENUM('yes','no') NOT NULL,
        new_attendee    ENUM('yes','no') NOT NULL,
        mac             VARCHAR(50),
                        PRIMARY KEY (forename, surname),
                        FOREIGN KEY (mac) REFERENCES macs (mac)
) COMMENT "HLUG BaB meeting register Southampton Uni (ECS)";

DROP TABLE IF EXISTS macs;
CREATE TABLE macs (
        mac             VARCHAR(50) NOT NULL,
                        PRIMARY KEY (mac)
) COMMENT "MAC Address entries";

Cheers Damian

--
http://www.diap.org.uk - distributed backup volume management system.

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.