ww_robot/sql.py at master · danilsolo/ww_robot · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
import sqlite3

querry = '''
CREATE TABLE profiles(
    id integer PRIMARY KEY,
    username text default null,
    heroflag text default null,
    heroname text default null,
    prof text default null,
    attack integer default 0,
    defense integer default 0,
    exp integer default 0,
    stamina integer default 0,
    mana integer default 0,
    gold integer default 0,
    gems integer default 0,
    wins integer default 0,
    sword text default null,
    dagger text default null,
    head text default null,
    arms text default null,
    body text default null,
    legs text default null,
    specials text default null,
    stock integer default 0,
    pet text default null,
    proftime text default null
)'''

conn = sqlite3.connect('wwbot.db')
c = conn.cursor()
c.execute(querry)
conn.commit()
conn.close()