aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-05-18 19:43:53 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-05-18 19:43:53 -0700
commitda7abbb089ccb586ec8c7f33fcc21fb80b3fd3c2 (patch)
tree17156b93aece10069f2855c1b935c3bcae68cfa3 /install/schema_mysql.sql
parenteae241df5682fe35ab875608164f1745d80c2301 (diff)
downloadvolse-hubzilla-da7abbb089ccb586ec8c7f33fcc21fb80b3fd3c2.tar.gz
volse-hubzilla-da7abbb089ccb586ec8c7f33fcc21fb80b3fd3c2.tar.bz2
volse-hubzilla-da7abbb089ccb586ec8c7f33fcc21fb80b3fd3c2.zip
bring the new photo schema into play
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql4
1 files changed, 2 insertions, 2 deletions
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` (