Oi galera,
Se alguém puder ajudar ficarei imensamente grata! Há dias estou tentando criar um banco de dados usando o DBDesigner. Consegui modelar direitinho meu banco, mas na hora de sincronizar com o MySQL, ele dá erro de sintaxe! Aí vai o Script com os erros:
Obs.: onde aparecer uma carinha é um oito entre parênteses.
------------------------------ Statistics ------------------------------
· Connection established with host “localhost” on port 3306
· Server: 4.0.15-nt
· Client: 3.23.52
· Protocol-Version: 10
· Uptime: 1652
· Threads: 2
· Questions: 104
· Slow queries: 0
· Opens: 17
· Flush tables: 1
· Open tables: 9
· Queries per second avg: 0.063
SELECT VERSION()
SHOW VARIABLES
SHOW STATUS
SHOW PROCESSLIST
SHOW DATABASES
SHOW TABLES FROM audit
SHOW TABLES FROM mysql
SHOW TABLES FROM sisatend
SHOW TABLES FROM test
SHOW TABLE STATUS
CREATE TABLE tbl_depe (
CD_PRF_DEPE SMALLINT UNSIGNED NOT NULL,
NM_DEPE VARCHAR NULL,
PRIMARY KEY(CD_PRF_DEPE)
)
TYPE=InnoDB
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, PRIMARY KEY(CD_PRF_DEPE) ) TYPE=InnoDB’ at line 1
CREATE TABLE tbl_situ (
CD_SITU SMALLINT UNSIGNED NOT NULL,
TX_DCR_SITU VARCHAR NULL,
PRIMARY KEY(CD_SITU)
)
TYPE=InnoDB
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, PRIMARY KEY(CD_SITU) ) TYPE=InnoDB’ at line 1
CREATE TABLE tbl_usu (
CD_USU VARCHAR(8) NOT NULL,
NM_USU VARCHAR NULL,
CRG_USU VARCHAR NULL,
DIV_USU VARCHAR NULL,
PRIMARY KEY(CD_USU)
)
TYPE=InnoDB
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, CRG_USU VARCHAR NULL, DIV_USU VARCHAR NULL, PRIMARY KEY(C
CREATE TABLE tbl_tip_asnt (
CD_TIP_ASNT SMALLINT UNSIGNED NOT NULL,
TX_DCR_TIP_ASNT VARCHAR NULL,
PRIMARY KEY(CD_TIP_ASNT)
)
TYPE=InnoDB
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, PRIMARY KEY(CD_TIP_ASNT) ) TYPE=InnoDB’ at line 1
CREATE TABLE tbl_asnt (
CD_ASNT SMALLINT UNSIGNED NOT NULL,
CD_TIP_ASNT SMALLINT UNSIGNED NOT NULL,
TX_DCR_ASNT BLOB NULL,
PRIMARY KEY(CD_ASNT),
INDEX tbl_asnt_FKIndex1(CD_TIP_ASNT),
FOREIGN KEY(CD_TIP_ASNT)
REFERENCES tbl_tip_asnt(CD_TIP_ASNT)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
TYPE=InnoDB
Can’t create table ‘.\sisatend\tbl_asnt.frm’ (errno: 150)
CREATE TABLE tbl_div (
CD_PRF_DEPE SMALLINT UNSIGNED NOT NULL,
CD_DIV SMALLINT UNSIGNED NOT NULL,
NM_DIV VARCHAR NULL,
PRIMARY KEY(CD_PRF_DEPE, CD_DIV),
INDEX tbl_div_FKIndex1(CD_PRF_DEPE),
FOREIGN KEY(CD_PRF_DEPE)
REFERENCES tbl_depe(CD_PRF_DEPE)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
TYPE=InnoDB
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, PRIMARY KEY(CD_PRF_DEPE, CD_DIV), INDEX tbl_div_FKIndex1(
CREATE TABLE tbl_atdt (
CD_ATDT MEDIUMINT UNSIGNED NOT NULL,
CD_ASNT SMALLINT UNSIGNED NOT NULL,
DT_ATDT DATE NULL,
TMP_INC_ATDT TIME NULL,
TMP_FIM_ATDT TIME NULL,
CMPT_ASNT BLOB NULL,
NM_CTT VARCHAR NULL,
TEL_CTT VARCHAR NULL,
PRIMARY KEY(CD_ATDT),
INDEX tbl_atdt_FKIndex1(CD_ASNT),
FOREIGN KEY(CD_ASNT)
REFERENCES tbl_asnt(CD_ASNT)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
TYPE=InnoDB
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, TEL_CTT VARCHAR NULL, PRIMARY KEY(CD_ATDT), INDEX tbl_atd
CREATE TABLE tbl_hst_situ (
TS_SITU_ATDT DATETIME NOT NULL,
CD_ATDT MEDIUMINT UNSIGNED NOT NULL,
CD_DIV SMALLINT UNSIGNED NOT NULL,
CD_PRF_DEPE SMALLINT UNSIGNED NOT NULL,
CD_SITU SMALLINT UNSIGNED NOT NULL,
CD_USU VARCHAR(8) NOT NULL,
DT_SITU_ATDT DATE NULL,
TX_CMPT_HST VARCHAR NULL,
PRIMARY KEY(TS_SITU_ATDT, CD_ATDT),
INDEX tbl_hst_situ_FKIndex1(CD_ATDT),
INDEX tbl_hst_situ_FKIndex2(CD_USU),
INDEX tbl_hst_situ_FKIndex3(CD_SITU),
INDEX tbl_hst_situ_FKIndex4(CD_PRF_DEPE, CD_DIV),
FOREIGN KEY(CD_ATDT)
REFERENCES tbl_atdt(CD_ATDT)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
FOREIGN KEY(CD_USU)
REFERENCES tbl_usu(CD_USU)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
FOREIGN KEY(CD_SITU)
REFERENCES tbl_situ(CD_SITU)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
FOREIGN KEY(CD_PRF_DEPE, CD_DIV)
REFERENCES tbl_div(CD_PRF_DEPE, CD_DIV)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
TYPE=Inno
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, PRIMARY KEY(TS_SITU_ATDT, CD_ATDT), INDEX tbl_hst_situ_FK
Me ajudem!!!