database import problem

[rninja]

I have been trying to host a friend on my linux box. Before, they had used a windows nt machine running coldfusion and mssql.
I am also running coldfusion, but getting the database to be created is hard. I've had the database converted to mysql compatibility however, I am running into problems with one table entry. This is the table entry I am having problems with:

CREATE TABLE Corporation.Forms
(Form_ID INT NOT NULL,
Section_ID INT NULL,
Name VARCHAR(25) NULL,
Title VARCHAR(25) NULL,
Description LONGTEXT NULL,
DSID INT NULL,
TableName VARCHAR(50) NULL,
Columns LONGTEXT NULL,
IDCol VARCHAR(25) NULL,
Add_ TINYINT NOT NULL,
Modify_ TINYINT NOT NULL,
Delete_ TINYINT NOT NULL,
Ownership_ TINYINT NOT NULL,
Custom_Processor VARCHAR(50) NULL);

Everytime I import this table into the Corporations database, I get this error:
" ERROR 1064 at line 100: You have an error in your SQL syntax near 'Columns
LONGTEXT NULL,
IDCol VARCHAR(25) NULL,
Add_ TINYINT NOT NULL,
Modi' at line 9 "

I am not sure what the problem is because the code seems to be fine.

I appreciate all the help I can get in this matter.

Rninja

http://www.rninja.com

 

[gheist]

you need to specify a nonzero default value for NOT NULL fields
and some default instead of NULL

 

[rninja]

What fields need to have not null removed? the ones that came up in error? Rninja

http://www.rninja.com

 

[rninja]

I found out that it was the Columns word that caused problems. Columns is a reserved word in mysql in which mysql is VERY picky. I tried renaming it to Col_umns and it worked without a glitch.

Thanks for the lead Gheist!

Thanks! Rninja

http://www.rninja.com