diff options
| author | Friendika <info@friendika.com> | 2010-12-07 18:13:51 -0800 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2010-12-07 18:13:51 -0800 |
| commit | 5763d31b4f213fbb2eea4d366a9c7ad534a7f1ec (patch) | |
| tree | 7e90cc7594e842f9bc9da8bdefd298a3bf73a274 /database.sql | |
| parent | 8b086a76e5607c3db96ca17ce66d2a68139d2584 (diff) | |
| download | volse-hubzilla-5763d31b4f213fbb2eea4d366a9c7ad534a7f1ec.tar.gz volse-hubzilla-5763d31b4f213fbb2eea4d366a9c7ad534a7f1ec.tar.bz2 volse-hubzilla-5763d31b4f213fbb2eea4d366a9c7ad534a7f1ec.zip | |
db prepare for enhanced magic profiles and remote privacy indicators, fixed $lang setting to use system config var, some other syntax issues
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/database.sql b/database.sql index be0671bb1..0b322e9e0 100644 --- a/database.sql +++ b/database.sql @@ -187,6 +187,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, + `private` tinyint(1) NOT NULL DEFAULT '0', `visible` tinyint(1) NOT NULL DEFAULT '0', `unseen` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', @@ -319,7 +320,9 @@ CREATE TABLE IF NOT EXISTS `profile` ( CREATE TABLE IF NOT EXISTS `profile_check` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, + `cid` int(10) unsigned NOT NULL, `dfrn_id` char(255) NOT NULL, + `sec` char(255) NOT NULL, `expire` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |