Photo Organizer podoc

podoc:access_type_id_sequence_sql_sequence

2007-04-23T10:37:31-04:00

Database Sequence Description of "access_type_id_sequence" Name access_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'access_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'access_type'.

podoc:access_type_sql_table

2007-04-20T11:23:39-04:00

Database Table Description of "access_type" Name access_type Description Contains a mapping of 'permissions' to textual names of those pemissions. Purpose To enforce referential integrity. * Note, this table will go away as part of the permission model rewrite (see pobug>8)

podoc:administration

2007-08-03T14:48:21-04:00

System Administration During installation, an administrator account is created. The login name for this account is “admin”, the password is also “admin”. This account will display an extra “Admin” tab in the main menu which will bring up the system administration interface.

podoc:album_and_subalbums_sql_function

2007-10-19T11:05:42-04:00

Database Function Description of "album_and_subalbums" Name album_and_subalbums Description Purpose Schema ----- Recursive bulk updates! CREATE OR REPLACE FUNCTION album_and_subalbums(int) RETURNS SETOF int AS ' DECLARE ident record; ident2 record; BEGIN RETURN NEXT $1; FOR ident IN SELECT identifier FROM album f WHERE f.parent_album = $1 LOOP FOR ident2 IN SELECT * FROM album_and_subalbums(ident.identifier) LOOP RETURN NEXT ident2.album_and_subalbums; …

podoc:album_content_album_idx_sql_index

2007-04-23T10:52:06-04:00

Database Index Description of "album_content_album_idx" Name album_content_album_idx Description Index on column 'album' of table 'album_content'. Purpose Speedup of table row lookups based on column 'album' in table 'album_content'. Schema create index album_content_album_idx on album_content(album);

podoc:album_content_id_idx_sql_index

2007-10-19T11:38:45-04:00

Database Index Description of "album_content_id_idx" Name album_content_id_idx Description Index on column 'identifier' of table 'album_content'. Purpose Speedup of table row lookups based on column 'identifier' in table 'album_content'. Schema create index album_content_id_idx on album_content(identifier);

podoc:album_content_id_sequence_sql_sequence

2007-04-23T10:37:09-04:00

Database Sequence Description of "album_content_id_sequence" Name album_content_id_sequence Description Sequence generator for the column 'identifier' of the table 'album_content'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'album_content'.

podoc:album_content_photo_idx_sql_index

2007-04-23T10:52:19-04:00

Database Index Description of "album_content_photo_idx" Name album_content_photo_idx Description Index on column 'photo' of table 'album_content'. Purpose Speedup of table row lookups based on column 'photo' in table 'album_content'. Schema create index album_content_photo_idx on album_content(photo);

podoc:album_content_sql_table

2007-10-19T16:55:47-04:00

Database Table Description of "album_content" Name album_content Description This table keeps track of what photos are in which albums. Purpose Unlike folders, it's possible for a photo to be in more than one album. This table allows for that.

podoc:album_content_version_idx_sql_index

2007-10-19T11:34:28-04:00

Database Index Description of "album_content_version_idx" Name album_content_version_idx Description Index on column 'version' of table 'album_content'. Purpose Speedup of table row lookups based on column 'version' in table 'album_content'.

podoc:album_event_idx_sql_index

2007-10-19T15:23:07-04:00

Database Index Description of "album_event_idx" Name album_event_idx Description Index on column 'event' of table 'album'. Purpose Speedup of table row lookups based on column 'event' in table 'album'. Schema create index album_event_idx on album(event);

podoc:album_id_idx_sql_index

2007-10-19T11:38:43-04:00

Database Index Description of "album_id_idx" Name album_id_idx Description Index on column 'identifier' of table 'album'. Purpose Speedup of table row lookups based on column 'identifier' in table 'album'. Schema create index album_id_idx on album(identifier);

podoc:album_id_sequence_sql_sequence

2007-04-23T10:37:01-04:00

Database Sequence Description of "album_id_sequence" Name album_id_sequence Description Sequence generator for the column 'identifier' of the table 'album'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'album'.

podoc:album_sql_table

2007-10-19T16:45:03-04:00

