diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/database.sql b/database.sql index dfa039559..00b3dc122 100644 --- a/database.sql +++ b/database.sql @@ -459,7 +459,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `wall` tinyint(1) NOT NULL DEFAULT '0', `gravity` tinyint(1) NOT NULL DEFAULT '0', `parent` int(10) unsigned NOT NULL DEFAULT '0', - `parent-uri` char(255) CHARACTER SET ascii NOT NULL, + `parent_uri` char(255) CHARACTER SET ascii NOT NULL, `thr-parent` char(255) NOT NULL, `created` datetime NOT NULL, `edited` datetime NOT NULL, @@ -477,9 +477,9 @@ CREATE TABLE IF NOT EXISTS `item` ( `app` char(255) NOT NULL, `lang` char(64) NOT NULL, `verb` char(255) NOT NULL, - `object-type` char(255) NOT NULL, + `obj_type` char(255) NOT NULL, `object` text NOT NULL, - `target-type` char(255) NOT NULL, + `tgt_type` char(255) NOT NULL, `target` text NOT NULL, `postopts` text NOT NULL, `plink` char(255) NOT NULL, @@ -510,7 +510,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `contact-id` (`contact-id`), KEY `type` (`type`), KEY `parent` (`parent`), - KEY `parent-uri` (`parent-uri`), + KEY `parent_uri` (`parent_uri`), KEY `created` (`created`), KEY `edited` (`edited`), KEY `visible` (`visible`), @@ -571,7 +571,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( `replied` tinyint(1) NOT NULL, `unknown` tinyint(1) NOT NULL DEFAULT '0', `uri` char(255) NOT NULL, - `parent-uri` char(255) NOT NULL, + `parent_uri` char(255) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `reply` (`reply`), @@ -579,7 +579,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( KEY `guid` (`guid`), KEY `seen` (`seen`), KEY `uri` (`uri`), - KEY `parent-uri` (`parent-uri`), + KEY `parent_uri` (`parent_uri`), KEY `created` (`created`), KEY `convid` (`convid`), KEY `unknown` (`unknown`), |