diff options
| author | Friendika <info@friendika.com> | 2011-07-05 23:23:43 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-07-05 23:23:43 -0700 |
| commit | 84d12c3e08ae4b6fe228ce881b0c1570175d1667 (patch) | |
| tree | bb8f4ccca207ff6c226cf79f4ce348c5bc8d9df9 /database.sql | |
| parent | c221d5ea597040c27a8918f9c08629e979a6e273 (diff) | |
| download | volse-hubzilla-84d12c3e08ae4b6fe228ce881b0c1570175d1667.tar.gz volse-hubzilla-84d12c3e08ae4b6fe228ce881b0c1570175d1667.tar.bz2 volse-hubzilla-84d12c3e08ae4b6fe228ce881b0c1570175d1667.zip | |
move hidewall to user table - queries are getting too complicated and servers falling over
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database.sql b/database.sql index b11e72f6c..8ea3e42de 100644 --- a/database.sql +++ b/database.sql @@ -301,7 +301,6 @@ CREATE TABLE IF NOT EXISTS `profile` ( `profile-name` char(255) NOT NULL, `is-default` tinyint(1) NOT NULL DEFAULT '0', `hide-friends` tinyint(1) NOT NULL DEFAULT '0', - `hidewall` tinyint(1) NOT NULL DEFAULT '0', `name` char(255) NOT NULL, `pdesc` char(255) NOT NULL, `dob` char(32) NOT NULL DEFAULT '0000-00-00', @@ -399,6 +398,7 @@ CREATE TABLE IF NOT EXISTS `user` ( `verified` tinyint(1) unsigned NOT NULL DEFAULT '0', `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0', `blockwall` tinyint(1) unsigned NOT NULL DEFAULT '0', + `hidewall` tinyint(1) unsigned NOT NULL DEFAULT '0', `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535', `page-flags` int(11) unsigned NOT NULL DEFAULT '0', `prvnets` tinyint(1) NOT NULL DEFAULT '0', |