diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-09-01 17:06:58 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-09-01 17:06:58 -0700 |
| commit | 3852b5ce7fe83cce93c0826a92c378a589bc8664 (patch) | |
| tree | 26b3d216c9f4fb284d64902a593c5b66a31e47ab /install/schema_mysql.sql | |
| parent | 1447499776ce07bf48b76435a23de704952e6aa2 (diff) | |
| download | volse-hubzilla-3852b5ce7fe83cce93c0826a92c378a589bc8664.tar.gz volse-hubzilla-3852b5ce7fe83cce93c0826a92c378a589bc8664.tar.bz2 volse-hubzilla-3852b5ce7fe83cce93c0826a92c378a589bc8664.zip | |
separate objs/things from taxonomy
Diffstat (limited to 'install/schema_mysql.sql')
| -rw-r--r-- | install/schema_mysql.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 5ee1ec463..d7d44a0a6 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -823,6 +823,11 @@ CREATE TABLE IF NOT EXISTS `obj` ( `obj_type` int(10) unsigned NOT NULL DEFAULT '0', `obj_obj` char(255) NOT NULL DEFAULT '', `obj_channel` int(10) unsigned NOT NULL DEFAULT '0', + `obj_term` char(255) NOT NULL DEFAULT '', + `obj_url` char(255) NOT NULL DEFAULT '', + `obj_imgurl` char(255) NOT NULL DEFAULT '', + `obj_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `obj_edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, @@ -832,6 +837,11 @@ CREATE TABLE IF NOT EXISTS `obj` ( KEY `obj_page` (`obj_page`), KEY `obj_type` (`obj_type`), KEY `obj_channel` (`obj_channel`), + KEY `obj_term` (`obj_term`), + KEY `obj_url` (`obj_url`), + KEY `obj_imgurl` (`obj_imgurl`), + KEY `obj_created` (`obj_created`), + KEY `obj_edited` (`obj_edited`), KEY `obj_obj` (`obj_obj`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |