sql/I18n.sql

sql/Person.sql
sql/core_email.sql
sql/core_enum.sql
sql/core_notify.sql
sql/core_oauth_access_tokens.sql
sql/core_oauth_clients.sql
sql/core_oauth_jwt.sql
sql/core_oauth_refresh_tokens.sql
sql/core_oauth_scopes.sql
sql/core_person_signup.sql
sql/core_watch.sql
sql/events.sql
sql/images.sql
sql/projectdirectory.sql

diff --git a/sql/I18n.sql b/sql/I18n.sql
index 8baeb70..c52447a 100644 (file)
--- a/sql/I18n.sql
+++ b/sql/I18n.sql
@@ -13,4 +13,4 @@ CREATE TABLE `i18n` (
 
 ALTER TABLE i18n ADD COLUMN is_active int(1) NOT NULL DEFAULT 1;
 
-ALTER TABLE i18n ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('i18n');
\ No newline at end of file

diff --git a/sql/Person.sql b/sql/Person.sql
index 47fe141..7fa8a6c 100644 (file)
--- a/sql/Person.sql
+++ b/sql/Person.sql
@@ -98,5 +98,5 @@ ALTER TABLE Person add index lookup_owner(owner_id);
  
 --  finally - always innodb
  
- ALTER TABLE Person ENGINE=InnoDB;
+ call mysql_change_engine('Person');
  

diff --git a/sql/core_email.sql b/sql/core_email.sql
index ba946ed..647b221 100644 (file)
--- a/sql/core_email.sql
+++ b/sql/core_email.sql
@@ -13,7 +13,7 @@ CREATE  TABLE core_email (
 );
 
 
-ALTER TABLE core_email ENGINE=InnoDB;
+call mysql_change_engine('core_email');
 
 
 UPDATE core_email SET updated_dt = NOW();
\ No newline at end of file

diff --git a/sql/core_enum.sql b/sql/core_enum.sql
index 040741a..f20d4a2 100644 (file)
--- a/sql/core_enum.sql
+++ b/sql/core_enum.sql
@@ -20,4 +20,4 @@ alter table  core_enum ADD  INDEX lookup(seqid, active, name, etype);
 
 UPDATE core_enum SET display_name = name WHERE display_name = '';
 
-ALTER TABLE core_enum ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_enum');
\ No newline at end of file

diff --git a/sql/core_notify.sql b/sql/core_notify.sql
index ea8ff40..03f359a 100644 (file)
--- a/sql/core_notify.sql
+++ b/sql/core_notify.sql
@@ -33,6 +33,6 @@ ALTER TABLE core_notify add   index lookup_d (person_id, msgid, ontable);
 
 
 -- used by email / tracker to handle alises - we have to be carefull adding to this table...
-ALTER TABLE core_notify ENGINE=InnoDB;
+call mysql_change_engine('core_notify');
 
 ALTER TABLE core_notify ADD COLUMN person_table VARCHAR(256) NOT NULL DEFAULT '';
\ No newline at end of file

diff --git a/sql/core_oauth_access_tokens.sql b/sql/core_oauth_access_tokens.sql
index 8391b2e..507db3b 100644 (file)
--- a/sql/core_oauth_access_tokens.sql
+++ b/sql/core_oauth_access_tokens.sql
@@ -12,4 +12,4 @@ CREATE INDEX access_token_idx ON core_oauth_access_tokens (access_token) USING B
 CREATE INDEX client_id_idx ON core_oauth_access_tokens (client_id) USING BTREE;
 CREATE INDEX user_id_idx ON core_oauth_access_tokens (user_id) USING BTREE;
 
-ALTER TABLE core_oauth_access_tokens ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_oauth_access_tokens');
\ No newline at end of file

diff --git a/sql/core_oauth_clients.sql b/sql/core_oauth_clients.sql
index 9d3cff8..b7bd525 100644 (file)
--- a/sql/core_oauth_clients.sql
+++ b/sql/core_oauth_clients.sql
@@ -14,4 +14,4 @@ CREATE INDEX client_secret_idx ON core_oauth_clients (client_secret) USING BTREE
 CREATE INDEX redirect_uri_idx ON core_oauth_clients (redirect_uri) USING BTREE;
 CREATE INDEX user_id_idx ON core_oauth_clients (user_id) USING BTREE;
 
-ALTER TABLE core_oauth_clients ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_oauth_clients');
\ No newline at end of file

diff --git a/sql/core_oauth_jwt.sql b/sql/core_oauth_jwt.sql
index 4b5be9e..034d039 100644 (file)
--- a/sql/core_oauth_jwt.sql
+++ b/sql/core_oauth_jwt.sql
@@ -9,4 +9,4 @@ CREATE TABLE core_oauth_jwt (
 CREATE INDEX client_id_idx ON core_oauth_jwt (client_id) USING BTREE;
 CREATE INDEX public_key_idx ON core_oauth_jwt (public_key) USING BTREE;
 
-ALTER TABLE core_oauth_jwt ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_oauth_jwt');
\ No newline at end of file

diff --git a/sql/core_oauth_refresh_tokens.sql b/sql/core_oauth_refresh_tokens.sql
index 14cb6c7..79a5054 100644 (file)
--- a/sql/core_oauth_refresh_tokens.sql
+++ b/sql/core_oauth_refresh_tokens.sql
@@ -12,4 +12,4 @@ CREATE INDEX refresh_token_idx ON core_oauth_refresh_tokens (refresh_token) USIN
 CREATE INDEX client_id_idx ON core_oauth_refresh_tokens (client_id) USING BTREE;
 CREATE INDEX user_id_idx ON core_oauth_refresh_tokens (user_id) USING BTREE;
 
-ALTER TABLE core_oauth_refresh_tokens ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_oauth_refresh_tokens');
\ No newline at end of file

diff --git a/sql/core_oauth_scopes.sql b/sql/core_oauth_scopes.sql
index a16dd88..282fc04 100644 (file)
--- a/sql/core_oauth_scopes.sql
+++ b/sql/core_oauth_scopes.sql
@@ -5,4 +5,4 @@ CREATE TABLE core_oauth_scopes (
     PRIMARY KEY (id)
 );
 
-ALTER TABLE core_oauth_scopes ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_oauth_scopes');
\ No newline at end of file

diff --git a/sql/core_person_signup.sql b/sql/core_person_signup.sql
index b922399..0c94d0a 100644 (file)
--- a/sql/core_person_signup.sql
+++ b/sql/core_person_signup.sql
@@ -32,4 +32,4 @@ ALTER TABLE core_person_signup ADD COLUMN   crm_mailing_list_id int(11) NOT NULL
 
 ALTER TABLE core_person_signup ADD COLUMN   phone varchar(256)  NOT NULL DEFAULT '';
 
-ALTER TABLE core_person_signup ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_person_signup');
\ No newline at end of file

diff --git a/sql/core_watch.sql b/sql/core_watch.sql
index d6fd160..b2b13e4 100644 (file)
--- a/sql/core_watch.sql
+++ b/sql/core_watch.sql
@@ -16,4 +16,4 @@ alter table  core_watch ADD COLUMN  active int(11) NOT NULL DEFAULT '1';
 
 ALTER TABLE core_watch ADD INDEX qlookup (ontable,onid,person_id,event,medium);
 
-ALTER TABLE core_watch ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('core_watch');
\ No newline at end of file

diff --git a/sql/events.sql b/sql/events.sql
index ea920f1..65e9c09 100644 (file)
--- a/sql/events.sql
+++ b/sql/events.sql
@@ -38,6 +38,6 @@ ALTER TABLE Events CHANGE COLUMN action action varchar(64)  default NULL;
 ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when, person_table);
   
  
-call mysql_change_engine('Events');  -- ALTER TABLE Events ENGINE=InnoDB;
+call mysql_change_engine('Events');  -- call mysql_change_engine('Events');
 
  
\ No newline at end of file

diff --git a/sql/images.sql b/sql/images.sql
index 14e89a0..f07a74d 100644 (file)
--- a/sql/images.sql
+++ b/sql/images.sql
@@ -29,4 +29,4 @@ ALTER TABLE Images ADD INDEX lookup(ontable, onid);
 
 ALTER TABLE Images ADD INDEX lookupc(created, ontable, onid
 
-ALTER TABLE Images ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('Images');
\ No newline at end of file

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index 42365bc..627ce3c 100644 (file)
--- a/sql/projectdirectory.sql
+++ b/sql/projectdirectory.sql
@@ -20,4 +20,4 @@ ALTER TABLE  ProjectDirectory ADD COLUMN   office_id int(11) NOT NULL DEFAULT 0;
 
 ALTER TABLE ProjectDirectory ADD INDEX plookup (project_id,person_id, ispm, role);
 
-ALTER TABLE ProjectDirectory ENGINE=InnoDB;
\ No newline at end of file
+call mysql_change_engine('ProjectDirectory');
\ No newline at end of file