Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: CapJo on September 15, 2006, 06:15:31 am

Title: Possible Bug in Oracle_BaseModel.sql???
Post by: CapJo on September 15, 2006, 06:15:31 am

Quote

----------------------------------------------
-- Table structure for t_secuser
----------------------------------------------
CREATE TABLE t_secuser (

UserID VARCHAR2(40) PRIMARY KEY,

UserLogin VARCHAR2(32) NOT NULL,

FirstName VARCHAR2(50) NOT NULL,

Surname VARCHAR2(50) NOT NULL,

Department VARCHAR2(50),

Password VARCHAR2(12)
);

--CREATE UNIQUE INDEX UserID ON t_secuser (UserID);

I have copied the lines above from the Oracle_BaseModel.sql    

The last line is here an comment, but it contains valid sql commands.
Is this a mistake or have someone forgotten to delete this line?

Maybe someone from Sparx can give us the answer.

Title: Re: Possible Bug in Oracle_BaseModel.sql???
Post by: hd on October 01, 2006, 08:18:16 pm

The unique index is not required. Because UserID is the primary key, it is already indexed.