another simple mysql problem

date posted 27th April 2001 17:11

does anyone know why this .sql file won't import into a mysql database? It seems to come up with errors concerning the date, date right from the start.

thanks in advance

Rob

use shopmob;

create table members(
mem_no int(11) primary key not null,
name char(30),
address1 char(50),
address2 char(50),
address3 char(50),
postcode char(10),
tel_no char(20),
emerg_name char(20),
emerg_no char(20),
email char(40),
last_use date,
notes char(250));

create table scaft(
date date,
day char(15),
s1 char(10),
s2 char(10),
s3 char(10),
s4 char(10),
s5 char(10),
s6 char(10),
s7 char(10),
s8 char(10),
s9 char(10),
s10 char(10),
s11 char(10))

create table scmid(
date date,
day char(15),
s1 char(10),
s2 char(10),
s3 char(10),
s4 char(10),
s5 char(10),
s6 char(10),
s7 char(10),
s8 char(10),
s9 char(10),
s10 char(10),
s11 char(10))

create table scmorn(
date date,
day char(15),
s1 char(10),
s2 char(10),
s3 char(10),
s4 char(10),
s5 char(10),
s6 char(10),
s7 char(10),
s8 char(10),
s9 char(10),
s10 char(10),
s11 char(10))

create table wcmorn(
date date,
day char(15),
s1 char(10),
s2 char(10))

create table wcmid(
date date,
day char(15),
s1 char(10),
s2 char(10))

create table wcaft(
date date,
day char(15),
s1 char(10),
s2 char(10))

create table scooters(
number int(11) primary key,
wheelno char(3),
maxpay char(5),
speed char(10),
colour char(20),
notes char(250),
fault char(3),
lastuse char(10))

create table wheelchairs(
number int(11) primary key,
maxpay int(11),
colour char(20),
notes char(250),
fault char(3),
lastuse char(10))