what are the changes that are made to the vbdatabase?

[HumanNature]

Just this, when you install cmps what are the modificsations that the install script made to the original db?

[Brian]

$DB_site->query("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "adv_setting (
varname varchar(100) NOT NULL default '',
grouptitle varchar(50) NOT NULL default '',
value mediumtext NOT NULL default '',
defaultvalue varchar(250) NOT NULL default '',
optioncode mediumtext NOT NULL,
displayorder smallint(3) unsigned NOT NULL default '0'
) TYPE=MyISAM");



$DB_site->query("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "adv_settinggroup (
grouptitle varchar(50) NOT NULL default '',
displayorder smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (grouptitle)
) TYPE=MyISAM
");

$DB_site->query("
CREATE TABLE " . TABLE_PREFIX . "adv_modules (
modid smallint(5) unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
identifier varchar(100) NOT NULL default '',
filename varchar(100) NOT NULL default '',
inctype int(3) unsigned NOT NULL default '0',
modcol smallint(3) unsigned NOT NULL default '0',
displayorder smallint(5) unsigned NOT NULL default '0',
templatelist varchar(255) NOT NULL default '',
userperms varchar(255) NOT NULL default '',
active smallint(3) unsigned NOT NULL default '1',
PRIMARY KEY (modid)
) TYPE=MyISAM
");

$DB_site->query("
CREATE TABLE " . TABLE_PREFIX . "adv_pages (
pageid int(10) unsigned NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
name varchar(100) NOT NULL default '',
template varchar(100) NOT NULL default '',
modules mediumtext NOT NULL,
advanced mediumtext NOT NULL,
userperms varchar(255) NOT NULL default '',
styleid smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (pageid)
) TYPE=MyISAM
");

$DB_site->query("ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_adv_portal MEDIUMTEXT NOT NULL");
$DB_site->query("ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_adv_portal_cp MEDIUMTEXT NOT NULL");

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrasetype VALUES (569, 'adv_portal', 'vBadvanced CMPS', 3)");
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrasetype VALUES (570, 'adv_portal_cp', 'vBadvanced CMPS CP', 3)");

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('adv_portal_opts', '')");
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('adv_modules', '')");


Plus the templates and phrases that are inserted.

[Our Sponsors]

[HumanNature]

So cmps does only create new tables?

The Phrases and templates are not important to me because I think that nothing is going to work wrong in my vb because I have more templates or more phases but as long as I don´t kown much of data bases is important to me to known that cmps will not modify nothing important.

So if I just drop the tables that you have posted above (without using the uninstall script) my vb installation will be working just like if I had never installed cmps? (but with more phrases and templates)