aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-06-27 19:35:59 -0700
committerfriendica <info@friendica.com>2013-06-27 19:35:59 -0700
commitcdc66da52fb985c33e27b955324dd977830a1d8c (patch)
tree6896bf8d57b224231ec2a8c9fe4b84893b883cd3 /install/database.sql
parent230aeb782eaea85626640d14f5949606de73d502 (diff)
downloadvolse-hubzilla-cdc66da52fb985c33e27b955324dd977830a1d8c.tar.gz
volse-hubzilla-cdc66da52fb985c33e27b955324dd977830a1d8c.tar.bz2
volse-hubzilla-cdc66da52fb985c33e27b955324dd977830a1d8c.zip
Basic ability to create "things"
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/install/database.sql b/install/database.sql
index 056124649..30b8edfd7 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -829,6 +829,7 @@ CREATE TABLE IF NOT EXISTS `term` (
`term` char(255) NOT NULL,
`url` char(255) NOT NULL,
`imgurl` char(255) NOT NULL,
+ `term_hash` char(255) NOT NULL DEFAULT '',
PRIMARY KEY (`tid`),
KEY `oid` (`oid`),
KEY `otype` (`otype`),
@@ -836,7 +837,8 @@ CREATE TABLE IF NOT EXISTS `term` (
KEY `term` (`term`),
KEY `uid` (`uid`),
KEY `aid` (`aid`),
- KEY `imgurl` (`imgurl`)
+ KEY `imgurl` (`imgurl`),
+ KEY `term_hash` (`term_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `tokens` (
@@ -933,7 +935,7 @@ CREATE TABLE IF NOT EXISTS `xlink` (
KEY `xlink_link` (`xlink_link`),
KEY `xlink_updated` (`xlink_updated`),
KEY `xlink_rating` (`xlink_rating`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `xprof` (
`xprof_hash` char(255) NOT NULL,