[مقال] : حل مشاكل الجداول الناقصة فى ل vb cms

[لجنة التطوير]

السلام عليكم و رحمة الله و بركاته
منتشر فى المنتدي الكثير من المشاكل تدور حول فكرة وجود جداول ناقصة فى المنتدى
تلك الخداول خاصة ب المجلة او ال cms
اليوم قابلتني نفس المشكلة و احتجت الى تجميع تلك الجداول من ملف تنصيب المنتدي
تم تجميع الجداول من ملف ل vb 4.2.0

اتمنى ان تكون مفيدة لمن يبحث عنها

حاولت ترتيبها قدر المستطاع


رمز PHP:

CREATE TABLE IF NOT EXISTS cms_rate (
rateid INT UNSIGNED NOT NULL AUTO_INCREMENT,
nodeid INT UNSIGNED NOT NULL,
userid INT UNSIGNED NOT NULL,
vote INT UNSIGNED NOT NULL,
ipaddress VARCHAR(15) NOT NULL,
PRIMARY KEY (rateid),
KEY nodeid (nodeid, userid)
);




CREATE TABLE IF NOT EXISTS cms_article (
*******id INT UNSIGNED NOT NULL AUTO_INCREMENT,
pagetext MEDIUMTEXT NOT NULL,
threadid INT UNSIGNED,
blogid INT UNSIGNED,
posttitle VARCHAR(255),
postauthor VARCHAR(100),
poststarter INT UNSIGNED,
blogpostid INT UNSIGNED,
postid INT UNSIGNED,
post_posted INT UNSIGNED,
post_started INT UNSIGNED,
previewtext VARCHAR(2048),
previewimage VARCHAR(256),
imagewidth INT UNSIGNED,
imageheight INT UNSIGNED,
PRIMARY KEY (*******id)
);

CREATE TABLE IF NOT EXISTS cms_grid (
gridid INT UNSIGNED NOT NULL AUTO_INCREMENT,
gridhtml MEDIUMTEXT,
title VARCHAR(255) NOT NULL,
gridhtml_backup MEDIUMTEXT NOT NULL,
auxheader SMALLINT UNSIGNED NOT NULL DEFAULT '0',
auxfooter SMALLINT UNSIGNED NOT NULL DEFAULT '0',
addcolumn SMALLINT UNSIGNED NOT NULL DEFAULT '0',
addcolumnsnap SMALLINT UNSIGNED NOT NULL DEFAULT '0',
addcolumnsize SMALLINT UNSIGNED NOT NULL DEFAULT '0',
`columns` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
flattened SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (gridid),
UNIQUE KEY title (title)
);

CREATE TABLE IF NOT EXISTS cms_layout (
layoutid INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(255) NOT NULL,
gridid INT UNSIGNED NOT NULL,
template VARCHAR(100),
status ENUM('draft', 'active', 'retired') NOT NULL DEFAULT 'active',
*******column INT UNSIGNED NOT NULL DEFAULT '0',
*******index INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (layoutid)
);

CREATE TABLE IF NOT EXISTS cms_layoutwidget (
layoutid INT UNSIGNED NOT NULL,
widgetid INT UNSIGNED NOT NULL,
layoutcolumn INT UNSIGNED NOT NULL DEFAULT 0,
layoutindex INT UNSIGNED NOT NULL DEFAULT 0,
KEY layoutid (layoutid)
);

CREATE TABLE IF NOT EXISTS cms_node (
nodeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
nodeleft INT UNSIGNED NOT NULL,
noderight INT UNSIGNED NOT NULL,
parentnode INT UNSIGNED DEFAULT NULL,
*******typeid INT UNSIGNED NOT NULL,
*******id INT UNSIGNED DEFAULT '0',
url VARCHAR(255) NOT NULL,
styleid INT UNSIGNED DEFAULT NULL,
layoutid INT UNSIGNED DEFAULT NULL,
userid INT UNSIGNED NOT NULL DEFAULT 0,
publishdate INT UNSIGNED DEFAULT NULL,
setpublish TINYINT UNSIGNED DEFAULT 0,
issection TINYINT DEFAULT 0,
onhomepage TINYINT DEFAULT 0,
permissionsfrom INT UNSIGNED DEFAULT 0,
lastupdated INT UNSIGNED DEFAULT NULL,
publicpreview TINYINT DEFAULT 0,
auto_displayorder TINYINT DEFAULT 0,
comments_enabled TINYINT DEFAULT 0,
PRIMARY KEY (nodeid),
KEY *******id (*******typeid, *******id),
KEY nodeleft (nodeleft),
KEY noderight (noderight),
KEY parentnode (parentnode),
KEY *******type (*******typeid)
);

