In Turbine 2.1 (from cvs), a schema like this one:
<table name="SF_STF_OPERATOR">
<column name="BRANCH_CODE" primaryKey="true" required="true"
type="INTEGER"></column>
<column name="OPERATOR_CODE" primaryKey="true" required="true"
type="INTEGER"></column>
<column name="LOGIN_NAME" required="false" type="VARCHAR"
size="32"></column>
<column name="SIGNED_ON" required="false" type="BOOLEANINT"></column>
<column name="DAY_OPEN" required="false" type="BOOLEANINT"></column>
</table>
is generating (for MySQL) a script like this one:
CREATE TABLE SF_STF_OPERATOR
(
BRANCH_CODE INTEGER NOT NULL,
OPERATOR_CODE INTEGER NOT NULL,
LOGIN_NAME VARCHAR (32),
SIGNED_ON INTEGER,
DAY_OPEN INTEGER,
PRIMARY KEY(BRANCH_CODE,OPERATOR_CODE),
INDEX(OPERATOR_CODE)
);
Notice the index is only on OPERATOR_CODE, not on BRANCH_CODE and
OPERATOR_CODE, the two primary key fields. Is this intended?
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
