John McNally wrote:
>
> Sean Allen wrote:
> >
> > Ahem, I re-iterate
> > I am attempting to create a schema that models customer accounts
> > a snippet of my xml-schema looks like so
> > " <column name="LAST_PAY_AMNT" required="true" size="6,2" type="FLOAT"/>
> > <column name="AMNT_DUE" required="true" size="6,2" type="FLOAT"/>"
> > this produces the following when build-project.sh init is run
> > "
>
> I am working on this problem. Should be solved real soon.
>
Should be fixed in cvs. I took the simple route and just allowed size
to be character data. Again, anyone know if some db's have a special
sql that will not support precision in a single size string?
> > "
> > which obviously kills the build, if I change the FLOATS to read "6" it
> > builds ok and I can ALTER the TABLE manually, but this kind of defeats
> > the point.
> >
> > also, in another part of the same schema:
> > The Index declaration
> > "<index name="BY_AGENT">
> > <index-column name="AGENT_ID"/>
> > </index>
> > <index name="BY_CLIENT">
> > <index-column name="CLIENT_ID"/>
> > </index>"
> >
> > produces the following malformed SQL
> >
> > " INDEX BY_AGENT (AGENT_ID)
> > INDEX BY_CLIENT (CLIENT_ID)
> > ); "
> >
> I will try to take a look at this too, unless someone else more familar
> with the db schema generation would like to take a look, just let me
> know.
>
I added a comma to the mysql index.vm.
John McNally
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
