carMAN
20-04-2004, 10:06
devo creare un database Mysql partendo da questo codice SQL :
--------------------------------------------------------------------------
-- Creazione del database
--------------------------------------------------------------------------
DROP DATABASE IF EXISTS exeurakmsdb;
CREATE DATABASE exeurakmsdb;
USE exeurakmsdb;
# -----------------------------------------------------------------------
# USER_PROFILE
# Contiene i profili utente.
# -----------------------------------------------------------------------
drop table if exists USER_PROFILE;
CREATE TABLE USER_PROFILE
(
ID INTEGER NOT NULL AUTO_INCREMENT,
NAME VARCHAR(99) NOT NULL,
DESCRIPTION VARCHAR(255),
PRIMARY KEY(ID),
UNIQUE(NAME)
) TYPE=InnoDB;
# -----------------------------------------------------------------------
# USER_ACCOUNT
# Tabella contenente gli utenti del sistema.
# -----------------------------------------------------------------------
drop table if exists USER_ACCOUNT;
CREATE TABLE USER_ACCOUNT
(
ID INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME VARCHAR(99),
LASTNAME VARCHAR(99),
USERNAME VARCHAR(99) NOT NULL,
PASSWORD VARCHAR(99) NOT NULL,
TELEPHONE VARCHAR(99),
EMAIL VARCHAR(99),
PRIMARY KEY(ID),
UNIQUE(USERNAME)
) TYPE=InnoDB;
# -----------------------------------------------------------------------
# ACCOUNT_PROFILE
# Relazione che definisce i profili utente assegnati ad ogni account
# -----------------------------------------------------------------------
drop table if exists ACCOUNT_PROFILE;
CREATE TABLE ACCOUNT_PROFILE
(
USER_ACCOUNT_ID INTEGER NOT NULL,
USER_PROFILE_ID INTEGER NOT NULL,
INDEX ap_account_id (USER_ACCOUNT_ID),
INDEX ap_profile_id (USER_PROFILE_ID),
PRIMARY KEY(USER_ACCOUNT_ID, USER_PROFILE_ID)
FOREIGN KEY(USER_ACCOUNT_ID) REFERENCES USER_ACCOUNT(ID),
FOREIGN KEY(USER_PROFILE_ID) REFERENCES USER_PROFILE(ID)
) TYPE=InnoDB;
etc...
etc..
purtroppo ottengo il seguente errore....
Query OK, 36 rows affected (0.03 sec)
Query OK, 1 row affected (0.00 sec)
Database changed
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
ERROR 1064: You have an error in your SQL syntax near 'FOREIGN KEY(USER_ACCOUNT_
ID) REFERENCES USER_ACCOUNT(ID),
FOREIGN KEY(USER_' at line 8
Query OK, 0 rows affected (0.00 sec)
..............
.............
dove sbaglio?
vi prego aiutatemi....
ciao ciao
--------------------------------------------------------------------------
-- Creazione del database
--------------------------------------------------------------------------
DROP DATABASE IF EXISTS exeurakmsdb;
CREATE DATABASE exeurakmsdb;
USE exeurakmsdb;
# -----------------------------------------------------------------------
# USER_PROFILE
# Contiene i profili utente.
# -----------------------------------------------------------------------
drop table if exists USER_PROFILE;
CREATE TABLE USER_PROFILE
(
ID INTEGER NOT NULL AUTO_INCREMENT,
NAME VARCHAR(99) NOT NULL,
DESCRIPTION VARCHAR(255),
PRIMARY KEY(ID),
UNIQUE(NAME)
) TYPE=InnoDB;
# -----------------------------------------------------------------------
# USER_ACCOUNT
# Tabella contenente gli utenti del sistema.
# -----------------------------------------------------------------------
drop table if exists USER_ACCOUNT;
CREATE TABLE USER_ACCOUNT
(
ID INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME VARCHAR(99),
LASTNAME VARCHAR(99),
USERNAME VARCHAR(99) NOT NULL,
PASSWORD VARCHAR(99) NOT NULL,
TELEPHONE VARCHAR(99),
EMAIL VARCHAR(99),
PRIMARY KEY(ID),
UNIQUE(USERNAME)
) TYPE=InnoDB;
# -----------------------------------------------------------------------
# ACCOUNT_PROFILE
# Relazione che definisce i profili utente assegnati ad ogni account
# -----------------------------------------------------------------------
drop table if exists ACCOUNT_PROFILE;
CREATE TABLE ACCOUNT_PROFILE
(
USER_ACCOUNT_ID INTEGER NOT NULL,
USER_PROFILE_ID INTEGER NOT NULL,
INDEX ap_account_id (USER_ACCOUNT_ID),
INDEX ap_profile_id (USER_PROFILE_ID),
PRIMARY KEY(USER_ACCOUNT_ID, USER_PROFILE_ID)
FOREIGN KEY(USER_ACCOUNT_ID) REFERENCES USER_ACCOUNT(ID),
FOREIGN KEY(USER_PROFILE_ID) REFERENCES USER_PROFILE(ID)
) TYPE=InnoDB;
etc...
etc..
purtroppo ottengo il seguente errore....
Query OK, 36 rows affected (0.03 sec)
Query OK, 1 row affected (0.00 sec)
Database changed
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
ERROR 1064: You have an error in your SQL syntax near 'FOREIGN KEY(USER_ACCOUNT_
ID) REFERENCES USER_ACCOUNT(ID),
FOREIGN KEY(USER_' at line 8
Query OK, 0 rows affected (0.00 sec)
..............
.............
dove sbaglio?
vi prego aiutatemi....
ciao ciao