Error 1064, når jeg vil oprette database
Jeg forsøger at oprette en ny database i MySQL direkte med et SQL query, jeg har nu klippet en kode direkte herinde fra, fordi jeg troede at det var min egen der var helt f*cked up, men jeg får stadig samme fejl :Her er SQL, som jeg submitter direkte fra Query Analyzer :
#
# Opretter databasen: webshop
#
CREATE DATABASE webshop;
use webshop;
#
#Tabel struktur for: shop_dealer
#
CREATE TABLE shop_dealer (
dealer_id INT NOT NULL auto_increment,
company_name VARCHAR (30) NOT NULL,
contact_person VARCHAR (128) NOT NULL,
address1 VARCHAR (128) NOT NULL,
address2 VARCHAR (128) NOT NULL,
zipcide INT (4) NOT NULL,
town VARCHAR (128) NOT NULL,
phone INT (11) NOT NULL,
cellphone INT (11) NOT NULL,
PRIMARY KEY (dealer_id)
) TYPE=INNODB;
#
#Tabel struktur for: shop_products
#
CREATE TABLE shop_products (
product_id INT NOT NULL auto_increment,
name VARCHAR (15) NOT NULL ,
descript TEXT NOT NULL ,
in_price MEDIUMINT (16) NOT NULL ,
out_price MEDIUMINT (16) NOT NULL ,
cat VARCHAR (10) NOT NULL ,
photo BLOB NOT NULL ,
sale ENUM ('Y','N') NOT NULL default 'N',
store MEDIUMINT (16) NOT NULL ,
ordermore MEDIUMINT (16) NOT NULL ,
primary_dealer INT NOT NULL,
PRIMARY KEY (product_id) ,
INDEX dealer_id_idx (primary_dealer),
FOREIGN KEY (primary_dealer) REFERENCES shop_dealer(dealer_id)
) TYPE=INNODB;
#
#Tabel struktur for: shop_customer
#
CREATE TABLE shop_customer (
customer_id INT NOT NULL auto_increment,
f_name VARCHAR (128) NOT NULL,
l_name VARCHAR (128) NOT NULL,
address1 VARCHAR (128) NOT NULL,
address2 VARCHAR (128) NOT NULL,
zipcide INT (4) NOT NULL,
town VARCHAR (128) NOT NULL,
phone INT (11) NOT NULL,
cellphone INT (11) NOT NULL,
PRIMARY KEY (customer_id)
) TYPE=INNODB;
#
#Tabel struktur for: shop_basket
#
CREATE TABLE shop_basket(
basket_id INT NOT NULL auto_increment ,
session_id VARCHAR (32) NOT NULL ,
product_id INT NOT NULL ,
PRIMARY KEY (basket_id) ,
INDEX product_id_idx(product_id),
FOREIGN KEY (product_id) REFERENCES shop_products(product_id)
) TYPE=INNODB;
#
#Tabel struktur for: shop_orders
#
CREATE TABLE shop_orders (
order_id INT (12) NOT NULL auto_increment ,
product_id INT NOT NULL ,
customer_id INT NOT NULL ,
date INT (12) NOT NULL,
PRIMARY KEY (order_id) ,
INDEX product_id_idx(product_id),
FOREIGN KEY (product_id) REFERENCES shop_products(product_id) ,
INDEX customer_id_idx(customer_id),
FOREIGN KEY (customer_id) REFERENCES shop_customer(customer_id)
) TYPE=INNODB;
Og her er fejlen som jeg modtager:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
use webshop;
#
#Tabel struktur for: shop_dealer
#
CREATE TABLE shop_d' at line 4
Det er en MySQl 4.12 på en Windows 2000 server, jeg er logget ind som root, remote, men med alle rettigheder på alle tabeller *.*.
Hvis jeg skriver CREATE DATABASE webshop, så bliver den oprettet, men ikke når det er en del af et større script.
Please anyone ??