From da7abbb089ccb586ec8c7f33fcc21fb80b3fd3c2 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Mon, 18 May 2015 19:43:53 -0700 Subject: bring the new photo schema into play --- install/schema_mysql.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 461fcb122..40552c5ed 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -830,7 +830,7 @@ CREATE TABLE IF NOT EXISTS `photo` ( `size` int(10) unsigned NOT NULL DEFAULT '0', `data` mediumblob NOT NULL, `scale` tinyint(3) NOT NULL DEFAULT '0', - `usage` smallint(6) NOT NULL DEFAULT '0', + `photo_usage` smallint(6) NOT NULL DEFAULT '0', `profile` tinyint(1) NOT NULL DEFAULT '0', `is_nsfw` tinyint(1) NOT NULL DEFAULT '0', `os_storage` tinyint(1) NOT NULL DEFAULT '0', @@ -854,7 +854,7 @@ CREATE TABLE IF NOT EXISTS `photo` ( KEY `resource_id` (`resource_id`), KEY `is_nsfw` (`is_nsfw`), KEY `os_storage` (`os_storage`), - KEY `usage` (`usage`) + KEY `photo_usage` (`photo_usage`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `poll` ( -- cgit v1.2.3