1create table {PREFIX}mediaproperties (
2  mediaid int(11) not null,
3  property varchar(128) not null,
4  property_group varchar(50) not null default '',
5  property_subgroup varchar(50) not null default '',
6  value text
7) {UTF_8};
8
9CREATE INDEX mediapropid_idx ON {PREFIX}mediaproperties (mediaid);
10CREATE UNIQUE INDEX media_idx ON {PREFIX}mediaproperties (mediaid, property, property_group, property_subgroup);
11