Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python
- # -*- coding: utf-8 -*-
- import sqlite3 as db
- conn = db.connect('herostat.db')
- c = conn.cursor()
- c.execute('''CREATE TABLE warrior_stat
- (con int, str int, wit int, _int int, dex int, mp int, pdef int, mdef int, patack int, matack int)''')
- c.execute("""INSERT INTO warrior_stat
- VALUES (3000, 300, 9, 9, 5, 1500, 1700, 700, 200, 120)""")
- c.execute('''CREATE TABLE archer_stat
- (con int, str int, wit int, _int int, dex int, mp int, pdef int, mdef int, patack int, matack int)''')
- c.execute("""INSERT INTO archer_stat
- VALUES (2300, 250, 9, 9, 20, 1800, 1200, 800, 250, 120)""")
- c.execute('''CREATE TABLE wizard_stat
- (con int, str int, wit int, _int int, dex int, mp int, pdef int, mdef int, patack int, matack int)''')
- c.execute("""INSERT INTO wizard_stat
- VALUES (1800, 80, 750, 300, 20, 2300, 700, 1200, 120, 300)""")
- conn.commit()
- c.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement