User Tools

Site Tools


podoc:film_iso_sql_table

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
podoc:film_iso_sql_table [2007/04/19 08:34] Luudpodoc:film_iso_sql_table [2007/04/20 12:45] Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table film_iso ( +<code sql> 
-    identifier            integer not null primary key, +create table film_iso ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[film_type sql table|film_type]](format) references identifier
  
 === Related sequences === === Related sequences ===
Line 47: Line 57:
 = Version 2.5 = = Version 2.5 =
  
-  create table film_iso ( +<code sql> 
-    identifier            integer not null primary key, +create table film_iso ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 56: Line 68:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into film_iso values (nextval('film_iso_id_sequence'), '6'); insert into film_iso values (nextval('film_iso_id_sequence'), '6');
 insert into film_iso values (nextval('film_iso_id_sequence'), '8'); insert into film_iso values (nextval('film_iso_id_sequence'), '8');
Line 91: Line 103:
 = Version 2.27 = = Version 2.27 =
  
-<code>+<code sql>
 insert into film_iso values (nextval('film_iso_id_sequence'), '64'); insert into film_iso values (nextval('film_iso_id_sequence'), '64');
 alter table film_iso add column value_2 integer; alter table film_iso add column value_2 integer;
Line 98: Line 110:
 alter table film_iso rename column value_2 to value; alter table film_iso rename column value_2 to value;
 </code> </code>
 +
podoc/film_iso_sql_table.txt · Last modified: 2007/04/20 14:28 by Luud