Differences

This shows you the differences between two versions of the page.

--- podoc:submission_status_sql_table [2007/04/20 14:47] – Luud
+++ podoc:submission_status_sql_table [2007/10/19 19:55] (current) – Luud
@@ Line 11: / Line 11: @@
 === Schema ===
-  create table submission_status (
+<code sql>
-    identifier            integer not null primary key,
+create table submission_status (
-    value                 varchar(10)
+  identifier            integer not null primary key,
-  );
+  value                 varchar(10)
+);
+</code>
 === References tables ===
@@ Line 22: / Line 24: @@
 === Is referenced by tables ===
-None.
+  * [[submission sql table|submission]](status) references identifier
 === Related sequences ===
@@ Line 48: / Line 50: @@
 == Used last ==
-Still in use
+Version 2.33
 == Schema change history ==
@@ Line 54: / Line 56: @@
 = Version 2.5 =
-  create table submission_status (
+<code sql>
-    identifier            integer not null primary key,
+create table submission_status (
-    value                 varchar(10)
+  identifier            integer not null primary key,
-  );
+  value                 varchar(10)
+);
+</code>
+= Version 2.34 =
+<code sql>
+drop table submission_status;
+</code>
-== Data history ==
+== Data change history ==
 = Version 2.5 =
-<code>
+<code sql>
 insert into submission_status values (nextval('submission_status_id_sequence'), 'On stock');
 insert into submission_status values (nextval('submission_status_id_sequence'), 'Submitted');