Toolserver:Database schema/Images and media

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

Images and media

Image

Image table
Field	Type	Null	Key	Default	Extra
img_name	varchar(255)	No
img_size	int(8) unsigned	No		0
img_width	int(5)	No		0
img_height	int(5)	No		0
img_metadata	mediumblob	No		Null
img_bits	int(3)	No		0
img_media_type	enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE')	Yes		Null
img_major_mime	enum('unknown','application','audio','image','text','video','message','model','multipart')	No		Unknown
img_minor_mime	varchar(32)	No		Unknown
img_description	tinyblob	No		Null
img_user	int(5) unsigned	No		0
img_user_text	varchar(255)	No
img_timestamp	varchar(14)	No
img_sha1	varchar(32)	No

Filearchive

Filearchivee table
Field	Type	Null	Key	Default	Extra
fa_id	int(11)	No		0
fa_name	varchar(255)	No
fa_archive_name	varchar(255)	Yes
fa_storage_group	varchar(16)	Yes		Null
fa_storage_key	varchar(64)	Yes
fa_deleted_user	int(11)	Yes		Null
fa_deleted_timestamp	varchar(14)	Yes
fa_deleted_reason	text	Yes		Null
fa_size	int(8) unsigned	Yes		0
fa_width	int(5)	Yes		0
fa_height	int(5)	Yes		0
fa_metadata	mediumblob	Yes		Null
fa_bits	int(3)	Yes		0
fa_media_type	enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE')	Yes		Null
fa_major_mime	enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE')	Yes		unknown
fa_minor_mime	varchar(32)	Yes		unknown
fa_user	int(5) unsigned	Yes		0
fa_user_text	varchar(255)	Yes
fa_timestamp	varchar(14)	Yes
fa_deleted	tinyint(1) unsigned	No		0

Oldimage

Oldimage table
Field	Type	Null	Key	Default	Extra
oi_name	varchar(255)	No
oi_archive_name	varchar(255)	No
oi_size	int(8) unsigned	No		0
oi_width	int(5)	No		0
oi_height	int(5)	No		0
oi_bits	int(3)	No		0
oi_description	tinyblob	No		Null
oi_user	int(5) unsigned	No		0
oi_user_text	varchar(255)	No
oi_timestamp	varchar(14)	No
oi_metadata	mediumblob	No		Null
oi_media_type	enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE')	Yes		Null
oi_major_mime	enum('unknown','application','audio','image','text','video','message','model','multipart')	No		Unknown
oi_minor_mime	varchar(32)	No		Unknown
oi_deleted	tinyint(3) unsigned	No
oi_sha1	varchar(32)	No

Imagelinks

Imagelinks table
Field	Type	Null	Key	Default	Extra
il_from	var(8) unsigned	No		0
il_to	varchar(255)	No

Category:Database schema