diff options
| author | friendica <info@friendica.com> | 2012-08-15 22:33:37 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-08-15 22:33:37 -0700 |
| commit | f7c6a6ff9071c120f5bd6efe51cdb934e0c30cc7 (patch) | |
| tree | 586454a21f87a8f9a5e75073ac065cfbbae935a4 /database.sql | |
| parent | 77b334efbce9eb9aef825b968a2c852da21bfe94 (diff) | |
| download | volse-hubzilla-f7c6a6ff9071c120f5bd6efe51cdb934e0c30cc7.tar.gz volse-hubzilla-f7c6a6ff9071c120f5bd6efe51cdb934e0c30cc7.tar.bz2 volse-hubzilla-f7c6a6ff9071c120f5bd6efe51cdb934e0c30cc7.zip | |
item table rename parent-uri, target-type, object-type (more to come later)
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`), |