| Revision: | 1.8 |
| Committed: | Mon Feb 6 23:18:54 2006 UTC (19 years, 3 months ago) by afaq |
| Content type: | application/sql |
| Branch: | MAIN |
| CVS Tags: | DBS_1_0_0_pre6, DBS_1_0_0_pre5, pre5_v01_00_00, pre4_v01_00_00, pre3_v01_00_00, pre2_v01_00_00, pre_v01_00_00, v00_00_14, v00_00_13, v00_00_12, v00_00_11, v00_00_10, v00_00_09, v00_00_08, v00_00_07, v00_00_06, v00_00_05, v00_00_004, DBS_0_0_3a, DBS_0_0_3, DBS_0_0_2, DBS_0_0_1, pre_DBS_0_0_1, post_dict_type_checking_merge, post_MiniPythonAPI_merged_to_trunk, pre_MiniPythonAPI_merge_to_trunk, DBS_0_0_0, vs20060320, AfterJan2006SchemaChanges_v01_00_01, AfterJan2006SchemaChanges_v01_00_00, AfterJan2006SchemaChanges, HEAD |
| Branch point for: | BranchForCPPWebServiceTesting |
| Changes since 1.7: | +1 -1 lines |
| Log Message: | Non working set, Checking IN for securing the changes, will resume working |
| # | 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 | afaq | 1.8 | 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); |