Hi,
I need a bit more advise how to add columns to TURBINE_USER (or other
Security tables) using the SecurityService proposal.
I am confused by the following:
F:\cvs\jakarta-turbine-fulcrum\turbine-schema.xml says
...
<column name="OBJECTDATA" type="VARBINARY"/>
@EXTRA_USER_COLUMNS@
...
meaning that extra columns should be placed at that place.
But contridictary, db-security-service.html-howto suggests to create a new
table like this:
<table name="CUSTOM_USER" idMethod="idbroker">
<column name="USER_ID" required="true" primaryKey="true"
type="INTEGER"/>
<column name="LOGIN_NAME" required="true" size="64" type="VARCHAR"
javaName="UserName"/>
<column name="PASSWORD_VALUE" required="true" size="16" type="VARCHAR"
javaName="Password"/>
<column name="FIRST_NAME" required="true" size="64" type="VARCHAR"/>
<column name="LAST_NAME" required="true" size="64" type="VARCHAR"/>
<column name="EMAIL" size="64" type="VARCHAR"/>
<column name="CONFIRM_VALUE" size="16" type="VARCHAR"
javaName="Confirmed"/>
<column name="MODIFIED" type="TIMESTAMP"/>
<column name="CREATED" type="TIMESTAMP" javaName="CreateDate"/>
<column name="LAST_LOGIN" type="TIMESTAMP"/>
<column name="OBJECTDATA" type="VARBINARY"/>
<column name="TELEPHONE" size="32" type="VARCHAR" javaName="Phone" />
<column name="FAX" size="32" type="VARCHAR"/>
<unique>
<unique-column name="LOGIN_NAME"/>
</unique>
</table>
Which one is the correct way to add extra fields?
Keeping the standard table and just adding/removing fields?
Or adding a new table (to turbine-schema or project-schema ??) with a
different name? In this case, what to do with the standard-schema
"TURBINE_USER" ? Deleting?
Thanks.
Marc
--
To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
