Index: openacs-4/packages/ref-itu/sql/oracle/ref-itu-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-itu/sql/oracle/ref-itu-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ref-itu/sql/oracle/ref-itu-create.sql	26 Feb 2003 18:05:25 -0000	1.1
+++ openacs-4/packages/ref-itu/sql/oracle/ref-itu-create.sql	4 Mar 2003 22:47:02 -0000	1.2
@@ -16,17 +16,18 @@
 );
 
 create table itu_codes (
-    itu_code    char(6)
+    itu_id      integer
+                constraint itu_code_pk
+                    primary key,
+    code        char(6)
                 constraint itu_code_nn
                     not null,
     country     varchar(100)
                 constraint itu_country_nn
                     not null,
-      note_id   char(3)
-		        constraint itu_codes_note_fk
-                    references itu_notes (note_id),
-                constraint itu_code_pk
-                    primary key (itu_code,country)
+      note_id     char(3)
+		constraint itu_codes_note_fk
+                    references itu_notes (note_id)
 );
 
 
Index: openacs-4/packages/ref-itu/sql/postgresql/ref-itu-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-itu/sql/postgresql/ref-itu-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ref-itu/sql/postgresql/ref-itu-create.sql	26 Feb 2003 18:08:53 -0000	1.1
+++ openacs-4/packages/ref-itu/sql/postgresql/ref-itu-create.sql	4 Mar 2003 22:44:53 -0000	1.2
@@ -16,17 +16,18 @@
 );
 
 create table itu_codes (
-    itu_code    char(6)
+    itu_id      integer
+                constraint itu_code_pk
+                    primary key,
+    code        char(6)
                 constraint itu_code_nn
                     not null,
     country     varchar(100)
                 constraint itu_country_nn
                     not null,
       note_id     char(3)
 		constraint itu_codes_note_fk
-                    references itu_notes (note_id),
-                constraint itu_code_pk
-                    primary key (itu_code,country)
+                    references itu_notes (note_id)
 );
 
 comment on table itu_codes is '