CREATE TABLE IF NOT EXISTS cms_category(
categoryid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
parentnode INTEGER,
category VARCHAR(40),
description VARCHAR(255),
catleft INTEGER NOT NULL,
catright INTEGER NOT NULL,
parentcat INTEGER,
enabled TINYINT UNSIGNED DEFAULT 0,
*******count INTEGER,
KEY parentnode(parentnode)
);

CREATE TABLE IF NOT EXISTS cms_navigation (
nodeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
nodelist VARCHAR(255),
PRIMARY KEY (nodeid)
);

CREATE TABLE IF NOT EXISTS cms_nodecategory (
categoryid INT UNSIGNED NOT NULL,
nodeid INT UNSIGNED NOT NULL,
PRIMARY KEY (nodeid, categoryid),
KEY categoryid(categoryid)
);

CREATE TABLE IF NOT EXISTS cms_sectionorder(
sectionid INTEGER NOT NULL,
nodeid INTEGER NOT NULL,
displayorder SMALLINT NOT NULL,
UNIQUE KEY (sectionid, nodeid)
);

CREATE TABLE IF NOT EXISTS cms_nodeinfo (
nodeid INT UNSIGNED NOT NULL,
description MEDIUMTEXT,
title VARCHAR(255) NOT NULL,
html_title VARCHAR(255) NOT NULL,
viewcount INT UNSIGNED DEFAULT '0',
creationdate INT UNSIGNED NOT NULL,
workflowdate INT UNSIGNED DEFAULT NULL,
workflowstatus ENUM('draft','parentpending','published','deleted') DEFAULT NULL,
workflowcheckedout TINYINT,
workflowpending TINYINT,
workflowlevelid INT UNSIGNED DEFAULT '0',
associatedthreadid INT UNSIGNED NOT NULL DEFAULT '0',
keywords TEXT,
PRIMARY KEY (nodeid)
);




CREATE TABLE IF NOT EXISTS cms_nodeconfig (
nodeid INT UNSIGNED NOT NULL,
name VARCHAR(255) NOT NULL,
value MEDIUMTEXT,
serialized TINYINT UNSIGNED DEFAULT '0',
KEY nodeid (nodeid),
UNIQUE KEY unique_1(nodeid, name)
);

CREATE TABLE IF NOT EXISTS cms_widget (
widgetid INT UNSIGNED NOT NULL AUTO_INCREMENT,
varname VARBINARY(50) NOT NULL,
widgettypeid INT NOT NULL,
title VARCHAR(255) NOT NULL,
description MEDIUMTEXT DEFAULT '',
product VARCHAR(25) NOT NULL DEFAULT '',
PRIMARY KEY (widgetid),
UNIQUE KEY title(title),
KEY widgettypeid (widgettypeid)
);

CREATE TABLE IF NOT EXISTS cms_widgetconfig (
widgetid INT UNSIGNED NOT NULL AUTO_INCREMENT,
nodeid INT UNSIGNED NOT NULL DEFAULT '0',
name VARCHAR(255) NOT NULL DEFAULT '',
value MEDIUMBLOB,
serialized TINYINT,
PRIMARY KEY (widgetid, nodeid, name)
);

CREATE TABLE IF NOT EXISTS cms_widgettype (
widgettypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
class VARBINARY(50) NOT NULL,
packageid INT UNSIGNED NOT NULL,
PRIMARY KEY (widgettypeid)
);

CREATE TABLE IF NOT EXISTS cms_permissions (
permissionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
usergroupid INT UNSIGNED NOT NULL,
nodeid INT UNSIGNED NOT NULL,
permissions INT UNSIGNED NOT NULL,
PRIMARY KEY (permissionid),
KEY nodeid (nodeid)
);
​