Schema/RefDBLegacy/OracleCMS.sql

-- ======================================================================
create sequence seq_person;

-- ======================================================================
create table t_person
  (id                           integer         not null,
   name                         varchar (1000)  not null,
   distinguished_name           varchar (1000)  not null,
   contact_info                 varchar (1000)  not null);

-- ======================================================================
alter table t_person
  add constraint pk_person
  primary key (id)
  using index tablespace INDX01;

alter table t_person
  add constraint uq_person_name
  unique (name);

alter table t_person
  add constraint uq_person_distinguished
  unique (distinguished_name);
Revision:	1.6
Committed:	Fri Jan 20 11:53:17 2006 UTC (19 years, 3 months ago) by lat
Content type:	application/sql
Branch:	MAIN
Changes since 1.5:	+1 -26 lines
Log Message:	Intermediate schema clean-up for RefDB imported data. Implements most agreed schema changes, except not those which would have required significant modifications to the provenance tracking system.
#	User	Rev	Content
1	lat	1.1	-- ======================================================================
2			create sequence seq_person;
3
4			-- ======================================================================
5			create table t_person
6			(id integer not null,
7	lat	1.2	name varchar (1000) not null,
8			distinguished_name varchar (1000) not null,
9	lat	1.5	contact_info varchar (1000) not null);
10	lat	1.1
11			-- ======================================================================
12			alter table t_person
13			add constraint pk_person
14			primary key (id)
15	lat	1.6	using index tablespace INDX01;
16	lat	1.1
17			alter table t_person
18			add constraint uq_person_name
19			unique (name);
20
21			alter table t_person
22			add constraint uq_person_distinguished
23			unique (distinguished_name);