Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: News klaida

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. :)