txpun:gallery:database
Table of Contents
Database Reference
The following is a complete list of all singapore database tables and their respective fields. CSV files or MySQL database tables can be used on install.
CSV database format
If you choose to use metadata files then each gallery must contain a CSV (comma separated values) file called metadata.csv containing the information about images in the gallery and the gallery itself. CSV files can be edited manually (in a text editor such as Notepad) or using a spreadsheet application (such as MS Excel). Care must be taken when using Excel to save using commas as the separator character and not tabs or semi-colons.
Galleries
The first line of each file stores human-readable descriptions of the fields and is ignored by singapore. The second line stores information about this gallery:
| Field | Description |
|---|---|
| field 0 | the filename of the image used to represent the gallery in the gallery list |
| field 1 | (not used) |
| field 2 | the owner of the gallery |
| field 3 | space-separated list of usergroups |
| field 4 | gallery permission flags |
| field 5 | space-separated list of categories the gallery belongs in (not used) |
| field 6 | gallery name/title |
| field 7 | artist name (optional) |
| field 8 | artist email (optional) |
| field 9 | copyright holder (optional) |
| field 10 | description of the gallery (optional) |
| field 11 | short summary of the gallery (optional) |
| field 12 | human-readable date (optional) |
| field 13 | onwards (not used) |
Images
Each of the following lines (3 - …) represents an image in the gallery. The format is as follows:
| Field | Description |
|---|---|
| field 0 | the filename of the image |
| field 1 | the filename of the thumbnail image |
| field 2 | the owner of the image |
| field 3 | space-separated list of usergroups |
| field 4 | image permission flags |
| field 5 | space-separated list of categories the image belongs in (not used) |
| field 6 | image name/title |
| field 7 | artist name (optional) |
| field 8 | artist email (optional) |
| field 9 | copyright holder (optional) |
| field 10 | description of the image (optional) |
| field 11 | location that the image was taken/made/represents (optional) |
| field 12 | date taken/made (optional) |
| field 13 | make and model of camera used (optional) |
| field 14 | make and model of lens used (optional) |
| field 15 | make and type of film used (optional) |
| field 16 | darkroom manipulation (optional) |
| field 17 | digital manipulation (optional) |
MySQL database format
sg_galleries
| Field | Type | Default | Description |
|---|---|---|---|
| id | varchar(250) | ||
| lang | varchar(16) | ||
| filename | varchar(200) | NULL | the filename of the image used to represent the gallery in the gallery list |
| owner | varchar(32) | NULL | the owner of the gallery |
| groups | varchar(64) | NULL | space-separated list of usergroups |
| permissions | int(10) | NULL | gallery permission flags |
| categories | varchar(255) | NULL | space-separated list of categories the gallery belongs in (not used) |
| name | varchar(255) | NULL | gallery name/title |
| artist | varchar(255) | NULL | artist name (optional) |
| varchar(255) | NULL | artist email (optional) | |
| copyright | varchar(255) | NULL | copyright holder (optional) |
| description | text | NULL | description of the gallery (optional) |
| summary | text | NULL | short summary of the gallery (optional) |
| date | varchar(255) | NULL | human-readable date (optional) |
| hits | smallint(5) | NULL | |
| lasthit | int(10) | NULL |
sg_images
| Field | Type | Default | Description |
|---|---|---|---|
| galleryid | varchar(250) | ||
| filename | varchar(200) | the filename of the image | |
| lang | varchar(16) | ||
| thumbnail | varchar(255) | NULL | the filename of the thumbnail image |
| owner | varchar(32) | NULL | the owner of the image |
| groups | varchar(64) | NULL | space-separated list of usergroups |
| permissions | int(11) | NULL | image permission flags |
| categories | varchar(64) | NULL | space-separated list of categories the image belongs in (not used) |
| name | varchar(255) | NULL | image name/title |
| artist | varchar(255) | NULL | artist name (optional) |
| varchar(255) | NULL | artist email (optional) | |
| copyright | varchar(255) | NULL | copyright holder (optional) |
| description | text | NULL | description of the image (optional) |
| width | smallint(5) | NULL | |
| height | smallint(5) | NULL | |
| type | tinyint(3) | NULL | |
| location | varchar(255) | NULL | location that the image was taken/made/represents (optional) |
| date | varchar(255) | NULL | date taken/made (optional) |
| camera | varchar(255) | NULL | make and model of camera used (optional) |
| lens | varchar(255) | NULL | make and model of lens used (optional) |
| film | varchar(255) | NULL | make and type of film used (optional) |
| darkroom | text | NULL | darkroom manipulation (optional) |
| digital | text | NULL | digital manipulation (optional) |
| hits | smallint(5) | NULL | |
| lasthit | int(10) | NULL |
sg_users
| Field | Type | Default | Description |
|---|---|---|---|
| username | varchar(32) | ||
| userpass | varchar(32) | ||
| permissions | int(10) | NULL | |
| groups | varchar(64) | NULL | |
| varchar(255) | NULL | ||
| fullname | varchar(255) | NULL | |
| description | varchar(255) | NULL | |
| stats | varchar(255) | NULL |
txpun/gallery/database.txt · Last modified: 2008/12/06 13:55 (external edit)