-- mysql -h homepages.cs.ncl.ac.uk -u root -p <TableCreate.sql

USE `ncrr`;
DROP TABLE IF EXISTS `dsnregistrations`;
CREATE TABLE `dsnregistrations` (

    `id`		INT (4) UNSIGNED AUTO_INCREMENT,

    `fullname`		varchar(80) default NULL,
    `organisation`	varchar(80) default NULL,
    `address`		varchar(80) default NULL,
    `phone`		varchar(80) default NULL,
    `fax`		varchar(80) default NULL,
    `email`		varchar(80) default NULL,
    `diet`		varchar(80) default NULL,
    `membershipNo`	varchar(80) default NULL,
    `delegateType`	varchar(80) default NULL,
    `confType`		varchar(80) default NULL,
    `tutorialAM`	varchar(80) default NULL,
    `tutorialPM`	varchar(80) default NULL,
    `stirling`		varchar(80) default NULL,
    `stirlingChild`	varchar(80) default NULL,
    `proc`		varchar(80) default NULL,
    `total`		varchar(80) default NULL,
    `cardType`		varchar(80) default NULL,
    `ccnum`		varchar(80) default NULL,
    `cardmonth`		varchar(80) default NULL,
    `cardyear`		varchar(80) default NULL,
    `cv2`		varchar(80) default NULL,
    `cardname`		varchar(80) default NULL,
    `cardaddr`		varchar(80) default NULL,

    `priceConf`		varchar(80) default NULL,
    `priceProc`		varchar(80) default NULL,
    `priceStirling`	varchar(80) default NULL,
    `priceTotal`	varchar(80) default NULL,
    `priceTut`		varchar(80) default NULL,
    `datestamp`		date default NULL,
    `timestamp`		time default NULL,
    `remoteIP`		varchar(80) default NULL,

    PRIMARY KEY (`ID`)

) COMMENT='DSN 2007 online bookings';

