#
# Table structure for table 'Images'
#

CREATE TABLE Images (
  image int(11) NOT NULL auto_increment,
  path text DEFAULT '' NOT NULL,
  view_count int(11) DEFAULT '0' NOT NULL,
  view_time int(11) DEFAULT '0' NOT NULL,
  category int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (image),
  KEY time_index (view_time),
  KEY cat_index (category),
  KEY supa_sort (view_time,image),
  KEY avg_index (view_time,view_count,image)
);

