-
Notifications
You must be signed in to change notification settings - Fork 2
/
database_creation.py
42 lines (32 loc) · 1.05 KB
/
database_creation.py
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
35
36
37
38
39
40
41
42
import sqlite3
#user data
conn = sqlite3.connect('pass_manager.db')
c = conn.cursor()
#User storage
c.execute("""CREATE TABLE IF NOT EXISTS user_data(
M_username TEXT(20) UNIQUE NOT NULL,
master_pwd TEXT(20) NOT NULL,
PRIMARY KEY(M_username)
)""")
c.execute("""CREATE TABLE IF NOT EXISTS user_data_storage(
M_username TEXT(20) NOT NULL,
url TEXT NOT NULL,
user_name TEXT NOT NULL,
service_pwd TEXT NOT NULL,
website_name TEXT NOT NULL,
FOREIGN KEY(M_username) REFERENCES user_data(M_username))""")
c.execute("""CREATE TABLE IF NOT EXISTS admin_user_data(
admin_username TEXT(20) UNIQUE NOT NULL,
admin_pwd TEXT(20) NOT NULL,
PRIMARY KEY(admin_username)
)""")
c.execute("""INSERT INTO admin_user_data
(admin_username, admin_pwd)
VALUES
('adhiraj','1234'),
('bharghav','1234'),
('kanish','1234'),
('seyan','1234');
""")
conn.commit()
conn.close()