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 CMS_DBS_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.7
Committed:	Fri Jan 20 16:55:06 2006 UTC (19 years, 3 months ago) by lat
Content type:	application/sql
Branch:	MAIN
CVS Tags:	BeforeJan2006SchemaChanges
Changes since 1.6:	+1 -1 lines
Log Message:	Default to production tablespace names.
#	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 CMS_DBS_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);