--- /home/cvs/contributions/modules/views_bookmark/views_bookmark.install 2006-05-14 22:51:46.000000000 -0400 +++ views_bookmark.install 2006-05-15 14:55:04.000000000 -0400 @@ -5,7 +5,7 @@ switch ($GLOBALS['db_type']) { case 'mysql': case 'mysqli': - db_query("CREATE TABLE views_bookmarks ( + db_query("CREATE TABLE {views_bookmarks} ( vbid int(10) unsigned NOT NULL default '0', title varchar(255) default '', mark varchar(255) default '', @@ -18,34 +18,34 @@ key (vbid) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); - db_query("CREATE TABLE views_bookmark_nodes ( + db_query("CREATE TABLE {views_bookmark_nodes} ( vbid int(10) unsigned NOT NULL default '0', uid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', key (nid, vbid, uid) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); - db_query("CREATE TABLE views_bookmark_nodetypes ( + db_query("CREATE TABLE {views_bookmark_nodetypes} ( vbid int(10) unsigned NOT NULL default '0', type varchar(32) NOT NULL default '' ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); // Insert a starting record. - $sql = "INSERT INTO views_bookmarks VALUES (1, 'bookmarks', 'bookmark this', 'Add this post to your bookmarks', 'unbookmark this', 'Remove this post from your bookmarks', '2', 0, 0)"; + $sql = "INSERT INTO {views_bookmarks} VALUES (1, 'bookmarks', 'bookmark this', 'Add this post to your bookmarks', 'unbookmark this', 'Remove this post from your bookmarks', '2', 0, 0)"; db_query($sql); - $sql = "INSERT INTO views_bookmark_nodetypes VALUES (1, 'story')"; + $sql = "INSERT INTO {views_bookmark_nodetypes} VALUES (1, 'story')"; db_query($sql); - $sql = "INSERT INTO views_bookmark_nodetypes VALUES (1, 'forum')"; + $sql = "INSERT INTO {views_bookmark_nodetypes} VALUES (1, 'forum')"; db_query($sql); - $sql = "INSERT INTO views_bookmark_nodetypes VALUES (1, 'blog')"; + $sql = "INSERT INTO {views_bookmark_nodetypes} VALUES (1, 'blog')"; db_query($sql); // Set up our counter so it starts in the right place - $sql = "REPLACE INTO sequences VALUES ('views_bookmarks_vbid', 1)"; - db_query($sql); + $sql = "REPLACE INTO {sequences} VALUES ('{%s}', 1)"; + db_query($sql,'views_bookmarks_vbid'); $success = TRUE; break;