aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-12-22 18:37:39 -0800
committerfriendica <info@friendica.com>2013-12-22 18:37:39 -0800
commit1a42580ad44f768ba8d4eb0669f3b8be03670e04 (patch)
treee40948063cea08c8c0ea4ece8efbcc6bef6464d8 /install/database.sql
parenteff38538eeaa3af0774c77d26c5b00dd79cb9e8c (diff)
downloadvolse-hubzilla-1a42580ad44f768ba8d4eb0669f3b8be03670e04.tar.gz
volse-hubzilla-1a42580ad44f768ba8d4eb0669f3b8be03670e04.tar.bz2
volse-hubzilla-1a42580ad44f768ba8d4eb0669f3b8be03670e04.zip
remove a couple of mysql reserved words from being used as table or row names. For this round we're getting 'group' and 'desc'. Warning: potentially destabilising as this touches a lot of code.
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/install/database.sql b/install/database.sql
index 915cecdba..f73460937 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -240,7 +240,7 @@ CREATE TABLE IF NOT EXISTS `event` (
`start` datetime NOT NULL,
`finish` datetime NOT NULL,
`summary` text NOT NULL,
- `desc` text NOT NULL,
+ `description` text NOT NULL,
`location` text NOT NULL,
`type` char(255) NOT NULL,
`nofinish` tinyint(1) NOT NULL DEFAULT '0',
@@ -319,7 +319,7 @@ CREATE TABLE IF NOT EXISTS `fsuggest` (
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-CREATE TABLE IF NOT EXISTS `group` (
+CREATE TABLE IF NOT EXISTS `groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hash` char(255) NOT NULL DEFAULT '',
`uid` int(10) unsigned NOT NULL,
@@ -639,7 +639,7 @@ CREATE TABLE IF NOT EXISTS `photo` (
`created` datetime NOT NULL,
`edited` datetime NOT NULL,
`title` char(255) NOT NULL,
- `desc` text NOT NULL,
+ `description` text NOT NULL,
`album` char(255) NOT NULL,
`filename` char(255) NOT NULL,
`type` char(128) NOT NULL DEFAULT 'image/jpeg',