Author Topic: Possible Bug in Oracle_BaseModel.sql???  (Read 2051 times)

CapJo

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Possible Bug in Oracle_BaseModel.sql???
« 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.
« Last Edit: September 18, 2006, 04:21:22 am by CapJo »

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Possible Bug in Oracle_BaseModel.sql???
« Reply #1 on: October 01, 2006, 08:18:16 pm »
The unique index is not required. Because UserID is the primary key, it is already indexed.