g1TES4n6

1Authors = sqlite3.connect('Authors.db')
2Authors.execute('''CREATE TABLE Authors
3       (AuthorID      INT  PRIMARY KEY, 
4       Name           TEXT);''')
5Authors.close()
6
7
8Books = sqlite3.connect('Books.db')
9Books.execute('''CREATE TABLE Books
10       (BookID            INT  PRIMARY KEY, 
11       Title              TEXT,
12       AuthorID           INT,
13       FOREIGN KEY(AuthorID) REFERENCES Authors(AuthorID));''')
14Books.close()
15	
16Authors = sqlite3.connect('Authors.db') 
17Authors.execute("INSERT INTO Authors (AuthorID, Name) 
18        VALUES (1, 'Jane Austin')");
19
20Authors.commit()
21Authors.close()
22
23
24Books = sqlite3.connect('Books.db')
25Books.execute("INSERT INTO Books (BookID, Title, AuthorID) 
26        VALUES (1, 'Emma', 1)");
27
28Books.commit()
29Books.close()
30	
31Books.execute("PRAGMA foreign_keys = 1")
32	
33conn=sqlite3.connect("clientdatabase.db")
34conn.execute("PRAGMA foreign_keys = 1")
35cur=conn.cursor()
36
37# Create 2 tables if they don't exist: Clients and Work_Done
38cur.execute('''CREATE TABLE IF NOT EXISTS Clients
39(CID INTEGER PRIMARY KEY,
40First_Name  TEXT    NOT NULL,
41Last_Name       TEXT,
42Business_Name   TEXT,
43Phone           TEXT,
44Address         TEXT,
45City            TEXT,
46Notes           TEXT,
47Active_Status   TEXT    NOT NULL)''')      
48
49cur.execute('''CREATE TABLE IF NOT EXISTS Work_Done
50(ID INTEGER PRIMARY KEY,
51Date            TEXT    NOT NULL,
52Onsite_Contact  TEXT,
53Work_Done       TEXT    NOT NULL,
54Parts_Installed TEXT,
55Next_Steps      TEXT,
56CID             INT,
57FOREIGN KEY (CID) REFERENCES CLIENTS (CID))''')
58conn.commit()