Update create_db.py

Sebastian Raschka · Sebastian Raschka · commit 3139a22f38b3 · 2013-12-02T18:20:58.000-05:00
diff --git a/sqlite3/create_db.py b/sqlite3/create_db.py
@@ -9,7 +9,7 @@
 
 # create table
 c.execute('''CREATE TABLE zinc_db1
-             (zinc_id TEXT, purchasable TEXT, non_rot_bonds INT)''')
+             (zinc_id PRIMARY KEY, purchasable TEXT, non_rot_bonds INT)''')
 
 # Insert one row of data
 c.execute("INSERT INTO zinc_db1 VALUES ('ZINC00895032','YES', 4)")
