Merge pull request #1379 from KZeni/patch-1

Fix "1103 Incorrect table name" error
ThinkUpLLC · Sep 10, 2012 · 989190e · 989190e
2 parents 33ae913 + c284bfe
commit 989190e
Showing 1 changed file with 20 additions and 20 deletions.
diff --git a/webapp/install/sql/mysql_migrations/2012-09-06_complete_comments_v1.1.sql b/webapp/install/sql/mysql_migrations/2012-09-06_complete_comments_v1.1.sql
@@ -1,7 +1,7 @@
 --
 -- Comment encoded_locations table
 --
-CREATE TABLE IF NOT EXISTS `tu_encoded_locations_1.1` (
+CREATE TABLE IF NOT EXISTS `tu_encoded_locations_1_1` (
   id int(11) NOT NULL AUTO_INCREMENT COMMENT 'Internal unique ID.',
   short_name varchar(255) NOT NULL COMMENT 'Short name of a location, such as NYC.',
   full_name varchar(255) NOT NULL COMMENT 'Full name of location, such as New York, NY, USA.',
@@ -10,36 +10,36 @@ CREATE TABLE IF NOT EXISTS `tu_encoded_locations_1.1` (
   KEY short_name (short_name)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Geo-encoded locations.';
 
-INSERT INTO `tu_encoded_locations_1.1` (SELECT * FROM tu_encoded_locations)#rollback=1;
+INSERT INTO `tu_encoded_locations_1_1` (SELECT * FROM tu_encoded_locations)#rollback=1;
 
-RENAME TABLE tu_encoded_locations TO `tu_encoded_locations_1.0`;
+RENAME TABLE tu_encoded_locations TO `tu_encoded_locations_1_0`;
 
-RENAME TABLE `tu_encoded_locations_1.1` TO tu_encoded_locations;
+RENAME TABLE `tu_encoded_locations_1_1` TO tu_encoded_locations;
 
-DROP TABLE IF EXISTS `tu_encoded_locations_1.0`;
+DROP TABLE IF EXISTS `tu_encoded_locations_1_0`;
 
 
 --
 -- Comment invites table
 --
-CREATE TABLE IF NOT EXISTS `tu_invites_1.1` (
+CREATE TABLE IF NOT EXISTS `tu_invites_1_1` (
   invite_code varchar(10) DEFAULT NULL COMMENT 'Invitation code.',
   created_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Time the invitation was created, used to calculate expiration time.'
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Individual user registration invitations.';
 
-INSERT INTO `tu_invites_1.1` (SELECT * FROM tu_invites)#rollback=1;
+INSERT INTO `tu_invites_1_1` (SELECT * FROM tu_invites)#rollback=1;
 
-RENAME TABLE tu_invites TO `tu_invites_1.0`;
+RENAME TABLE tu_invites TO `tu_invites_1_0`;
 
-RENAME TABLE `tu_invites_1.1` TO tu_invites;
+RENAME TABLE `tu_invites_1_1` TO tu_invites;
 
-DROP TABLE IF EXISTS `tu_invites_1.0`;
+DROP TABLE IF EXISTS `tu_invites_1_0`;
 
 
 --
 -- Comment options table
 --
-CREATE TABLE IF NOT EXISTS `tu_options_1.1` (
+CREATE TABLE IF NOT EXISTS `tu_options_1_1` (
   option_id int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique internal ID.',
   namespace varchar(50) NOT NULL COMMENT 'Option namespace, ie, application or specific plugin.',
   option_name varchar(50) NOT NULL COMMENT 'Name of option or setting.',
@@ -51,19 +51,19 @@ CREATE TABLE IF NOT EXISTS `tu_options_1.1` (
   KEY name_key (option_name)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Application and plugin options or settings.';
 
-INSERT INTO `tu_options_1.1` (SELECT * FROM tu_options)#rollback=1;
+INSERT INTO `tu_options_1_1` (SELECT * FROM tu_options)#rollback=1;
 
-RENAME TABLE tu_options TO `tu_options_1.0`;
+RENAME TABLE tu_options TO `tu_options_1_0`;
 
-RENAME TABLE `tu_options_1.1` TO tu_options;
+RENAME TABLE `tu_options_1_1` TO tu_options;
 
-DROP TABLE IF EXISTS `tu_options_1.0`;
+DROP TABLE IF EXISTS `tu_options_1_0`;
 
 
 --
 -- Comment plugins table
 --
-CREATE TABLE IF NOT EXISTS `tu_plugins_1.1` (
+CREATE TABLE IF NOT EXISTS `tu_plugins_1_1` (
   id int(11) NOT NULL AUTO_INCREMENT COMMENT 'Internal unique ID.',
   name varchar(255) NOT NULL COMMENT 'Plugin display name, such as Hello ThinkUp.',
   folder_name varchar(255) NOT NULL COMMENT 'Name of folder where plugin lives.',
@@ -75,10 +75,10 @@ CREATE TABLE IF NOT EXISTS `tu_plugins_1.1` (
   PRIMARY KEY (id)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Application plugins.';
 
-INSERT INTO `tu_plugins_1.1` (SELECT * FROM tu_plugins)#rollback=1;
+INSERT INTO `tu_plugins_1_1` (SELECT * FROM tu_plugins)#rollback=1;
 
-RENAME TABLE tu_plugins TO `tu_plugins_1.0`;
+RENAME TABLE tu_plugins TO `tu_plugins_1_0`;
 
-RENAME TABLE `tu_plugins_1.1` TO tu_plugins;
+RENAME TABLE `tu_plugins_1_1` TO tu_plugins;
 
-DROP TABLE IF EXISTS `tu_plugins_1.0`;
+DROP TABLE IF EXISTS `tu_plugins_1_0`;