Jim Nicholson wrote:
> To add a mac address, you must have an attendee, and you cannot delete
> an attendee if there are any mac addresses referring to it.
Thanks, I see that, apart from the comma at PRIMARY KEY (id), now removed
and MySQL complains about AUTO_INCREMENT not being a primary key so I
changed that from mac to id in table macs, that won't matter.
Jacqui wrote:
>vc(50) for email address is often too short - consider vc(200)
150, compromise...
CREATE DATABASE bab_register;
USE bab_register;
DROP TABLE IF EXISTS attendee;
CREATE TABLE attendee (
id INT NOT NULL AUTO_INCREMENT,
forename VARCHAR(50) NOT NULL,
surname VARCHAR(50) NOT NULL,
email VARCHAR(150),
member ENUM('yes','no') NOT NULL,
new_attendee ENUM('yes','no') NOT NULL,
PRIMARY KEY (id)
) COMMENT "HLUG BaB meeting register Southampton Uni (ECS)";
DROP TABLE IF EXISTS macs;
CREATE TABLE macs (
id INT NOT NULL AUTO_INCREMENT,
attendee_id INT NOT NULL,
mac VARCHAR(50) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (attendee_id) REFERENCES attendee (id)
) COMMENT "MAC Address entries, more than one per attendee";
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.
