[Bbps-commits] bbps/sql upgrade_schema.sql,1.2,1.3

[Maxim <wz...@us...>]

Update of /cvsroot/bbps/bbps/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13090

Modified Files:
	upgrade_schema.sql 
Log Message:
Oops. There was a database name in there. Shouldn't have been. Sorry.

Index: upgrade_schema.sql
===================================================================
RCS file: /cvsroot/bbps/bbps/sql/upgrade_schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** upgrade_schema.sql	9 Sep 2005 14:44:45 -0000	1.2
--- upgrade_schema.sql	9 Sep 2005 15:12:23 -0000	1.3
***************
*** 11,17 ****
  create temporary table temp select distinct * from bbps_rel_keywords_bookmarks;
  
! DROP TABLE IF EXISTS `db_bbps`.`bbps_rel_keywords_bookmarks` ;
  
! CREATE TABLE `db_bbps`.`bbps_rel_keywords_bookmarks` (
  `bbps_rel_keyword_id` int( 10 ) unsigned NOT NULL default '0',
  `bbps_rel_bookmark_id` int( 10 ) unsigned NOT NULL default '0',
--- 11,17 ----
  create temporary table temp select distinct * from bbps_rel_keywords_bookmarks;
  
! DROP TABLE IF EXISTS `bbps_rel_keywords_bookmarks` ;
  
! CREATE TABLE `bbps_rel_keywords_bookmarks` (
  `bbps_rel_keyword_id` int( 10 ) unsigned NOT NULL default '0',
  `bbps_rel_bookmark_id` int( 10 ) unsigned NOT NULL default '0',
***************
*** 25,31 ****
  create temporary table temp2 select * from bbps_keywords group by upper(bbps_keyword_name);
  
! DROP TABLE IF EXISTS `db_bbps`.`bbps_keywords` ;
  
! CREATE TABLE `db_bbps`.`bbps_keywords` (
  `bbps_keyword_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
  `bbps_keyword_name` varchar( 32 ) default NULL ,
--- 25,31 ----
  create temporary table temp2 select * from bbps_keywords group by upper(bbps_keyword_name);
  
! DROP TABLE IF EXISTS `bbps_keywords` ;
  
! CREATE TABLE `bbps_keywords` (
  `bbps_keyword_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
  `bbps_keyword_name` varchar( 32 ) default NULL ,