diff --git a/Makefile b/Makefile
index 73823df..993247b 100644
--- a/Makefile
+++ b/Makefile
@@ -1,77 +1,86 @@
 GITREV=`git describe --tags | cut -c 2-`
 LDFLAGS=-ldflags="-X 'github.com/writeas/writefreely.softwareVer=$(GITREV)'"
 
 GOCMD=go
 GOINSTALL=$(GOCMD) install $(LDFLAGS)
 GOBUILD=$(GOCMD) build $(LDFLAGS)
 GOTEST=$(GOCMD) test $(LDFLAGS)
 GOGET=$(GOCMD) get
 BINARY_NAME=writefreely
 DOCKERCMD=docker
 IMAGE_NAME=writeas/writefreely
 
 all : build
 
 build: deps
 	cd cmd/writefreely; $(GOBUILD) -v
 
 build-linux: deps
-	cd cmd/writefreely; GOOS=linux GOARCH=amd64 $(GOBUILD) -v
+	@hash xgo > /dev/null 2>&1; if [ $$? -ne 0 ]; then \
+		$(GOGET) -u github.com/karalabe/xgo; \
+	fi
+	xgo --targets=linux/amd64, -dest build/ $(LDFLAGS) -out writefreely ./cmd/writefreely
 
 build-windows: deps
-	cd cmd/writefreely; GOOS=windows GOARCH=amd64 $(GOBUILD) -v
+	@hash xgo > /dev/null 2>&1; if [ $$? -ne 0 ]; then \
+		$(GOGET) -u github.com/karalabe/xgo; \
+	fi
+	xgo --targets=windows/amd64, -dest build/ $(LDFLAGS) -out writefreely ./cmd/writefreely
 
 build-darwin: deps
-	cd cmd/writefreely; GOOS=darwin GOARCH=amd64 $(GOBUILD) -v
+	@hash xgo > /dev/null 2>&1; if [ $$? -ne 0 ]; then \
+		$(GOGET) -u github.com/karalabe/xgo; \
+	fi
+	xgo --targets=darwin/amd64, -dest build/ $(LDFLAGS) -out writefreely ./cmd/writefreely
 
 build-docker :
 	$(DOCKERCMD) build -t $(IMAGE_NAME):latest -t $(IMAGE_NAME):$(GITREV) .
 
 test:
 	$(GOTEST) -v ./...
 
 run:
 	$(GOINSTALL) ./...
 	$(BINARY_NAME) --debug
 
 deps :
 	$(GOGET) -v ./...
 
 install : build
 	cmd/writefreely/$(BINARY_NAME) --gen-keys
 	cd less/; $(MAKE) install $(MFLAGS)
 
 release : clean ui
 	mkdir build
 	cp -r templates build
 	cp -r pages build
 	cp -r static build
 	mkdir build/keys
 	cp schema.sql build
 	cp sqlite.sql build
 	$(MAKE) build-linux
-	cp cmd/writefreely/$(BINARY_NAME) build
+	mv build/$(BINARY_NAME)-linux-amd64 build/$(BINARY_NAME)
 	cd build; tar -cvzf ../$(BINARY_NAME)_$(GITREV)_linux_amd64.tar.gz *
 	rm build/$(BINARY_NAME)
 	$(MAKE) build-darwin
-	cp cmd/writefreely/$(BINARY_NAME) build
+	mv build/$(BINARY_NAME)-darwin-10.6-amd64 build/$(BINARY_NAME)
 	cd build; tar -cvzf ../$(BINARY_NAME)_$(GITREV)_darwin_amd64.tar.gz *
 	rm build/$(BINARY_NAME)
 	$(MAKE) build-windows
