It appears that you are getting a size on the CC_TYPE date column in ORDERS. I don't think mysql allows a length on a date column. I'd guess you have a wrong datatype there.
Also, try adding 'required="true"' to the ARTICLE_TYPE column in MISC_ARTICLE. -----Original Message----- From: Donald Rosengartner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:43 PM To: [EMAIL PROTECTED] Subject: Re: Schema producing invalid SQL As you can see from close inspection of the output, there are 4 sql files being acted upon(should be two). I renamed the database to 'fishing' in my properties file and schema to be inline with the datsource changes being made, hence new filenames. These errors do not reflect current schema conditions. Merely cleaning up the $torque-home\src\sql directory and rebuilding has resolved this. *********************************************** insert-sql: [torque-sql-exec] Our new url -> jdbc:mysql://localhost:3306/fishing [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\id-table-schema.sql [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\project-schema.sql [torque-sql-exec] Failed to execute: CREATE TABLE ORDERS ( ORDER_ID INTEGER NOT NULL AUTO_INCRE MENT, ORDER_DATE DATE NOT NULL, PRIORITY VARCHAR (5), AUTOBILL INTEGER, TERM INTEGER default -1 , BEGIN_DATE DATE NOT NULL, CC_TYPE DATE (10), CC_NUM BIGINT, CC_EXPIRE DATE, CC_NAME VARCHAR ( 75), FKCUSTOMER_ID INTEGER, PRIMARY KEY(ORDER_ID), FOREIGN KEY (FKCUSTOMER_ID) REFERENCES CUSTO MER (CUSTOMER_ID) ) [torque-sql-exec] java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '(10), CC_NUM BIGINT, CC_EXPIRE DATE, CC_NAME VARCHAR (75), FKCUSTOMER_ID INTEGER' at line 1 [torque-sql-exec] Failed to execute: CREATE TABLE MISC_ARTICLE ( ARTICLE_ID INTEGER NOT NULL AU TO_INCREMENT, ARTICLE_TYPE VARCHAR (40), P_1 VARCHAR (250) NOT NULL, P_2 VARCHAR (250), P_3 VAR CHAR (250), P_4 VARCHAR (250), P_5 VARCHAR (250), IMAGE_DIR VARCHAR (70) NOT NULL, IMAGE_1 VARC HAR (30), IMAGE_2 VARCHAR (30), IMAGE_3 VARCHAR (30), BG_IMAGE VARCHAR (30), LINK_1 VARCHAR (15 0), APPROVED INTEGER, ADDED DATE, FKPOSTED_BY VARCHAR (50) NOT NULL, PRIMARY KEY(ARTICLE_ID,ART ICLE_TYPE), FOREIGN KEY (FKPOSTED_BY) REFERENCES GFEUSER (USER_NAME) ) [torque-sql-exec] java.sql.SQLException: General error: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead [torque-sql-exec] 66 of 68 SQL statements executed successfully [torque-sql-exec] Our new url -> jdbc:mysql://localhost:3306/fishing [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\fishing-schema.sql [torque-sql-exec] Executing file: C:\projects\torque-3.0-rc2\src\sql\fishing-schema-idtable-ini t.sql [torque-sql-exec] 78 of 80 SQL statements executed successfully -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
