--- a/talosnames/api.py	Fri Jul 06 16:22:42 2012 -0700
+++ b/talosnames/api.py	Sun Jul 08 10:09:51 2012 -0700
@@ -1,5 +1,21 @@
+import sqlite3
+import urllib2
+
 class TalosNames(object):
     graphserver_sql = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/data.sql'
-    
+    schema = 'http://hg.mozilla.org/graphs/raw-file/tip/sql/schema.sql'
+
+    tables = ['os_list',
+              'branches',
+              'machines',
+              'pagesets',
+              'tests']
+
     def __init__(self):
-        import pdb; pdb.set_trace()
+        self.db = sqlite3.connect(':memory:')
+        for table in self.tables:
+            pass
+        schema = urllib2.urlopen(self.schema).read()
+        cursor = self.db.cursor()
+        cursor.executescript(schema)
+