podoc:user_type_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:user_type_sql_table [2007/04/12 15:57] – Luud | podoc:user_type_sql_table [2007/04/20 15:32] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | < |
- | identifier | + | create table user_type ( |
- | value | + | identifier |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | None. | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[system_preferences sql table|system_preferences]](new_user_type) references identifier | ||
+ | * [[users sql table|users]](type) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 21: | Line 32: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 36: | Line 53: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change history == |
+ | |||
+ | = Version 2.5 = | ||
+ | |||
+ | <code sql> | ||
+ | create table user_type ( | ||
+ | identifier | ||
+ | value | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | == Data change | ||
= Version 2.5 = | = Version 2.5 = | ||
- | create table user_type ( | + | <code sql> |
- | | + | insert into user_type |
- | | + | insert into user_type values (nextval(' |
- | ); | + | insert into user_type values (nextval(' |
+ | insert into user_type values (nextval(' | ||
+ | </ | ||
podoc/user_type_sql_table.1176393446.txt.gz · Last modified: 2007/04/12 15:57 by Luud