Parašė bad_user· 2008 Bal. 8 15:04:17
#19
<?php
$db_prefixas = 'prefixas_';
$result = dbquery("CREATE TABLE ".$db_prefixas."news (
news_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
news_subject VARCHAR(200) NOT NULL DEFAULT '',
news_cat SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
news_news TEXT NOT NULL,
news_extended TEXT NOT NULL,
news_breaks CHAR(1) NOT NULL DEFAULT '',
news_name SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
news_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
news_start INT(10) UNSIGNED NOT NULL DEFAULT '0',
news_end INT(10) UNSIGNED NOT NULL DEFAULT '0',
news_visibility TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
news_reads SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
news_sticky TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
news_allow_comments TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
news_allow_ratings TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (news_id)
) TYPE=MyISAM;");
?>
Bandyk per pridėtinius. prefixas_ pirmoje eilutėje keiti į savo visos db prefixa. :)