-	cp cmd/writefreely/$(BINARY_NAME).exe build
+	mv build/$(BINARY_NAME)-windows-4.0-amd64.exe build/$(BINARY_NAME).exe
 	cd build; zip -r ../$(BINARY_NAME)_$(GITREV)_windows_amd64.zip ./*
 	$(MAKE) build-docker
 	$(MAKE) release-docker
 
 release-docker :
 	$(DOCKERCMD) push $(IMAGE_NAME)
 	
 ui : force_look
 	cd less/; $(MAKE) $(MFLAGS)
 
 clean :
 	-rm -rf build
 	cd less/; $(MAKE) clean $(MFLAGS)
 
 force_look : 
 	true
diff --git a/schema.sql b/schema.sql
index 7058f40..2e2953a 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,203 +1,203 @@
 --
 -- Database: `writefreely`
 --
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `accesstokens`
 --
 
 CREATE TABLE IF NOT EXISTS `accesstokens` (
   `token` binary(16) NOT NULL,
   `user_id` int(6) NOT NULL,
   `sudo` tinyint(1) NOT NULL DEFAULT '0',
   `one_time` tinyint(1) NOT NULL DEFAULT '0',
   `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `expires` datetime DEFAULT NULL,
-  `user_agent` varchar(255) NOT NULL,
+  `user_agent` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`token`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `appcontent`
 --
 
 CREATE TABLE IF NOT EXISTS `appcontent` (
   `id` varchar(36) NOT NULL,
   `content` mediumtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `collectionattributes`
 --
 
 CREATE TABLE IF NOT EXISTS `collectionattributes` (
   `collection_id` int(6) NOT NULL,
   `attribute` varchar(128) NOT NULL,
   `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   PRIMARY KEY (`collection_id`,`attribute`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `collectionkeys`
 --
 
 CREATE TABLE IF NOT EXISTS `collectionkeys` (
   `collection_id` int(6) NOT NULL,
   `public_key` blob NOT NULL,
   `private_key` blob NOT NULL,
   PRIMARY KEY (`collection_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `collectionpasswords`
 --
 
 CREATE TABLE IF NOT EXISTS `collectionpasswords` (
   `collection_id` int(6) NOT NULL,
   `password` char(60) NOT NULL,
   PRIMARY KEY (`collection_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `collectionredirects`
 --
 
 CREATE TABLE IF NOT EXISTS `collectionredirects` (
   `prev_alias` varchar(100) NOT NULL,
   `new_alias` varchar(100) NOT NULL,
   PRIMARY KEY (`prev_alias`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `collections`
 --
 
 CREATE TABLE IF NOT EXISTS `collections` (
   `id` int(6) NOT NULL AUTO_INCREMENT,
   `alias` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   `description` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   `style_sheet` text,
   `script` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
   `format` varchar(8) DEFAULT NULL,
   `privacy` tinyint(1) NOT NULL,
   `owner_id` int(6) NOT NULL,
   `view_count` int(6) NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `alias` (`alias`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `posts`
 --
 
 CREATE TABLE IF NOT EXISTS `posts` (
   `id` char(16) NOT NULL,
   `slug` varchar(100) DEFAULT NULL,
   `modify_token` char(32) DEFAULT NULL,
   `text_appearance` char(4) NOT NULL DEFAULT 'norm',
   `language` char(2) DEFAULT NULL,
   `rtl` tinyint(1) DEFAULT NULL,
   `privacy` tinyint(1) NOT NULL,
   `owner_id` int(6) DEFAULT NULL,
   `collection_id` int(6) DEFAULT NULL,
   `pinned_position` tinyint(1) UNSIGNED DEFAULT NULL,
   `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `view_count` int(6) NOT NULL,
   `title` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `id_slug` (`collection_id`,`slug`),
   UNIQUE KEY `owner_id` (`owner_id`,`id`),
   KEY `privacy_id` (`privacy`,`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `remotefollows`
 --
 
 CREATE TABLE IF NOT EXISTS `remotefollows` (
   `collection_id` int(11) NOT NULL,
   `remote_user_id` int(11) NOT NULL,
   `created` datetime NOT NULL,
   PRIMARY KEY (`collection_id`,`remote_user_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `remoteuserkeys`
 --
 
 CREATE TABLE IF NOT EXISTS `remoteuserkeys` (
   `id` varchar(255) NOT NULL,
   `remote_user_id` int(11) NOT NULL,
   `public_key` blob NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `follower_id` (`remote_user_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `remoteusers`
 --
 
 CREATE TABLE IF NOT EXISTS `remoteusers` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `actor_id` varchar(255) NOT NULL,
   `inbox` varchar(255) NOT NULL,
   `shared_inbox` varchar(255) NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `collection_id` (`actor_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `userattributes`
 --
 
 CREATE TABLE IF NOT EXISTS `userattributes` (
   `user_id` int(6) NOT NULL,
   `attribute` varchar(64) NOT NULL,
   `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   PRIMARY KEY (`user_id`,`attribute`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table `users`
 --
 
 CREATE TABLE IF NOT EXISTS `users` (
   `id` int(6) NOT NULL AUTO_INCREMENT,
   `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
   `password` char(60) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   `email` varbinary(255) DEFAULT NULL,
   `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
   UNIQUE KEY `username` (`username`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
diff --git a/sqlite.sql b/sqlite.sql
index 8b5d2a1..6ce2b6b 100644
--- a/sqlite.sql
+++ b/sqlite.sql
@@ -1,191 +1,191 @@
 --
 -- Database: writefreely
 --
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table accesstokens
 --
 
 CREATE TABLE IF NOT EXISTS `accesstokens` (
   token TEXT NOT NULL PRIMARY KEY,
   user_id INTEGER NOT NULL,
   sudo INTEGER NOT NULL DEFAULT '0',
   one_time INTEGER NOT NULL DEFAULT '0',
   created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
   expires DATETIME DEFAULT NULL,
-  user_agent TEXT NOT NULL
+  user_agent TEXT DEFAULT NULL
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table appcontent
 --
 
 CREATE TABLE IF NOT EXISTS `appcontent` (
   id TEXT NOT NULL PRIMARY KEY,
   content TEXT NOT NULL,
   updated DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table collectionattributes
 --
 
 CREATE TABLE IF NOT EXISTS `collectionattributes` (
   collection_id INTEGER NOT NULL,
   attribute TEXT NOT NULL,
   value TEXT NOT NULL,
   PRIMARY KEY (collection_id, attribute)
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table collectionkeys
 --
 
 CREATE TABLE IF NOT EXISTS `collectionkeys` (
   collection_id INTEGER PRIMARY KEY,
   public_key blob NOT NULL,
   private_key blob NOT NULL
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table collectionpasswords
 --
 
 CREATE TABLE IF NOT EXISTS `collectionpasswords` (
   collection_id INTEGER PRIMARY KEY,
   password TEXT NOT NULL
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table collectionredirects
 --
 
 CREATE TABLE IF NOT EXISTS `collectionredirects` (
   prev_alias TEXT NOT NULL PRIMARY KEY,
   new_alias TEXT NOT NULL
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table collections
 --
 
 CREATE TABLE IF NOT EXISTS `collections` (
   id INTEGER PRIMARY KEY AUTOINCREMENT,
   alias TEXT DEFAULT NULL UNIQUE,
   title TEXT NOT NULL,
   description TEXT NOT NULL,
   style_sheet TEXT,
   script TEXT,
   format TEXT DEFAULT NULL,
   privacy INTEGER NOT NULL,
   owner_id INTEGER NOT NULL,
   view_count INTEGER NOT NULL
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table posts
 --
 
 CREATE TABLE IF NOT EXISTS `posts` (
   id TEXT NOT NULL,
   slug TEXT DEFAULT NULL,
   modify_token TEXT DEFAULT NULL,
   text_appearance TEXT NOT NULL DEFAULT 'norm',
   language TEXT DEFAULT NULL,
   rtl INTEGER DEFAULT NULL,
   privacy INTEGER NOT NULL,
   owner_id INTEGER DEFAULT NULL,
   collection_id INTEGER DEFAULT NULL,
   pinned_position INTEGER UNSIGNED DEFAULT NULL,
   created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
   updated DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
   view_count INTEGER NOT NULL,
   title TEXT NOT NULL,
   content TEXT NOT NULL,
   CONSTRAINT id_slug UNIQUE (collection_id, slug),
   CONSTRAINT owner_id UNIQUE (owner_id, id),
   CONSTRAINT privacy_id UNIQUE (privacy, id)
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table remotefollows
 --
 
 CREATE TABLE IF NOT EXISTS `remotefollows` (
   collection_id INTEGER NOT NULL,
   remote_user_id INTEGER NOT NULL,
   created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (collection_id,remote_user_id)
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table remoteuserkeys
 --
 
 CREATE TABLE IF NOT EXISTS `remoteuserkeys` (
   id TEXT NOT NULL,
   remote_user_id INTEGER NOT NULL,
   public_key blob NOT NULL,
   CONSTRAINT follower_id UNIQUE (remote_user_id)
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table remoteusers
 --
 
 CREATE TABLE IF NOT EXISTS `remoteusers` (
   id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   actor_id TEXT NOT NULL,
   inbox TEXT NOT NULL,
   shared_inbox TEXT NOT NULL,
   CONSTRAINT collection_id UNIQUE (actor_id)
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table userattributes
 --
 
 CREATE TABLE IF NOT EXISTS `userattributes` (
   user_id INTEGER NOT NULL,
   attribute TEXT NOT NULL,
   value TEXT NOT NULL,
   PRIMARY KEY (user_id, attribute)
 );
 
 -- --------------------------------------------------------
 
 --
 -- Table structure for table users
 --
 
 CREATE TABLE IF NOT EXISTS `users` (
   id INTEGER PRIMARY KEY AUTOINCREMENT,
   username TEXT NOT NULL UNIQUE,
   password TEXT NOT NULL,
   email TEXT DEFAULT NULL,
   created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
 );