ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

root/cvsroot/COMP/DBS/Schema/RefDBLegacy/OracleApps.sql

Comparing COMP/DBS/Schema/RefDBLegacy/OracleApps.sql (file contents):
Revision 1.1 by lat, Tue Oct 4 21:46:23 2005 UTC vs.
Revision 1.3 by lat, Thu Oct 6 21:41:37 2005 UTC

#	Line 7 | Line 7 | create sequence seq_app_config;
7		-- ======================================================================
8		create table t_collection_type
9		(id                           integer         not null,
10	<	name                         varchar (80)    not null,
10	>	name                         varchar (1000)  not null,
11		created_at                   float           not null,
12		created_by                   integer         not null,
13		modified_at                  float           not null,
#	Line 15 | Line 15 | create table t_collection_type
15
16		create table t_app_family
17		(id                           integer         not null,
18	<	name                         varchar (80)    not null,
18	>	name                         varchar (1000)  not null,
19		created_at                   float           not null,
20		created_by                   integer         not null,
21		modified_at                  float           not null,
#	Line 23 | Line 23 | create table t_app_family
23
24		create table t_application
25		(id                           integer         not null,
26	<	executable                   varchar (80)    not null,
27	<	app_version                  varchar (80)    not null,
26	>	executable                   varchar (1000)  not null,
27	>	app_version                  varchar (1000)  not null,
28		app_family                   integer         not null,
29		input_type                   integer         not null,
30		output_type                  integer         not null,
#	Line 36 | Line 36 | create table t_application
36		create table t_app_config
37		(id                           integer         not null,
38		application                  integer         not null,
39	<	conditions_version           varchar (80)    not null,
39	>	conditions_version           varchar (1000)  not null,
40		created_at                   float           not null,
41		created_by                   integer         not null,
42		modified_at                  float           not null,
#	Line 77 | Line 77 | alter table t_app_family
77		alter table t_app_family
78		add constraint fk_app_family_mod
79		foreign key (modified_by) references t_person (id);
80	<
80	>
81		--
82		alter table t_application
83		add constraint pk_application
#	Line 107 | Line 107 | alter table t_application
107		alter table t_application
108		add constraint fk_application_mod
109		foreign key (modified_by) references t_person (id);
110	<
110	>
111		--
112		alter table t_app_config
113		add constraint pk_app_config

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines