CREATE TABLE command fails
Hi all
The following command fails and I am unable to determine where.
CREATE TABLE USER (ADDRESS_1 VARCHAR(31) NULL, ADDRESS_2 VARCHAR(31) NULL, AUTO_SAVE BIT NULL, CAR_INV_NO DECIMAL(6, 0) NULL, COMM_PORT DECIMAL(1, 0) NULL, COMPANY_NO VARCHAR(10) NULL, COMPANY VARCHAR(31) NULL, CON_TOTAL DECIMAL(5, 0) NULL, COUNTY VARCHAR(21) NULL, DECIMAL BIT NULL, DRIVE_LETT VARCHAR(1) NULL, ENVIRONM DECIMAL(7, 2) NULL, FAX_NO VARCHAR(25) NULL, HEADING BIT NULL, INDENT DECIMAL(2, 0) NULL, INVOICE_NO DECIMAL(6, 0) NULL, JOB_NO DECIMAL(6, 0) NULL, KEY_CODE DECIMAL(9, 0) NULL, LAB_RATE DECIMAL(6, 2) NULL, LASTRECORD DECIMAL(5, 0) NULL, MESSAGE VARCHAR(45) NULL, MARKUP DECIMAL(3, 0) NULL, MODULECODE VARCHAR(5) NULL, MOT_COST DECIMAL(5, 2) NULL, MOT_INVO DECIMAL(5, 2) NULL, MOT_LETTER TEXT NULL, MOT_TOTAL DECIMAL(5, 2) NULL, NETWORK BIT NULL, PARTSPURCH DECIMAL(6, 0) NULL, PASSWORD VARCHAR(5) NULL, POSTCODE VARCHAR(11) NULL, PREFIX VARCHAR(1) NULL, PRINTER VARCHAR(40) NULL, PURCHASE_N DECIMAL(6, 0) NULL, REGISTERED BIT NULL, RENEW_DATE DATE NULL, RUN_M_LETT BIT NULL, RUN_REMIND BIT NULL, RUN_S_LETT BIT NULL, SER_LETTER TEXT NULL, SETUP_DATE DATE NULL, SERVER BIT NULL, SERVERPATH VARCHAR(1) NULL, STOCK_NO DECIMAL(5, 0) NULL, STOCKPURCH DECIMAL(6, 0) NULL, TOWN VARCHAR(31) NULL, TRIAL BIT NULL, VAT_NO VARCHAR(12) NULL, VAT_RATE DECIMAL(5, 2) NULL, VERSION DATE NULL, WEEKDAY VARCHAR(9) NULL, WORK_NO VARCHAR(25) NULL) ENGINE = INNODB
The code was created programatically and is the only one of over 70 similarly created programatically to fail.
TIA