Parašė MAnjack· 2008 Kov. 3 19:03:15
#2
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."downloads");
$result = dbquery("CREATE TABLE ".$db_prefix."downloads (
download_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
download_title VARCHAR(100) NOT NULL DEFAULT '',
download_description TEXT NOT NULL,
download_url VARCHAR(200) NOT NULL DEFAULT '',
download_cat SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
download_license VARCHAR(50) NOT NULL DEFAULT '',
download_os VARCHAR(50) NOT NULL DEFAULT '',
download_version VARCHAR(20) NOT NULL DEFAULT '',
download_filesize VARCHAR(20) NOT NULL DEFAULT '',
download_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
download_count SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (download_id)
) TYPE=MyISAM;");