· 8 years ago · Aug 27, 2018, 11:30 AM
1 cur.execute(
2 '''CREATE TABLE IF NOT EXISTS proteins
3 (uniprotid TEXT PRIMARY KEY)
4 WITHOUT ROWID
5 ''')
6 cur.execute(
7 '''CREATE TABLE IF NOT EXISTS DBS
8 (protein TEXT, ionType TEXT, charge INTEGER, numPeaks INTEGER,
9 PRIMARY KEY (protein, ionType, charge), FOREIGN KEY (protein) REFERENCES proteins(uniprotid))
10 WITHOUT ROWID
11 ''')