Hallo zusammen,
irgendwie find ich garnix mehr.... wo liegt der verd*** Fehler??
Keine Ahnung was hier faul ist. Gruss
irgendwie find ich garnix mehr.... wo liegt der verd*** Fehler??
Code:
CREATE TABLE account (
account_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
accountNo INTEGER UNSIGNED NULL,
bankCode INTEGER UNSIGNED NULL,
credit DOUBLE NULL,
rentDuration TIME NULL,
customer_Id INTEGER UNSIGNED NULL,
car_Id INTEGER UNSIGNED NULL,
PRIMARY KEY(account_id)
);
CREATE TABLE car (
car_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
manufacturer VARCHAR NULL,
modelName VARCHAR NULL,
carNo VARCHAR NULL,
licensePlateNo VARCHAR NULL,
category_id INTEGER UNSIGNED NULL,
location_id INTEGER UNSIGNED NULL,
PRIMARY KEY(car_id)
);
CREATE TABLE carcategory (
carcategory_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
categoryName VARCHAR NULL,
basicConfiguration VARCHAR NULL,
location_id INTEGER UNSIGNED NULL,
attribute_01 VARCHAR NULL,
attribute_02 VARCHAR NULL,
attribute_03 VARCHAR NULL,
attribute_04 VARCHAR NULL,
attribute_05 VARCHAR NULL,
attribute_06 VARCHAR NULL,
attribute_07 VARCHAR NULL,
PRIMARY KEY(carcategory_id)
);
CREATE TABLE customer (
customer_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
accountId INTEGER UNSIGNED NULL,
firstName VARCHAR(45) NULL,
secondName VARCHAR(45) NULL,
adresse VARCHAR NULL,
privTelNo VARCHAR NULL,
privFaxNo VARCHAR NULL,
businessTelNo VARCHAR NOT NULL,
businessFaxNo VARCHAR NULL,
mobileTelNo VARCHAR NULL,
privEmailAdr VARCHAR NULL,
driversLicenseNo INTEGER UNSIGNED NULL,
isCollectivMember BOOL NULL,
identificationIdNo INTEGER UNSIGNED NULL,
company_name VARCHAR NULL,
buisnessEmailAdr VARCHAR NULL,
mainLocationId INTEGER UNSIGNED NULL,
PRIMARY KEY(customer_id)
);
CREATE TABLE rentCars (
rentCars_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
rentFrom DATE NULL,
rentTill DATE NULL,
PRIMARY KEY(rentCars_id)
);
CREATE TABLE location (
location_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR NULL,
adresse VARCHAR NULL,
parkinglotsNo INTEGER UNSIGNED NULL,
PRIMARY KEY(location_id)
);
Code:
[1] sammy@uranos > mysql -u testusr -h dbserv testdb < /mnt/usb/testdb.sql ~
Enter password:
ERROR 1064 (42000) at line 12: 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 'NULL,
modelName VARCHAR NULL,
carNo VARCHAR NULL,
licensePlateNo VARCHA' at line 3Keine Ahnung was hier faul ist. Gruss
