Parašė Dandžu· 2007 Lap. 30 19:11:23
#9
Manau reiktų šias užklausas paredaguoti. Ir viskas bus čikipiki
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."forum_attachments");
$result = dbquery("CREATE TABLE ".$db_prefix."forum_attachments (
attach_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
thread_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
post_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
attach_name VARCHAR(100) NOT NULL DEFAULT '',
attach_ext VARCHAR(5) NOT NULL DEFAULT '',
attach_size INT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (attach_id)
) TYPE=MyISAM;");
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."forums");
$result = dbquery("CREATE TABLE ".$db_prefix."forums (
forum_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
forum_cat SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
forum_name VARCHAR(100) NOT NULL DEFAULT '',
forum_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
forum_description TEXT NOT NULL,
forum_moderators TEXT NOT NULL,
forum_access TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
forum_posting TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
forum_lastpost INT(10) UNSIGNED NOT NULL DEFAULT '0',
forum_lastuser SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (forum_id)
) TYPE=MyISAM;");