yes they do exist. thats what is confusing me! I could have put the whole of my code in but i thought u experts would think i was trying to get you to debug my code! anyway this is what i have and the last table does not work! ps vincent r u from the US? thanks if you can assist me! I'm about to start a career in the IT industry and was wondering what good jobs are available/ pay well! I currently live in london. cheers!
CREATE TABLE CLIENTS
( CID INT UNISGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
CMPNYNAME VARCHAR(20),
FNAME VARCHAR(20) NOT NULL,
LNAME VARCHAR(20) NOT NULL,
HOUSE_NO CHAR(6) NOT NULL,
STREET VARCHAR(30) NOT NULL,
TOWN VARCHAR(20),
POSTCODE VARCHAR(10) NOT NULL,
EMAIL VARCHAR(20),
CONTACT_NO INT ZEROFILL NOT NULL
)
TYPE=INNODB;
CREATE TABLE ARTISTS
( MEMBERID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
FNAME VARCHAR(20) NOT NULL,
LNAME VARCHAR(20) NOT NULL,
HOUSE_NO CHAR(6) NOT NULL,
STREET VARCHAR(30) NOT NULL,
TOWN VARCHAR(20),
POSTCODE VARCHAR(10) NOT NULL,
DOB DATE NOT NULL,
EMAIL VARCHAR(20),
CONTACT_NO INT ZEROFILL NOT NULL,
STAGENAME VARCHAR(15),
EXPRNCE_IN_YEARS INT UNSIGNED NOT NULL,
SEX CHAR(1) NOT NULL,
NI_NO VARCHAR(12) NOT NULL
)
TYPE=INNODB;
CREATE TABLE SPECIALIST_AREA
( MEMBERID INT UNSIGNED NOT NULL
SPECIAL_AREA VARCHAR(20) NOT NULL //EG DJ, SINGER, DANCER, MC ETC.
GENRE VARCHAR(20),
FOREIGN KEY (MEMBERID)REFERENCES ARTISTS (MEMBERID)
)
TYPE=INNODB;
CREATE TABLE ARTIST_BOOKING
( MEMBERID INT UNSIGNED NOT NULL,
CID INT UNSIGNED NOT NULL,
DATE_NOW TIMESTAMP(6) NOT NULL,
DATE_FOR DATE,
HOURS TINYINT(2),
PRIMARY KEY (MEMBERID, CID, DATE_NOW),
FOREIGN KEY (MEMBERID) REFERENCES ARTISTS (MEMBERID),
FOREIGN KEY (CID) REFERENCES CLIENTS (CID)
)
TYPE=INNODB;
ps I copyright the code here so no one can use it or ill have there hides!
