[Openinteract-commits] CVS: OpenInteract/pkg/base_page/struct content_type.sql,1.1,1.2

[Chris W. <la...@us...>]

Update of /cvsroot/openinteract/OpenInteract/pkg/base_page/struct
In directory usw-pr-cvs1:/tmp/cvs-serv5680/struct

Modified Files:
	content_type.sql 
Log Message:
modified content_type structure to have a UNIQUE index on the mime_type


Index: content_type.sql
===================================================================
RCS file: /cvsroot/openinteract/OpenInteract/pkg/base_page/struct/content_type.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** content_type.sql	2001/10/26 21:09:05	1.1
--- content_type.sql	2001/10/29 05:15:42	1.2
***************
*** 4,7 ****
    extensions        varchar(20) not null,
    description       varchar(100) null,
!   primary key       ( content_type_id )
  )
--- 4,8 ----
    extensions        varchar(20) not null,
    description       varchar(100) null,
!   PRIMARY KEY       ( content_type_id ),
!   UNIQUE            ( mime_type )
  )