Patch update_schema_for_5.5.patch for Systems problem Bug #77138

Patch version 2018-11-11 07:45 UTC

• 2018-11-11 07:45 UTC [diff to current]

Developer: zach@zrhoffman.net

commit a8ae9a96d2846280370271b7b07e133409f70787
Author: zrhoffman <zach@zrhoffman.net>
Date:   Sun Nov 11 00:54:02 2018 -0600

    Update db schema for MySQL 5.5+
    
    • TYPE= -> ENGINE=
    • TIMESTAMP(14) -> TIMESTAMP

diff --git a/event.sql b/event.sql
index 395f14a..3f70348 100644
--- a/event.sql
+++ b/event.sql
@@ -22,5 +22,5 @@ CREATE TABLE phpcal (
   KEY country (country),
   KEY category (category),
   FULLTEXT KEY sdesc (sdesc,ldesc,email)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
diff --git a/mirrors.sql b/mirrors.sql
index 7de9e18..3f1d25c 100644
--- a/mirrors.sql
+++ b/mirrors.sql
@@ -30,5 +30,5 @@ CREATE TABLE mirrors (
   ipv6_addr varchar(55) default NULL,
   PRIMARY KEY  (id),
   UNIQUE KEY hostname (hostname)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
diff --git a/note.sql b/note.sql
index da8de21..5d1cea5 100644
--- a/note.sql
+++ b/note.sql
@@ -26,13 +26,13 @@ CREATE TABLE IF NOT EXISTS note (
   updated datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (id),
   KEY idx_sect (sect)
-) TYPE=MyISAM PACK_KEYS=1;
+) ENGINE=MyISAM PACK_KEYS=1;
 
 CREATE TABLE IF NOT EXISTS alerts (
   user INT NOT NULL default '0',
   sect VARCHAR(80) not NULL default '',
-  updated TIMESTAMP(14) NOT NULL
-) TYPE=MyISAM;
+  updated TIMESTAMP NOT NULL
+) ENGINE=MyISAM;
 
 -- New votes table added for keeping track of user notes ratings 
 CREATE TABLE IF NOT EXISTS `votes` (
@@ -45,4 +45,4 @@ CREATE TABLE IF NOT EXISTS `votes` (
   PRIMARY KEY (`id`),
   KEY `note_id` (`note_id`,`ip`,`vote`),
   KEY `hostip` (`hostip`)
-) TYPE=MyISAM AUTO_INCREMENT=1;
+) ENGINE=MyISAM AUTO_INCREMENT=1;
diff --git a/users.sql b/users.sql
index 3e98734..2d6a3ae 100644
--- a/users.sql
+++ b/users.sql
@@ -48,7 +48,7 @@ CREATE TABLE users (
   UNIQUE KEY email (email),
   UNIQUE KEY username (username),
   FULLTEXT KEY name (name,email,username)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 /* the user_note table just contains notes about each user. */
 CREATE TABLE users_note (
@@ -58,7 +58,7 @@ CREATE TABLE users_note (
   note text,
   PRIMARY KEY  (noteid),
   FULLTEXT KEY note (note)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 /* the users_profile table contains up to one profile row for each user */
 CREATE TABLE users_profile (