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.
#	Content
1	-- ======================================================================
2	create sequence seq_person;
3
4	-- ======================================================================
5	create table t_person
6	(id integer not null,
7	name varchar (1000) not null,
8	distinguished_name varchar (1000) not null,
9	contact_info varchar (1000) not null);
10
11	-- ======================================================================
12	alter table t_person
13	add constraint pk_person
14	primary key (id)
15	using index tablespace INDX01;
16
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);