[wolfstream]

Originally Posted by webrats

can you send me the mysql commands that the xml does when it installs

i have a very large database and need to do it the install threw mysql

You shouldn't have a problem installing the SQL with this, the user tables aren't altered.

3 tables are created, vbnexus_nonvbuser, vbnexus_facebookuser and vbnexus_templates. The code for creating them is below. Note that this assumes that you're not using a prefix for your tables (ie: vb_ , etc). If you are, add the prefix to the 3 insert statements , so

CREATE TABLE IF NOT EXISTS `vbnexus_facebookfeedtemplates` (

would actually be

CREATE TABLE IF NOT EXISTS `vb_vbnexus_facebookfeedtemplates` (

in my above example:

The queries:

CREATE TABLE IF NOT EXISTS `vbnexus_facebookfeedtemplates` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(20) default NULL,
  `content` mediumtext,
  PRIMARY KEY  (`id`)
) ;


CREATE TABLE IF NOT EXISTS `vbnexus_nonvbuser` (
  `nonvbid` bigint(20) unsigned NOT NULL,
  `userid` int(11) NOT NULL,
  `associated` tinyint(1) default '0',
  `type` enum('1','2') NOT NULL default '1',
  `emailonfile` tinyint(1) default '0',
  PRIMARY KEY  (`nonvbid`,`type`),
  KEY `userid_type` (`userid`,`type`)
) ;

CREATE TABLE IF NOT EXISTS `vbnexus_facebookuser` (
  `uid` bigint(20) unsigned NOT NULL,
  `newthreadfeed` tinyint(1) unsigned default '1',
  `newreplyfeed` tinyint(1) unsigned default '1',
  `newalbumfeed` tinyint(1) unsigned default '1',
  `newpmnotify` tinyint(1) unsigned default '1',
  `mythreadnotify` tinyint(1) unsigned default '1',
  `subscribedthreadnotify` tinyint(1) unsigned default '1',
  PRIMARY KEY  (`uid`)
) ;