Documentation

From Photolibrary

Jump to: navigation, search

Contents

Database schema

accountaccess

Indices
Name Type
PRIMARY user_id,category
Fields
Name Type NULL Default Extras
user_id int(8) unsigned   0  
category int(8) unsigned   0  

accounts

Indices
Name Type
PRIMARY user_id
username username
Fields
Name Type NULL Default Extras
user_id int(8) unsigned     auto_increment
username varchar(32)      
password varchar(32)      
admin tinyint(1) unsigned   0  

categories

Indices
Name Type
PRIMARY category
cat name,parent
parent parent
fulltext name
Fields
Name Type NULL Default Extras
category int(8) unsigned     auto_increment
name varchar(64)      
parent int(8) unsigned   0  
children_count int(8) unsigned   0  
public_photos int(8) unsigned   0  
top_parent int(8) unsigned   0  
lat_min float(9,6) NULL    
lat_max float(9,6) NULL    
lng_min float(9,6) NULL    
lng_max float(9,6) NULL    
located tinyint(1) unsigned   0  

errorlog

Indices
Name Type
PRIMARY line,file
Fields
Name Type NULL Default Extras
line smallint(5)   0  
file varchar(64)      
timestamp datetime   0000-00-00 00:00:00  
error text      
get text      
post text      
user_id int(8) unsigned   0  

import

Indices
Name Type
PRIMARY start
Fields
Name Type NULL Default Extras
start datetime   0000-00-00 00:00:00  
files_total smallint(5) unsigned   0  
files_done smallint(5) unsigned   0  

language

Indices
Name Type
PRIMARY var,lang
Fields
Name Type NULL Default Extras
var varchar(32)      
lang varchar(8)      
val text      
context text      

makemodel

Indices
Name Type
PRIMARY text_from
Fields
Name Type NULL Default Extras
text_from varchar(64)      
text_to varchar(64)      

photocomments

Indices
Name Type
PRIMARY id
hash hash
Fields
Name Type NULL Default Extras
id int(8)     auto_increment
hash varchar(32)      
name varchar(32)      
email varchar(64)      
ip varchar(15)      
comment text      
approved tinyint(1)   1  
timestamp datetime   0000-00-00 00:00:00  

photos

Indices
Name Type
PRIMARY hash
session session
Fields
Name Type NULL Default Extras
hash varchar(32)      
type tinyint(3)   2  
added datetime NULL    
taken datetime NULL    
timeoffset bigint(14)   0  
timezone float(3,1)   0.0  
filesize int(10) unsigned   0  
orientation tinyint(1)   0  
height int(8) unsigned   0  
width int(8) unsigned   0  
make varchar(64) NULL    
model varchar(64) NULL    
exposure varchar(16) NULL    
aperturefnumber varchar(8) NULL    
isospeedratings smallint(5) NULL    
shutterspeed varchar(16) NULL    
aperture varchar(32) NULL    
brightness varchar(16) NULL    
exposurebias varchar(16) NULL    
flash tinyint(3) unsigned NULL    
focallength varchar(16) NULL    
continuous tinyint(1) unsigned   0  
warning_blur tinyint(1) unsigned   0  
warning_focus tinyint(1) unsigned   0  
warning_ae tinyint(1) unsigned   0  
edited_hash varchar(32)      
session int(8) unsigned   0  
hits int(8) unsigned   0  
comments int(8) unsigned   0  

photostocategories

Indices
Name Type
hash hash,category
category category
Fields
Name Type NULL Default Extras
hash varchar(32)      
category int(8) unsigned   0  

sessions

Indices
Name Type
PRIMARY session
Fields
Name Type NULL Default Extras
session int(8) unsigned   0  
name varchar(64)      

settings

Indices
Name Type
PRIMARY variable
Fields
Name Type NULL Default Extras
variable varchar(32)      
value text      
Retrieved from "http://photolibrary.sourceforge.net/wiki/Documentation"