User Tools

Site Tools


podoc:folder_sql_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
podoc:folder_sql_table [2007/10/19 16:21]
Luud
podoc:folder_sql_table [2007/10/19 16:39] (current)
Luud
Line 21: Line 21:
   description ​          text,   description ​          text,
   password ​             text,,   password ​             text,,
-  date_changed ​         timestamp without time zone+  date_changed ​         timestamp without time zone
 +  event                 ​integer references calendar(identifier)
 ); );
 </​code>​ </​code>​
Line 28: Line 29:
  
   * access_rights references [[access_type sql table|access_type]](identifier)   * access_rights references [[access_type sql table|access_type]](identifier)
 +  * event references [[calendar sql table|calendar]](identifier)
   * parent_folder references [[folder sql table|folder]](identifier) // **self reference** //   * parent_folder references [[folder sql table|folder]](identifier) // **self reference** //
   * users references [[users sql table|users]](identifier)   * users references [[users sql table|users]](identifier)
Line 108: Line 110:
 -- Drop '​orderby'​ fields; they'​re useless now. -- Drop '​orderby'​ fields; they'​re useless now.
 alter table folder drop orderby; alter table folder drop orderby;
 +</​code>​
 +
 +<code sql>
 +-- Associate events with folders
 +alter table folder add column event integer references calendar(identifier);​
 </​code>​ </​code>​
  
podoc/folder_sql_table.txt · Last modified: 2007/10/19 16:39 by Luud