From 422aeef56ff7cd5109d954e75de322e20dc832ef Mon Sep 17 00:00:00 2001 From: brettp Date: Tue, 2 Mar 2010 18:22:56 +0000 Subject: Fixes #1562: Added a default value for entities.last_action in the schema and as an upgraded. Bumped version number to 1.7 final. git-svn-id: http://code.elgg.org/elgg/trunk@3984 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 2 +- engine/schema/upgrades/2010030101.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 engine/schema/upgrades/2010030101.sql (limited to 'engine/schema') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 638f7ce26..56c2a4077 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -130,7 +130,7 @@ CREATE TABLE `prefix_entities` ( `access_id` int(11) NOT NULL, `time_created` int(11) NOT NULL, `time_updated` int(11) NOT NULL, - `last_action` int(11) NOT NULL, + `last_action` int(11) NOT NULL DEFAULT '0', `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', PRIMARY KEY (`guid`), KEY `type` (`type`), diff --git a/engine/schema/upgrades/2010030101.sql b/engine/schema/upgrades/2010030101.sql new file mode 100644 index 000000000..cc7af98c9 --- /dev/null +++ b/engine/schema/upgrades/2010030101.sql @@ -0,0 +1 @@ +ALTER TABLE `prefix_entities` CHANGE `last_action` `last_action` INT( 11 ) NOT NULL DEFAULT '0' -- cgit v1.2.3