diff options
| -rw-r--r-- | Zotlabs/Lib/Apps.php | 10 | ||||
| -rw-r--r-- | doc/bugs.bb | 21 | ||||
| -rw-r--r-- | doc/toc.html | 1 | ||||
| -rw-r--r-- | install/sample-nginx.conf | 2 | ||||
| -rw-r--r-- | install/schema_mysql.sql | 458 | ||||
| -rw-r--r-- | install/schema_postgres.sql | 398 | ||||
| -rw-r--r-- | install/update.php | 2 |
7 files changed, 447 insertions, 445 deletions
diff --git a/Zotlabs/Lib/Apps.php b/Zotlabs/Lib/Apps.php index edf050b95..2ace361ca 100644 --- a/Zotlabs/Lib/Apps.php +++ b/Zotlabs/Lib/Apps.php @@ -34,7 +34,7 @@ class Apps { if($files) { foreach($files as $f) { $path = explode('/',$f); - $plugin = $path[1]; + $plugin = trim($path[1]); if(plugin_is_installed($plugin)) { $x = self::parse_app_description($f,$translate); if($x) { @@ -285,7 +285,7 @@ class Apps { self::translate_system_apps($papp); - if(($papp['plugin']) && (! plugin_is_installed($papp['plugin']))) + if(trim($papp['plugin']) && (! plugin_is_installed(trim($papp['plugin'])))) return ''; $papp['papp'] = self::papp_encode($papp); @@ -575,7 +575,7 @@ class Apps { $darray['app_addr'] = ((x($arr,'addr')) ? escape_tags($arr['addr']) : ''); $darray['app_price'] = ((x($arr,'price')) ? escape_tags($arr['price']) : ''); $darray['app_page'] = ((x($arr,'page')) ? escape_tags($arr['page']) : ''); - $darray['app_plugin'] = ((x($arr,'plugin')) ? escape_tags($arr['plugin']) : ''); + $darray['app_plugin'] = ((x($arr,'plugin')) ? escape_tags(trim($arr['plugin'])) : ''); $darray['app_requires'] = ((x($arr,'requires')) ? escape_tags($arr['requires']) : ''); $darray['app_system'] = ((x($arr,'system')) ? intval($arr['system']) : 0); $darray['app_deleted'] = ((x($arr,'deleted')) ? intval($arr['deleted']) : 0); @@ -653,7 +653,7 @@ class Apps { $darray['app_addr'] = ((x($arr,'addr')) ? escape_tags($arr['addr']) : ''); $darray['app_price'] = ((x($arr,'price')) ? escape_tags($arr['price']) : ''); $darray['app_page'] = ((x($arr,'page')) ? escape_tags($arr['page']) : ''); - $darray['app_plugin'] = ((x($arr,'plugin')) ? escape_tags($arr['plugin']) : ''); + $darray['app_plugin'] = ((x($arr,'plugin')) ? escape_tags(trim($arr['plugin'])) : ''); $darray['app_requires'] = ((x($arr,'requires')) ? escape_tags($arr['requires']) : ''); $darray['app_system'] = ((x($arr,'system')) ? intval($arr['system']) : 0); $darray['app_deleted'] = ((x($arr,'deleted')) ? intval($arr['deleted']) : 0); @@ -763,7 +763,7 @@ class Apps { $ret['system'] = $app['app_system']; if($app['app_plugin']) - $ret['plugin'] = $app['app_plugin']; + $ret['plugin'] = trim($app['app_plugin']); if($app['app_deleted']) $ret['deleted'] = $app['app_deleted']; diff --git a/doc/bugs.bb b/doc/bugs.bb index f50337648..cc1ea3a20 100644 --- a/doc/bugs.bb +++ b/doc/bugs.bb @@ -1,31 +1,32 @@ [h2]Bugs, Issues, and things that go bump in the night...[/h2] [h3]Something went wrong! Who is charge of fixing it?[/h3] -[b]Hubzilla Community Server[/b] +[b]$Projectname Community Server[/b] -Hubzilla Community Server is open source software which is maintained by "the community" - essentially unpaid volunteers. +$Projectname Community Server is open source software which is maintained by "the community" - essentially unpaid volunteers. Nobody is in charge of fixing bugs. We work together to keep the software and network running smoothly and error free. You are a member of this community, so we also require your help to provide quality software. There are no mythical "developers" who magically fix everything. It's up to all of us to pitch in and help. The first thing you need to do is talk to your hub administrator - the person who runs and manages your site. They are in the unique position of having access to the internal software and database and [b]logfiles[/b] and will need to be involved in fixing your problem. Other people "on the net" can't really help with this. The first thing the hub administrator needs to do is look at their logs and/or try to reproduce the problem. So try to be as helpful and courteous as possible in helping them look into the problem. -To find your hub administrator (if you don't know who they are) please look at [url=[baseurl]/siteinfo]this page[/url]. If they have not provided any contact info on that page or provided an "Impressum" there, see [url=[baseurl]/siteinfo/json]this site info summary[/url] under the heading "admin:". +To find your hub administrator (if you don't know who they are) please look at [url=[baseurl]/siteinfo]this page[/url]. If they have not provided any contact info on that page or provided an "Impressum" there, see [url=[baseurl]/siteinfo.json]this site info summary[/url] under the heading "admin:". + +It is highly recommended that bug reports be filed by hub administrators so that they can include the relevant logfile and database information relevant to the issue and be available to try workarounds and followup tests. Without this level of cooperation it may not be possible to fix the problem. [h3]I'm a hub administrator; what do I do?[/h3] -The software instructions which provide this server are open source and are available for your inspection. If an error message was reported, often one can do a search on the source files for that error message and find out what triggered it. With this information and the site logfiles it may be possible to figure out the sequence of events leading to the error. There could also be other sites involved, and the problem may not even be on your site but elsewhere in the network. Try to pin down the communication endpoints (hubs or sites) involved in the problem and contact the administrator of that site or those sites. Please try and provide an event time of when things went wrong so it can be found in the logs. Work with the other administrator(s) to try and find the cause of the problem. Logfiles are your friend. When something happens in the software that we didn't expect, it is nearly always logged. +The software instructions which provide this web service are open source and are available for your inspection. We encourage everybody to read it and see how everything works and verify that we aren't doing anything evil or negligent with your personal communications. If an error message was reported, often one can do a search on the source files for that error message and find out what triggered it. With this information and the site logfiles it may be possible to figure out the sequence of events leading to the error. There could also be other sites involved, and the problem may not even be on your site but elsewhere in the network. Try to pin down the communication endpoints (hubs or sites) involved in the problem and contact the administrator of that site or those sites. Please try and provide an event time of when things went wrong so it can be found in the logs. Work with the other administrator(s) to try and find the cause of the problem. Logfiles are your friend. When something happens in the software that we didn't expect, it is nearly always logged. [h3]The white screen of death[/h3] -If you get a blank white screen when doing something, this is almost always a code or syntax error. There are instructions in your .htconfig.php file for enabling syntax logging. We recommend all sites use this. With syntax logging enabled repeat the sequence which led to the error and it should log the offending line of code. Hopefully you will be able to fix the problem with this information. When you do, please submit the fix "upstream" so that we can share the fix with the rest of the project members and other communities. This is a key benefit of using open source software - we share with each other and everybody benefits. +If you get a blank white screen when doing something, this is almost always a code or syntax error. There are instructions in the site .htconfig.php file which will allow the site administrator to enabling syntax logging. We recommend all sites use this. With syntax logging enabled repeat the sequence which led to the error and it should log the offending line of code. Hopefully you will be able to fix the problem with this information. When you do, please submit the fix "upstream" so that we can share the fix with the rest of the project members and other communities. This is a key benefit of using open source software - we share with each other and everybody benefits. [h3]I'm stumped. I can't figure out what is wrong.[/h3] -At this point it might be worthwhile discussing the issue on one of the online forums. There may be several of these and some may be more suited to your spoken language. As a last resort, try "Channel One", which is in English. +At this point it might be worthwhile discussing the issue on one of the online forums. There may be several of these and some may be more suited to your spoken language. At this time, the 'Hubzilla Support' channel (support@gravizot.de) is the recommended forum for discussing bugs. -If the community developers can't help you right away, understand that they are volunteers and may have a lot of other work and demands on their time. At this point you need to file a bug report. You will need an account on github.com to do this. So register, and then visit https://github.com/redmatrix/hubzilla/issues -. Create an issue here and provide all the same information that you provided online. Don't leave out anything. +If community members with software engineering training/expertise can't help you right away, understand that they are volunteers and may have a lot of other work and demands on their time. At this point you need to file a bug report. You will need an account on github.com to do this. So register, and then visit https://github.com/redmatrix/hubzilla/issues . Create an issue here and provide all the same information that you provided online. Don't leave out anything. -Then you wait. If it's a high profile issue, it may get fixed quickly. But nobody is in charge of fixing bugs. If it lingers without resolution, please spend some more time investigating the problem. Ask about anything you don't understand related to the behaviour. You will learn more about how the software works and quite possibly figure out why it isn't working now. Ultimately it is somebody in the community who is going to fix this and you are a member of the community; and this is how the open source process works. +Then you wait. If it's a high profile issue, it may get fixed quickly. But nobody is in charge of fixing bugs. If it lingers without resolution, please spend some more time investigating the problem. Ask about anything you don't understand related to the behaviour. You will learn more about how the software works and quite possibly figure out why it isn't working now. Ultimately it is somebody in the community who is going to fix this and you are a member of the community; and this is how the open source process works. -Other developers working to fix the problem may need to find out more, so do your homework and document what is happening and everything you've tried. Don't say "I did xyz and it didn't work." That doesn't tell us anything. Tell us precisely what steps you took and what you expected the result to be, and precisely what happened as a result. If there were any error messages, don't say "there was an error message". Tell us exactly what the message said. Tell us what version you're running and any other details that may be unique about your site configuration. +Other people working to fix the problem may need to find out more, so do your homework and document what is happening and everything you've tried. Don't say "I did xyz and it didn't work." That doesn't tell us anything. Tell us precisely what steps you took and what you expected the result to be, and precisely what happened as a result. What page/URL were you looking at or what form were you filling in? If there were any error messages, don't say "there was an error message". Tell us exactly what the message said. Also tell us what hub you are using, what software version you're running and any other details that may be unique about your site configuration. It is understood that you might wish to keep some information and your connections private, however if you aren't willing to share the information other people need to reproduce/fix the problem, it may not get fixed.
\ No newline at end of file diff --git a/doc/toc.html b/doc/toc.html index 11635930e..78cc74979 100644 --- a/doc/toc.html +++ b/doc/toc.html @@ -23,6 +23,7 @@ <div class="flex-column"> <a class="nav-link" href="/help/member/member_guide">Guide</a> <a class="nav-link" href="/help/member/bbcode">BBcode Reference</a> + <a class="nav-link" href="/help/bugs">Reporting Bugs</a> <a class="nav-link" href="/help/member/member_faq">FAQ</a> </div> </div> diff --git a/install/sample-nginx.conf b/install/sample-nginx.conf index 85178596a..4121ff2ec 100644 --- a/install/sample-nginx.conf +++ b/install/sample-nginx.conf @@ -56,7 +56,7 @@ server { ssl_certificate_key /etc/nginx/ssl/example.net.key; ssl_session_timeout 5m; ssl_protocols TLSv1 TLSv1.1 TLSv1.2; - ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-DSS-AES128-SHA256:DHE-DSS-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!DHE-RSA-AES128-GCM-SHA256:!DHE-RSA-AES256-GCM-SHA384:!DHE-RSA-AES128-SHA256:!DHE-RSA-AES256-SHA:!DHE-RSA-AES128-SHA:!DHE-RSA-AES256-SHA256:!DHE-RSA-CAMELLIA128-SHA:!DHE-RSA-CAMELLIA256-SHA; + ssl_ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS; ssl_prefer_server_ciphers on; fastcgi_param HTTPS on; diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 602f7ac2f..ceb63fce9 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -1,7 +1,7 @@ CREATE TABLE IF NOT EXISTS `abconfig` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `chan` int(10) unsigned NOT NULL DEFAULT '0', + `chan` int(10) unsigned NOT NULL DEFAULT 0 , `xchan` char(255) NOT NULL DEFAULT '', `cat` char(255) NOT NULL DEFAULT '', `k` char(255) NOT NULL DEFAULT '', @@ -15,26 +15,26 @@ CREATE TABLE IF NOT EXISTS `abconfig` ( CREATE TABLE IF NOT EXISTS `abook` ( `abook_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `abook_account` int(10) unsigned NOT NULL DEFAULT '0', - `abook_channel` int(10) unsigned NOT NULL DEFAULT '0', + `abook_account` int(10) unsigned NOT NULL DEFAULT 0 , + `abook_channel` int(10) unsigned NOT NULL DEFAULT 0 , `abook_xchan` char(255) NOT NULL DEFAULT '', - `abook_my_perms` int(11) NOT NULL DEFAULT '0', - `abook_their_perms` int(11) NOT NULL DEFAULT '0', - `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT '99', + `abook_my_perms` int(11) NOT NULL DEFAULT 0 , + `abook_their_perms` int(11) NOT NULL DEFAULT 0 , + `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT 99, `abook_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `abook_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `abook_connected` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `abook_dob` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `abook_flags` int(11) NOT NULL DEFAULT '0', - `abook_blocked` tinyint(4) NOT NULL DEFAULT '0', - `abook_ignored` tinyint(4) NOT NULL DEFAULT '0', - `abook_hidden` tinyint(4) NOT NULL DEFAULT '0', - `abook_archived` tinyint(4) NOT NULL DEFAULT '0', - `abook_pending` tinyint(4) NOT NULL DEFAULT '0', - `abook_unconnected` tinyint(4) NOT NULL DEFAULT '0', - `abook_self` tinyint(4) NOT NULL DEFAULT '0', - `abook_feed` tinyint(4) NOT NULL DEFAULT '0', - `abook_not_here` tinyint(4) NOT NULL DEFAULT '0', + `abook_flags` int(11) NOT NULL DEFAULT 0 , + `abook_blocked` tinyint(4) NOT NULL DEFAULT 0 , + `abook_ignored` tinyint(4) NOT NULL DEFAULT 0 , + `abook_hidden` tinyint(4) NOT NULL DEFAULT 0 , + `abook_archived` tinyint(4) NOT NULL DEFAULT 0 , + `abook_pending` tinyint(4) NOT NULL DEFAULT 0 , + `abook_unconnected` tinyint(4) NOT NULL DEFAULT 0 , + `abook_self` tinyint(4) NOT NULL DEFAULT 0 , + `abook_feed` tinyint(4) NOT NULL DEFAULT 0 , + `abook_not_here` tinyint(4) NOT NULL DEFAULT 0 , `abook_profile` char(64) NOT NULL DEFAULT '', `abook_incl` TEXT NOT NULL DEFAULT '', `abook_excl` TEXT NOT NULL DEFAULT '', @@ -65,8 +65,8 @@ CREATE TABLE IF NOT EXISTS `abook` ( CREATE TABLE IF NOT EXISTS `account` ( `account_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `account_parent` int(10) unsigned NOT NULL DEFAULT '0', - `account_default_channel` int(10) unsigned NOT NULL DEFAULT '0', + `account_parent` int(10) unsigned NOT NULL DEFAULT 0 , + `account_default_channel` int(10) unsigned NOT NULL DEFAULT 0 , `account_salt` char(32) NOT NULL DEFAULT '', `account_password` char(255) NOT NULL DEFAULT '', `account_email` char(255) NOT NULL DEFAULT '', @@ -74,13 +74,13 @@ CREATE TABLE IF NOT EXISTS `account` ( `account_language` char(16) NOT NULL DEFAULT 'en', `account_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `account_lastlog` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `account_flags` int(10) unsigned NOT NULL DEFAULT '0', - `account_roles` int(10) unsigned NOT NULL DEFAULT '0', + `account_flags` int(10) unsigned NOT NULL DEFAULT 0 , + `account_roles` int(10) unsigned NOT NULL DEFAULT 0 , `account_reset` char(255) NOT NULL DEFAULT '', `account_expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `account_expire_notified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `account_service_class` char(32) NOT NULL DEFAULT '', - `account_level` int(10) unsigned NOT NULL DEFAULT '0', + `account_level` int(10) unsigned NOT NULL DEFAULT 0 , `account_password_changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY (`account_id`), KEY `account_email` (`account_email`), @@ -100,10 +100,10 @@ CREATE TABLE IF NOT EXISTS `addon` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aname` char(255) NOT NULL DEFAULT '', `version` char(255) NOT NULL DEFAULT '', - `installed` tinyint(1) NOT NULL DEFAULT '0', - `hidden` tinyint(1) NOT NULL DEFAULT '0', - `tstamp` bigint(20) NOT NULL DEFAULT '0', - `plugin_admin` tinyint(1) NOT NULL DEFAULT '0', + `installed` tinyint(1) NOT NULL DEFAULT 0 , + `hidden` tinyint(1) NOT NULL DEFAULT 0 , + `tstamp` bigint(20) NOT NULL DEFAULT 0 , + `plugin_admin` tinyint(1) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `hidden` (`hidden`), KEY `aname` (`aname`), @@ -120,13 +120,13 @@ CREATE TABLE IF NOT EXISTS `app` ( `app_url` char(255) NOT NULL DEFAULT '', `app_photo` char(255) NOT NULL DEFAULT '', `app_version` char(255) NOT NULL DEFAULT '', - `app_channel` int(11) NOT NULL DEFAULT '0', + `app_channel` int(11) NOT NULL DEFAULT 0 , `app_addr` char(255) NOT NULL DEFAULT '', `app_price` char(255) NOT NULL DEFAULT '', `app_page` char(255) NOT NULL DEFAULT '', `app_requires` char(255) NOT NULL DEFAULT '', - `app_deleted` int(11) NOT NULL DEFAULT '0', - `app_system` int(11) NOT NULL DEFAULT '0', + `app_deleted` int(11) NOT NULL DEFAULT 0 , + `app_system` int(11) NOT NULL DEFAULT 0 , `app_plugin` char(255) NOT NULL DEFAULT '', `app_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `app_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -163,19 +163,19 @@ CREATE TABLE IF NOT EXISTS `atoken` ( CREATE TABLE IF NOT EXISTS `attach` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(10) unsigned NOT NULL DEFAULT '0', + `aid` int(10) unsigned NOT NULL DEFAULT 0 , + `uid` int(10) unsigned NOT NULL DEFAULT 0 , `hash` char(64) NOT NULL DEFAULT '', `creator` char(128) NOT NULL DEFAULT '', `filename` char(255) NOT NULL DEFAULT '', `filetype` char(64) NOT NULL DEFAULT '', - `filesize` int(10) unsigned NOT NULL DEFAULT '0', - `revision` int(10) unsigned NOT NULL DEFAULT '0', + `filesize` int(10) unsigned NOT NULL DEFAULT 0 , + `revision` int(10) unsigned NOT NULL DEFAULT 0 , `folder` char(64) NOT NULL DEFAULT '', - `flags` int(10) unsigned NOT NULL DEFAULT '0', - `is_dir` tinyint(1) NOT NULL DEFAULT '0', - `is_photo` tinyint(1) NOT NULL DEFAULT '0', - `os_storage` tinyint(1) NOT NULL DEFAULT '0', + `flags` int(10) unsigned NOT NULL DEFAULT 0 , + `is_dir` tinyint(1) NOT NULL DEFAULT 0 , + `is_photo` tinyint(1) NOT NULL DEFAULT 0 , + `os_storage` tinyint(1) NOT NULL DEFAULT 0 , `os_path` mediumtext NOT NULL, `display_path` mediumtext NOT NULL, `content` longblob NOT NULL, @@ -207,7 +207,7 @@ CREATE TABLE IF NOT EXISTS `auth_codes` ( `id` varchar(40) NOT NULL DEFAULT '', `client_id` varchar(20) NOT NULL DEFAULT '', `redirect_uri` varchar(200) NOT NULL DEFAULT '', - `expires` int(11) NOT NULL DEFAULT '0', + `expires` int(11) NOT NULL DEFAULT 0 , `auth_scope` varchar(512) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -221,8 +221,8 @@ CREATE TABLE IF NOT EXISTS `cache` ( CREATE TABLE IF NOT EXISTS `cal` ( `cal_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `cal_aid` int(10) unsigned NOT NULL DEFAULT '0', - `cal_uid` int(10) unsigned NOT NULL DEFAULT '0', + `cal_aid` int(10) unsigned NOT NULL DEFAULT 0 , + `cal_uid` int(10) unsigned NOT NULL DEFAULT 0 , `cal_hash` varchar(255) NOT NULL DEFAULT '', `cal_name` varchar(255) NOT NULL DEFAULT '', `uri` varchar(255) NOT NULL DEFAULT '', @@ -241,8 +241,8 @@ CREATE TABLE IF NOT EXISTS `cal` ( CREATE TABLE IF NOT EXISTS `channel` ( `channel_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel_account_id` int(10) unsigned NOT NULL DEFAULT '0', - `channel_primary` tinyint(1) unsigned NOT NULL DEFAULT '0', + `channel_account_id` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_primary` tinyint(1) unsigned NOT NULL DEFAULT 0 , `channel_name` char(255) NOT NULL DEFAULT '', `channel_address` char(255) NOT NULL DEFAULT '', `channel_guid` char(255) NOT NULL DEFAULT '', @@ -254,40 +254,40 @@ CREATE TABLE IF NOT EXISTS `channel` ( `channel_startpage` char(255) NOT NULL DEFAULT '', `channel_pubkey` text NOT NULL, `channel_prvkey` text NOT NULL, - `channel_notifyflags` int(10) unsigned NOT NULL DEFAULT '65535', - `channel_pageflags` int(10) unsigned NOT NULL DEFAULT '0', + `channel_notifyflags` int(10) unsigned NOT NULL DEFAULT 65535, + `channel_pageflags` int(10) unsigned NOT NULL DEFAULT 0 , `channel_dirdate` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `channel_lastpost` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `channel_deleted` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `channel_max_anon_mail` int(10) unsigned NOT NULL DEFAULT '10', - `channel_max_friend_req` int(10) unsigned NOT NULL DEFAULT '10', - `channel_expire_days` int(11) NOT NULL DEFAULT '0', + `channel_max_anon_mail` int(10) unsigned NOT NULL DEFAULT 10, + `channel_max_friend_req` int(10) unsigned NOT NULL DEFAULT 10, + `channel_expire_days` int(11) NOT NULL DEFAULT 0 , `channel_passwd_reset` char(255) NOT NULL DEFAULT '', `channel_default_group` char(255) NOT NULL DEFAULT '', `channel_allow_cid` mediumtext NOT NULL, `channel_allow_gid` mediumtext NOT NULL, `channel_deny_cid` mediumtext NOT NULL, `channel_deny_gid` mediumtext NOT NULL, - `channel_r_stream` int(10) unsigned NOT NULL DEFAULT '0', - `channel_r_profile` int(10) unsigned NOT NULL DEFAULT '0', - `channel_r_photos` int(10) unsigned NOT NULL DEFAULT '0', - `channel_r_abook` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_stream` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_wall` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_comment` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_mail` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_photos` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_chat` int(10) unsigned NOT NULL DEFAULT '0', - `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT '0', - `channel_r_storage` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_storage` int(10) unsigned NOT NULL DEFAULT '0', - `channel_r_pages` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_pages` int(10) unsigned NOT NULL DEFAULT '0', - `channel_a_republish` int(10) unsigned NOT NULL DEFAULT '0', - `channel_w_like` int(10) unsigned NOT NULL DEFAULT '0', - `channel_removed` tinyint(1) NOT NULL DEFAULT '0', - `channel_system` tinyint(1) NOT NULL DEFAULT '0', + `channel_r_stream` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_r_profile` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_r_photos` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_r_abook` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_stream` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_wall` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_tagwall` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_comment` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_mail` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_photos` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_chat` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_a_delegate` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_r_storage` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_storage` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_r_pages` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_pages` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_a_republish` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_w_like` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_removed` tinyint(1) NOT NULL DEFAULT 0 , + `channel_system` tinyint(1) NOT NULL DEFAULT 0 , `channel_moved` char(255) NOT NULL DEFAULT '', `channel_password` varchar(255) NOT NULL, `channel_salt` varchar(255) NOT NULL, @@ -335,7 +335,7 @@ CREATE TABLE IF NOT EXISTS `channel` ( CREATE TABLE IF NOT EXISTS `chat` ( `chat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `chat_room` int(10) unsigned NOT NULL DEFAULT '0', + `chat_room` int(10) unsigned NOT NULL DEFAULT 0 , `chat_xchan` char(255) NOT NULL DEFAULT '', `chat_text` mediumtext NOT NULL, `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -347,7 +347,7 @@ CREATE TABLE IF NOT EXISTS `chat` ( CREATE TABLE IF NOT EXISTS `chatpresence` ( `cp_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `cp_room` int(10) unsigned NOT NULL DEFAULT '0', + `cp_room` int(10) unsigned NOT NULL DEFAULT 0 , `cp_xchan` char(255) NOT NULL DEFAULT '', `cp_last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `cp_status` char(255) NOT NULL DEFAULT '', @@ -361,12 +361,12 @@ CREATE TABLE IF NOT EXISTS `chatpresence` ( CREATE TABLE IF NOT EXISTS `chatroom` ( `cr_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `cr_aid` int(10) unsigned NOT NULL DEFAULT '0', - `cr_uid` int(10) unsigned NOT NULL DEFAULT '0', + `cr_aid` int(10) unsigned NOT NULL DEFAULT 0 , + `cr_uid` int(10) unsigned NOT NULL DEFAULT 0 , `cr_name` char(255) NOT NULL DEFAULT '', `cr_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `cr_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `cr_expire` int(10) unsigned NOT NULL DEFAULT '0', + `cr_expire` int(10) unsigned NOT NULL DEFAULT 0 , `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, @@ -386,7 +386,7 @@ CREATE TABLE IF NOT EXISTS `clients` ( `redirect_uri` varchar(200) NOT NULL DEFAULT '', `clname` text, `icon` text, - `uid` int(11) NOT NULL DEFAULT '0', + `uid` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`client_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -403,7 +403,7 @@ CREATE TABLE IF NOT EXISTS `conv` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `guid` char(255) NOT NULL DEFAULT '', `recips` mediumtext NOT NULL, - `uid` int(11) NOT NULL DEFAULT '0', + `uid` int(11) NOT NULL DEFAULT 0 , `creator` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -415,7 +415,7 @@ CREATE TABLE IF NOT EXISTS `conv` ( CREATE TABLE IF NOT EXISTS `dreport` ( `dreport_id` int(11) NOT NULL AUTO_INCREMENT, - `dreport_channel` int(11) NOT NULL DEFAULT '0', + `dreport_channel` int(11) NOT NULL DEFAULT 0 , `dreport_mid` char(255) NOT NULL DEFAULT '', `dreport_site` char(255) NOT NULL DEFAULT '', `dreport_recip` char(255) NOT NULL DEFAULT '', @@ -434,9 +434,9 @@ CREATE TABLE IF NOT EXISTS `dreport` ( CREATE TABLE IF NOT EXISTS `event` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(11) NOT NULL DEFAULT '0', - `cal_id` int(11) unsigned NOT NULL DEFAULT '0', + `aid` int(10) unsigned NOT NULL DEFAULT 0 , + `uid` int(11) NOT NULL DEFAULT 0 , + `cal_id` int(11) unsigned NOT NULL DEFAULT 0 , `event_xchan` char(255) NOT NULL DEFAULT '', `event_hash` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -447,19 +447,19 @@ CREATE TABLE IF NOT EXISTS `event` ( `description` text NOT NULL, `location` text NOT NULL, `etype` char(255) NOT NULL DEFAULT '', - `nofinish` tinyint(1) NOT NULL DEFAULT '0', - `adjust` tinyint(1) NOT NULL DEFAULT '1', - `dismissed` tinyint(1) NOT NULL DEFAULT '0', + `nofinish` tinyint(1) NOT NULL DEFAULT 0 , + `adjust` tinyint(1) NOT NULL DEFAULT 1, + `dismissed` tinyint(1) NOT NULL DEFAULT 0 , `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, `event_status` char(255) NOT NULL DEFAULT '', `event_status_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `event_percent` smallint(6) NOT NULL DEFAULT '0', + `event_percent` smallint(6) NOT NULL DEFAULT 0 , `event_repeat` text NOT NULL, - `event_sequence` smallint(6) NOT NULL DEFAULT '0', - `event_priority` smallint(6) NOT NULL DEFAULT '0', + `event_sequence` smallint(6) NOT NULL DEFAULT 0 , + `event_priority` smallint(6) NOT NULL DEFAULT 0 , `event_vdata` text NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -481,9 +481,9 @@ CREATE TABLE IF NOT EXISTS `event` ( CREATE TABLE IF NOT EXISTS `groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `hash` char(255) NOT NULL DEFAULT '', - `uid` int(10) unsigned NOT NULL DEFAULT '0', - `visible` tinyint(1) NOT NULL DEFAULT '0', - `deleted` tinyint(1) NOT NULL DEFAULT '0', + `uid` int(10) unsigned NOT NULL DEFAULT 0 , + `visible` tinyint(1) NOT NULL DEFAULT 0 , + `deleted` tinyint(1) NOT NULL DEFAULT 0 , `gname` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -495,8 +495,8 @@ CREATE TABLE IF NOT EXISTS `groups` ( CREATE TABLE IF NOT EXISTS `group_member` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `uid` int(10) unsigned NOT NULL DEFAULT '0', - `gid` int(10) unsigned NOT NULL DEFAULT '0', + `uid` int(10) unsigned NOT NULL DEFAULT 0 , + `gid` int(10) unsigned NOT NULL DEFAULT 0 , `xchan` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -509,8 +509,8 @@ CREATE TABLE IF NOT EXISTS `hook` ( `hook` char(255) NOT NULL DEFAULT '', `file` char(255) NOT NULL DEFAULT '', `fn` char(255) NOT NULL DEFAULT '', - `priority` smallint NOT NULL DEFAULT '0', - `hook_version` int(11) NOT NULL DEFAULT '0', + `priority` smallint NOT NULL DEFAULT 0 , + `hook_version` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `hook` (`hook`), KEY `priority` (`priority`), @@ -524,8 +524,8 @@ CREATE TABLE IF NOT EXISTS `hubloc` ( `hubloc_hash` char(255) NOT NULL DEFAULT '', `hubloc_addr` char(255) NOT NULL DEFAULT '', `hubloc_network` char(32) NOT NULL DEFAULT '', - `hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0', - `hubloc_status` int(10) unsigned NOT NULL DEFAULT '0', + `hubloc_flags` int(10) unsigned NOT NULL DEFAULT 0 , + `hubloc_status` int(10) unsigned NOT NULL DEFAULT 0 , `hubloc_url` char(255) NOT NULL DEFAULT '', `hubloc_url_sig` text NOT NULL, `hubloc_host` char(255) NOT NULL DEFAULT '', @@ -534,10 +534,10 @@ CREATE TABLE IF NOT EXISTS `hubloc` ( `hubloc_sitekey` text NOT NULL, `hubloc_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `hubloc_connected` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `hubloc_primary` tinyint(1) NOT NULL DEFAULT '0', - `hubloc_orphancheck` tinyint(1) NOT NULL DEFAULT '0', - `hubloc_error` tinyint(1) NOT NULL DEFAULT '0', - `hubloc_deleted` tinyint(1) NOT NULL DEFAULT '0', + `hubloc_primary` tinyint(1) NOT NULL DEFAULT 0 , + `hubloc_orphancheck` tinyint(1) NOT NULL DEFAULT 0 , + `hubloc_error` tinyint(1) NOT NULL DEFAULT 0 , + `hubloc_deleted` tinyint(1) NOT NULL DEFAULT 0 , PRIMARY KEY (`hubloc_id`), KEY `hubloc_url` (`hubloc_url`), KEY `hubloc_guid` (`hubloc_guid`), @@ -558,11 +558,11 @@ CREATE TABLE IF NOT EXISTS `hubloc` ( CREATE TABLE IF NOT EXISTS `iconfig` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `iid` int(11) NOT NULL DEFAULT '0', + `iid` int(11) NOT NULL DEFAULT 0 , `cat` char(255) NOT NULL DEFAULT '', `k` char(255) NOT NULL DEFAULT '', `v` mediumtext NOT NULL, - `sharing` int(11) NOT NULL DEFAULT '0', + `sharing` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `iid` (`iid`), KEY `cat` (`cat`), @@ -575,8 +575,8 @@ CREATE TABLE IF NOT EXISTS `issue` ( `issue_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `issue_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `issue_assigned` char(255) NOT NULL DEFAULT '', - `issue_priority` int(11) NOT NULL DEFAULT '0', - `issue_status` int(11) NOT NULL DEFAULT '0', + `issue_priority` int(11) NOT NULL DEFAULT 0 , + `issue_status` int(11) NOT NULL DEFAULT 0 , `issue_component` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`issue_id`), KEY `issue_created` (`issue_created`), @@ -590,9 +590,9 @@ CREATE TABLE IF NOT EXISTS `issue` ( CREATE TABLE IF NOT EXISTS `item` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mid` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(10) unsigned NOT NULL DEFAULT '0', - `parent` int(10) unsigned NOT NULL DEFAULT '0', + `aid` int(10) unsigned NOT NULL DEFAULT 0 , + `uid` int(10) unsigned NOT NULL DEFAULT 0 , + `parent` int(10) unsigned NOT NULL DEFAULT 0 , `parent_mid` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', `thr_parent` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -611,7 +611,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `html` mediumtext NOT NULL, `app` char(255) NOT NULL DEFAULT '', `lang` char(64) NOT NULL DEFAULT '', - `revision` int(10) unsigned NOT NULL DEFAULT '0', + `revision` int(10) unsigned NOT NULL DEFAULT 0 , `verb` char(255) NOT NULL DEFAULT '', `obj_type` char(255) NOT NULL DEFAULT '', `obj` text NOT NULL, @@ -635,32 +635,32 @@ CREATE TABLE IF NOT EXISTS `item` ( `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, - `item_restrict` int(11) NOT NULL DEFAULT '0', - `item_flags` int(11) NOT NULL DEFAULT '0', - `item_private` tinyint(1) NOT NULL DEFAULT '0', - `item_origin` tinyint(1) NOT NULL DEFAULT '0', - `item_unseen` tinyint(1) NOT NULL DEFAULT '0', - `item_starred` tinyint(1) NOT NULL DEFAULT '0', - `item_uplink` tinyint(1) NOT NULL DEFAULT '0', - `item_consensus` tinyint(1) NOT NULL DEFAULT '0', - `item_wall` tinyint(1) NOT NULL DEFAULT '0', - `item_thread_top` tinyint(1) NOT NULL DEFAULT '0', - `item_notshown` tinyint(1) NOT NULL DEFAULT '0', - `item_nsfw` tinyint(1) NOT NULL DEFAULT '0', - `item_relay` tinyint(1) NOT NULL DEFAULT '0', - `item_mentionsme` tinyint(1) NOT NULL DEFAULT '0', - `item_nocomment` tinyint(1) NOT NULL DEFAULT '0', - `item_obscured` tinyint(1) NOT NULL DEFAULT '0', - `item_verified` tinyint(1) NOT NULL DEFAULT '0', - `item_retained` tinyint(1) NOT NULL DEFAULT '0', - `item_rss` tinyint(1) NOT NULL DEFAULT '0', - `item_deleted` tinyint(1) NOT NULL DEFAULT '0', - `item_type` int(11) NOT NULL DEFAULT '0', - `item_hidden` tinyint(1) NOT NULL DEFAULT '0', - `item_unpublished` tinyint(1) NOT NULL DEFAULT '0', - `item_delayed` tinyint(1) NOT NULL DEFAULT '0', - `item_pending_remove` tinyint(1) NOT NULL DEFAULT '0', - `item_blocked` tinyint(1) NOT NULL DEFAULT '0', + `item_restrict` int(11) NOT NULL DEFAULT 0 , + `item_flags` int(11) NOT NULL DEFAULT 0 , + `item_private` tinyint(1) NOT NULL DEFAULT 0 , + `item_origin` tinyint(1) NOT NULL DEFAULT 0 , + `item_unseen` tinyint(1) NOT NULL DEFAULT 0 , + `item_starred` tinyint(1) NOT NULL DEFAULT 0 , + `item_uplink` tinyint(1) NOT NULL DEFAULT 0 , + `item_consensus` tinyint(1) NOT NULL DEFAULT 0 , + `item_wall` tinyint(1) NOT NULL DEFAULT 0 , + `item_thread_top` tinyint(1) NOT NULL DEFAULT 0 , + `item_notshown` tinyint(1) NOT NULL DEFAULT 0 , + `item_nsfw` tinyint(1) NOT NULL DEFAULT 0 , + `item_relay` tinyint(1) NOT NULL DEFAULT 0 , + `item_mentionsme` tinyint(1) NOT NULL DEFAULT 0 , + `item_nocomment` tinyint(1) NOT NULL DEFAULT 0 , + `item_obscured` tinyint(1) NOT NULL DEFAULT 0 , + `item_verified` tinyint(1) NOT NULL DEFAULT 0 , + `item_retained` tinyint(1) NOT NULL DEFAULT 0 , + `item_rss` tinyint(1) NOT NULL DEFAULT 0 , + `item_deleted` tinyint(1) NOT NULL DEFAULT 0 , + `item_type` int(11) NOT NULL DEFAULT 0 , + `item_hidden` tinyint(1) NOT NULL DEFAULT 0 , + `item_unpublished` tinyint(1) NOT NULL DEFAULT 0 , + `item_delayed` tinyint(1) NOT NULL DEFAULT 0 , + `item_pending_remove` tinyint(1) NOT NULL DEFAULT 0 , + `item_blocked` tinyint(1) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `parent` (`parent`), @@ -723,8 +723,8 @@ CREATE TABLE IF NOT EXISTS `item` ( CREATE TABLE IF NOT EXISTS `item_id` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `iid` int(11) NOT NULL DEFAULT '0', - `uid` int(11) NOT NULL DEFAULT '0', + `iid` int(11) NOT NULL DEFAULT 0 , + `uid` int(11) NOT NULL DEFAULT 0 , `sid` char(255) NOT NULL DEFAULT '', `service` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -736,10 +736,10 @@ CREATE TABLE IF NOT EXISTS `item_id` ( CREATE TABLE IF NOT EXISTS `likes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel_id` int(10) unsigned NOT NULL DEFAULT '0', + `channel_id` int(10) unsigned NOT NULL DEFAULT 0 , `liker` char(128) NOT NULL DEFAULT '', `likee` char(128) NOT NULL DEFAULT '', - `iid` int(11) unsigned NOT NULL DEFAULT '0', + `iid` int(11) unsigned NOT NULL DEFAULT 0 , `i_mid` char(255) NOT NULL DEFAULT '', `verb` char(255) NOT NULL DEFAULT '', `target_type` char(255) NOT NULL DEFAULT '', @@ -758,13 +758,13 @@ CREATE TABLE IF NOT EXISTS `likes` ( CREATE TABLE IF NOT EXISTS `mail` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `convid` int(10) unsigned NOT NULL DEFAULT '0', + `convid` int(10) unsigned NOT NULL DEFAULT 0 , `conv_guid` char(255) NOT NULL DEFAULT '', - `mail_flags` int(10) unsigned NOT NULL DEFAULT '0', + `mail_flags` int(10) unsigned NOT NULL DEFAULT 0 , `from_xchan` char(255) NOT NULL DEFAULT '', `to_xchan` char(255) NOT NULL DEFAULT '', - `account_id` int(10) unsigned NOT NULL DEFAULT '0', - `channel_id` int(10) unsigned NOT NULL DEFAULT '0', + `account_id` int(10) unsigned NOT NULL DEFAULT 0 , + `channel_id` int(10) unsigned NOT NULL DEFAULT 0 , `mail_mimetype` char(64) NOT NULL DEFAULT 'text/bbcode', `title` text NOT NULL, `body` mediumtext NOT NULL, @@ -772,13 +772,13 @@ CREATE TABLE IF NOT EXISTS `mail` ( `attach` mediumtext NOT NULL, `mid` char(255) NOT NULL DEFAULT '', `parent_mid` char(255) NOT NULL DEFAULT '', - `mail_deleted` tinyint(4) NOT NULL DEFAULT '0', - `mail_replied` tinyint(4) NOT NULL DEFAULT '0', - `mail_isreply` tinyint(4) NOT NULL DEFAULT '0', - `mail_seen` tinyint(4) NOT NULL DEFAULT '0', - `mail_recalled` tinyint(4) NOT NULL DEFAULT '0', - `mail_obscured` smallint(6) NOT NULL DEFAULT '0', - `mail_raw` tinyint(4) NOT NULL DEFAULT '0', + `mail_deleted` tinyint(4) NOT NULL DEFAULT 0 , + `mail_replied` tinyint(4) NOT NULL DEFAULT 0 , + `mail_isreply` tinyint(4) NOT NULL DEFAULT 0 , + `mail_seen` tinyint(4) NOT NULL DEFAULT 0 , + `mail_recalled` tinyint(4) NOT NULL DEFAULT 0 , + `mail_obscured` smallint(6) NOT NULL DEFAULT 0 , + `mail_raw` tinyint(4) NOT NULL DEFAULT 0 , `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY (`id`), @@ -803,10 +803,10 @@ CREATE TABLE IF NOT EXISTS `mail` ( CREATE TABLE IF NOT EXISTS `menu` ( `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `menu_channel_id` int(10) unsigned NOT NULL DEFAULT '0', + `menu_channel_id` int(10) unsigned NOT NULL DEFAULT 0 , `menu_name` char(255) NOT NULL DEFAULT '', `menu_desc` char(255) NOT NULL DEFAULT '', - `menu_flags` int(11) NOT NULL DEFAULT '0', + `menu_flags` int(11) NOT NULL DEFAULT 0 , `menu_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `menu_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY (`menu_id`), @@ -821,14 +821,14 @@ CREATE TABLE IF NOT EXISTS `menu_item` ( `mitem_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mitem_link` char(255) NOT NULL DEFAULT '', `mitem_desc` char(255) NOT NULL DEFAULT '', - `mitem_flags` int(11) NOT NULL DEFAULT '0', + `mitem_flags` int(11) NOT NULL DEFAULT 0 , `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, - `mitem_channel_id` int(10) unsigned NOT NULL DEFAULT '0', - `mitem_menu_id` int(10) unsigned NOT NULL DEFAULT '0', - `mitem_order` int(11) NOT NULL DEFAULT '0', + `mitem_channel_id` int(10) unsigned NOT NULL DEFAULT 0 , + `mitem_menu_id` int(10) unsigned NOT NULL DEFAULT 0 , + `mitem_order` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`mitem_id`), KEY `mitem_channel_id` (`mitem_channel_id`), KEY `mitem_menu_id` (`mitem_menu_id`), @@ -843,12 +843,12 @@ CREATE TABLE IF NOT EXISTS `notify` ( `photo` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `msg` mediumtext NOT NULL, - `aid` int(11) NOT NULL DEFAULT '0', - `uid` int(11) NOT NULL DEFAULT '0', + `aid` int(11) NOT NULL DEFAULT 0 , + `uid` int(11) NOT NULL DEFAULT 0 , `link` char(255) NOT NULL DEFAULT '', `parent` char(255) NOT NULL DEFAULT '', - `seen` tinyint(1) NOT NULL DEFAULT '0', - `ntype` int(11) NOT NULL DEFAULT '0', + `seen` tinyint(1) NOT NULL DEFAULT 0 , + `ntype` int(11) NOT NULL DEFAULT 0 , `verb` char(255) NOT NULL DEFAULT '', `otype` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -867,15 +867,15 @@ CREATE TABLE IF NOT EXISTS `obj` ( `obj_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `obj_page` char(64) NOT NULL DEFAULT '', `obj_verb` char(255) NOT NULL DEFAULT '', - `obj_type` int(10) unsigned NOT NULL DEFAULT '0', + `obj_type` int(10) unsigned NOT NULL DEFAULT 0 , `obj_obj` char(255) NOT NULL DEFAULT '', - `obj_channel` int(10) unsigned NOT NULL DEFAULT '0', + `obj_channel` int(10) unsigned NOT NULL DEFAULT 0 , `obj_term` char(255) NOT NULL DEFAULT '', `obj_url` char(255) NOT NULL DEFAULT '', `obj_imgurl` char(255) NOT NULL DEFAULT '', `obj_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `obj_edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `obj_quantity` int(11) NOT NULL DEFAULT '0', + `obj_quantity` int(11) NOT NULL DEFAULT 0 , `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, @@ -896,18 +896,18 @@ CREATE TABLE IF NOT EXISTS `obj` ( CREATE TABLE IF NOT EXISTS `outq` ( `outq_hash` char(255) NOT NULL, - `outq_account` int(10) unsigned NOT NULL DEFAULT '0', - `outq_channel` int(10) unsigned NOT NULL DEFAULT '0', + `outq_account` int(10) unsigned NOT NULL DEFAULT 0 , + `outq_channel` int(10) unsigned NOT NULL DEFAULT 0 , `outq_driver` char(32) NOT NULL DEFAULT '', `outq_posturl` char(255) NOT NULL DEFAULT '', - `outq_async` tinyint(1) NOT NULL DEFAULT '0', - `outq_delivered` tinyint(1) NOT NULL DEFAULT '0', + `outq_async` tinyint(1) NOT NULL DEFAULT 0 , + `outq_delivered` tinyint(1) NOT NULL DEFAULT 0 , `outq_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `outq_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `outq_scheduled` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `outq_notify` mediumtext NOT NULL, `outq_msg` mediumtext NOT NULL, - `outq_priority` smallint(6) NOT NULL DEFAULT '0', + `outq_priority` smallint(6) NOT NULL DEFAULT 0 , PRIMARY KEY (`outq_hash`), KEY `outq_account` (`outq_account`), KEY `outq_channel` (`outq_channel`), @@ -922,7 +922,7 @@ CREATE TABLE IF NOT EXISTS `outq` ( CREATE TABLE IF NOT EXISTS `pconfig` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `uid` int(11) NOT NULL DEFAULT '0', + `uid` int(11) NOT NULL DEFAULT 0 , `cat` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', `k` char(255) CHARACTER SET ascii NOT NULL DEFAULT '', `v` mediumtext NOT NULL, @@ -933,8 +933,8 @@ CREATE TABLE IF NOT EXISTS `pconfig` ( CREATE TABLE IF NOT EXISTS `photo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(10) unsigned NOT NULL DEFAULT '0', + `aid` int(10) unsigned NOT NULL DEFAULT 0 , + `uid` int(10) unsigned NOT NULL DEFAULT 0 , `xchan` char(255) NOT NULL DEFAULT '', `resource_id` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -944,18 +944,18 @@ CREATE TABLE IF NOT EXISTS `photo` ( `album` char(255) NOT NULL DEFAULT '', `filename` char(255) NOT NULL DEFAULT '', `mimetype` char(128) NOT NULL DEFAULT 'image/jpeg', - `height` smallint(6) NOT NULL DEFAULT '0', - `width` smallint(6) NOT NULL DEFAULT '0', - `filesize` int(10) unsigned NOT NULL DEFAULT '0', + `height` smallint(6) NOT NULL DEFAULT 0 , + `width` smallint(6) NOT NULL DEFAULT 0 , + `filesize` int(10) unsigned NOT NULL DEFAULT 0 , `content` mediumblob NOT NULL, - `imgscale` tinyint(3) NOT NULL DEFAULT '0', - `photo_usage` smallint(6) NOT NULL DEFAULT '0', - `profile` tinyint(1) NOT NULL DEFAULT '0', - `is_nsfw` tinyint(1) NOT NULL DEFAULT '0', - `os_storage` tinyint(1) NOT NULL DEFAULT '0', + `imgscale` tinyint(3) NOT NULL DEFAULT 0 , + `photo_usage` smallint(6) NOT NULL DEFAULT 0 , + `profile` tinyint(1) NOT NULL DEFAULT 0 , + `is_nsfw` tinyint(1) NOT NULL DEFAULT 0 , + `os_storage` tinyint(1) NOT NULL DEFAULT 0 , `os_path` mediumtext NOT NULL, `display_path` mediumtext NOT NULL, - `photo_flags` int(10) unsigned NOT NULL DEFAULT '0', + `photo_flags` int(10) unsigned NOT NULL DEFAULT 0 , `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, @@ -978,10 +978,10 @@ CREATE TABLE IF NOT EXISTS `photo` ( CREATE TABLE IF NOT EXISTS `poll` ( `poll_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `poll_channel` int(10) unsigned NOT NULL DEFAULT '0', + `poll_channel` int(10) unsigned NOT NULL DEFAULT 0 , `poll_desc` text NOT NULL, - `poll_flags` int(11) NOT NULL DEFAULT '0', - `poll_votes` int(11) NOT NULL DEFAULT '0', + `poll_flags` int(11) NOT NULL DEFAULT 0 , + `poll_votes` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`poll_id`), KEY `poll_channel` (`poll_channel`), KEY `poll_flags` (`poll_flags`), @@ -990,10 +990,10 @@ CREATE TABLE IF NOT EXISTS `poll` ( CREATE TABLE IF NOT EXISTS `poll_elm` ( `pelm_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `pelm_poll` int(10) unsigned NOT NULL DEFAULT '0', + `pelm_poll` int(10) unsigned NOT NULL DEFAULT 0 , `pelm_desc` text NOT NULL, - `pelm_flags` int(11) NOT NULL DEFAULT '0', - `pelm_result` float NOT NULL DEFAULT '0', + `pelm_flags` int(11) NOT NULL DEFAULT 0 , + `pelm_result` float NOT NULL DEFAULT 0 , PRIMARY KEY (`pelm_id`), KEY `pelm_poll` (`pelm_poll`), KEY `pelm_result` (`pelm_result`) @@ -1012,7 +1012,7 @@ CREATE TABLE IF NOT EXISTS `profdef` ( CREATE TABLE IF NOT EXISTS `profext` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel_id` int(10) unsigned NOT NULL DEFAULT '0', + `channel_id` int(10) unsigned NOT NULL DEFAULT 0 , `hash` char(255) NOT NULL DEFAULT '', `k` char(255) NOT NULL DEFAULT '', `v` mediumtext NOT NULL, @@ -1025,11 +1025,11 @@ CREATE TABLE IF NOT EXISTS `profext` ( CREATE TABLE IF NOT EXISTS `profile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile_guid` char(64) NOT NULL DEFAULT '', - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(11) NOT NULL DEFAULT '0', + `aid` int(10) unsigned NOT NULL DEFAULT 0 , + `uid` int(11) NOT NULL DEFAULT 0 , `profile_name` char(255) NOT NULL DEFAULT '', - `is_default` tinyint(1) NOT NULL DEFAULT '0', - `hide_friends` tinyint(1) NOT NULL DEFAULT '0', + `is_default` tinyint(1) NOT NULL DEFAULT 0 , + `hide_friends` tinyint(1) NOT NULL DEFAULT 0 , `fullname` char(255) NOT NULL DEFAULT '', `pdesc` char(255) NOT NULL DEFAULT '', `chandesc` text NOT NULL, @@ -1066,7 +1066,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `homepage` char(255) NOT NULL DEFAULT '', `photo` char(255) NOT NULL DEFAULT '', `thumb` char(255) NOT NULL DEFAULT '', - `publish` tinyint(1) NOT NULL DEFAULT '0', + `publish` tinyint(1) NOT NULL DEFAULT 0 , `profile_vcard` text NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `guid` (`profile_guid`,`uid`), @@ -1087,11 +1087,11 @@ 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 DEFAULT '0', - `cid` int(10) unsigned NOT NULL DEFAULT '0', + `uid` int(10) unsigned NOT NULL DEFAULT 0 , + `cid` int(10) unsigned NOT NULL DEFAULT 0 , `dfrn_id` char(255) NOT NULL DEFAULT '', `sec` char(255) NOT NULL DEFAULT '', - `expire` int(11) NOT NULL DEFAULT '0', + `expire` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `cid` (`cid`), @@ -1104,7 +1104,7 @@ CREATE TABLE IF NOT EXISTS `register` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `hash` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `uid` int(10) unsigned NOT NULL DEFAULT '0', + `uid` int(10) unsigned NOT NULL DEFAULT 0 , `password` char(255) NOT NULL DEFAULT '', `lang` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`), @@ -1117,7 +1117,7 @@ CREATE TABLE IF NOT EXISTS `session` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` char(255) NOT NULL DEFAULT '', `sess_data` text NOT NULL, - `expire` bigint(20) unsigned NOT NULL DEFAULT '0', + `expire` bigint(20) unsigned NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `sid` (`sid`), KEY `expire` (`expire`) @@ -1125,8 +1125,8 @@ CREATE TABLE IF NOT EXISTS `session` ( CREATE TABLE IF NOT EXISTS `shares` ( `share_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `share_type` int(11) NOT NULL DEFAULT '0', - `share_target` int(10) unsigned NOT NULL DEFAULT '0', + `share_type` int(11) NOT NULL DEFAULT 0 , + `share_target` int(10) unsigned NOT NULL DEFAULT 0 , `share_xchan` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`share_id`), KEY `share_type` (`share_type`), @@ -1136,8 +1136,8 @@ CREATE TABLE IF NOT EXISTS `shares` ( CREATE TABLE IF NOT EXISTS `sign` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `iid` int(10) unsigned NOT NULL DEFAULT '0', - `retract_iid` int(10) unsigned NOT NULL DEFAULT '0', + `iid` int(10) unsigned NOT NULL DEFAULT 0 , + `retract_iid` int(10) unsigned NOT NULL DEFAULT 0 , `signed_text` mediumtext NOT NULL, `signature` text NOT NULL, `signer` char(255) NOT NULL DEFAULT '', @@ -1148,19 +1148,19 @@ CREATE TABLE IF NOT EXISTS `sign` ( CREATE TABLE IF NOT EXISTS `site` ( `site_url` char(255) NOT NULL, - `site_access` int(11) NOT NULL DEFAULT '0', - `site_flags` int(11) NOT NULL DEFAULT '0', + `site_access` int(11) NOT NULL DEFAULT 0 , + `site_flags` int(11) NOT NULL DEFAULT 0 , `site_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `site_pull` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `site_sync` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `site_directory` char(255) NOT NULL DEFAULT '', - `site_register` int(11) NOT NULL DEFAULT '0', + `site_register` int(11) NOT NULL DEFAULT 0 , `site_sellpage` char(255) NOT NULL DEFAULT '', `site_location` char(255) NOT NULL DEFAULT '', `site_realm` char(255) NOT NULL DEFAULT '', - `site_valid` smallint NOT NULL DEFAULT '0', - `site_dead` smallint NOT NULL DEFAULT '0', - `site_type` smallint NOT NULL DEFAULT '0', + `site_valid` smallint NOT NULL DEFAULT 0 , + `site_dead` smallint NOT NULL DEFAULT 0 , + `site_type` smallint NOT NULL DEFAULT 0 , `site_project` char(255) NOT NULL DEFAULT '', `site_version` varchar(32) NOT NULL DEFAULT '', `site_crypto` text NOT NULL DEFAULT '', @@ -1181,7 +1181,7 @@ CREATE TABLE IF NOT EXISTS `site` ( CREATE TABLE IF NOT EXISTS `source` ( `src_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `src_channel_id` int(10) unsigned NOT NULL DEFAULT '0', + `src_channel_id` int(10) unsigned NOT NULL DEFAULT 0 , `src_channel_xchan` char(255) NOT NULL DEFAULT '', `src_xchan` char(255) NOT NULL DEFAULT '', `src_patt` mediumtext NOT NULL, @@ -1197,17 +1197,17 @@ CREATE TABLE IF NOT EXISTS `sys_perms` ( `cat` char(255) NOT NULL DEFAULT '', `k` char(255) NOT NULL DEFAULT '', `v` mediumtext NOT NULL, - `public_perm` tinyint(1) unsigned NOT NULL DEFAULT '0', + `public_perm` tinyint(1) unsigned NOT NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `term` ( `tid` int(10) unsigned NOT NULL AUTO_INCREMENT, - `aid` int(10) unsigned NOT NULL DEFAULT '0', - `uid` int(10) unsigned NOT NULL DEFAULT '0', - `oid` int(10) unsigned NOT NULL DEFAULT '0', - `otype` tinyint(3) unsigned NOT NULL DEFAULT '0', - `ttype` tinyint(3) unsigned NOT NULL DEFAULT '0', + `aid` int(10) unsigned NOT NULL DEFAULT 0 , + `uid` int(10) unsigned NOT NULL DEFAULT 0 , + `oid` int(10) unsigned NOT NULL DEFAULT 0 , + `otype` tinyint(3) unsigned NOT NULL DEFAULT 0 , + `ttype` tinyint(3) unsigned NOT NULL DEFAULT 0 , `term` char(255) NOT NULL DEFAULT '', `url` char(255) NOT NULL DEFAULT '', `imgurl` char(255) NOT NULL DEFAULT '', @@ -1229,9 +1229,9 @@ CREATE TABLE IF NOT EXISTS `tokens` ( `id` varchar(40) NOT NULL DEFAULT '', `secret` text NOT NULL, `client_id` varchar(20) NOT NULL DEFAULT '', - `expires` bigint(20) unsigned NOT NULL DEFAULT '0', + `expires` bigint(20) unsigned NOT NULL DEFAULT 0 , `auth_scope` varchar(512) NOT NULL DEFAULT '', - `uid` int(11) NOT NULL DEFAULT '0', + `uid` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), KEY `client_id` (`client_id`), KEY `expires` (`expires`), @@ -1244,7 +1244,7 @@ CREATE TABLE IF NOT EXISTS `updates` ( `ud_guid` char(255) NOT NULL DEFAULT '', `ud_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `ud_last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `ud_flags` int(11) NOT NULL DEFAULT '0', + `ud_flags` int(11) NOT NULL DEFAULT 0 , `ud_addr` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`ud_id`), KEY `ud_date` (`ud_date`), @@ -1257,7 +1257,7 @@ CREATE TABLE IF NOT EXISTS `updates` ( CREATE TABLE IF NOT EXISTS `verify` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `channel` int(10) unsigned NOT NULL DEFAULT '0', + `channel` int(10) unsigned NOT NULL DEFAULT 0 , `vtype` char(32) NOT NULL DEFAULT '', `token` char(255) NOT NULL DEFAULT '', `meta` char(255) NOT NULL DEFAULT '', @@ -1272,8 +1272,8 @@ CREATE TABLE IF NOT EXISTS `verify` ( CREATE TABLE IF NOT EXISTS `vote` ( `vote_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `vote_poll` int(11) NOT NULL DEFAULT '0', - `vote_element` int(11) NOT NULL DEFAULT '0', + `vote_poll` int(11) NOT NULL DEFAULT 0 , + `vote_element` int(11) NOT NULL DEFAULT 0 , `vote_result` text NOT NULL, `vote_xchan` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`vote_id`), @@ -1299,16 +1299,16 @@ CREATE TABLE IF NOT EXISTS `xchan` ( `xchan_name` char(255) NOT NULL DEFAULT '', `xchan_network` char(255) NOT NULL DEFAULT '', `xchan_instance_url` char(255) NOT NULL DEFAULT '', - `xchan_flags` int(10) unsigned NOT NULL DEFAULT '0', + `xchan_flags` int(10) unsigned NOT NULL DEFAULT 0 , `xchan_photo_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `xchan_name_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `xchan_hidden` tinyint(1) NOT NULL DEFAULT '0', - `xchan_orphan` tinyint(1) NOT NULL DEFAULT '0', - `xchan_censored` tinyint(1) NOT NULL DEFAULT '0', - `xchan_selfcensored` tinyint(1) NOT NULL DEFAULT '0', - `xchan_system` tinyint(1) NOT NULL DEFAULT '0', - `xchan_pubforum` tinyint(1) NOT NULL DEFAULT '0', - `xchan_deleted` tinyint(1) NOT NULL DEFAULT '0', + `xchan_hidden` tinyint(1) NOT NULL DEFAULT 0 , + `xchan_orphan` tinyint(1) NOT NULL DEFAULT 0 , + `xchan_censored` tinyint(1) NOT NULL DEFAULT 0 , + `xchan_selfcensored` tinyint(1) NOT NULL DEFAULT 0 , + `xchan_system` tinyint(1) NOT NULL DEFAULT 0 , + `xchan_pubforum` tinyint(1) NOT NULL DEFAULT 0 , + `xchan_deleted` tinyint(1) NOT NULL DEFAULT 0 , PRIMARY KEY (`xchan_hash`), KEY `xchan_guid` (`xchan_guid`), KEY `xchan_addr` (`xchan_addr`), @@ -1355,7 +1355,7 @@ CREATE TABLE IF NOT EXISTS `xconfig` ( CREATE TABLE IF NOT EXISTS `xign` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `uid` int(11) NOT NULL DEFAULT '0', + `uid` int(11) NOT NULL DEFAULT 0 , `xchan` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), @@ -1366,10 +1366,10 @@ CREATE TABLE IF NOT EXISTS `xlink` ( `xlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `xlink_xchan` char(255) NOT NULL DEFAULT '', `xlink_link` char(255) NOT NULL DEFAULT '', - `xlink_rating` int(11) NOT NULL DEFAULT '0', + `xlink_rating` int(11) NOT NULL DEFAULT 0 , `xlink_rating_text` text NOT NULL, `xlink_updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `xlink_static` tinyint(1) NOT NULL DEFAULT '0', + `xlink_static` tinyint(1) NOT NULL DEFAULT 0 , `xlink_sig` text NOT NULL, PRIMARY KEY (`xlink_id`), KEY `xlink_xchan` (`xlink_xchan`), @@ -1382,7 +1382,7 @@ CREATE TABLE IF NOT EXISTS `xlink` ( CREATE TABLE IF NOT EXISTS `xperm` ( `xp_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `xp_client` varchar(20) NOT NULL DEFAULT '', - `xp_channel` int(10) unsigned NOT NULL DEFAULT '0', + `xp_channel` int(10) unsigned NOT NULL DEFAULT 0 , `xp_perm` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`xp_id`), KEY `xp_client` (`xp_client`), @@ -1392,7 +1392,7 @@ CREATE TABLE IF NOT EXISTS `xperm` ( CREATE TABLE IF NOT EXISTS `xprof` ( `xprof_hash` char(255) NOT NULL, - `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT '0', + `xprof_age` tinyint(3) unsigned NOT NULL DEFAULT 0 , `xprof_desc` char(255) NOT NULL DEFAULT '', `xprof_dob` char(12) NOT NULL DEFAULT '', `xprof_gender` char(255) NOT NULL DEFAULT '', @@ -1424,7 +1424,7 @@ CREATE TABLE IF NOT EXISTS `xtag` ( `xtag_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `xtag_hash` char(255) NOT NULL DEFAULT '', `xtag_term` char(255) NOT NULL DEFAULT '', - `xtag_flags` int(11) NOT NULL DEFAULT '0', + `xtag_flags` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`xtag_id`), KEY `xtag_term` (`xtag_term`), KEY `xtag_hash` (`xtag_hash`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 389cc6a84..a5231b40c 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -1,6 +1,6 @@ CREATE TABLE "abconfig" ( "id" serial NOT NULL, - "chan" bigint NOT NULL DEFAULT '0', + "chan" bigint NOT NULL DEFAULT 0, "xchan" text NOT NULL, "cat" text NOT NULL, "k" text NOT NULL, @@ -16,23 +16,23 @@ CREATE TABLE "abook" ( "abook_account" bigint NOT NULL, "abook_channel" bigint NOT NULL, "abook_xchan" text NOT NULL DEFAULT '', - "abook_my_perms" bigint NOT NULL DEFAULT '0', - "abook_their_perms" bigint NOT NULL DEFAULT '0', - "abook_closeness" numeric(3) NOT NULL DEFAULT '99', + "abook_my_perms" bigint NOT NULL DEFAULT 0, + "abook_their_perms" bigint NOT NULL DEFAULT 0, + "abook_closeness" numeric(3) NOT NULL DEFAULT 99, "abook_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "abook_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "abook_connected" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "abook_dob" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "abook_flags" bigint NOT NULL DEFAULT '0', - "abook_blocked" smallint NOT NULL DEFAULT '0', - "abook_ignored" smallint NOT NULL DEFAULT '0', - "abook_hidden" smallint NOT NULL DEFAULT '0', - "abook_archived" smallint NOT NULL DEFAULT '0', - "abook_pending" smallint NOT NULL DEFAULT '0', - "abook_unconnected" smallint NOT NULL DEFAULT '0', - "abook_self" smallint NOT NULL DEFAULT '0', - "abook_feed" smallint NOT NULL DEFAULT '0', - "abook_not_here" smallint NOT NULL DEFAULT '0', + "abook_flags" bigint NOT NULL DEFAULT 0 , + "abook_blocked" smallint NOT NULL DEFAULT 0 , + "abook_ignored" smallint NOT NULL DEFAULT 0 , + "abook_hidden" smallint NOT NULL DEFAULT 0 , + "abook_archived" smallint NOT NULL DEFAULT 0 , + "abook_pending" smallint NOT NULL DEFAULT 0 , + "abook_unconnected" smallint NOT NULL DEFAULT 0 , + "abook_self" smallint NOT NULL DEFAULT 0 , + "abook_feed" smallint NOT NULL DEFAULT 0 , + "abook_not_here" smallint NOT NULL DEFAULT 0 , "abook_profile" char(64) NOT NULL DEFAULT '', "abook_incl" TEXT NOT NULL DEFAULT '', "abook_excl" TEXT NOT NULL DEFAULT '', @@ -64,8 +64,8 @@ CREATE TABLE "abook" ( CREATE TABLE "account" ( "account_id" serial NOT NULL, - "account_parent" bigint NOT NULL DEFAULT '0', - "account_default_channel" bigint NOT NULL DEFAULT '0', + "account_parent" bigint NOT NULL DEFAULT 0 , + "account_default_channel" bigint NOT NULL DEFAULT 0 , "account_salt" char(32) NOT NULL DEFAULT '', "account_password" text NOT NULL DEFAULT '', "account_email" text NOT NULL DEFAULT '', @@ -73,13 +73,13 @@ CREATE TABLE "account" ( "account_language" varchar(16) NOT NULL DEFAULT 'en', "account_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "account_lastlog" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "account_flags" bigint NOT NULL DEFAULT '0', - "account_roles" bigint NOT NULL DEFAULT '0', + "account_flags" bigint NOT NULL DEFAULT 0 , + "account_roles" bigint NOT NULL DEFAULT 0 , "account_reset" text NOT NULL DEFAULT '', "account_expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "account_expire_notified" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "account_service_class" varchar(32) NOT NULL DEFAULT '', - "account_level" bigint NOT NULL DEFAULT '0', + "account_level" bigint NOT NULL DEFAULT 0 , "account_password_changed" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY ("account_id") ); @@ -97,11 +97,11 @@ create index "account_password_changed" on account ("account_password_changed") CREATE TABLE "addon" ( "id" serial NOT NULL, "aname" text NOT NULL, - "version" text NOT NULL DEFAULT '0', - "installed" numeric(1) NOT NULL DEFAULT '0', - "hidden" numeric(1) NOT NULL DEFAULT '0', - "tstamp" numeric(20) NOT NULL DEFAULT '0', - "plugin_admin" numeric(1) NOT NULL DEFAULT '0', + "version" text NOT NULL DEFAULT 0 , + "installed" numeric(1) NOT NULL DEFAULT 0 , + "hidden" numeric(1) NOT NULL DEFAULT 0 , + "tstamp" numeric(20) NOT NULL DEFAULT 0 , + "plugin_admin" numeric(1) NOT NULL DEFAULT 0 , PRIMARY KEY ("id") ); create index "addon_hidden_idx" on addon ("hidden"); @@ -117,13 +117,13 @@ CREATE TABLE "app" ( "app_url" text NOT NULL DEFAULT '', "app_photo" text NOT NULL DEFAULT '', "app_version" text NOT NULL DEFAULT '', - "app_channel" bigint NOT NULL DEFAULT '0', + "app_channel" bigint NOT NULL DEFAULT 0 , "app_addr" text NOT NULL DEFAULT '', "app_price" text NOT NULL DEFAULT '', "app_page" text NOT NULL DEFAULT '', "app_requires" text NOT NULL DEFAULT '', - "app_deleted" smallint NOT NULL DEFAULT '0', - "app_system" smallint NOT NULL DEFAULT '0', + "app_deleted" smallint NOT NULL DEFAULT 0 , + "app_system" smallint NOT NULL DEFAULT 0 , "app_plugin" text NOT NULL DEFAULT '', "app_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "app_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -158,19 +158,19 @@ create index atoken_expires on atoken (atoken_expires); CREATE TABLE "attach" ( "id" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', - "uid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , + "uid" bigint NOT NULL DEFAULT 0 , "hash" varchar(64) NOT NULL DEFAULT '', "creator" varchar(128) NOT NULL DEFAULT '', "filename" text NOT NULL DEFAULT '', "filetype" varchar(64) NOT NULL DEFAULT '', - "filesize" bigint NOT NULL DEFAULT '0', - "revision" bigint NOT NULL DEFAULT '0', + "filesize" bigint NOT NULL DEFAULT 0 , + "revision" bigint NOT NULL DEFAULT 0 , "folder" varchar(64) NOT NULL DEFAULT '', - "flags" bigint NOT NULL DEFAULT '0', - "is_dir" smallint NOT NULL DEFAULT '0', - "is_photo" smallint NOT NULL DEFAULT '0', - "os_storage" smallint NOT NULL DEFAULT '0', + "flags" bigint NOT NULL DEFAULT 0 , + "is_dir" smallint NOT NULL DEFAULT 0 , + "is_photo" smallint NOT NULL DEFAULT 0 , + "os_storage" smallint NOT NULL DEFAULT 0 , "os_path" text NOT NULL, "display_path" text NOT NULL, "content" bytea NOT NULL, @@ -214,8 +214,8 @@ CREATE TABLE "cache" ( ); CREATE TABLE "cal" ( "cal_id" serial NOT NULL, - "cal_aid" bigint NOT NULL DEFAULT '0', - "cal_uid" bigint NOT NULL DEFAULT '0', + "cal_aid" bigint NOT NULL DEFAULT 0 , + "cal_uid" bigint NOT NULL DEFAULT 0 , "cal_hash" text NOT NULL, "cal_name" text NOT NULL, "uri" text NOT NULL, @@ -223,7 +223,7 @@ CREATE TABLE "cal" ( "pass" text NOT NULL, "ctag" text NOT NULL, "synctoken" text NOT NULL, - "cal_types" text NOT NULL DEFAULT '0', + "cal_types" text NOT NULL DEFAULT 0 , PRIMARY KEY ("cal_id") ); create index "cal_hash_idx" on cal ("cal_hash"); @@ -234,8 +234,8 @@ create index "cal_uid_idx" on cal ("cal_uid"); CREATE TABLE "channel" ( "channel_id" serial NOT NULL, - "channel_account_id" bigint NOT NULL DEFAULT '0', - "channel_primary" numeric(1) NOT NULL DEFAULT '0', + "channel_account_id" bigint NOT NULL DEFAULT 0 , + "channel_primary" numeric(1) NOT NULL DEFAULT 0 , "channel_name" text NOT NULL DEFAULT '', "channel_address" text NOT NULL DEFAULT '', "channel_guid" text NOT NULL DEFAULT '', @@ -247,40 +247,40 @@ CREATE TABLE "channel" ( "channel_startpage" text NOT NULL DEFAULT '', "channel_pubkey" text NOT NULL, "channel_prvkey" text NOT NULL, - "channel_notifyflags" bigint NOT NULL DEFAULT '65535', - "channel_pageflags" bigint NOT NULL DEFAULT '0', + "channel_notifyflags" bigint NOT NULL DEFAULT 65535, + "channel_pageflags" bigint NOT NULL DEFAULT 0 , "channel_dirdate" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "channel_lastpost" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "channel_deleted" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "channel_max_anon_mail" bigint NOT NULL DEFAULT '10', - "channel_max_friend_req" bigint NOT NULL DEFAULT '10', - "channel_expire_days" bigint NOT NULL DEFAULT '0', + "channel_max_anon_mail" bigint NOT NULL DEFAULT 10, + "channel_max_friend_req" bigint NOT NULL DEFAULT 10, + "channel_expire_days" bigint NOT NULL DEFAULT 0 , "channel_passwd_reset" text NOT NULL DEFAULT '', "channel_default_group" text NOT NULL DEFAULT '', "channel_allow_cid" text , "channel_allow_gid" text , "channel_deny_cid" text , "channel_deny_gid" text , - "channel_r_stream" bigint NOT NULL DEFAULT '128', - "channel_r_profile" bigint NOT NULL DEFAULT '128', - "channel_r_photos" bigint NOT NULL DEFAULT '128', - "channel_r_abook" bigint NOT NULL DEFAULT '128', - "channel_w_stream" bigint NOT NULL DEFAULT '128', - "channel_w_wall" bigint NOT NULL DEFAULT '128', - "channel_w_tagwall" bigint NOT NULL DEFAULT '128', - "channel_w_comment" bigint NOT NULL DEFAULT '128', - "channel_w_mail" bigint NOT NULL DEFAULT '128', - "channel_w_photos" bigint NOT NULL DEFAULT '128', - "channel_w_chat" bigint NOT NULL DEFAULT '128', - "channel_a_delegate" bigint NOT NULL DEFAULT '0', - "channel_r_storage" bigint NOT NULL DEFAULT '128', - "channel_w_storage" bigint NOT NULL DEFAULT '128', - "channel_r_pages" bigint NOT NULL DEFAULT '128', - "channel_w_pages" bigint NOT NULL DEFAULT '128', - "channel_a_republish" bigint NOT NULL DEFAULT '128', - "channel_w_like" bigint NOT NULL DEFAULT '128', - "channel_removed" smallint NOT NULL DEFAULT '0', - "channel_system" smallint NOT NULL DEFAULT '0', + "channel_r_stream" bigint NOT NULL DEFAULT 0, + "channel_r_profile" bigint NOT NULL DEFAULT 0, + "channel_r_photos" bigint NOT NULL DEFAULT 0, + "channel_r_abook" bigint NOT NULL DEFAULT 0, + "channel_w_stream" bigint NOT NULL DEFAULT 0, + "channel_w_wall" bigint NOT NULL DEFAULT 0, + "channel_w_tagwall" bigint NOT NULL DEFAULT 0, + "channel_w_comment" bigint NOT NULL DEFAULT 0, + "channel_w_mail" bigint NOT NULL DEFAULT 0, + "channel_w_photos" bigint NOT NULL DEFAULT 0, + "channel_w_chat" bigint NOT NULL DEFAULT 0, + "channel_a_delegate" bigint NOT NULL DEFAULT 0 , + "channel_r_storage" bigint NOT NULL DEFAULT 0, + "channel_w_storage" bigint NOT NULL DEFAULT 0, + "channel_r_pages" bigint NOT NULL DEFAULT 0, + "channel_w_pages" bigint NOT NULL DEFAULT 0, + "channel_a_republish" bigint NOT NULL DEFAULT 0, + "channel_w_like" bigint NOT NULL DEFAULT 0, + "channel_removed" smallint NOT NULL DEFAULT 0 , + "channel_system" smallint NOT NULL DEFAULT 0 , "channel_moved" text NOT NULL DEFAULT '', "channel_password" varchar(255) NOT NULL, "channel_salt" varchar(255) NOT NULL, @@ -327,7 +327,7 @@ create index "channel_system" on channel ("channel_system"); create index "channel_moved" on channel ("channel_moved"); CREATE TABLE "chat" ( "chat_id" serial NOT NULL, - "chat_room" bigint NOT NULL DEFAULT '0', + "chat_room" bigint NOT NULL DEFAULT 0 , "chat_xchan" text NOT NULL DEFAULT '', "chat_text" text NOT NULL, "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -338,7 +338,7 @@ create index "chat_xchan_idx" on chat ("chat_xchan"); create index "chat_created_idx" on chat ("created"); CREATE TABLE "chatpresence" ( "cp_id" serial NOT NULL, - "cp_room" bigint NOT NULL DEFAULT '0', + "cp_room" bigint NOT NULL DEFAULT 0 , "cp_xchan" text NOT NULL DEFAULT '', "cp_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "cp_status" text NOT NULL, @@ -352,12 +352,12 @@ create index "cp_status" on chatpresence ("cp_status"); CREATE TABLE "chatroom" ( "cr_id" serial NOT NULL, - "cr_aid" bigint NOT NULL DEFAULT '0', - "cr_uid" bigint NOT NULL DEFAULT '0', + "cr_aid" bigint NOT NULL DEFAULT 0 , + "cr_uid" bigint NOT NULL DEFAULT 0 , "cr_name" text NOT NULL DEFAULT '', "cr_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "cr_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "cr_expire" bigint NOT NULL DEFAULT '0', + "cr_expire" bigint NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, @@ -376,7 +376,7 @@ CREATE TABLE "clients" ( "redirect_uri" varchar(200) NOT NULL, "clname" text, "icon" text, - "uid" bigint NOT NULL DEFAULT '0', + "uid" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("client_id") ); CREATE TABLE "config" ( @@ -403,7 +403,7 @@ create index "conv_updated_idx" on conv ("updated"); CREATE TABLE IF NOT EXISTS "dreport" ( "dreport_id" serial NOT NULL, - "dreport_channel" int NOT NULL DEFAULT '0', + "dreport_channel" int NOT NULL DEFAULT 0 , "dreport_mid" char(255) NOT NULL DEFAULT '', "dreport_site" char(255) NOT NULL DEFAULT '', "dreport_recip" char(255) NOT NULL DEFAULT '', @@ -423,9 +423,9 @@ create index "dreport_channel" on dreport ("dreport_channel"); CREATE TABLE "event" ( "id" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, - "cal_id" bigint NOT NULL DEFAULT '0', + "cal_id" bigint NOT NULL DEFAULT 0 , "event_xchan" text NOT NULL DEFAULT '', "event_hash" text NOT NULL DEFAULT '', "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -436,19 +436,19 @@ CREATE TABLE "event" ( "description" text NOT NULL, "location" text NOT NULL, "etype" text NOT NULL, - "nofinish" numeric(1) NOT NULL DEFAULT '0', - "adjust" numeric(1) NOT NULL DEFAULT '1', - "dismissed" numeric(1) NOT NULL DEFAULT '0', + "nofinish" numeric(1) NOT NULL DEFAULT 0 , + "adjust" numeric(1) NOT NULL DEFAULT 1, + "dismissed" numeric(1) NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, "deny_gid" text NOT NULL, "event_status" char(255) NOT NULL DEFAULT '', "event_status_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "event_percent" smallint NOT NULL DEFAULT '0', + "event_percent" smallint NOT NULL DEFAULT 0 , "event_repeat" text NOT NULL, - "event_sequence" smallint NOT NULL DEFAULT '0', - "event_priority" smallint NOT NULL DEFAULT '0', + "event_sequence" smallint NOT NULL DEFAULT 0 , + "event_priority" smallint NOT NULL DEFAULT 0 , "event_vdata" text NOT NULL, PRIMARY KEY ("id") ); @@ -482,8 +482,8 @@ CREATE TABLE "groups" ( "id" serial NOT NULL, "hash" text NOT NULL DEFAULT '', "uid" bigint NOT NULL, - "visible" numeric(1) NOT NULL DEFAULT '0', - "deleted" numeric(1) NOT NULL DEFAULT '0', + "visible" numeric(1) NOT NULL DEFAULT 0 , + "deleted" numeric(1) NOT NULL DEFAULT 0 , "gname" text NOT NULL, PRIMARY KEY ("id") @@ -498,8 +498,8 @@ CREATE TABLE "hook" ( "hook" text NOT NULL, "file" text NOT NULL, "fn" text NOT NULL, - "priority" smallint NOT NULL DEFAULT '0', - "hook_version" smallint NOT NULL DEFAULT '0', + "priority" smallint NOT NULL DEFAULT 0 , + "hook_version" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("id") ); @@ -514,8 +514,8 @@ CREATE TABLE "hubloc" ( "hubloc_hash" text NOT NULL, "hubloc_addr" text NOT NULL DEFAULT '', "hubloc_network" text NOT NULL DEFAULT '', - "hubloc_flags" bigint NOT NULL DEFAULT '0', - "hubloc_status" bigint NOT NULL DEFAULT '0', + "hubloc_flags" bigint NOT NULL DEFAULT 0 , + "hubloc_status" bigint NOT NULL DEFAULT 0 , "hubloc_url" text NOT NULL DEFAULT '', "hubloc_url_sig" text NOT NULL DEFAULT '', "hubloc_host" text NOT NULL DEFAULT '', @@ -524,10 +524,10 @@ CREATE TABLE "hubloc" ( "hubloc_sitekey" text NOT NULL DEFAULT '', "hubloc_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "hubloc_connected" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "hubloc_primary" smallint NOT NULL DEFAULT '0', - "hubloc_orphancheck" smallint NOT NULL DEFAULT '0', - "hubloc_error" smallint NOT NULL DEFAULT '0', - "hubloc_deleted" smallint NOT NULL DEFAULT '0', + "hubloc_primary" smallint NOT NULL DEFAULT 0 , + "hubloc_orphancheck" smallint NOT NULL DEFAULT 0 , + "hubloc_error" smallint NOT NULL DEFAULT 0 , + "hubloc_deleted" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("hubloc_id") ); create index "hubloc_url" on hubloc ("hubloc_url"); @@ -546,11 +546,11 @@ create index "hubloc_error" on hubloc ("hubloc_error"); create index "hubloc_deleted" on hubloc ("hubloc_deleted"); CREATE TABLE "iconfig" ( "id" serial NOT NULL, - "iid" bigint NOT NULL DEFAULT '0', + "iid" bigint NOT NULL DEFAULT 0 , "cat" text NOT NULL DEFAULT '', "k" text NOT NULL DEFAULT '', "v" text NOT NULL DEFAULT '', - "sharing" int NOT NULL DEFAULT '0', + "sharing" int NOT NULL DEFAULT 0 , PRIMARY KEY("id") ); create index "iconfig_iid" on iconfig ("iid"); @@ -577,9 +577,9 @@ create index "issue_component" on issue ("issue_component"); CREATE TABLE "item" ( "id" serial NOT NULL, "mid" text NOT NULL DEFAULT '', - "aid" bigint NOT NULL DEFAULT '0', - "uid" bigint NOT NULL DEFAULT '0', - "parent" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , + "uid" bigint NOT NULL DEFAULT 0 , + "parent" bigint NOT NULL DEFAULT 0 , "parent_mid" text NOT NULL DEFAULT '', "thr_parent" text NOT NULL DEFAULT '', "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -598,7 +598,7 @@ CREATE TABLE "item" ( "html" text NOT NULL, "app" text NOT NULL DEFAULT '', "lang" varchar(64) NOT NULL DEFAULT '', - "revision" bigint NOT NULL DEFAULT '0', + "revision" bigint NOT NULL DEFAULT 0 , "verb" text NOT NULL DEFAULT '', "obj_type" text NOT NULL DEFAULT '', "obj" text NOT NULL, @@ -622,32 +622,32 @@ CREATE TABLE "item" ( "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, "deny_gid" text NOT NULL, - "item_restrict" bigint NOT NULL DEFAULT '0', - "item_flags" bigint NOT NULL DEFAULT '0', - "item_private" numeric(4) NOT NULL DEFAULT '0', - "item_unseen" smallint NOT NULL DEFAULT '0', - "item_wall" smallint NOT NULL DEFAULT '0', - "item_origin" smallint NOT NULL DEFAULT '0', - "item_starred" smallint NOT NULL DEFAULT '0', - "item_uplink" smallint NOT NULL DEFAULT '0', - "item_consensus" smallint NOT NULL DEFAULT '0', - "item_thread_top" smallint NOT NULL DEFAULT '0', - "item_notshown" smallint NOT NULL DEFAULT '0', - "item_nsfw" smallint NOT NULL DEFAULT '0', - "item_relay" smallint NOT NULL DEFAULT '0', - "item_mentionsme" smallint NOT NULL DEFAULT '0', - "item_nocomment" smallint NOT NULL DEFAULT '0', - "item_obscured" smallint NOT NULL DEFAULT '0', - "item_verified" smallint NOT NULL DEFAULT '0', - "item_retained" smallint NOT NULL DEFAULT '0', - "item_rss" smallint NOT NULL DEFAULT '0', - "item_deleted" smallint NOT NULL DEFAULT '0', - "item_type" int NOT NULL DEFAULT '0', - "item_hidden" smallint NOT NULL DEFAULT '0', - "item_unpublished" smallint NOT NULL DEFAULT '0', - "item_delayed" smallint NOT NULL DEFAULT '0', - "item_pending_remove" smallint NOT NULL DEFAULT '0', - "item_blocked" smallint NOT NULL DEFAULT '0', + "item_restrict" bigint NOT NULL DEFAULT 0 , + "item_flags" bigint NOT NULL DEFAULT 0 , + "item_private" numeric(4) NOT NULL DEFAULT 0 , + "item_unseen" smallint NOT NULL DEFAULT 0 , + "item_wall" smallint NOT NULL DEFAULT 0 , + "item_origin" smallint NOT NULL DEFAULT 0 , + "item_starred" smallint NOT NULL DEFAULT 0 , + "item_uplink" smallint NOT NULL DEFAULT 0 , + "item_consensus" smallint NOT NULL DEFAULT 0 , + "item_thread_top" smallint NOT NULL DEFAULT 0 , + "item_notshown" smallint NOT NULL DEFAULT 0 , + "item_nsfw" smallint NOT NULL DEFAULT 0 , + "item_relay" smallint NOT NULL DEFAULT 0 , + "item_mentionsme" smallint NOT NULL DEFAULT 0 , + "item_nocomment" smallint NOT NULL DEFAULT 0 , + "item_obscured" smallint NOT NULL DEFAULT 0 , + "item_verified" smallint NOT NULL DEFAULT 0 , + "item_retained" smallint NOT NULL DEFAULT 0 , + "item_rss" smallint NOT NULL DEFAULT 0 , + "item_deleted" smallint NOT NULL DEFAULT 0 , + "item_type" int NOT NULL DEFAULT 0 , + "item_hidden" smallint NOT NULL DEFAULT 0 , + "item_unpublished" smallint NOT NULL DEFAULT 0 , + "item_delayed" smallint NOT NULL DEFAULT 0 , + "item_pending_remove" smallint NOT NULL DEFAULT 0 , + "item_blocked" smallint NOT NULL DEFAULT 0 , "item_search_vector" tsvector, PRIMARY KEY ("id") ); @@ -725,10 +725,10 @@ create index "itemid_service" on item_id ("service"); create index "itemid_iid" on item_id ("iid"); CREATE TABLE "likes" ( "id" serial NOT NULL, - "channel_id" bigint NOT NULL DEFAULT '0', + "channel_id" bigint NOT NULL DEFAULT 0 , "liker" char(128) NOT NULL DEFAULT '', "likee" char(128) NOT NULL DEFAULT '', - "iid" bigint NOT NULL DEFAULT '0', + "iid" bigint NOT NULL DEFAULT 0 , "i_mid" char(255) NOT NULL DEFAULT '', "verb" text NOT NULL DEFAULT '', "target_type" text NOT NULL DEFAULT '', @@ -746,27 +746,27 @@ create index "likes_target_type" on likes ("target_type"); create index "likes_target_id" on likes ("target_id"); CREATE TABLE "mail" ( "id" serial NOT NULL, - "convid" bigint NOT NULL DEFAULT '0', + "convid" bigint NOT NULL DEFAULT 0 , "conv_guid" text NOT NULL, - "mail_flags" bigint NOT NULL DEFAULT '0', + "mail_flags" bigint NOT NULL DEFAULT 0 , "from_xchan" text NOT NULL DEFAULT '', "to_xchan" text NOT NULL DEFAULT '', - "account_id" bigint NOT NULL DEFAULT '0', - "channel_id" bigint NOT NULL DEFAULT '0', - "mail_mimetype" char(64) NOT NULL DEFAULT '0', + "account_id" bigint NOT NULL DEFAULT 0 , + "channel_id" bigint NOT NULL DEFAULT 0 , + "mail_mimetype" char(64) NOT NULL DEFAULT 'text/bbcode', "title" text NOT NULL, "body" text NOT NULL, "sig" text NOT NULL, "attach" text NOT NULL DEFAULT '', "mid" text NOT NULL, "parent_mid" text NOT NULL, - "mail_deleted" smallint NOT NULL DEFAULT '0', - "mail_replied" smallint NOT NULL DEFAULT '0', - "mail_isreply" smallint NOT NULL DEFAULT '0', - "mail_seen" smallint NOT NULL DEFAULT '0', - "mail_recalled" smallint NOT NULL DEFAULT '0', - "mail_obscured" smallint NOT NULL DEFAULT '0', - "mail_raw" smallint NOT NULL DEFAULT '0', + "mail_deleted" smallint NOT NULL DEFAULT 0 , + "mail_replied" smallint NOT NULL DEFAULT 0 , + "mail_isreply" smallint NOT NULL DEFAULT 0 , + "mail_seen" smallint NOT NULL DEFAULT 0 , + "mail_recalled" smallint NOT NULL DEFAULT 0 , + "mail_obscured" smallint NOT NULL DEFAULT 0 , + "mail_raw" smallint NOT NULL DEFAULT 0 , "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY ("id") @@ -790,10 +790,10 @@ create index "mail_recalled" on mail ("mail_recalled"); create index "mail_obscured" on mail ("mail_obscured"); CREATE TABLE "menu" ( "menu_id" serial NOT NULL, - "menu_channel_id" bigint NOT NULL DEFAULT '0', + "menu_channel_id" bigint NOT NULL DEFAULT 0 , "menu_name" text NOT NULL DEFAULT '', "menu_desc" text NOT NULL DEFAULT '', - "menu_flags" bigint NOT NULL DEFAULT '0', + "menu_flags" bigint NOT NULL DEFAULT 0 , "menu_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "menu_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY ("menu_id") @@ -807,14 +807,14 @@ CREATE TABLE "menu_item" ( "mitem_id" serial NOT NULL, "mitem_link" text NOT NULL DEFAULT '', "mitem_desc" text NOT NULL DEFAULT '', - "mitem_flags" bigint NOT NULL DEFAULT '0', + "mitem_flags" bigint NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, "deny_gid" text NOT NULL, "mitem_channel_id" bigint NOT NULL, - "mitem_menu_id" bigint NOT NULL DEFAULT '0', - "mitem_order" bigint NOT NULL DEFAULT '0', + "mitem_menu_id" bigint NOT NULL DEFAULT 0 , + "mitem_order" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("mitem_id") ); @@ -833,7 +833,7 @@ CREATE TABLE "notify" ( "uid" bigint NOT NULL, "link" text NOT NULL, "parent" text NOT NULL DEFAULT '', - "seen" numeric(1) NOT NULL DEFAULT '0', + "seen" numeric(1) NOT NULL DEFAULT 0 , "ntype" bigint NOT NULL, "verb" text NOT NULL, "otype" varchar(16) NOT NULL, @@ -882,18 +882,18 @@ create index "obj_quantity" on obj ("obj_quantity"); CREATE TABLE "outq" ( "outq_hash" text NOT NULL, - "outq_account" bigint NOT NULL DEFAULT '0', - "outq_channel" bigint NOT NULL DEFAULT '0', + "outq_account" bigint NOT NULL DEFAULT 0 , + "outq_channel" bigint NOT NULL DEFAULT 0 , "outq_driver" varchar(32) NOT NULL DEFAULT '', "outq_posturl" text NOT NULL DEFAULT '', - "outq_async" numeric(1) NOT NULL DEFAULT '0', - "outq_delivered" numeric(1) NOT NULL DEFAULT '0', + "outq_async" numeric(1) NOT NULL DEFAULT 0 , + "outq_delivered" numeric(1) NOT NULL DEFAULT 0 , "outq_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "outq_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "outq_scheduled" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "outq_notify" text NOT NULL, "outq_msg" text NOT NULL, - "outq_priority" smallint NOT NULL DEFAULT '0', + "outq_priority" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("outq_hash") ); create index "outq_account" on outq ("outq_account"); @@ -908,7 +908,7 @@ create index "outq_priority" on outq ("outq_priority"); CREATE TABLE "pconfig" ( "id" serial NOT NULL, - "uid" bigint NOT NULL DEFAULT '0', + "uid" bigint NOT NULL DEFAULT 0 , "cat" text NOT NULL, "k" text NOT NULL, "v" text NOT NULL, @@ -918,7 +918,7 @@ CREATE TABLE "pconfig" ( CREATE TABLE "photo" ( "id" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, "xchan" text NOT NULL DEFAULT '', "resource_id" text NOT NULL, @@ -931,16 +931,16 @@ CREATE TABLE "photo" ( "mimetype" varchar(128) NOT NULL DEFAULT 'image/jpeg', "height" numeric(6) NOT NULL, "width" numeric(6) NOT NULL, - "filesize" bigint NOT NULL DEFAULT '0', + "filesize" bigint NOT NULL DEFAULT 0 , "content" bytea NOT NULL, - "imgscale" numeric(3) NOT NULL DEFAULT '0', - "profile" numeric(1) NOT NULL DEFAULT '0', - "photo_usage" smallint NOT NULL DEFAULT '0', - "is_nsfw" smallint NOT NULL DEFAULT '0', - "os_storage" smallint NOT NULL DEFAULT '0', + "imgscale" numeric(3) NOT NULL DEFAULT 0 , + "profile" numeric(1) NOT NULL DEFAULT 0 , + "photo_usage" smallint NOT NULL DEFAULT 0 , + "is_nsfw" smallint NOT NULL DEFAULT 0 , + "os_storage" smallint NOT NULL DEFAULT 0 , "os_path" text NOT NULL, "display_path" text NOT NULL, - "photo_flags" bigint NOT NULL DEFAULT '0', + "photo_flags" bigint NOT NULL DEFAULT 0 , "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, @@ -963,10 +963,10 @@ create index "photo_os_storage" on photo ("os_storage"); CREATE TABLE "poll" ( "poll_id" serial NOT NULL, - "poll_channel" bigint NOT NULL DEFAULT '0', + "poll_channel" bigint NOT NULL DEFAULT 0 , "poll_desc" text NOT NULL, - "poll_flags" bigint NOT NULL DEFAULT '0', - "poll_votes" bigint NOT NULL DEFAULT '0', + "poll_flags" bigint NOT NULL DEFAULT 0 , + "poll_votes" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("poll_id") ); @@ -975,10 +975,10 @@ create index "poll_flags" on poll ("poll_flags"); create index "poll_votes" on poll ("poll_votes"); CREATE TABLE "poll_elm" ( "pelm_id" serial NOT NULL, - "pelm_poll" bigint NOT NULL DEFAULT '0', + "pelm_poll" bigint NOT NULL DEFAULT 0 , "pelm_desc" text NOT NULL, - "pelm_flags" bigint NOT NULL DEFAULT '0', - "pelm_result" float NOT NULL DEFAULT '0', + "pelm_flags" bigint NOT NULL DEFAULT 0 , + "pelm_result" float NOT NULL DEFAULT 0 , PRIMARY KEY ("pelm_id") ); create index "pelm_poll" on poll_elm ("pelm_poll"); @@ -996,7 +996,7 @@ CREATE TABLE "profdef" ( create index "profdef_field_name" on profdef ("field_name"); CREATE TABLE "profext" ( "id" serial NOT NULL, - "channel_id" bigint NOT NULL DEFAULT '0', + "channel_id" bigint NOT NULL DEFAULT 0 , "hash" text NOT NULL DEFAULT '', "k" text NOT NULL DEFAULT '', "v" text NOT NULL, @@ -1009,11 +1009,11 @@ create index "profext_k" on profext ("k"); CREATE TABLE "profile" ( "id" serial NOT NULL, "profile_guid" char(64) NOT NULL DEFAULT '', - "aid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , "uid" bigint NOT NULL, "profile_name" text NOT NULL, - "is_default" numeric(1) NOT NULL DEFAULT '0', - "hide_friends" numeric(1) NOT NULL DEFAULT '0', + "is_default" numeric(1) NOT NULL DEFAULT 0 , + "hide_friends" numeric(1) NOT NULL DEFAULT 0 , "fullname" text NOT NULL, "pdesc" text NOT NULL DEFAULT '', "chandesc" text NOT NULL DEFAULT '', @@ -1050,7 +1050,7 @@ CREATE TABLE "profile" ( "homepage" text NOT NULL DEFAULT '', "photo" text NOT NULL, "thumb" text NOT NULL, - "publish" numeric(1) NOT NULL DEFAULT '0', + "publish" numeric(1) NOT NULL DEFAULT 0 , "profile_vcard" text NOT NULL DEFAULT '', PRIMARY KEY ("id"), UNIQUE ("profile_guid","uid") @@ -1072,7 +1072,7 @@ create index "profile_guid" on profile ("profile_guid"); CREATE TABLE "profile_check" ( "id" serial NOT NULL, "uid" bigint NOT NULL, - "cid" bigint NOT NULL DEFAULT '0', + "cid" bigint NOT NULL DEFAULT 0 , "dfrn_id" text NOT NULL, "sec" text NOT NULL, "expire" bigint NOT NULL, @@ -1107,8 +1107,8 @@ create index "session_sid" on session ("sid"); create index "session_expire" on session ("expire"); CREATE TABLE "shares" ( "share_id" serial NOT NULL, - "share_type" bigint NOT NULL DEFAULT '0', - "share_target" bigint NOT NULL DEFAULT '0', + "share_type" bigint NOT NULL DEFAULT 0 , + "share_target" bigint NOT NULL DEFAULT 0 , "share_xchan" text NOT NULL DEFAULT '', PRIMARY KEY ("share_id") ); @@ -1118,8 +1118,8 @@ create index "share_xchan" on shares ("share_xchan"); CREATE TABLE "sign" ( "id" serial NOT NULL, - "iid" bigint NOT NULL DEFAULT '0', - "retract_iid" bigint NOT NULL DEFAULT '0', + "iid" bigint NOT NULL DEFAULT 0 , + "retract_iid" bigint NOT NULL DEFAULT 0 , "signed_text" text NOT NULL, "signature" text NOT NULL, "signer" text NOT NULL, @@ -1130,19 +1130,19 @@ create index "sign_retract_iid" on "sign" ("retract_iid"); CREATE TABLE "site" ( "site_url" text NOT NULL, - "site_access" bigint NOT NULL DEFAULT '0', - "site_flags" bigint NOT NULL DEFAULT '0', + "site_access" bigint NOT NULL DEFAULT 0 , + "site_flags" bigint NOT NULL DEFAULT 0 , "site_update" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "site_pull" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "site_sync" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "site_directory" text NOT NULL DEFAULT '', - "site_register" bigint NOT NULL DEFAULT '0', + "site_register" bigint NOT NULL DEFAULT 0 , "site_sellpage" text NOT NULL DEFAULT '', "site_location" text NOT NULL DEFAULT '', "site_realm" text NOT NULL DEFAULT '', - "site_valid" smallint NOT NULL DEFAULT '0', - "site_dead" smallint NOT NULL DEFAULT '0', - "site_type" smallint NOT NULL DEFAULT '0', + "site_valid" smallint NOT NULL DEFAULT 0 , + "site_dead" smallint NOT NULL DEFAULT 0 , + "site_type" smallint NOT NULL DEFAULT 0 , "site_project" text NOT NULL DEFAULT '', "site_version" text NOT NULL DEFAULT '', "site_crypto" text NOT NULL DEFAULT '', @@ -1162,7 +1162,7 @@ create index "site_project" on site ("site_project"); CREATE TABLE "source" ( "src_id" serial NOT NULL, - "src_channel_id" bigint NOT NULL DEFAULT '0', + "src_channel_id" bigint NOT NULL DEFAULT 0 , "src_channel_xchan" text NOT NULL DEFAULT '', "src_xchan" text NOT NULL DEFAULT '', "src_patt" text NOT NULL DEFAULT '', @@ -1182,8 +1182,8 @@ CREATE TABLE "sys_perms" ( ); CREATE TABLE "term" ( "tid" serial NOT NULL, - "aid" bigint NOT NULL DEFAULT '0', - "uid" bigint NOT NULL DEFAULT '0', + "aid" bigint NOT NULL DEFAULT 0 , + "uid" bigint NOT NULL DEFAULT 0 , "oid" bigint NOT NULL, "otype" numeric(3) NOT NULL, "ttype" numeric(3) NOT NULL, @@ -1222,7 +1222,7 @@ CREATE TABLE "updates" ( "ud_guid" text NOT NULL DEFAULT '', "ud_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "ud_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "ud_flags" bigint NOT NULL DEFAULT '0', + "ud_flags" bigint NOT NULL DEFAULT 0 , "ud_addr" text NOT NULL DEFAULT '', PRIMARY KEY ("ud_id") ); @@ -1234,7 +1234,7 @@ create index "ud_addr" on updates ("ud_addr"); create index "ud_last" on updates ("ud_last"); CREATE TABLE "verify" ( "id" serial NOT NULL, - "channel" bigint NOT NULL DEFAULT '0', + "channel" bigint NOT NULL DEFAULT 0 , "vtype" varchar(32) NOT NULL DEFAULT '', "token" text NOT NULL DEFAULT '', "meta" text NOT NULL DEFAULT '', @@ -1248,8 +1248,8 @@ create index "verify_meta" on verify ("meta"); create index "verify_created" on verify ("created"); CREATE TABLE "vote" ( "vote_id" serial NOT NULL, - "vote_poll" bigint NOT NULL DEFAULT '0', - "vote_element" bigint NOT NULL DEFAULT '0', + "vote_poll" bigint NOT NULL DEFAULT 0 , + "vote_element" bigint NOT NULL DEFAULT 0 , "vote_result" text NOT NULL, "vote_xchan" text NOT NULL DEFAULT '', PRIMARY KEY ("vote_id"), @@ -1274,16 +1274,16 @@ CREATE TABLE "xchan" ( "xchan_name" text NOT NULL DEFAULT '', "xchan_network" text NOT NULL DEFAULT '', "xchan_instance_url" text NOT NULL DEFAULT '', - "xchan_flags" bigint NOT NULL DEFAULT '0', + "xchan_flags" bigint NOT NULL DEFAULT 0 , "xchan_photo_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "xchan_name_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "xchan_hidden" smallint NOT NULL DEFAULT '0', - "xchan_orphan" smallint NOT NULL DEFAULT '0', - "xchan_censored" smallint NOT NULL DEFAULT '0', - "xchan_selfcensored" smallint NOT NULL DEFAULT '0', - "xchan_system" smallint NOT NULL DEFAULT '0', - "xchan_pubforum" smallint NOT NULL DEFAULT '0', - "xchan_deleted" smallint NOT NULL DEFAULT '0', + "xchan_hidden" smallint NOT NULL DEFAULT 0 , + "xchan_orphan" smallint NOT NULL DEFAULT 0 , + "xchan_censored" smallint NOT NULL DEFAULT 0 , + "xchan_selfcensored" smallint NOT NULL DEFAULT 0 , + "xchan_system" smallint NOT NULL DEFAULT 0 , + "xchan_pubforum" smallint NOT NULL DEFAULT 0 , + "xchan_deleted" smallint NOT NULL DEFAULT 0 , PRIMARY KEY ("xchan_hash") ); create index "xchan_guid" on xchan ("xchan_guid"); @@ -1328,7 +1328,7 @@ create index "xconfig_cat" on xconfig ("cat"); create index "xconfig_k" on xconfig ("k"); CREATE TABLE "xign" ( "id" serial NOT NULL, - "uid" bigint NOT NULL DEFAULT '0', + "uid" bigint NOT NULL DEFAULT 0 , "xchan" text NOT NULL DEFAULT '', PRIMARY KEY ("id") ); @@ -1338,10 +1338,10 @@ CREATE TABLE "xlink" ( "xlink_id" serial NOT NULL, "xlink_xchan" text NOT NULL DEFAULT '', "xlink_link" text NOT NULL DEFAULT '', - "xlink_rating" bigint NOT NULL DEFAULT '0', + "xlink_rating" bigint NOT NULL DEFAULT 0 , "xlink_rating_text" TEXT NOT NULL DEFAULT '', "xlink_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "xlink_static" numeric(1) NOT NULL DEFAULT '0', + "xlink_static" numeric(1) NOT NULL DEFAULT 0 , "xlink_sig" text NOT NULL DEFAULT '', PRIMARY KEY ("xlink_id") ); @@ -1353,7 +1353,7 @@ create index "xlink_static" on xlink ("xlink_static"); CREATE TABLE "xperm" ( "xp_id" serial NOT NULL, "xp_client" varchar( 20 ) NOT NULL DEFAULT '', - "xp_channel" bigint NOT NULL DEFAULT '0', + "xp_channel" bigint NOT NULL DEFAULT 0 , "xp_perm" varchar( 64 ) NOT NULL DEFAULT '', PRIMARY KEY ("xp_id") ); @@ -1362,7 +1362,7 @@ create index "xp_channel" on xperm ("xp_channel"); create index "xp_perm" on xperm ("xp_perm"); CREATE TABLE "xprof" ( "xprof_hash" text NOT NULL, - "xprof_age" numeric(3) NOT NULL DEFAULT '0', + "xprof_age" numeric(3) NOT NULL DEFAULT 0 , "xprof_desc" text NOT NULL DEFAULT '', "xprof_dob" varchar(12) NOT NULL DEFAULT '', "xprof_gender" text NOT NULL DEFAULT '', @@ -1393,7 +1393,7 @@ CREATE TABLE "xtag" ( "xtag_id" serial NOT NULL, "xtag_hash" text NOT NULL, "xtag_term" text NOT NULL DEFAULT '', - "xtag_flags" bigint NOT NULL DEFAULT '0', + "xtag_flags" bigint NOT NULL DEFAULT 0 , PRIMARY KEY ("xtag_id") ); create index "xtag_term" on xtag ("xtag_term"); diff --git a/install/update.php b/install/update.php index 65506a2f7..ca347e4c2 100644 --- a/install/update.php +++ b/install/update.php @@ -2533,7 +2533,7 @@ function update_r1189() { } function update_r1190() { - $r1 = q("alter table abook add abook_not_here int(11) not null default '0' "); + $r1 = q("alter table abook add abook_not_here smallint not null default 0 "); $r2 = q("create index abook_not_here on abook (abook_not_here)"); |