[pLog-svn] r7232 - plog/branches/lifetype-1.2/install
jondaley at devel.lifetype.net
jondaley at devel.lifetype.net
Mon Jul 13 02:55:23 EDT 2020
Author: jondaley
Date: 2020-07-13 02:55:23 -0400 (Mon, 13 Jul 2020)
New Revision: 7232
Modified:
plog/branches/lifetype-1.2/install/dbschemas.properties.php
Log:
updated for mysql 5.5 and newer.
Modified: plog/branches/lifetype-1.2/install/dbschemas.properties.php
===================================================================
--- plog/branches/lifetype-1.2/install/dbschemas.properties.php 2020-07-13 06:48:48 UTC (rev 7231)
+++ plog/branches/lifetype-1.2/install/dbschemas.properties.php 2020-07-13 06:55:23 UTC (rev 7232)
@@ -23,7 +23,7 @@
INDEX global_category_status (global_category_id, status),
INDEX date(date)
";
-$Tables["articles"]["options"] = "TYPE=MyISAM";
+$Tables["articles"]["options"] = "ENGINE=MyISAM";
$Tables["articles_categories"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -42,7 +42,7 @@
INDEX blog_id (blog_id),
INDEX mangled_name (mangled_name)
";
-$Tables["articles_categories"]["options"] = "TYPE=MyISAM";
+$Tables["articles_categories"]["options"] = "ENGINE=MyISAM";
$Tables["articles_comments"]["schema"] = "
@@ -73,7 +73,7 @@
FULLTEXT normalized_text (normalized_text),
FULLTEXT normalized_topic (normalized_topic)
";
-$Tables["articles_comments"]["options"] = "TYPE=MyISAM";
+$Tables["articles_comments"]["options"] = "ENGINE=MyISAM";
$Tables["articles_notifications"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -84,7 +84,7 @@
INDEX user_id (user_id),
INDEX blog_id (blog_id)
";
-$Tables["articles_notifications"]["options"] = "TYPE=MyISAM";
+$Tables["articles_notifications"]["options"] = "ENGINE=MyISAM";
$Tables["blogs"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT INDEX PRIMARY,
@@ -108,7 +108,7 @@
INDEX custom_domain(custom_domain),
INDEX create_date(create_date)
";
-$Tables["blogs"]["options"] = "TYPE=MyISAM";
+$Tables["blogs"]["options"] = "ENGINE=MyISAM";
$Tables["mylinks"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -123,7 +123,7 @@
INDEX blog_id (blog_id),
INDEX category_id (category_id)
";
-$Tables["mylinks"]["options"] = "TYPE=MyISAM";
+$Tables["mylinks"]["options"] = "ENGINE=MyISAM";
$Tables["mylinks_categories"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -134,7 +134,7 @@
num_links I(10) NOTNULL DEFAULT '0',
INDEX blog_id (blog_id)
";
-$Tables["mylinks_categories"]["options"] = "TYPE=MyISAM";
+$Tables["mylinks_categories"]["options"] = "ENGINE=MyISAM";
$Tables["permissions"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -143,7 +143,7 @@
admin_only I(1) NOTNULL DEFAULT '1',
core_perm I(1) NOTNULL DEFAULT '1'
";
-$Tables["permissions"]["options"] = "TYPE=MyISAM";
+$Tables["permissions"]["options"] = "ENGINE=MyISAM";
$Tables["referers"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -155,7 +155,7 @@
INDEX article_id (article_id),
INDEX blog_id_article_id (blog_id, article_id)
";
-$Tables["referers"]["options"] = "TYPE=MyISAM";
+$Tables["referers"]["options"] = "ENGINE=MyISAM";
$Tables["users"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -171,7 +171,7 @@
last_login T(14),
UNIQUE user (user)
";
-$Tables["users"]["options"] = "TYPE=MyISAM";
+$Tables["users"]["options"] = "ENGINE=MyISAM";
$Tables["users_permissions"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -181,7 +181,7 @@
INDEX blog_id (blog_id),
INDEX user_id_permission_id (user_id,permission_id)
";
-$Tables["users_permissions"]["options"] = "TYPE=MyISAM";
+$Tables["users_permissions"]["options"] = "ENGINE=MyISAM";
//
// temporary table only used during the upgrade process, will be dropped at the end of it
@@ -194,7 +194,7 @@
INDEX blog_id (blog_id),
INDEX user_id_permission_id (user_id,permission_id)
";
-$Tables["users_permissions"]["options"] = "TYPE=MyISAM";
+$Tables["users_permissions"]["options"] = "ENGINE=MyISAM";
$Tables["config"]["schema"] = "
config_key C(255) NOTNULL DEFAULT '' PRIMARY,
@@ -201,7 +201,7 @@
config_value TEXT NOTNULL,
value_type I(3) DEFAULT '0'
";
-$Tables["config"]["options"] = "TYPE=MyISAM";
+$Tables["config"]["options"] = "ENGINE=MyISAM";
$Tables["filtered_content"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -211,7 +211,7 @@
date T(14) NOTNULL,
INDEX blog_id (blog_id)
";
-$Tables["filtered_content"]["options"] = "TYPE=MyISAM";
+$Tables["filtered_content"]["options"] = "ENGINE=MyISAM";
$Tables["host_blocking_rules"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -225,7 +225,7 @@
INDEX block_type (block_type),
INDEX blog_id_block_type(blog_id, block_type)
";
-$Tables["host_blocking_rules"]["options"] = "TYPE=MyISAM";
+$Tables["host_blocking_rules"]["options"] = "ENGINE=MyISAM";
$Tables["gallery_resources"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -248,7 +248,7 @@
INDEX resource_type (resource_type),
FULLTEXT normalized_description (normalized_description)
";
-$Tables["gallery_resources"]["options"] = "TYPE=MyISAM";
+$Tables["gallery_resources"]["options"] = "ENGINE=MyISAM";
$Tables["gallery_albums"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -272,7 +272,7 @@
FULLTEXT normalized_description (normalized_description),
FULLTEXT normalized_fields (normalized_name, normalized_description)
";
-$Tables["gallery_albums"]["options"] = "TYPE=MyISAM";
+$Tables["gallery_albums"]["options"] = "ENGINE=MyISAM";
$Tables["bayesian_filter_info"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -281,7 +281,7 @@
total_nonspam I(10) UNSIGNED DEFAULT NULL,
INDEX blog_id (blog_id)
";
-$Tables["bayesian_filter_info"]["options"] = "TYPE=MyISAM";
+$Tables["bayesian_filter_info"]["options"] = "ENGINE=MyISAM";
$Tables["bayesian_tokens"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -293,13 +293,13 @@
INDEX blog_id (blog_id),
INDEX token (token)
";
-$Tables["bayesian_tokens"]["options"] = "TYPE=MyISAM";
+$Tables["bayesian_tokens"]["options"] = "ENGINE=MyISAM";
$Tables["article_categories_link"]["schema"] = "
article_id I(10) NOTNULL PRIMARY,
category_id I(10) NOTNULL PRIMARY
";
-$Tables["article_categories_link"]["options"] = "TYPE=MyISAM";
+$Tables["article_categories_link"]["options"] = "ENGINE=MyISAM";
$Tables["custom_fields_definition"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -313,7 +313,7 @@
hidden I1(1) DEFAULT 1,
INDEX blog_id (blog_id)
";
-$Tables["custom_fields_definition"]["options"] = "TYPE=MyISAM";
+$Tables["custom_fields_definition"]["options"] = "ENGINE=MyISAM";
$Tables["custom_fields_values"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -327,7 +327,7 @@
INDEX field_id (field_id),
INDEX blog_id_article_id (blog_id, article_id)
";
-$Tables["custom_fields_values"]["options"] = "TYPE=MyISAM";
+$Tables["custom_fields_values"]["options"] = "ENGINE=MyISAM";
$Tables["articles_text"]["schema"] = "
id I(10) NOTNULL AUTOINCREMENT PRIMARY,
@@ -342,7 +342,7 @@
FULLTEXT normalized_topic (normalized_topic),
FULLTEXT normalized_fields (normalized_text, normalized_topic)
";
-$Tables["articles_text"]["options"] = "TYPE=MyISAM";
+$Tables["articles_text"]["options"] = "ENGINE=MyISAM";
$Tables["phpbb2_users"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -354,7 +354,7 @@
status I(10) NOTNULL DEFAULT 0,
UNIQUE phpbb_id(phpbb_id)
";
-$Tables["phpbb2_users"]["options"] = "TYPE=MyISAM";
+$Tables["phpbb2_users"]["options"] = "ENGINE=MyISAM";
$Tables["blog_categories"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -366,7 +366,7 @@
num_active_blogs I(10) NOTNULL DEFAULT '0',
INDEX mangled_name(mangled_name)
";
-$Tables["blog_categories"]["options"] = "TYPE=MyISAM";
+$Tables["blog_categories"]["options"] = "ENGINE=MyISAM";
$Tables["global_articles_categories"]["schema"] = "
id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
@@ -378,6 +378,6 @@
num_active_articles I(10) NOTNULL DEFAULT '0',
INDEX mangled_name(mangled_name)
";
-$Tables["global_articles_categories"]["options"] = "TYPE=MyISAM";
+$Tables["global_articles_categories"]["options"] = "ENGINE=MyISAM";
?>
More information about the pLog-svn
mailing list