<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."photos");
$result = dbquery("CREATE TABLE ".$db_prefix."photos (
photo_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
album_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_title VARCHAR(100) NOT NULL DEFAULT '',
photo_description TEXT NOT NULL,
photo_filename VARCHAR(100) NOT NULL DEFAULT '',
photo_thumb1 VARCHAR(100) NOT NULL DEFAULT '',
photo_thumb2 VARCHAR(100) NOT NULL DEFAULT '',
photo_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
photo_user SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_views SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_allow_comments tinyint(1) unsigned NOT NULL default '1',
photo_allow_ratings tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (photo_id)
) TYPE=MyISAM;");
?>