Change some fields to blobs.

diff --git a/buildfarm/__init__.py b/buildfarm/__init__.py
index d185ed4bf744b7d382a3456ce28d3fa6b3bb1db6..5d35f42b1b078f3b0c981a2494be3223d315c2d0 100644 (file)
--- a/buildfarm/__init__.py
+++ b/buildfarm/__init__.py
@@ -154,5 +154,3 @@ class BuildFarm(object):
                     yield self.get_build(tree, host, compiler)
                 except data.NoSuchBuildError:
                     pass
-
-

diff --git a/buildfarm/sqldb.py b/buildfarm/sqldb.py
index b69da4d183cb6322caefd944ba9bfea712221c98..e8184c1dde4752a97f7fd150a5798ef56201d9c8 100644 (file)
--- a/buildfarm/sqldb.py
+++ b/buildfarm/sqldb.py
@@ -257,9 +257,9 @@ class StormCachingBuildFarm(BuildFarm):
 
 
 def setup_schema(db):
-    db.execute("CREATE TABLE IF NOT EXISTS host (name text, owner text, owner_email text, password text, ssh_access int, fqdn text, platform text, permission text, last_dead_mail int, join_time int);", noresult=True)
+    db.execute("CREATE TABLE IF NOT EXISTS host (name blob, owner text, owner_email text, password text, ssh_access int, fqdn text, platform text, permission text, last_dead_mail int, join_time int);", noresult=True)
     db.execute("CREATE UNIQUE INDEX IF NOT EXISTS unique_hostname ON host (name);", noresult=True)
-    db.execute("CREATE TABLE IF NOT EXISTS build (id integer primary key autoincrement, tree text, revision text, host text, compiler text, checksum text, age int, status text, commit_revision text);", noresult=True)
+    db.execute("CREATE TABLE IF NOT EXISTS build (id integer primary key autoincrement, tree blob, revision blob, host blob, compiler blob, checksum blob, age int, status blob, commit_revision blob);", noresult=True)
     db.execute("CREATE UNIQUE INDEX IF NOT EXISTS unique_checksum ON build (checksum);", noresult=True)