diff options
| author | friendica <info@friendica.com> | 2013-12-22 18:37:39 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2013-12-22 18:37:39 -0800 |
| commit | 1a42580ad44f768ba8d4eb0669f3b8be03670e04 (patch) | |
| tree | e40948063cea08c8c0ea4ece8efbcc6bef6464d8 /install/database.sql | |
| parent | eff38538eeaa3af0774c77d26c5b00dd79cb9e8c (diff) | |
| download | volse-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.sql | 6 |
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', |