Database Table Description of "album" Name album Description This is the list of all albums in the system, including album specifics like their descriptions. Purpose We need to keep track of this stuff. Schema create table album ( identifier integer not null primary key, users integer not null references users(identifier), -- the users who uploaded the picture, not necessarily the owner caption text, date_of_creation timestamp, access_rights …

podoc:album_users_idx_sql_index

2007-04-23T10:52:33-04:00

Database Index Description of "album_users_idx" Name album_users_idx Description Index on column 'users' of table 'album'. Purpose Speedup of table row lookups based on column 'users' in table 'album'. Schema create index album_users_idx on album(users);

podoc:aperture_id_sequence_sql_sequence

2007-04-23T10:36:54-04:00

Database Sequence Description of "aperture_id_sequence" Name aperture_id_sequence Description Sequence generator for the column 'identifier' of the table 'aperture'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'aperture'.

podoc:aperture_sql_table

2007-04-20T10:22:12-04:00

Database Table Description of "aperture" Name aperture Description This table contains a list of all valid apertures (eg f/2, f/5.6, etc). Purpose To enforce referential integrity. Note: This table will likely be eliminated in the future in favor of direct aperture representation -- this is an unnecessary abstraction.

podoc:bulk_update

2007-08-03T16:00:26-04:00

Bulk Update Photo Organizer's Bulk Update feature is one of its most powerful. It allows you to change the attributes of several of your images at once, using different search criteria: * Per-Folder: All images in a specified folder (and optionally its subfolders), or all of your folders at once. * Per-Album: All images in a specified album (and optionally its subalbums). * Spool: All images on the temporary spool. If the spool is empty, this is not displayed. * Selection-based:…

podoc:bulk_update_rule_id_sequence_sql_sequence

2007-04-23T10:36:45-04:00

Database Sequence Description of "bulk_update_rule_id_sequence" Name bulk_update_rule_id_sequence Description Sequence generator for the column 'identifier' of the table 'bulk_update_rule'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'bulk_update_rule'.

podoc:bulk_update_rule_sql_table

2007-04-20T07:46:22-04:00

Database Table Description of "bulk_update_rule" dropped in 2.32 Name bulk_update_rule Description Purpose Schema create table bulk_update_rule ( identifier integer not null primary key, users integer not null references users(identifier), rule_name varchar(300), regenerate_thumbnail char(1) check (regenerate_thumbnail in ('t', 'f')), regenerate_preview char(1) check (regenerate_preview in ('t', 'f')), title …

podoc:bulk_upload_id_sequence_sql_sequence

2007-04-23T10:36:36-04:00

Database Sequence Description of "bulk_upload_id_sequence" Name bulk_upload_id_sequence Description Sequence generator for bulk_upload actions. Purpose To facilitate the generation of unique values for bulk_upload actions. Schema create sequence bulk_upload_id_sequence start 1;

podoc:calendar_client_idx_sql_index

2007-10-19T15:26:21-04:00

Database Index Description of "calendar_client_idx" Name calendar_client_idx Description Index on column 'client' of table 'calendar'. Purpose Speedup of table row lookups based on column 'client' in table 'calendar'. Schema create index calendar_client_idx on calendar(client);

podoc:calendar_id_idx_sql_index

2007-04-23T10:52:44-04:00

Database Index Description of "calendar_id_idx" Name calendar_id_idx Description Index on column 'identifier' of table 'calendar'. Purpose Speedup of table row lookups based on column 'identifier' in table 'calendar'. Schema create index calendar_id_idx on calendar(identifier);

podoc:calendar_id_sequence_sql_sequence

2007-04-23T10:36:25-04:00

Database Sequence Description of "calendar_id_sequence" Name calendar_id_sequence Description Sequence generator for the column 'identifier' of the table 'calendar'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'calendar'.

podoc:calendar_sql_table

2007-10-19T16:42:44-04:00

Database Table Description of "calendar" Name calendar Description A listing of all datebook events. Purpose It needs to be kept track of somewhere, eh? Schema create table calendar ( identifier integer not null primary key, users integer not null references users(identifier), start_date timestamp, end_date timestamp, date_of_creation timestamp, remark text, client integer references u…

podoc:calendar_user_idx_sql_index

2007-10-19T15:25:19-04:00

Database Index Description of "calendar_user_idx" Name calendar_user_idx Description Index on column 'users' of table 'calendar'. Purpose Speedup of table row lookups based on column 'users' in table 'calendar'. Schema create index calendar_user_idx on calendar(users);

podoc:camera_id_sequence_sql_sequence

2007-04-23T10:36:18-04:00

Database Sequence Description of "camera_id_sequence" Name camera_id_sequence Description Sequence generator for the column 'identifier' of the table 'camera'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'camera'.

podoc:camera_metering_id_sequence_sql_sequence

2007-04-23T10:36:06-04:00

Database Sequence Description of "camera_metering_id_sequence" Name camera_metering_id_sequence Description Sequence generator for the column 'identifier' of the table 'camera_metering'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'camera_metering'.

podoc:camera_metering_sql_table

2007-04-20T10:23:02-04:00

Database Table Description of "camera_metering" Name camera_metering Description Contains a listing of the valid camera metering modes. Note that this table will likely go away; the strings aren't internationalizable and specific to Nikons. AT the very least, additional types need to be added to correspond to the 'EXIF' types.

podoc:camera_program_id_sequence_sql_sequence

2007-04-23T10:35:55-04:00

Database Sequence Description of "camera_program_id_sequence" Name camera_program_id_sequence Description Sequence generator for the column 'identifier' of the table 'camera_program'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'camera_program'.

podoc:camera_program_sql_table

2007-04-20T10:23:15-04:00

Database Table Description of "camera_program" Name camera_program Description Contains a listing of all program modes. Note that this table will likely go away in the future, as it's not easily internationalized and lacks several modes. Purpose Referential Integrity.

podoc:camera_sql_table

2007-10-19T16:05:39-04:00

Database Table Description of "camera" Name camera Description A listing of all *specific* cameras that the users owns, complete with serial number. A camera can be associated with a photo. Purpose A user should be able to keep track of their cameras.

podoc:camera_type_id_sequence_sql_sequence

2007-04-23T10:35:44-04:00

Database Sequence Description of "camera_type_id_sequence" Name camera_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'camera_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'camera_type'.

podoc:camera_type_idx_sql_index

2007-04-23T10:52:51-04:00

Database Index Description of "camera_type_idx" Name camera_type_idx Description Index on column 'type' of table 'camera'. Purpose Speedup of table row lookups based on column 'type' in table 'camera'. Schema create index camera_type_idx on camera(type);

podoc:camera_type_manufacturer_idx_sql_index

2007-04-23T10:52:57-04:00

Database Index Description of "camera_type_manufacturer_idx" Name camera_type_manufacturer_idx Description Index on column 'manufacturer' of table 'camera_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'camera_type'.

podoc:camera_type_sql_table

2007-04-20T08:02:18-04:00

Database Table Description of "camera_type" Name camera_type Description A listing of all known camera types in the system. Purpose We could have several cameras of the same type, so this is a way of specifiying the common stuff. For example, I could have several 'Nikon D70' cameras, which are otherwise identical -- but the specifics (like serial number) are stored in the camera table.

podoc:camera_users_idx_sql_index

2007-04-23T10:53:18-04:00

Database Index Description of "camera_users_idx" Name camera_users_idx Description Index on column 'users' of table 'camera'. Purpose Speedup of table row lookups based on column 'users' in table 'camera'. Schema create index camera_users_idx on camera(users);

podoc:can_access_album_sql_function

2007-10-19T11:09:27-04:00

Database Function Description of "can_access_album" Name can_access_album Description Purpose Schema CREATE OR REPLACE FUNCTION can_access_album(integer, integer, varchar[]) returns boolean as ' DECLARE res_id alias for $1; user_id alias for $2; passwd_list alias for $3; res_access integer; owns_id integer; can_access boolean; admin_type boolean; passwd varchar; BEGIN -- 1 == public, 2 == protected, 3 == private -- 1 == diabled, 2 == client, 3 == user, 4 == admin SE…

podoc:can_access_folder_sql_function

2007-10-19T11:11:04-04:00

Database Function Description of "can_access_folder" Name can_access_folder Description Purpose Schema CREATE OR REPLACE FUNCTION can_access_folder(integer, integer, varchar[]) returns boolean as ' DECLARE res_id alias for $1; user_id alias for $2; passwd_list alias for $3; res_access integer; owns_id integer; can_access boolean; admin_type boolean; passwd varchar; BEGIN -- 1 == public, 2 == protected, 3 == private -- 1 == diabled, 2 == client, 3 == user, 4 == admin …

podoc:can_access_photo_sql_function

2007-10-19T11:10:12-04:00

Database Function Description of "can_access_photo" Name can_access_photo Description Purpose Schema CREATE OR REPLACE FUNCTION can_access_photo(integer, integer, varchar[]) returns boolean as ' DECLARE res_id alias for $1; user_id alias for $2; passwd_list alias for $3; res_access integer; owns_id integer; can_access boolean; admin_type boolean; BEGIN -- 1 == public, 2 == protected, 3 == private -- 1 == diabled, 2 == client, 3 == user, 4 == admin SELECT INTO res_acce…

podoc:client_client_idx_sql_index

2007-04-23T10:58:16-04:00

Database Index Description of "client_client_idx" Name client_client_idx Description Index on column 'client' of table 'client'. Purpose Speedup of table row lookups based on column 'client' in table 'client'. Schema create index client_client_idx on client(client);

podoc:client_id_idx_sql_index

2007-04-23T10:53:28-04:00

Database Index Description of "client_id_idx" Name client_id_idx Description Description Index on column 'identifier' of table 'client'. Purpose Speedup of table row lookups based on column 'identifier' in table 'client'. create index client_id_idx on client(identifier);

podoc:client_id_sequence_sql_sequence

2007-04-23T10:40:11-04:00

Database Sequence Description of "client_id_sequence" Name client_id_sequence Description Sequence generator for the column 'identifier' of the table 'client'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'client'.

podoc:client_sql_table

2007-04-20T08:12:23-04:00

Database Table Description of "client" Name client Description Keeps track of all clients of a particular user. Purpose Clients are a special kind of user; this allows a client to access photos that are otherwise not available to the public.

podoc:client_status_id_sequence_sql_sequence

2007-04-23T10:40:18-04:00

Database Sequence Description of "client_status_id_sequence" Name client_status_id_sequence Description Sequence generator for the column 'identifier' of the table 'client_status'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'client_status'.

podoc:client_status_sql_table

2007-04-20T08:14:59-04:00

Database Table Description of "client_status" Name client_status Description A mapping of the allowed states of a client. Purpose Clients have to be approved. This table just enforces referential integrity into the process. Will be removed.

podoc:client_users_idx_sql_index

2007-04-23T10:58:25-04:00

Database Index Description of "client_users_idx" Name client_users_idx Description Index on column 'users' of table 'client'. Purpose Speedup of table row lookups based on column 'users' in table 'client'. Schema create index client_users_idx on client(users);

podoc:concat_ignore_null_sql_function

2007-04-23T10:25:25-04:00

Database Function Description of "concat_ignore_null" Name concat_ignore_null Description This function will concatenate two strings. The concatenation operator || has been redefined to use this function. Purpose This function will concatenate two strings. The difference from the || operator is that our function will ignore null arguments.

podoc:configuration_file

2008-02-16T16:49:48-04:00

Photo Organizer's configuration file lives under include/config.php. However, we recommend you make all configuration changes to include/config_site.php instead. All configuration settins and their current defaults are shown below: Core settings These settings MUST be changed in order for your installation to function

podoc:configuring_postgresql

2006-12-22T11:25:03-04:00

Configuring PostgreSQL Photo Organizer's installer takes care of database creation, but there is still some prep work necessary to get things to the point where the installer can run. Please note that I'm trying to keep these instructions as generic as possible; if someone has distribution-specific instructions to contribute, I'll happily add them to this page.

podoc:contact_info_id_sequence_sql_sequence

2007-04-23T10:40:26-04:00

Database Sequence Description of "contact_info_id_sequence" Name contact_info_id_sequence Description Sequence generator for the column 'identifier' of the table 'contact_info'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'contact_info'.

podoc:contact_info_idx_sql_index

2007-04-23T10:53:34-04:00

Database Index Description of "contact_info_idx" Name contact_info_idx Description Index on column 'identifier' of table 'contact_info'. Purpose Speedup of table row lookups based on column 'identifier' in table 'contact_info'. Schema create index contact_info_idx on contact_info(identifier);

podoc:contact_info_sql_table

2007-04-20T11:32:33-04:00

Database Table Description of "contact_info" Name contact_info Description Contact information for the individual users. Purpose It's split out from the main 'users' table to keep that schema simpler. Schema create table contact_info ( identifier integer not null primary key, address1 varchar(100), address2 varchar(100), city varchar(100), zipcode varchar(10), state integer references stat…

podoc:contributing

2006-11-23T04:47:00-04:00

Contributing Photo Organizer is still undergoing active development. There are various ways in which you can help in this effort: Documentation * When you figured out how something works which is not captured in the user documentation, add it to the user documentation wiki. * When you figured out how things are implemented, consider adding this information to the developer documentation wiki.

podoc:count_albums_by_user_sql_function

2007-04-23T10:25:38-04:00

Database Function Description of "count_albums_by_user" Name count_albums_by_user Description Counts the number of albums for a given user. There are two versions, one that counts all albums and one that counts only those albums up to a given access rights setting.

podoc:count_equipment_by_user_sql_function

2007-10-19T12:08:14-04:00

Database Function Description of "count_equipment_by_user" Name count_equipment_by_user Description Count the total amount of equipment items of a particular user. There are two versions, one that counts all equipment and one that counts only those equipment items up to a given access rights setting.

podoc:count_folders_by_user_sql_function

2007-04-23T10:26:20-04:00

Database Function Description of "count_folders_by_user" Name count_folders_by_user Description Count the total number of folders of a particular user. There are two versions, one that counts all folders and one that counts only those folders up to a given access rights setting.

podoc:count_photo_versions_by_user_sql_function

2007-04-23T10:26:50-04:00

Database Function Description of "count_photo_versions_by_user" Name count_photo_versions_by_user Description Count the total number of photo versions of a particular user. Purpose To retrieve the total number of photo versions of a particular user.

podoc:count_photo_versions_sql_function

2007-04-23T10:26:28-04:00

Database Function Description of "count_photo_versions" Name count_photo_versions Description Count the total number of photo versions. Purpose To retrieve the total number of photo versions. Schema create function count_photo_versions() returns bigint as 'select count(identifier) from photo_version' language 'sql';

podoc:count_photos_by_album_sql_function

2007-10-19T16:29:12-04:00

Database Function Description of "count_photos_by_album" Name count_photos_by_album Description Count the photos per album for all albums. Purpose To retrieve the number of photos per album for all albums. Schema create function count_photos_by_album(integer, integer, varchar[]) returns bigint as ' select count(photo) from album_content where album = $1 and can_access_photo(photo, $2, $3); ' language 'sql';

podoc:count_photos_by_folder_sql_function

2007-10-19T16:27:30-04:00

Database Function Description of "count_photos_by_folder" Name count_photos_by_folder Description Count the photos in a particular folder. Purpose To retrieve the number of photos in a particular folder. Schema create function count_photos_by_folder(integer, integer, varchar[]) returns bigint as ' select count(identifier) from photo where folder = $1 and can_access_photo(identifier, $2, $3); ' language 'sql';

podoc:count_photos_by_user_sql_function

2007-04-23T10:27:41-04:00

Database Function Description of "count_photos_by_user" Name count_photos_by_user Description Count the photos of a particular user. There are two versions, one that counts all photos and one that counts only those photos up to a given access rights setting (either in the folders or in the albums).

podoc:count_photos_sql_function

2007-04-23T10:26:42-04:00

Database Function Description of "count_photos" Name count_photos Description Count the total number of photos. There are two versions, one that counts all photos and one that counts only those photos up to a given access rights setting. Purpose To retrieve the total number of photos.

podoc:count_subalbums_by_album_sql_function

2007-10-19T16:29:20-04:00

Database Function Description of "count_subalbums_by_album" Name count_subalbums_by_album Description Count the number of sub-albums in a particular album. Purpose To retrieve the number of sub-albums in a particular album. Schema create function count_subalbums_by_album(integer, integer, varchar[]) returns bigint as ' select count(identifier) from album where parent_album = $1 and can_access_album(identifier, $2, $3); ' language 'sql';

podoc:count_subfolders_by_folder_sql_function

2007-10-19T16:26:23-04:00

Database Function Description of "count_subfolders_by_folder" Name count_subfolders_by_folder Description Count the number of sub-folders in a particular folder. Purpose To retrieve the number of sub-folders in a particular folder. Schema create function count_subfolders_by_folder(integer, integer, varchar[]) returns bigint as ' select count(identifier) from folder where parent_folder = $1 and can_access_folder(identifier, $2, $3); ' language 'sql';

podoc:count_users_sql_function

2007-04-23T10:29:56-04:00

Database Function Description of "count_users" Name count_users Description Count the total number of users. Purpose To retrieve the total number of users. Schema create function count_users() returns bigint as 'select count(identifier) from users' language 'sql';

podoc:country_id_sequence_sql_sequence

2007-04-23T10:40:33-04:00

Database Sequence Description of "country_id_sequence" Name country_id_sequence Description Sequence generator for the column 'identifier' of the table 'country'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'country'.

podoc:country_sql_table

2007-04-20T09:40:17-04:00

Database Table Description of "country" Name country Description A list of all countries in the world. Purpose Referential integrity. Schema create table country ( identifier integer not null primary key, code varchar(5), value varchar(40) );

podoc:currency_id_sequence_sql_sequence

2007-10-19T12:00:47-04:00

Database Sequence Description of "currency_id_sequence" Name currency_id_sequence Description Sequence generator for the column 'identifier' of the table 'currency'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'currency'.

podoc:currency_sql_table

2007-10-19T11:51:44-04:00

Database Table Description of "currency" Name currency Description A list of all known currency types. Purpose Referential integrity from the shop module. Schema create table currency ( identifier integer not null primary key, numeric_code numeric, alpha_code varchar(5), name varchar(40), entity text );

podoc:database_schemas

2007-10-19T16:50:24-04:00

Schema documentation These pages document the database schema of Photo Organizer. The specific pages for the database elements (tables, views, sequences, indexes and functions) will contain the history of the database all the way back to the 2.05 release of Photo Organizer.

podoc:date_book

2007-08-03T16:28:23-04:00

CALENDAR The date book provides basic calendar and client management functions. The calendar allows you to schedule your activities, though the features in this regard are restricted to the management of a list of events presented in three different view (day, week, month view).

podoc:dcraw_options_id_sequence_sql_sequence

2007-10-19T15:08:55-04:00

Database Sequence Description of "dcraw_options_id_sequence" Name dcraw_options_id_sequence Description Purpose Schema create sequence dcraw_options_id_sequence start 1; Related tables * dcraw_options Related indexes Related functions Related views History Used first Version 2.21

podoc:dcraw_options_sql_table

2007-10-19T14:53:16-04:00

Database Table Description of "dcraw_options" Name dcraw_options Description A set of parameters we pass into the 'dcraw' RAW converter when processing images. Purpose Users can customize the image processing parameters; this stores their settings.

podoc:developer_documentation

2006-11-23T05:08:25-04:00

Developer Documentation The developer documentation is intended for anyone who wants to contribute more to Photo Organizer than reporting bugs and creating documentation. Also, as this documentation describes the inner workings of PO it will probably also be a useful resource for anyone who wants to understand certain features of PO better or who is writing user documentation.

podoc:ev_comp_id_sequence_sql_sequence

2007-04-23T10:40:46-04:00

Database Sequence Description of "ev_comp_id_sequence" Name ev_comp_id_sequence Description Sequence generator for the column 'identifier' of the table 'ev_comp'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'ev_comp'.

podoc:ev_comp_sql_table

2007-04-20T10:24:24-04:00

Database Table Description of "ev_comp" Name ev_comp Description Purpose Schema create table ev_comp ( identifier integer not null primary key, value varchar(10) ); References tables None. Is referenced by tables * photo_tech(ev_difference) references identifier * photo_tech(exposure_comp) references identifier * photo_tech(flash_comp) references identifier

podoc:export_id_sequence_sql_sequence

2007-04-23T10:40:54-04:00

Database Sequence Description of "export_id_sequence" Name export_id_sequence Description TODO: is this right? Probably not. Sequence generator for the column 'identifier' of the table '???'. Purpose TODO: is this right? Probably not. To facilitate the generation of unique values for the primary key column 'identifier' of the table '???'.

podoc:files_id_sequence_sql_sequence

2007-10-19T15:48:37-04:00

Database Sequence Description of "files_id_sequence" Name files_id_sequence Description Sequence generator for the column 'identifier' of the table 'files'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'files'.

podoc:files_sql_table

2007-10-19T16:48:30-04:00

Database Table Description of "files" Name files Description Purpose Table to keep track of individual image files. Schema create table files ( identifier integer primary key, version integer references photo_version(identifier) not null, size integer not null, x_res integer not null, y_res integer not null, path text not null, created timestamp without time zone not null, filesize integer not…

podoc:files_version_idx_sql_index

2007-10-19T15:37:58-04:00

Database Index Description of "files_version_idx" Name files_version_idx Description Index on column 'version of table 'files'. Purpose Speedup of table row lookups based on column 'version' in table 'files'. Schema create index files_version_idx on files(version);

podoc:film_format_id_sequence_sql_sequence

2007-04-23T10:41:01-04:00

Database Sequence Description of "film_format_id_sequence" Name film_format_id_sequence Description Sequence generator for the column 'identifier' of the table 'film_format'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'film_format'.

podoc:film_format_sql_table

2007-04-20T08:45:05-04:00

Database Table Description of "film_format" Name film_format Description Purpose Schema create table film_format ( identifier integer not null primary key, value varchar(10) ); References tables None. Is referenced by tables * film_type(format) references identifier

podoc:film_id_sequence_sql_sequence

2007-04-23T10:41:07-04:00

Database Sequence Description of "film_id_sequence" Name film_id_sequence Description Sequence generator for the column 'identifier' of the table 'film'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'film'.

podoc:film_iso_id_sequence_sql_sequence

2007-04-23T10:41:15-04:00

Database Sequence Description of "film_iso_id_sequence" Name film_iso_id_sequence Description Sequence generator for the column 'identifier' of the table 'film_iso'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'film_iso'.

podoc:film_iso_sql_table

2007-04-20T10:28:25-04:00

Database Table Description of "film_iso" Name film_iso Description Purpose Schema create table film_iso ( identifier integer not null primary key, value varchar(10) ); References tables None. Is referenced by tables * film_type(format) references identifier * photo_tech(iso_override) references identifier

podoc:film_sql_table

2007-04-20T10:25:30-04:00

Database Table Description of "film" Name film Description Purpose Schema create table film ( identifier integer not null primary key, type integer not null references film_type(identifier), users integer not null references users(identifier), access_rights integer not null references access_type(identifier) );

podoc:film_type_id_sequence_sql_sequence

2007-04-23T10:41:21-04:00

Database Sequence Description of "film_type_id_sequence" Name film_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'film_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'film_type'.

podoc:film_type_idx_sql_index

2007-04-23T10:53:47-04:00

Database Index Description of "film_type_idx" Name film_type_idx Description Index on column 'type' of table 'film'. Purpose Speedup of table row lookups based on column 'type' in table 'film'. Schema create index film_type_idx on film(type);

podoc:film_type_manufacturer_idx_sql_index

2007-04-23T10:54:50-04:00

Database Index Description of "film_type_manufacturer_idx" Name film_type_manufacturer_idx Description Index on column 'manufacturer' of table 'film_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'film_type'.

podoc:film_type_sql_table

2007-04-20T08:42:07-04:00

Database Table Description of "film_type" Name film_type Description Purpose Schema create table film_type ( identifier integer not null primary key, manufacturer integer not null references manufacturer(identifier), model varchar(100), iso integer not null references film_iso(identifier), format integer not null references film_format(identifier), last_modified_date timestamp, last_modifying_users intege…

podoc:film_users_idx_sql_index

2007-04-23T10:54:56-04:00

Database Index Description of "film_users_idx" Name film_users_idx Description Index on column 'users' of table 'film'. Purpose Speedup of table row lookups based on column 'users' in table 'film'. Schema create index film_users_idx on film(users);

podoc:filter_id_sequence_sql_sequence

2007-04-23T10:41:28-04:00

Database Sequence Description of "filter_id_sequence" Name filter_id_sequence Description Sequence generator for the column 'identifier' of the table 'filter'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'filter'.

podoc:filter_sql_table

2007-04-20T10:27:32-04:00

Database Table Description of "filter" Name filter Description Purpose Schema create table filter ( identifier integer not null primary key, type integer not null references filter_type(identifier), users integer not null references users(identifier), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null references access_type(identifier), serial_…

podoc:filter_type_id_sequence_sql_sequence

2007-04-23T10:42:16-04:00

Database Sequence Description of "filter_type_id_sequence" Name filter_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'filter_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'filter_type'.

podoc:filter_type_idx_sql_index

2007-04-23T10:56:24-04:00

Database Index Description of "filter_type_idx" Name filter_type_idx Description Index on column 'type' of table 'filter'. Purpose Speedup of table row lookups based on column 'type' in table 'filter'. Schema create index filter_type_idx on filter(type);

podoc:filter_type_manufacturer_idx_sql_index

2007-04-23T10:55:08-04:00

Database Index Description of "filter_type_manufacturer_idx" Name filter_type_manufacturer_idx Description Index on column 'manufacturer' of table 'filter_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'filter_type'.

podoc:filter_type_sql_table

2007-04-20T08:51:22-04:00

Database Table Description of "filter_type" Name filter_type Description Purpose Schema create table filter_type ( identifier integer not null primary key, manufacturer integer not null references manufacturer(identifier), model varchar(100), variation varchar(100), last_modified_date timestamp, last_modifying_users integer references users(identifier) );

podoc:filter_users_idx_sql_index

2007-04-23T10:55:19-04:00

Database Index Description of "filter_users_idx" Name filter_users_idx Description Index on column 'users' of table 'filter'. Purpose Speedup of table row lookups based on column 'users' in table 'filter'. Schema create index filter_users_idx on filter(users);

podoc:flash_id_sequence_sql_sequence

2007-04-23T10:42:53-04:00

Database Sequence Description of "flash_id_sequence" Name flash_id_sequence Description Sequence generator for the column 'identifier' of the table 'flash'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'flash'.

podoc:flash_mode_id_sequence_sql_sequence

2007-04-23T10:42:59-04:00

Database Sequence Description of "flash_mode_id_sequence" Name flash_mode_id_sequence Description Sequence generator for the column 'identifier' of the table 'flash_mode'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'flash_mode'.

podoc:flash_mode_sql_table

2007-04-20T10:27:19-04:00

Database Table Description of "flash_mode" Name flash_mode Description Purpose Schema create table flash_mode ( identifier integer not null primary key, value varchar(40) ); References tables None. Is referenced by tables * photo_tech(flash_mode) references identifier

podoc:flash_sql_table

2007-04-20T10:26:59-04:00

Database Table Description of "flash" Name flash Description Purpose Schema create table flash ( identifier integer not null primary key, type integer not null references flash_type(identifier), users integer not null references users(identifier), serial_number varchar(20), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null references a…

podoc:flash_type_id_sequence_sql_sequence

2007-04-23T10:43:06-04:00

Database Sequence Description of "flash_type_id_sequence" Name flash_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'flash_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'flash_type'.

podoc:flash_type_idx_sql_index

2007-04-23T10:55:25-04:00

Database Index Description of "flash_type_idx" Name flash_type_idx Description Index on column 'type' of table 'flash'. Purpose Speedup of table row lookups based on column 'type' in table 'flash'. Schema create index flash_type_idx on flash(type);

podoc:flash_type_manufacturer_idx_sql_index

2007-04-23T10:55:33-04:00

Database Index Description of "flash_type_manufacturer_idx" Name flash_type_manufacturer_idx Description Index on column 'manufacturer' of table 'flash_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'flash_type'.

podoc:flash_type_sql_table

2007-04-20T08:59:28-04:00

Database Table Description of "flash_type" Name flash_type Description Purpose Schema create table flash_type ( identifier integer not null primary key, manufacturer integer not null references manufacturer(identifier), model varchar(100), variation varchar(100), last_modified_date timestamp, last_modifying_users integer references users(identifier) );

podoc:flash_users_idx_sql_index

2007-04-23T10:55:38-04:00

Database Index Description of "flash_users_idx" Name flash_users_idx Description Index on column 'users' of table 'flash'. Purpose Speedup of table row lookups based on column 'users' in table 'flash'. Schema create index flash_users_idx on flash(users);

podoc:focal_length_id_sequence_sql_sequence

2007-04-23T10:43:12-04:00

Database Sequence Description of "focal_length_id_sequence" Name focal_length_id_sequence Description Sequence generator for the column 'identifier' of the table 'focal_length'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'focal_length'.

podoc:focal_length_sql_table

2007-04-20T10:27:52-04:00

Database Table Description of "focal_length" Name focal_length Description Purpose Schema create table focal_length ( identifier integer not null primary key, value integer ); References tables None. Is referenced by tables * lens_type(max_focal_length) references identifier * lens_type(min_focal_length) references identifier * photo_tech(focal_length) references identifier

podoc:folder_and_subfolders_sql_function

2007-10-19T11:05:40-04:00

Database Function Description of "folder_and_subfolders" Name folder_and_subfolders Description Purpose Schema ----- Recursive bulk updates! CREATE OR REPLACE FUNCTION folder_and_subfolders(int) RETURNS SETOF int AS ' DECLARE ident record; ident2 record; BEGIN RETURN NEXT $1; FOR ident IN SELECT identifier FROM folder f WHERE f.parent_folder = $1 LOOP FOR ident2 IN SELECT * FROM folder_and_subfolders(ident.identifier) LOOP RETURN NEXT ident2.folder_and_subfo…

podoc:folder_event_idx_sql_index

2007-10-19T15:19:57-04:00

Database Index Description of "folder_event_idx" Name folder_event_idx Description Index on column 'event' of table 'folder'. Purpose Speedup of table row lookups based on column 'event' in table 'folder'. Schema create index folder_event_idx on folder(event);

podoc:folder_id_idx_sql_index

2007-10-19T11:38:48-04:00

Database Index Description of "folder_id_idx" Name folder_id_idx Description Index on column 'identifier' of table 'folder'. Purpose Speedup of table row lookups based on column 'identifier' in table 'folder'. Schema create index folder_id_idx on folder(identifier);

podoc:folder_id_sequence_sql_sequence

2007-04-23T10:43:18-04:00

Database Sequence Description of "folder_id_sequence" Name folder_id_sequence Description Sequence generator for the column 'identifier' of the table 'folder'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'folder'.

podoc:folder_parent_idx_sql_index

2007-10-19T15:31:50-04:00

Database Index Description of "folder_parent_idx" Name folder_parent_idx Description Index on column 'parent_folder' of table 'folder'. Purpose Speedup of table row lookups based on column 'parent_folder' in table 'folder'. Schema create index folder_parent_idx on folder(parent_folder);

podoc:folder_sql_table

2007-10-19T16:39:27-04:00

Database Table Description of "folder" Name folder Description Purpose Schema create table folder ( identifier integer not null primary key, parent_folder integer references folder(identifier), users integer not null references users(identifier), -- the users who uploaded the picture, not necessarily the owner caption text, date_of_creation timestamp, access_rights integer not null references access_type(iden…

podoc:folder_users_idx_sql_index

2007-04-23T10:55:49-04:00

Database Index Description of "folder_users_idx" Name folder_users_idx Description Index on column 'users' of table 'folder'. Purpose Speedup of table row lookups based on column 'users' in table 'folder'. Schema create index folder_users_idx on folder(users);

podoc:folders_and_albums

2006-11-22T12:59:02-04:00

FOLDERS AND ALBUMS Folders and albums are photo collections. The difference between folders and albums is that while one photo belongs to one and only one folder, it can be linked to an unlimited number of albums, which therefore may can contain photos belonging to different folders.

podoc:front_page

2007-08-03T15:57:58-04:00

Front Page Introduction The purpose of the front page is to provide a customizable platform allowing the system administrator to create a unique appearance for each Photo Organizer installation. Currently the Front Page consists only of a single page that is the default page of the software, but the eventual goal is to extend this mechanism and turn it into a complete customer-modifiable interface.

podoc:get_image_path_sql_function

2007-10-19T11:06:50-04:00

Database Function Description of "get_image_path" Name get_image_path Description Purpose Schema CREATE OR REPLACE FUNCTION get_image_path(int, int) RETURNS text AS ' SELECT path FROM files WHERE version = $1 AND size = $2; ' LANGUAGE 'sql';

podoc:get_user_pref_sql_function

2007-10-19T11:24:45-04:00

Database Function Description of "get_user_pref" Name get_user_pref Description Purpose Schema CREATE OR REPLACE FUNCTION get_user_pref(int, text) RETURNS text AS ' SELECT value FROM user_preferences WHERE owner = $1 AND key = $2; ' LANGUAGE 'sql';

podoc:imagemagick_composite_options_id_sequence_sql_sequence

2007-10-19T15:10:12-04:00

Database Sequence Description of "imagemagick_composite_options_id_sequence" Name imagemagick_composite_options_id_sequence Description Purpose Schema create sequence imagemagick_composite_options_id_sequence start 1; Related tables * imagemagick_composite_options

podoc:imagemagick_composite_options_sql_table

2007-10-19T14:53:21-04:00

Database Table Description of "imagemagick_composite_options" Name imagemagick_composite_options Description Purpose Schema create table imagemagick_composite_options ( identifier integer not null primary key, gravity varchar(20) check (gravity in ('center', 'northwest', 'north', 'northeast', 'west', 'center', 'east', 'southwest', 'south', 'southeast')), watermark integer not null, photo_version integer references photo_version…

podoc:imagemagick_options_id_sequence_sequence

2007-10-19T15:01:46-04:00

Database Sequence Description of "imagemagick_options_id_sequence" Name imagemagick_options_id_sequence Description Purpose Schema create sequence imagemagick_options_id_sequence start 1; Related tables * imagemagick_options Related indexes Related functions Related views History Used first Version 2.21 -- unsure

podoc:imagemagick_options_id_sequence_sql_sequence

2007-10-19T15:03:31-04:00

Database Sequence Description of "imagemagick_options_id_sequence" Name imagemagick_options_id_sequence Description Purpose Schema -- create sequence and set it to the same value as the preferences sequence was create sequence imagemagick_options_id_sequence; select setval('imagemagick_options_id_sequence',max(imagemagick_options)) from users;

podoc:imagemagick_options_sql_table

2007-10-19T14:53:19-04:00

Database Table Description of "imagemagick_options" Name imagemagick_options Description Purpose Schema create table imagemagick_options ( identifier integer not null primary key, preview_quality integer, preview_colorspace varchar(20), preview_gamma float, preview_sharpen_radius float, preview_sharpen_sigma float, preview_border_width integer, preview_border_height integer, preview_border_color …

podoc:installation

2007-11-27T11:08:47-04:00

Installation Overview Please note that these instructions are intended for v2.34. For versions 2.31 and older, please see the originial installation instructions at: Additionally, please read the installation_gotchas page before installing, as it contains a short list of common problems and their solutions.

podoc:installation_gotchas

2006-11-27T12:03:46-04:00

Installation Gotchas Photo Organizer isn't the easiest tool to install successfully. While v2.32+ has a new installer that makes things a lot simpler, PO has several dependencies that need to be set up independently. Database Problems This is perhaps the most complicated part to set up, as there's no way for Photo Organizer to work around this or automate it.

podoc:is_photo_for_sale_sql_function

2007-10-19T11:59:12-04:00

Database Function Description of "is_photo_for_sale" Name is_photo_for_sale Description Checks if a photo is for sale or not. Purpose To retrieve the ability/permission of a photo to be sold. Schema create function is_photo_for_sale(integer) returns bigint as 'select count(photo_item.identifier) from photo, photo_item where photo.identifier=photo_item.photo and photo.identifier = $1' language 'sql';

podoc:is_user_my_client_sql_function

2007-04-23T10:30:14-04:00

Database Function Description of "is_user_my_client" Name is_user_my_client Description Checks if a particular user is a client of another user. Purpose To retrieve the client status of a particular user with another user. Schema create function is_user_my_client(integer, integer) returns bigint as 'select count(identifier) from client where client.users = $1 and client.client = $2 and status=2' language 'sql';

podoc:label_id_sequence_sql_sequence

2007-04-23T10:43:26-04:00

Database Sequence Description of "label_id_sequence" Name label_id_sequence Description Sequence generator for the column 'identifier' of the table 'label'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'label'.

podoc:label_idx_sql_index

2007-04-23T10:55:57-04:00

Database Index Description of "label_idx" Name label_idx Description Index on column 'identifier' of table 'label'. Purpose Speedup of table row lookups based on column 'identifier' in table 'label'. Schema create index label_idx on label(identifier);

podoc:label_sql_table

2007-04-20T11:28:56-04:00

Database Table Description of "label" Name label Description Purpose Schema create table label ( -- labels, for printing identifier integer not null primary key, users integer references users(identifier), manufacturer integer references manufacturer(identifier), name varchar(300), space_x float, space_y float, size_x float, size_y float, offset_x …

podoc:lens_id_sequence_sql_sequence

2007-04-23T10:43:34-04:00

Database Sequence Description of "lens_id_sequence" Name lens_id_sequence Description Sequence generator for the column 'identifier' of the table 'lens'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'lens'.

podoc:lens_sql_table

2007-04-20T10:28:39-04:00

Database Table Description of "lens" Name lens Description Purpose Schema create table lens ( identifier integer not null primary key, type integer not null references lens_type(identifier), users integer not null references users(identifier), serial_number varchar(20), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null references acces…

podoc:lens_type_id_sequence_sql_sequence

2007-04-23T10:43:41-04:00

Database Sequence Description of "lens_type_id_sequence" Name lens_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'lens_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'lens_type'.

podoc:lens_type_idx_sql_index

2007-04-23T10:56:05-04:00

Database Index Description of "lens_type_idx" Name lens_type_idx Description Index on column 'type' of table 'lens'. Purpose Speedup of table row lookups based on column 'type' in table 'lens'. Schema create index lens_type_idx on lens(type);

podoc:lens_type_manufacturer_idx_sql_index

2007-04-23T10:57:16-04:00

Database Index Description of "lens_type_manufacturer_idx" Name lens_type_manufacturer_idx Description Index on column 'manufacturer' of table 'lens_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'lens_type'.

podoc:lens_type_sql_table

2007-10-19T16:09:50-04:00

Database Table Description of "lens_type" Name lens_type Description Purpose Schema create table lens_type ( identifier integer not null primary key, manufacturer integer not null references manufacturer(identifier), model varchar(100), variation varchar(100), min_focal_length integer not null references focal_length(identifier), max_focal_length integer not null references focal_length(identifier), min_aperture …

podoc:lens_users_idx_sql_index

2007-04-23T10:57:22-04:00

Database Index Description of "lens_users_idx" Name lens_users_idx Description Index on column 'users' of table 'lens'. Purpose Speedup of table row lookups based on column 'users' in table 'lens'. Schema create index lens_users_idx on lens(users);

podoc:location_id_sequence_sql_sequence

2007-04-23T10:44:57-04:00

Database Sequence Description of "location_id_sequence" Name location_id_sequence Description Sequence generator for the column 'identifier' of the table 'location'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'location'.

podoc:location_sql_table

2007-04-20T09:38:31-04:00

Database Table Description of "location" Name location Description Purpose Schema create table location ( -- location is the place the photo was taken identifier integer not null primary key, place varchar(300), state integer references state(identifier), country integer references country(identifier), last_modified_date timestamp, users integer references users(identifier), city varc…

podoc:login

2007-08-09T15:37:45-04:00

Login While logging in isn't necessary if you only wish to browse the images that other users have made public, actually uploading your own, or taking advantage of PO's other features requires you to log in. In order to log in you will need an account. If the PO installation allows open logins you can register yourself via the button on the login page.

podoc:manufacturer_id_sequence_sql_sequence

2007-04-23T10:43:59-04:00

Database Sequence Description of "manufacturer_id_sequence" Name manufacturer_id_sequence Description Sequence generator for the column 'identifier' of the table 'manufacturer'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'manufacturer'.

podoc:manufacturer_sql_table

2007-04-20T11:24:43-04:00

Database Table Description of "manufacturer" Name manufacturer Description Purpose Schema create table manufacturer ( identifier integer not null primary key, name varchar(100), url varchar(100), last_modified_date timestamp, last_modifying_users integer references users(identifier) );

podoc:number_of_camera_references_sql_function

2007-04-23T10:30:21-04:00

Database Function Description of "number_of_camera_references" Name number_of_camera_references Description Counts the number of references for a specific camera. Tentative (is this correct?): this represents the number of photos in the database generated by the specified camera.

podoc:number_of_dupes_sql_function

2007-04-23T10:30:28-04:00

Database Function Description of "number_of_dupes" Name number_of_dupes Description Count the number of photo duplicates. Purpose To return the number of photo duplicates. Schema create function number_of_dupes(integer) returns bigint as 'select count(identifier) from photo_dupe where photo = $1' language 'sql';

podoc:number_of_film_references_sql_function

2007-04-23T10:30:38-04:00

Database Function Description of "number_of_film_references" Name number_of_film_references Description Counts the number of references for a particular film. Tentative (is this correct?): this represents the number of photos in the database captured on the specified film.

podoc:number_of_filter_references_sql_function

2007-04-23T10:30:47-04:00

Database Function Description of "number_of_filter_references" Name number_of_filter_references Description Counts the number of references to a particular filter. Tentative (is this correct?): this represents the number of photos in the database captured using the specified filter.

podoc:number_of_flash_references_sql_function

2007-04-23T10:30:56-04:00

Database Function Description of "number_of_flash_references" Name number_of_flash_references Description Counts the number of references to a particular flash. Tentative (is this correct?): this represents the number of photos in the database captured using the specified flash.

podoc:number_of_lens_references_sql_function

2007-04-23T10:31:05-04:00

Database Function Description of "number_of_lens_references" Name number_of_lens_references Description Counts the number of references to a particular lens. Tentative (is this correct?): this represents the number of photos in the database captured using the specified lens.

podoc:number_of_location_references_sql_function

2007-04-23T10:31:14-04:00

Database Function Description of "number_of_location_references" Name number_of_location_references Description Counts the number of references to a particular location. Tentative (is this correct?): this represents the number of photos in the database captured at the specified location.

podoc:number_of_manufacturer_ref_sql_function

2007-10-19T12:07:14-04:00

Database Function Description of "number_of_manufacturer_ref" Name number_of_manufacturer_ref Description Counts the number of references to a particular manufacturer. Tentative (is this correct?): this represents the number of equipment items in the database created by the specified manufacturer.

podoc:number_of_scanner_references_sql_function

2007-04-23T10:31:30-04:00

Database Function Description of "number_of_scanner_references" Name number_of_scanner_references Description Counts the number of references to a particular scanner. Tentative (is this correct?): this represents the number of photos in the database captured using the specified scanner.

podoc:number_of_support_references_sql_function

2007-04-23T10:32:24-04:00

Database Function Description of "number_of_support_references" Name number_of_support_references Description Counts the number of references to a particular support. Tentative (is this correct?): this represents the number of photos in the database captured using the specified support.

podoc:orientations_id_sequence_sql_sequence

2007-04-23T10:44:08-04:00

Database Sequence Description of "orientations_id_sequence" Name orientations_id_sequence Description Sequence generator for the column 'identifier' of the table 'orientations'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'orientations'.

podoc:orientations_sql_table

2007-04-20T10:10:04-04:00

Database Table Description of "orientations" Name orientations Description Purpose Schema create table orientations ( identifier integer not null primary key, name varchar(100), im_transform varchar(100) );

podoc:paper_id_sequence_sql_sequence

2007-04-23T10:44:22-04:00

Database Sequence Description of "paper_id_sequence" Name paper_id_sequence Description Sequence generator for the column 'identifier' of the table 'paper'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'paper'.

podoc:paper_idx_sql_index

2007-04-23T10:57:29-04:00

Database Index Description of "paper_idx" Name paper_idx Description Index on column 'identifier' of table 'paper'. Purpose Speedup of table row lookups based on column 'identifier' in table 'paper'. Schema create index paper_idx on paper(identifier);

podoc:paper_sql_table

2007-04-20T11:29:05-04:00

Database Table Description of "paper" Name paper Description Purpose Schema create table paper ( -- labels, for printing identifier integer not null primary key, name varchar(300), size_x float, size_y float, last_modified_date timestamp, last_modifying_users integer references users(identifier) );

podoc:permission_model

2006-11-23T04:57:37-04:00

Permission Model This is where the permission model of PO should be documented. See also * Flyspray ticket #8: Better permission hierarchy

podoc:photo_dupe_id_sequence_sql_sequence

2007-04-23T10:45:46-04:00

Database Sequence Description of "photo_dupe_id_sequence" Name photo_dupe_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo_dupe'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo_dupe'.

podoc:photo_dupe_key_sql_index

2007-10-19T10:46:31-04:00

Database Index Description of "photo_dupe_key" Name photo_dupe_key Description Index on column 'key' of table 'photo_dupe'. Purpose Speedup of table row lookups based on column 'key' in table 'photo_dupe'. Schema create index photo_dupe_key on photo_dupe(key);

podoc:photo_dupe_sql_table

2007-10-31T11:38:37-04:00

Database Table Description of "photo_dupe" Name photo_dupe Description Purpose Schema create table photo_dupe ( identifier integer not null primary key, key integer not null, photo integer not null references photo(identifier), date_of_creation timestamp, -- date when it was inserted in the system storage_location varchar(50), storage_index varchar(10), remark text, -- dupe rema…

podoc:photo_dupe_version_idx_sql_index

2007-10-19T15:34:11-04:00

Database Index Description of "photo_dupe_version_idx" Name photo_dupe_version_idx Description Index on column 'version' of table 'photo_dupe'. Purpose Speedup of table row lookups based on column 'version' in table 'photo_dupe'. Schema create index photo_dupe_version_idx on photo_dupe(version);

podoc:photo_folder_sql_index

2007-10-19T15:29:14-04:00

Database Index Description of "photo_folder" Name photo_folder Description Index on column 'folder' of table 'photo'. Purpose Speedup of table row lookups based on column 'folder' in table 'photo'. Schema create index photo_folder on photo(folder);

podoc:photo_format_id_sequence_sql_sequence

2007-04-23T10:45:55-04:00

Database Sequence Description of "photo_format_id_sequence" Name photo_format_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo_format'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo_format'.

podoc:photo_format_sql_table

2007-04-20T10:55:38-04:00

Database Table Description of "photo_format" Dropped in 2.19. Replaced by shop_item. Name photo_format Description Purpose Schema create table photo_format ( identifier integer not null primary key, users integer references users(identifier), width varchar(100), height varchar(100), date_of_creation timestamp, date_of_last_edit timestamp );

podoc:photo_id_idx_sql_index

2007-10-19T11:38:50-04:00

Database Index Description of "photo_id_idx" Name photo_id_idx Description Index on column 'identifier' of table 'photo'. Purpose Speedup of table row lookups based on column 'identifier' in table 'photo'. Schema create index photo_id_idx on photo(identifier);

podoc:photo_id_sequence_sql_sequence

2007-04-23T10:46:02-04:00

Database Sequence Description of "photo_id_sequence" Name photo_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo'.

podoc:photo_item_id_sequence_sql_sequence

2007-10-19T11:59:24-04:00

Database Sequence Description of "photo_item_id_sequence" Name photo_item_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo_item'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo_item'.

podoc:photo_item_sql_table

2007-10-19T11:51:49-04:00

Database Table Description of "photo_item" Name photo_item Description Purpose Schema create table photo_item ( identifier integer not null primary key, photo integer not null references photo(identifier), shop_item integer not null references shop_item(identifier), price numeric, currency integer references currency(identifier), comment text, date_of_creation timestamp, date_of_last_ed…

podoc:photo_keyword_photo_sql_index

2007-04-17T09:32:00-04:00

page needs to be deleted

podoc:photo_keywords_photo_sql_index

2007-04-23T10:57:40-04:00

Database Index Description of "photo_keywords_photo" Name photo_keywords_photo Description Index on column 'photo' of table 'photo_keywords'. Purpose Speedup of table row lookups based on column 'photo' in table 'photo_keywords'. Schema create index photo_keywords_photo on photo_keywords(photo);

podoc:photo_keywords_sql_table

2007-04-20T10:06:43-04:00

Database Table Description of "photo_keywords" Name photo_keywords Description Purpose Schema create table photo_keywords ( photo integer not null references photo(identifier), keyword text not null ); References tables * photo references photo(identifier)

podoc:photo_location_idx_sql_index

2007-04-23T10:57:46-04:00

Database Index Description of "photo_location_idx" Name photo_location_idx Description Index on column 'location' of table 'photo'. Purpose Speedup of table row lookups based on column 'location' in table 'photo'. Schema create index photo_location_idx on photo(location);

podoc:photo_management

2007-08-03T16:14:45-04:00

ADDING PHOTOS When adding photos to Photo Organizer, the software will keep the images in their original format. The thumbnail and the preview will be generated in JPEG format which is customizable by the system administrator. Photo Organizer uses ImageMagick to recognize over one hundered image formats, and DCRaw to decode most digital camera RAW formats. For an up to date list please visit the ImageMagick web site and the DCRaw home page.

podoc:photo_shop_transaction_references_sql_function

2007-04-23T10:32:32-04:00

Database Function Description of "photo_shop_transaction_references" Name photo_shop_transaction_references Description Counts the number of shop transactions for a particular photo item. Tentative (is this correct?): this represents the number of copies of a photo sold.

podoc:photo_spooler_id_sequence_sql_sequence

2007-10-19T10:42:21-04:00

Database Sequence Description of "photo_spooler_id_sequence" Name photo_spooler_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo_spooler'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo_spooler'.

podoc:photo_spooler_sql_table

2007-10-19T10:41:16-04:00

Database Table Description of "photo_spooler" Name photo_spooler Description Purpose Schema create table photo_spooler ( identifier integer not null primary key, users integer references users(identifier), photo integer references photo(identifier) );

podoc:photo_sql_table

2007-10-31T11:43:07-04:00

Database Table Description of "photo" Name photo Description Purpose Schema create table photo ( identifier integer not null primary key, users integer not null references users(identifier), -- the users who uploaded the picture, not necessarily the owner folder integer not null references folder(identifier), location integer not null references location(identifier), caption text, -- a n…

podoc:photo_tech_id_idx_sql_index

2007-04-23T10:57:51-04:00

Database Index Description of "photo_tech_id_idx" Name photo_tech_id_idx Description Index on column 'identifier' of table 'photo_tech'. Purpose Speedup of table row lookups based on column 'identifier' in table 'photo_tech'. Schema create index photo_tech_id_idx on photo_tech(identifier);

podoc:photo_tech_id_sequence_sql_sequence

2007-04-23T10:46:20-04:00

Database Sequence Description of "photo_tech_id_sequence" Name photo_tech_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo_tech'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo_tech'.

podoc:photo_tech_photo_idx_sql_index

2007-04-23T10:57:57-04:00

Database Index Description of "photo_tech_photo_idx" Name photo_tech_photo_idx Description Index on column 'photo' of table 'photo_tech'. Purpose Speedup of table row lookups based on column 'photo' in table 'photo_tech'. create index photo_tech_photo_idx on photo_tech(photo);

podoc:photo_tech_sql_table

2007-10-19T16:31:03-04:00

Database Table Description of "photo_tech" Name photo_tech Description Purpose Schema create table photo_tech ( identifier integer not null primary key, photo integer not null references photo(identifier), camera integer references camera(identifier), lens integer references lens(identifier), film integer references film(identifier), flash integer references flash(identifier), scanne…

podoc:photo_users_idx_sql_index

2007-04-23T10:58:02-04:00

Database Index Description of "photo_users_idx" Name photo_users_idx Description Index on column 'users' of table 'photo'. Purpose Speedup of table row lookups based on column 'users' in table 'photo'. Schema create index photo_users_idx on photo(users);

podoc:photo_version_id_sequence_sql_sequence

2007-04-23T10:46:26-04:00

Database Sequence Description of "photo_version_id_sequence" Name photo_version_id_sequence Description Sequence generator for the column 'identifier' of the table 'photo_version'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'photo_version'.

podoc:photo_version_photo_idx_sql_index

2007-04-23T10:58:09-04:00

Database Index Description of "photo_version_photo_idx" Name photo_version_photo_idx Description Purpose Schema create index photo_version_photo_idx on photo_version(photo); Related tables (fields) * photo_version(photo) History Used first Version 2.33

podoc:photo_version_photo_sql_index

2007-10-19T15:36:36-04:00

Database Index Description of "photo_version_photo" Name photo_version_photo Description Index on column 'photo' of table 'photo_version'. Purpose Speedup of table row lookups based on column 'photo' in table 'photo_version'. Schema create index photo_version_photo on photo_version(photo);

podoc:photo_version_sql_table

2007-10-19T16:02:30-04:00

Database Table Description of "photo_version" Name photo_version Description Purpose Schema create table photo_version ( identifier integer not null primary key, key integer not null, photo integer not null references photo(identifier), master char(1) check (master in ('t', 'f')), date_of_creation timestamp, comment text, original_image_name varchar(500), colorspace integer not nul…

podoc:preferences_id_sequence_sql_sequence

2007-10-19T15:09:58-04:00

Database Sequence Description of "preferences_id_sequence" Name preferences_id_sequence Description Sequence generator for the column 'identifier' of the table 'preferences'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'preferences'.

podoc:preferences_sql_table

2007-10-19T14:54:35-04:00

Database Table Description of "preferences" Name preferences Description Purpose Schema create table preferences ( identifier integer not null primary key, print_out char(3) check (print_out in ('ps', 'pdf')), start_hour integer check (start_hour >= 0 and start_hour < 24), end_hour integer check (start_hour >= 0 and start_hour < 24), start_day integer check (start_day in (1, 0)), num_of_rows …

podoc:print

2006-11-28T00:07:17-04:00

Printing A key feature of Photo Organizer is the ability to print labels and brochures. Two formats are currently supported, Postscript (PS) and Portable Document Format (PDF). Photo Organizer actually generates Postscript files natively, and must rely on a third party utility (ps2pdf) to convert the PS document into PDF.

podoc:print_id_sequence_sql_index

2007-04-12T11:40:16-04:00

Database Sequence Description of "print_id_sequence" Name print_id_sequence Description Purpose Schema create sequence print_id_sequence start 1; Related tables * printer_spooler Related indexes Related functions Related views History Used first Version 2.5

podoc:print_id_sequence_sql_sequence

2007-04-23T10:46:38-04:00

Database Sequence Description of "print_id_sequence" Name print_id_sequence Description TODO: check up on this. It is probably wrong... Sequence generator for the column 'identifier' of the table 'print'. Purpose TODO: check up on this. It is probably wrong...

podoc:printer_spooler_id_sequence_sql_sequence

2007-04-23T10:46:47-04:00

Database Sequence Description of "printer_spooler_id_sequence" Name printer_spooler_id_sequence Description Sequence generator for the column 'identifier' of the table 'printer_spooler'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'printer_spooler'.

podoc:printer_spooler_sql_table

2007-04-20T10:56:11-04:00

Database Table Description of "printer_spooler" Dropped in 2.15. Replaced by photo_spooler. Name printer_spooler Description Purpose Schema create table printer_spooler ( identifier integer not null primary key, users integer references users(identifier), photo integer references photo(identifier) );

podoc:profile

2007-08-10T11:48:28-04:00

Managing your Profile In addition to your images, Photo Organizer can keep track of what equipment you use for each image, and where each was taken. The currently supported equipment types are: Lenses, Cameras, Flashes, Filters, Film, Supports, and Scanners. You can also define custom labels, and of course, locations. Once added, they will be available on the photo add/edit pages for association with images.

podoc:rating_id_idx_sql_index

2007-04-23T10:59:34-04:00

Database Index Description of "rating_id_idx" Name rating_id_idx Description Index on column 'identifier' of table 'rating'. Purpose Speedup of table row lookups based on column 'identifier' in table 'rating'. Schema create index rating_id_idx on rating(identifier);

podoc:rating_id_sequence_sql_sequence

2007-04-23T10:46:57-04:00

Database Sequence Description of "rating_id_sequence" Name rating_id_sequence Description Sequence generator for the column 'identifier' of the table 'rating'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'rating'.

podoc:rating_photo_idx_sql_index

2007-04-23T10:59:41-04:00

Database Index Description of "rating_photo_idx" Name rating_photo_idx Description Index on column 'photo' of table 'rating'. Purpose Speedup of table row lookups based on column 'photo' in table 'rating'. Schema create index rating_photo_idx on rating(photo);

podoc:rating_sql_table

2007-10-19T15:39:51-04:00

Database Table Description of "rating" Name rating Description Purpose Schema create table rating ( identifier integer not null primary key, photo integer not null references photo(identifier), users integer not null references users(identifier), date_of_creation timestamp, value integer not null, comment text, version integer not null references photo_version(identifier); );

podoc:rating_users_idx_sql_index

2007-04-23T10:59:50-04:00

Database Index Description of "rating_users_idx" Name rating_users_idx Description Index on column 'users' of table 'rating'. Purpose Speedup of table row lookups based on column 'users' in table 'rating'. Schema create index rating_users_idx on rating(users);

podoc:rating_version_idx_sql_index

2007-10-19T15:39:25-04:00

Database Index Description of "rating_version_idx" Name rating_version_idx Description Index on column 'version' of table 'rating'. Purpose Speedup of table row lookups based on column 'version' in table 'rating'. Schema create index rating_version_idx on rating(version);

podoc:requirements

2008-01-06T14:43:04-04:00

Requirements Photo Organizer was developed on Linux, but it should work on any UNIX-like platform that supports the following: * PHP >= 5.0.0 (with bcmath extension) * Web server capable of running PHP (eg Apache or lighttpd) * PostgreSQL, version 8.0 or newer * Ability to send e-mail * ExifTool for metadata extraction * ImageMagick for image manipulation * Lots of disk space for photographs!

podoc:scan_bitdepth_id_sequence_sql_sequence

2007-04-23T10:47:02-04:00

Database Sequence Description of "scan_bitdepth_id_sequence" Name scan_bitdepth_id_sequence Description Sequence generator for the column 'identifier' of the table 'scan_bitdepth'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'scan_bitdepth'.

podoc:scan_bitdepth_sql_table

2007-04-20T10:30:46-04:00

Database Table Description of "scan_bitdepth" Name scan_bitdepth Description Purpose Schema create table scan_bitdepth ( identifier integer not null primary key, value varchar(6) ); References tables None.

podoc:scan_multiscan_id_sequence_sql_sequence

2007-04-23T10:48:14-04:00

Database Sequence Description of "scan_multiscan_id_sequence" Name scan_multiscan_id_sequence Description Sequence generator for the column 'identifier' of the table 'scan_multiscan'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'scan_multiscan'.

podoc:scan_multiscan_sql_table

2007-04-20T10:31:29-04:00

Database Table Description of "scan_multiscan" Name scan_multiscan Description Purpose Schema create table scan_multiscan ( identifier integer not null primary key, value integer ); References tables None.

podoc:scan_resolution_id_sequence_sql_sequence

2007-04-23T10:48:21-04:00

Database Sequence Description of "scan_resolution_id_sequence" Name scan_resolution_id_sequence Description Sequence generator for the column 'identifier' of the table 'scan_resolution'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'scan_resolution'.

podoc:scan_resolution_sql_table

2007-04-20T10:32:14-04:00

Database Table Description of "scan_resolution" Name scan_resolution Description Purpose Schema create table scan_resolution ( identifier integer not null primary key, value varchar(6) ); References tables None.

podoc:scanner_id_sequence_sql_sequence

2007-04-23T10:48:26-04:00

Database Sequence Description of "scanner_id_sequence" Name scanner_id_sequence Description Sequence generator for the column 'identifier' of the table 'scanner'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'scanner'.

podoc:scanner_sql_table

2007-04-20T11:01:38-04:00

Database Table Description of "scanner" Name scanner Description Purpose Schema create table scanner ( identifier integer not null primary key, type integer not null references scanner_type(identifier), users integer not null references users(identifier), serial_number varchar(20), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null refe…

podoc:scanner_type_id_sequence_sql_sequence

2007-04-23T10:48:33-04:00

Database Sequence Description of "scanner_type_id_sequence" Name scanner_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'scanner_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'scanner_type'.

podoc:scanner_type_idx_sql_index

2007-04-23T10:59:56-04:00

Database Index Description of "scanner_type_idx" Name scanner_type_idx Description Index on column 'type' of table 'scanner'. Purpose Speedup of table row lookups based on column 'type' in table 'scanner'. Schema create index scanner_type_idx on scanner(type);

podoc:scanner_type_manufacturer_idx_sql_index

2007-04-23T11:00:02-04:00

Database Index Description of "scanner_type_manufacturer_idx" Name scanner_type_manufacturer_idx Description Index on column 'manufacturer' of table 'scanner_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'scanner_type'.

podoc:scanner_type_sql_table

2007-04-20T11:01:26-04:00

Database Table Description of "scanner_type" Name scanner_type Description Purpose Schema create table scanner_type ( identifier integer not null primary key, manufacturer integer not null references manufacturer(identifier), model varchar(100), variation varchar(100), last_modified_date timestamp, last_modifying_users integer references users(identifier) );

podoc:scanner_users_idx_sql_index

2007-04-23T11:00:10-04:00

Database Index Description of "scanner_users_idx" Name scanner_users_idx Description Index on column 'users' of table 'scanner'. Purpose Speedup of table row lookups based on column 'users' in table 'scanner'. Schema create index scanner_users_idx on scanner(users);

podoc:schema-2.33c

2007-04-20T10:03:50-04:00

Database schema dump of PO 2.33c -- -- PostgreSQL database dump -- SET client_encoding = 'UTF8'; SET check_function_bodies = false; SET client_min_messages = warning; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; -- -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -- CREATE PROCEDURAL LANGUAGE plpgsql; SET search_path = public, pg_catalog; -- -- Name: concat_ignore_null(character varying, ch…

podoc:search

2006-11-22T13:07:24-04:00

SEARCH ENGINE BASICS There are three categories on which Photo Organizer's search engine can perform queries. These categories were introduced to improve the search performance and to allow customized display of the results. The search engine uses stemming to automatically include related variations of your keywords. If you search for update, you will also find updated, updates, updating and so on. Every word in a search query is stemmed unless quotation marks are used.

podoc:security

2007-04-19T08:16:44-04:00

This page describes a conceptual model for security and access control. This does not describe the implementation of the current releases of Photo Organizer. However, it may become the design for future versions. For more information on current developments regarding the Photo Organizer permission model see FS#8 - Better permission hierarchy and new permission model.

podoc:settings

2007-08-14T13:51:34-04:00

Settings Your settings are collected into seven data groups: User Identification This is the basic user information used to log you into the system. Your username is only used to log in; afterwards your full name is used. You may also choose to hide yourself from the public user listings. If you have no publically-accessible photos, your name will be hidden even if you set this to 'yes'.

podoc:shop

2006-11-22T13:07:03-04:00

SHOP The shop module allows Photo Organizer users to sell their photos to registered clients or other PO users. Note: links need to be redirected to a local demo site To set up a shop, you will have to create Shop Categories and within these categories Shop Items. For instance typical categories and items would be:

podoc:shop_category_id_sequence_sql_sequence

2007-10-19T11:58:11-04:00

Database Sequence Description of "shop_category_id_sequence" Name shop_category_id_sequence Description Purpose Schema create sequence shop_category_id_sequence start 1; Related tables * shop_category Related indexes Related functions Related views History Used first Version 2.19

podoc:shop_category_sql_table

2007-10-19T11:51:46-04:00

Database Table Description of "shop_category" Name shop_category Description Purpose Schema create table shop_category ( identifier integer not null primary key, users integer not null references users(identifier), caption varchar(300), date_of_creation timestamp );

podoc:shop_implementation

2006-11-23T04:55:14-04:00

Shop implementation This is where the shop implementation of PO should be documented.

podoc:shop_item_generator_rule_id_sequence_sql_sequence

2007-10-19T11:59:41-04:00

Database Sequence Description of "shop_item_generator_rule_id_sequence" Name shop_item_generator_rule_id_sequence Description Sequence generator for the column 'identifier' of the table 'shop_item_generator_rule'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'shop_item_generator_rule'.

podoc:shop_item_generator_rule_sql_table

2007-10-19T11:51:54-04:00

Database Table Description of "shop_item_generator_rule" Name shop_item_generator_rule Description Purpose Schema create table shop_item_generator_rule ( identifier integer not null primary key, users integer not null references users(identifier), shop_item integer not null references shop_item(identifier), price numeric, currency integer references currency(identifier), comment text, da…

podoc:shop_item_id_sequence_sql_sequence

2007-04-16T11:56:21-04:00

Database Sequence Description of "shop_item_id_sequence" Name shop_item_id_sequence Description Purpose Schema create sequence shop_item_id_sequence start 1; Related tables * shop_item Related indexes Related functions Related views History Used first Version 2.19

podoc:shop_item_sql_table

2007-10-19T11:51:52-04:00

Database Table Description of "shop_item" Name shop_item Description Purpose Schema create table photo_format ( identifier integer not null primary key, users integer references users(identifier), date_of_creation timestamp, date_of_last_edit timestamp, description varchar(200), category integer not null references shop_category(identifier) );

podoc:shop_order_id_sequence_sql_sequence

2007-10-19T12:00:29-04:00

Database Sequence Description of "shop_order_id_sequence" Name shop_order_id_sequence Description Sequence generator for the column 'identifier' of the table 'shop_order'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'shop_order'.

podoc:shop_order_sql_table

2007-10-19T11:52:01-04:00

Database Table Description of "shop_order" Name shop_order Description Purpose Schema create table shop_order ( identifier integer not null primary key, client integer references users(identifier), transaction integer references shop_transaction, item integer not null references photo_item, pieces numeric, date_of_creation timestamp, date_of_last_edit timestamp, download_counter integer, d…

podoc:shop_transaction_id_sequence_sql_sequence

2007-10-19T12:01:07-04:00

Database Sequence Description of "shop_transaction_id_sequence" Name shop_transaction_id_sequence Description Sequence generator for the column 'identifier' of the table 'shop_transaction'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'shop_transaction'.

podoc:shop_transaction_sql_table

2007-10-19T11:51:59-04:00

Database Table Description of "shop_transaction" Name shop_transaction Description Purpose Schema create table shop_transaction ( identifier integer not null primary key, status integer not null references shop_transaction_status(identifier), remark text, date_of_creation timestamp, date_of_last_edit timestamp );

podoc:shop_transaction_status_id_sequence_sql_sequence

2007-10-19T12:00:57-04:00

Database Sequence Description of "shop_transaction_status_id_sequence" Name shop_transaction_status_id_sequence Description Sequence generator for the column 'identifier' of the table 'shop_transaction_status'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'shop_transaction_status'.

podoc:shop_transaction_status_sql_table

2007-10-19T11:51:56-04:00

Database Table Description of "shop_transaction_status" Name shop_transaction_status Description Purpose Schema create table shop_transaction_status ( identifier integer not null primary key, value varchar(15) );

podoc:shutter_id_sequence_sql_sequence

2007-04-23T10:49:13-04:00

Database Sequence Description of "shutter_id_sequence" Name shutter_id_sequence Description Sequence generator for the column 'identifier' of the table 'shutter'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'shutter'.

podoc:shutter_sql_table

2007-04-20T10:36:09-04:00

Database Table Description of "shutter" Name shutter Description Purpose Schema create table shutter ( identifier integer not null primary key, value varchar(10) ); References tables None. Is referenced by tables * shutter_id_sequence

podoc:sidebar

2007-08-28T09:29:03-04:00

Photo Organizer Documentation * Main PO site * Documentation Home Installation * System Requirements * Installation instructions * Configuration File * Installation gotchas * Database Config User Documentation * Target Audience * Login & Registration * Folders and Albums * Date Book * Profile * Photo Management * Print * Search * Settings * Tools * Bulk Update * Front Page * Administration

podoc:source_code

2007-08-28T09:42:00-04:00

Source code These pages document the source code of Photo Organizer. Ideally something like Doxygen should be used to document the source doe of Photo Organizer. However, the in code documentation for that is not there. The current code is very spartan when it comes to code comments.

podoc:start

2008-04-29T08:37:37-04:00

Photo Organizer Documentation Wiki Please pardon our dust -- we're migrating the old documentation to the wiki, where it'll then get cleaned up and generally made MoreBetter(tm) This documentation is intended to cover the upcoming 2.36 release Many thanks to contributors * Balint Kis - The original author of Photo Organizer. * Solomon Peachy - Added many features before taking over as the maintainer of Photo Organizer. * Phil Harvey - Author of the excellent ExifTool EXIF parser. * …

podoc:state_id_sequence_sql_sequence

2007-04-23T10:49:20-04:00

Database Sequence Description of "state_id_sequence" Name state_id_sequence Description Sequence generator for the column 'identifier' of the table 'state'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'state'.

podoc:state_sql_table

2007-04-20T09:39:58-04:00

Database Table Description of "state" Name state Description Purpose Schema create table state ( identifier integer not null primary key, code varchar(5), value varchar(40) ); References tables None.

podoc:submission_id_sequence_sql_sequence

2007-04-23T10:49:27-04:00

Database Sequence Description of "submission_id_sequence" Name submission_id_sequence Description Sequence generator for the column 'identifier' of the table 'submission'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'submission'.

podoc:submission_sql_table

2007-10-19T15:56:11-04:00

Database Table Description of "submission" Name submission Description Purpose Schema create table submission ( identifier integer not null primary key, photo_dupe integer not null references photo_dupe(identifier), status integer not null references submission_status(identifier), users integer references users(identifier), date_of_creation timestamp, remark text );

podoc:submission_status_id_sequence_sql_sequence

2007-04-23T10:49:35-04:00

Database Sequence Description of "submission_status_id_sequence" Name submission_status_id_sequence Description Sequence generator for the column 'identifier' of the table 'submission_status'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'submission_status'.

podoc:submission_status_sql_table

2007-10-19T15:55:59-04:00

Database Table Description of "submission_status" Name submission_status Description Purpose Schema create table submission_status ( identifier integer not null primary key, value varchar(10) ); References tables None.

podoc:support_id_sequence_sql_sequence

2007-04-23T10:50:21-04:00

Database Sequence Description of "support_id_sequence" Name support_id_sequence Description Sequence generator for the column 'identifier' of the table 'support'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'support'.

podoc:support_sql_table

2007-04-20T11:22:09-04:00

Database Table Description of "support" Name support Description Purpose Schema create table support ( identifier integer not null primary key, type integer not null references support_type(identifier), users integer not null references users(identifier), serial_number varchar(20), date_of_purchase timestamp, purchased_new char(1) check (purchased_new in ('t', 'f')), access_rights integer not null refe…

podoc:support_type_id_sequence_sql_sequence

2007-04-23T10:50:29-04:00

Database Sequence Description of "support_type_id_sequence" Name support_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'support_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'support_type'.

podoc:support_type_idx_sql_index

2007-04-23T11:00:16-04:00

Database Index Description of "support_type_idx" Name support_type_idx Description Index on column 'type' of table 'support'. Purpose Speedup of table row lookups based on column 'type' in table 'support'. Schema create index support_type_idx on support(type);

podoc:support_type_manufacturer_idx_sql_index

2007-04-23T11:00:27-04:00

Database Index Description of "support_type_manufacturer_idx" Name support_type_manufacturer_idx Description Index on column 'manufacturer' of table 'support_type'. Purpose Speedup of table row lookups based on column 'manufacturer' in table 'support_type'.

podoc:support_type_sql_table

2007-04-20T11:23:05-04:00

Database Table Description of "support_type" Name support_type Description Purpose Schema create table support_type ( identifier integer not null primary key, manufacturer integer not null references manufacturer(identifier), model varchar(100), variation varchar(100), last_modified_date timestamp, last_modifying_users integer references users(identifier) ); References tables * last_modifying_users references users(identifi…

podoc:support_users_idx_sql_index

2007-04-23T11:00:38-04:00

Database Index Description of "support_users_idx" Name support_users_idx Description Index on column 'users' of table 'support'. Purpose Speedup of table row lookups based on column 'users' in table 'support'. Schema create index support_users_idx on support(users);

podoc:system_preferences_sql_table

2007-10-19T10:32:58-04:00

Database Table Description of "system_preferences" Name system_preferences Description Purpose Schema create table system_preferences ( identifier integer not null primary key, new_user_type integer not null references user_type(identifier), new_user_bulk_upload_enable char(1) check (new_user_bulk_upload_enable in ('t', 'f')), new_user_paper integer references paper(identifier), new_user_label integer references labe…

podoc:tokenized_ilike_sql_function

2007-04-23T10:32:56-04:00

Database Function Description of "tokenized_ilike" Name tokenized_ilike Description This function searches for exact matches of 'keyword' in 'string'. The input 'string' is tokenized by a space, and each token is comapred to the 'keyword'. True is returned if the token fully matches the keyword. If the 'keyword' did not match any of the tokens of 'string' false is returned.

podoc:tokenized_like_sql_function

2007-04-23T10:33:22-04:00

Database Function Description of "tokenized_like" Name tokenized_like Description This function searches for exact matches of 'keyword' in 'string'. The input 'string' is tokenized by a space, and each token is comapred to the 'keyword'. True is returned if the token fully matches the keyword. If the 'keyword' did not match any of the tokens of 'string' false is returned.

podoc:tools

2007-08-03T16:01:13-04:00

Tools Several unrelated tools are lumped together: * Bulk Update * Shop Item Generator * XML Template Generator * XML Converter * Content Indexer XML CONVERTERS The XML tools were created in order to ease the labour of bulk upload. You don't want to pay an other secretary to click through the PO web interface set all fields and type in captions. You need some kind of automated way to assign the exisiting shooting data to each of your photo before upload, then let PO do the rest. That'…

podoc:user_documentation

2006-11-23T04:32:23-04:00

User Documentation The user documentation is intended for user and administrators of a Photo Organizer installation. It describes how Photo Organizer can be used and administered once it has been installed. NOTE: this documentation is currently still a bit spartan, but that is being worked on. If you feel you can help improving this you are welcome to contribute.

podoc:user_preferences_owner_idx_sql_index

2007-10-19T11:23:49-04:00

Database Index Description of "user_preferences_owner_idx" Name user_preferences_owner_idx Description Index on column 'owner' of table 'user_preferences'. Purpose Speedup of table row lookups based on column 'owner' in table 'user_preferences'.

podoc:user_preferences_sql_table

2007-10-19T11:19:13-04:00

Database Table Description of "user_preferences" Name user_preferences Description Purpose Schema create table user_preferences ( owner integer not null references users(identifier), key varchar(100) not null, value text );

podoc:user_type_id_sequence_sql_sequence

2007-04-23T10:50:35-04:00

Database Sequence Description of "user_type_id_sequence" Name user_type_id_sequence Description Sequence generator for the column 'identifier' of the table 'user_type'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'user_type'.

podoc:user_type_sql_table

2007-04-20T11:32:27-04:00

Database Table Description of "user_type" Name user_type Description Purpose Schema create table user_type ( identifier integer not null primary key, value varchar(15) ); References tables None. Is referenced by tables * system_preferences(new_user_type) references identifier * users(type) references identifier

podoc:users_id_sequence_sql_sequence

2007-04-23T10:50:41-04:00

Database Sequence Description of "users_id_sequence" Name users_id_sequence Description Sequence generator for the column 'identifier' of the table 'users'. Purpose To facilitate the generation of unique values for the primary key column 'identifier' of the table 'users'.

podoc:users_idx_sql_index

2007-10-19T16:14:59-04:00

Database Index Description of "users_idx" Name users_idx Description Index on column 'identifier' of table 'users'. Purpose Speedup of table row lookups based on column 'identifier' in table 'users'. Schema create index users_idx on users(identifier);

podoc:users_sql_table

2007-10-19T16:53:28-04:00

Database Table Description of "users" Name users Description Purpose Schema create table users ( identifier integer not null primary key, first_name varchar(50), last_name varchar(50), company varchar(50), username varchar(30), password varchar(30), contact integer references contact_info(identifier), member_since …

podoc:version_sql_table

2007-04-20T10:50:32-04:00

Database Table Description of "version" Name version Description Database table containing current version of the Photo Organizer database schema. Purpose This table contains vital information for updating the database schema of Photo Organizer. Based on this information the installer knows which patches to apply to the database in order to migrate to a newer database schema.

podoc:view_camera_sql_view

2007-10-19T16:07:26-04:00

Database View Description of "view_camera" Name view_camera Description Purpose Schema create view view_camera as select camera.identifier, manufacturer.name, model, variation, camera.serial_number, camera.users, date_of_purchase, camera.purchased_new, manufacturer.url, (access_type.value) as access_rights, raw_icc_profile, ignore_comment from camera_type, camera, manufacturer, access_type where camera_type.manufacturer = manufacturer.identifier and camer…

podoc:view_camera_type_sql_view

2007-04-20T11:39:36-04:00

Database View Description of "view_camera_type" Name view_camera_type Description Purpose Schema create view view_camera_type as select camera_type.identifier, manufacturer.name, model, variation, manufacturer.url, raw_icc_profile from camera_type, manufacturer where camera_type.manufacturer = manufacturer.identifier order by manufacturer.name, model, variation;

podoc:view_client_sql_view

2007-04-20T11:39:56-04:00

Database View Description of "view_client" Name view_client Description Purpose Schema create view view_client as select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status, users.type, client.trusted from client, users, client_status where client.client = users.identifier and client.status = client_status.identifier order by users.last_name, users.first_name;

podoc:view_contact_info_sql_view

2007-04-20T11:41:03-04:00

Database View Description of "view_contact_info" Name view_contact_info Description Purpose Schema create view view_contact_info as select identifier, address1, address2, city, zipcode, (select value from state where state.identifier=contact_info.state) as state, (select value from country where country.identifier=contact_info.country) as country, phone, email, url from contact_info;

podoc:view_contact_sql_view

2007-04-20T11:40:28-04:00

Database View Description of "view_contact" Name view_contact Description Purpose Schema create view view_contact as select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status from client, users, client_status where client.client = users.identifier and client.status = client_status.identifier order by users.last_name, users.first_name;

podoc:view_film_sql_view

2007-04-20T11:38:27-04:00

Database View Description of "view_film" Name view_film Description Purpose Schema create view view_film as select film.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, film.users, manufacturer.url, (access_type.value) as access_rights from film_type, film, manufacturer, film_iso, film_format, access_type where film_type.manufacturer = manufacturer.identifier and film_type.identifier = film.type and film_type.iso = film_iso.iden…

podoc:view_film_type_sql_view

2007-04-20T11:41:55-04:00

Database View Description of "view_film_type" Name view_film_type Description Purpose Schema create view view_film_type as select film_type.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, manufacturer.url from film_type, manufacturer, film_iso, film_format where film_type.manufacturer = manufacturer.identifier and film_type.iso = film_iso.identifier and film_type.format = film_format.identifier order by manufacturer.name, mo…

podoc:view_filter_sql_view

2007-04-20T11:42:13-04:00

Database View Description of "view_filter" Name view_filter Description Purpose Schema create view view_filter as select filter.identifier, manufacturer.name, model, variation, users, date_of_purchase, purchased_new, manufacturer.url, (access_type.value) as access_rights, serial_number from filter_type, filter, manufacturer, access_type where filter_type.manufacturer = manufacturer.identifier and filter_type.identifier = filter.type and filter.access_rights = acc…

podoc:view_filter_type_sql_view

2007-04-20T11:42:42-04:00

Database View Description of "view_filter_type" Name view_filter_type Description Purpose Schema create view view_filter_type as select filter_type.identifier, manufacturer.name, model, variation, manufacturer.url from filter_type, manufacturer where filter_type.manufacturer = manufacturer.identifier order by manufacturer.name, model, variation;

podoc:view_flash_sql_view

2007-04-20T11:44:22-04:00

Database View Description of "view_flash" Name view_flash Description Purpose Schema create view view_flash as select flash.identifier, manufacturer.name, model, variation, flash.serial_number, flash.users, date_of_purchase, flash.purchased_new, manufacturer.url, (access_type.value) as access_rights from flash_type, flash, manufacturer, access_type where flash_type.manufacturer = manufacturer.identifier and flash_type.identifier = flash.type and flash.access_rights = a…

podoc:view_flash_type_sql_view

2007-04-20T11:43:40-04:00

Database View Description of "view_flash_type" Name view_flash_type Description Purpose Schema create view view_flash_type as select flash_type.identifier, manufacturer.name, model, variation, manufacturer.url from flash_type, manufacturer where flash_type.manufacturer = manufacturer.identifier order by manufacturer.name, model, variation;

podoc:view_lens_sql_view

2007-10-19T16:13:05-04:00

Database View Description of "view_lens" Name view_lens Description Purpose Schema create view view_lens as select lens.identifier, manufacturer.name, model, variation, s_min_aperture, s_max_aperture, s_min_focal_length, s_max_focal_length, lens.serial_number, lens.users, date_of_purchase, lens.purchased_new, manufacturer.url, (access_type.value) as access_rights, exiftool_lens_id from lens_type, lens, manufacturer, access_type, (sel…

podoc:view_lens_type_sql_view

2007-10-19T16:13:31-04:00

Database View Description of "view_lens_type" Name view_lens_type Description Purpose Schema create view view_lens_type as select lens_type.identifier, manufacturer.name, model, variation, s_min_aperture, s_max_aperture, s_min_focal_length, s_max_focal_length, manufacturer.url, exiftool_lens_id from lens_type, manufacturer, (select identifier as identifier, value as s_min_focal_length from focal_length) as t_min_focal_length, (select …

podoc:view_location_sql_view

2007-04-20T12:16:35-04:00

Database View Description of "view_location" Name view_location Description Purpose Schema create view view_location as select location.identifier, location.place, location.city, (select value from state where state.identifier=location.state) as state, (select value from country where country.identifier=location.country) as country, users, last_modified_date, latitude, longitude, private from location;

podoc:view_photo_sql_view

2007-04-20T12:17:14-04:00

Database View Description of "view_photo" Name view_photo Description Purpose Schema create view view_photo as select photo.identifier, caption, users, date_of_exposure, photo_dupe.date_of_creation, storage_location, storage_index, photo_version.small_image_path, photo_version.medium_image_path, photo_version.large_image_path, folder, (access_type.value) as access_rights from photo, photo_dupe, photo_version, access_type where photo.identifier = photo_…

podoc:view_random_photo_sql_view

2007-04-23T10:19:46-04:00

Database View Description of "view_random_photo" Name view_random_photo Description Purpose Schema create view view_random_photo as select photo_version.small_image_path, photo_version.medium_image_path, photo_version.large_image_path from photo, photo_version where photo.identifier=photo_version.photo and photo.identifier=(select cast(random()*count_photos() as integer));

podoc:view_rating_sql_view

2007-10-19T15:50:57-04:00

Database View Description of "view_rating" Name view_rating Description Purpose Schema create view view_rating as select rating.identifier, photo, users, date_of_creation, value, first_name, last_name, comment, version from rating, users where rating.users=users.identifier;

podoc:view_scanner_sql_view

2007-04-23T10:20:50-04:00

Database View Description of "view_scanner" Name view_scanner Description Purpose Schema create view view_scanner as select scanner.identifier, manufacturer.name, model, variation, scanner.serial_number, scanner.users, date_of_purchase, scanner.purchased_new, manufacturer.url, (access_type.value) as access_rights from scanner_type, scanner, manufacturer, access_type where scanner_type.manufacturer = manufacturer.identifier and scanner_type.identifier = scanner.type and…

podoc:view_scanner_type_sql_view

2007-04-23T10:21:31-04:00

Database View Description of "view_scanner_type" Name view_scanner_type Description Purpose Schema create view view_scanner_type as select scanner_type.identifier, manufacturer.name, model, variation, manufacturer.url from scanner_type, manufacturer where scanner_type.manufacturer = manufacturer.identifier order by manufacturer.name, model, variation;

podoc:view_shop_item_generator_rule_sql_view

2007-10-19T11:53:33-04:00

Database View Description of "view_shop_item_generator_rule" Name view_shop_item_generator_rule Description Purpose Schema create view view_shop_item_generator_rule as select shop_item_generator_rule.identifier, shop_category.caption as shop_category, shop_item.description as shop_item, currency.alpha_code as currency, shop_item_generator_rule.price, shop_item_generator_rule.comment, shop_item_generator_rule.date_of_creation, …

podoc:view_submission_sql_view

2007-10-19T15:56:26-04:00

Database View Description of "view_submission" Name view_submission Description Purpose Schema create view view_submission as select submission.identifier, photo_dupe, photo_dupe.photo, photo_dupe.key, (select users.identifier from users where users.identifier = submission.users) as uidentifier, (select users.first_name from users where users.identifier = submission.users) as first_name, (select users.last_name from users where users.identifier = submission.u…

podoc:view_support_sql_view

2007-04-23T10:22:41-04:00

Database View Description of "view_support" Name view_support Description Purpose Schema create view view_support as select support.identifier, manufacturer.name, model, variation, support.serial_number, support.users, date_of_purchase, support.purchased_new, manufacturer.url, (access_type.value) as access_rights from support_type, support, manufacturer, access_type where support_type.manufacturer = manufacturer.identifier and support_type.identifier = support.type and…

podoc:view_support_type_sql_view

2007-04-23T10:23:19-04:00

Database View Description of "view_support_type" Name view_support_type Description Purpose Schema create view view_support_type as select support_type.identifier, manufacturer.name, model, variation, manufacturer.url from support_type, manufacturer where support_type.manufacturer = manufacturer.identifier order by manufacturer.name, model, variation;

podoc:view_users_subscribed_to_sql_view

2007-04-23T10:23:39-04:00

Database View Description of "view_users_subscribed_to" Name view_users_subscribed_to Description Tentative description: I'm not completely sure how this all goes. So here is an attempt to describe what the view is doing. I may be completely wrong as I'm not sure what the users and the client fields in the client table actually mean. Does the client.client field refer to the user of which that row is a client or does it mean that that user is the client of the client.users user?

podoc:webservice

2007-04-13T17:13:21-04:00

Photo Organizer Webservice By Luud Heck, April 2007 NOTE: at this moment this page is little more than a dump of some things I've tested and proven to work. I have made further advances already and will update this page as soon as possible. Introduction I've long wanted to include photos in my web pages without having to copy them over from PO. It is much nicer when you can include the images straight from PO. In a way this has long been possible by abusing the image.display.php file in …