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