Mercurial > kallithea

comparison pylons_app/lib/db_manage.py @ 67:ffd9ff6e2f33

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fixed name bug in create db script
author Marcin Kuzminski <marcin@python-blog.com>
date Sat, 10 Apr 2010 19:44:22 +0200
parents 163464441e0d
children 911dab498eb2
comparison
equal deleted inserted replaced
66:163464441e0d 67:ffd9ff6e2f33
29 (user_id INTEGER PRIMARY KEY AUTOINCREMENT, 29 (user_id INTEGER PRIMARY KEY AUTOINCREMENT,
30 username TEXT, 30 username TEXT,
31 password TEXT, 31 password TEXT,
32 active INTEGER, 32 active INTEGER,
33 admin INTEGER)""") 33 admin INTEGER)""")
34 logging.info('creating table %s', 'user_loggings') 34 logging.info('creating table %s', 'user_logs')
35 cur.execute("""DROP TABLE IF EXISTS user_loggings """) 35 cur.execute("""DROP TABLE IF EXISTS user_logs """)
36 cur.execute("""CREATE TABLE user_loggings 36 cur.execute("""CREATE TABLE user_logs
37 (id INTEGER PRIMARY KEY AUTOINCREMENT, 37 (id INTEGER PRIMARY KEY AUTOINCREMENT,
38 user_id INTEGER, 38 user_id INTEGER,
39 repository TEXT, 39 repository TEXT,
40 action TEXT, 40 action TEXT,
41 action_date DATETIME)""") 41 action_date DATETIME)""")