RE: FN-FORUM another simple mysql problem

date posted 27th April 2001 17:25

Any reason why you are using char(30) & char(50), a tinytext would probably
save space for you. If there are any reasons not to use them, please let me
know.


Regards


Darren Spink
http://www.arkad.leeds.co.uk


-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of [EMAIL REMOVED]
Sent: 27 April 2001 17:11
To: [EMAIL REMOVED]
Subject: FN-FORUM another simple mysql problem


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))



============================================================

* Free listing for freelancers
* Free to advertise jobs
* Free jobs distribution service
* Free database of 1000 freelancers

Freelancers and Freelance Jobs
http://www.freelancers.net

To post to the Forum:
[EMAIL REMOVED]

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]

To subscribe to the digest for this list or for further information please
visit:
http://www.freelancers.net/forum.html