TEXT: ...type="VARCHAR" size="20"... DATETIME: ...type="TIMESTAMP"...
Use the turbine-schema.xml as an example. Also, read the documentation on the Torque (a sub-project of Turbine) site for more information on schemas, peers, and Criteria. http://jakarta.apache.org/turbine/torque/ Chris > -----Original Message----- > From: michael shek sia lim [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 25, 2002 3:50 PM > To: [EMAIL PROTECTED] > Subject: Sql entry > > > Hi, > > I am trying to create a database via the TDK schema. Below is my .xml file > content: > > <table name="INVOICE"> > <column name="ID" required="true" autoIncrement="true" > primaryKey="true" type="INTEGER"/> > <column name="INVOICENO" size="10" type="INTEGER"/> > <column name="CUSTOMERREF" size="50" type="INTEGER"/> > <column name="DATE" type="DATETIME"/> > <column name="CONTACT" size="20" type="VARCHAR"/> > <column name="PAYMENTTERM" size="20" type="VARCHAR"/> > <column name="SUBTOTAL" type="FLOAT"/> > <column name="GST" type="FLOAT"/> > <column name="TOTAL" type="FLOAT"/> > <column name="COMMENT" type="TEXT"/> > </table> > > I realize that TDK does not like "TEXT" and "DATETIME" as input for type. > These are standard SQL entries and I believe they are quite common in > usage, I would appreciate if anyone could show me how to write an > acceptable .xml file. > > cheers > michael > > > > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
