commit 475753091b51a2c255dce94e16cb4f8e4d7807f2 Author: Sathyanarayanan Gunasekaran <gsathya.ceg@gmail.com> Date: Tue Sep 25 17:30:45 2012 +0530 Use "text" type in database schema --- pyonionoo/database.py | 26 +++++++++++++------------- 1 files changed, 13 insertions(+), 13 deletions(-) diff --git a/pyonionoo/database.py b/pyonionoo/database.py index ab02845..f342be3 100644 --- a/pyonionoo/database.py +++ b/pyonionoo/database.py @@ -40,21 +40,21 @@ FRESHEN_TIMER = None summary_tbl_name = 'summary' summary_schema = """ id INTEGER PRIMARY KEY, -type CHARACTER, -nickname STRING, -fingerprint STRING, -hashed_fingerprint STRING, +type TEXT, +nickname TEXT, +fingerprint TEXT, +hashed_fingerprint TEXT, running BOOLEAN, -time_published STRING, -or_port STRING, -dir_port STRING, +time_published TEXT, +or_port TEXT, +dir_port TEXT, consensus_weight INTEGER, -country_code STRING, -hostname STRING, -time_lookup STRING, -flags STRING, -addresses STRING, -search STRING +country_code TEXT, +hostname TEXT, +time_lookup TEXT, +flags TEXT, +addresses TEXT, +search TEXT """ def _create_table(conn, tbl_name, schema):