Hi, here's my sample of a user defined Database with 3 Tables in it. Just download http://jakarta.apache.org/turbine/dtd/database.dtd to find out which values are allowed and maybe you have an xml editor which gives you some kind of autocomplete functionality. A look at http://jakarta.apache.org/turbine/torque/schema-reference.html explains each entry in the xml file.
Using capitals or not is not relevant. The names get mangled anyway, a table called NEW_USER get's converted to NewUser in Java but you can influence this behaviour by the defaultJavaNamingMethod property in the xml file. Greetx Denis <?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?> <!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";> <!-- ==================================================================== --> <!-- --> <!-- T U R B I N E P R O J E C T S C H E M A --> <!-- --> <!-- ==================================================================== --> <!-- This is an example Turbine project schema. --> <!-- ==================================================================== --> <database defaultIdMethod="native" name="m4f"> <table name="SONGS"> <column name="SONG_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="TITLE" size="255" type="VARCHAR"/> <column name="ARTIST" size="255" type="VARCHAR"/> <column name="ALBUM" size="255" type="VARCHAR"/> <column name="FILENAME" type="LONGVARCHAR"/> <column name="LENGTH" type="INTEGER"/> <column name="BITRATE" type="INTEGER"/> </table> <table name="PLAYED_SONGS"> <column name="ID" required="true" primaryKey="true" type="INTEGER"/> <column name="SONG_ID" required="true" type="INTEGER"/> <column name="USER_ID" required="true" type="INTEGER"/> <column name="DATE" required="true" type="DATE"/> </table> <table name="LOGGED_IN"> <column name="ID" required="true" primaryKey="true" type="INTEGER"/> <column name="USER_ID" required="true" type="INTEGER"/> <column name="IP_ADRESS" size="20" type="VARCHAR"/> <column name="LAST_ACTIVITY" required="true" type="DATE"/> </table> </database> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
