podoc:film_iso_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
podoc:film_iso_sql_table [2007/04/19 08:34] – Luud | podoc:film_iso_sql_table [2007/04/20 12:45] – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table film_iso ( |
- | value | + | identifier |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === 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 = | ||
- | | + | <code sql> |
- | identifier | + | create table film_iso ( |
- | value | + | identifier |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
== Data change history == | == Data change history == | ||
Line 56: | Line 68: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into film_iso values (nextval(' | insert into film_iso values (nextval(' | ||
insert into film_iso values (nextval(' | insert into film_iso values (nextval(' | ||
Line 91: | Line 103: | ||
= Version 2.27 = | = Version 2.27 = | ||
- | < | + | < |
insert into film_iso values (nextval(' | insert into film_iso values (nextval(' | ||
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; | ||
</ | </ | ||
+ |
podoc/film_iso_sql_table.txt · Last modified: 2007/04/20 14:28 by Luud