aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-09-18 21:20:54 -0700
committerfriendica <info@friendica.com>2013-09-18 21:22:08 -0700
commit14f6bf06e7d0dd7a851715bb081e2f2a55d79c2a (patch)
tree3f0ac480eb7404597f37d48391bbc59bbd5977fc /install/database.sql
parente4d2e2200e04c8df699d9a8efade661123ef7ac8 (diff)
downloadvolse-hubzilla-14f6bf06e7d0dd7a851715bb081e2f2a55d79c2a.tar.gz
volse-hubzilla-14f6bf06e7d0dd7a851715bb081e2f2a55d79c2a.tar.bz2
volse-hubzilla-14f6bf06e7d0dd7a851715bb081e2f2a55d79c2a.zip
set default charset of email_header_encode, add ud_flags to indicate which (directory sync) updates have been processed in some way.
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 2e420fcbd..21d7575e9 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -891,10 +891,12 @@ CREATE TABLE IF NOT EXISTS `updates` (
`ud_hash` char(128) NOT NULL,
`ud_guid` char(255) NOT NULL DEFAULT '',
`ud_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `ud_flags` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ud_id`),
KEY `ud_hash` (`ud_hash`),
KEY `ud_guid` (`ud_guid`),
- KEY `ud_date` (`ud_date`)
+ KEY `ud_date` (`ud_date`),
+ KEY `ud_flags` (`ud_flags`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `verify` (