Quote
OK, no articles at all?
<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."articles");
$result = dbquery("CREATE TABLE ".$db_prefix."articles (
article_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
article_cat SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
article_subject VARCHAR(200) NOT NULL DEFAULT '',
article_snippet TEXT NOT NULL,
article_article TEXT NOT NULL,
article_breaks CHAR(1) NOT NULL DEFAULT '',
article_name SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
article_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
article_reads SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
article_allow_comments TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
article_allow_ratings TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (article_id)
) TYPE=MyISAM;");
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."article_cats");
$result = dbquery("CREATE TABLE ".$db_prefix."article_cats (
article_cat_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
article_cat_name VARCHAR(100) NOT NULL DEFAULT '',
article_cat_description VARCHAR(200) NOT NULL DEFAULT '',
article_cat_sorting VARCHAR(50) NOT NULL DEFAULT 'article_subject ASC',
article_cat_access TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (article_cat_id)
) TYPE=MyISAM;");
?>
Quote
article_id SMALLINT(5) => article_id MEDIUMINT(8)
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
0 participants
Notifications
You are not receiving notifications from this thread.
Related Questions