Changeset 9086 for trunk/install/piwigo_structure-mysql.sql

Timestamp:

Feb 3, 2011, 10:59:51 PM (13 years ago)

Author:

plg

Message:

bug 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of the
deprecated "TYPE=MyISAM", so that SQL creation table statements complies
with MySQL 5.5

File:

• trunk/install/piwigo_structure-mysql.sql (modified) (30 diffs)

trunk/install/piwigo_structure-mysql.sql

@@ -14 +14 @@
   `element_id` mediumint(8) NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`element_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -40 +40 @@
   UNIQUE KEY `categories_i3` (`permalink`),
   KEY `categories_i2` (`id_uppercat`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -59 +59 @@
   KEY `comments_i2` (`validation_date`),
   KEY `comments_i1` (`image_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -71 +71 @@
   `comment` varchar(255) default NULL,
   PRIMARY KEY  (`param`)
-) TYPE=MyISAM COMMENT='configuration table';
+) ENGINE=MyISAM COMMENT='configuration table';
 
 --
@@ -82 +82 @@
   `image_id` mediumint(8) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`image_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -93 +93 @@
   `cat_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`group_id`,`cat_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -106 +106 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `groups_ui1` (`name`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -127 +127 @@
   PRIMARY KEY  (`id`),
   KEY `history_i1` (`summarized`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -141 +141 @@
   `nb_pages` int(11) default NULL,
   UNIQUE KEY history_summary_ymdh (`year`,`month`,`day`,`hour`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -154 +154 @@
   PRIMARY KEY  (`image_id`,`category_id`),
   KEY `image_category_i1` (`category_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -166 +166 @@
   PRIMARY KEY  (`image_id`,`tag_id`),
   KEY `image_tag_i1` (`tag_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -202 +202 @@
   KEY `images_i5` (`date_creation`),
   KEY `images_i1` (`storage_category_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -214 +214 @@
   `name` varchar(64) default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -228 +228 @@
   `hit` int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (`permalink`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -240 +240 @@
   `version` varchar(64) NOT NULL default '0',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -254 +254 @@
   `date` date NOT NULL default '0000-00-00',
   PRIMARY KEY  (`element_id`,`user_id`,`anonymous_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -266 +266 @@
   `rules` text,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -278 +278 @@
   `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -290 +290 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `sites_ui1` (`galleries_url`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -303 +303 @@
   PRIMARY KEY  (`id`),
   KEY `tags_i1` (`url_name`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -315 +315 @@
   `name` varchar(64) default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -327 +327 @@
   `description` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -338 +338 @@
   `cat_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`cat_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -354 +354 @@
   `image_access_list` mediumtext default NULL,
   PRIMARY KEY  (`user_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -371 +371 @@
   `user_representative_picture_id` mediumint(8) unsigned default NULL,
   PRIMARY KEY  (`user_id`,`cat_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -383 +383 @@
   `last_check` datetime default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -394 +394 @@
   `group_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`group_id`,`user_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -418 +418 @@
   `level` tinyint unsigned NOT NULL default '0',
   UNIQUE KEY `user_infos_ui1` (`user_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -432 +432 @@
   PRIMARY KEY  (`user_id`),
   UNIQUE KEY `user_mail_notification_ui1` (`check_key`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
@@ -446 +446 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `users_ui1` (`username`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;