| 15 |
|
cursor.execute("""CREATE TABLE main_app_system(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT, short_name TEXT, relative_file_path TEXT)""") |
| 16 |
|
|
| 17 |
|
cursor.execute("""CREATE TABLE no_intro_system(id INTEGER NOT NULL PRIMARY KEY, name TEXT, description TEXT, dat_version TEXT)""") |
| 18 |
< |
#conn.commit() |
| 18 |
> |
|
| 19 |
|
|
| 20 |
|
cursor.execute("""CREATE TABLE no_intro_main (game_name TEXT, no_intro_id TEXT, clone_of_id TEXT, description TEXT, rom_name TEXT, crc TEXT, md5 TEXT, sha1 TEXT, sha256 TEXT, status TEXT, no_intro_system_id INTEGER NOT NULL, FOREIGN KEY (no_intro_system_id) REFERENCES no_intro_system(id) )""") |
| 21 |
+ |
|
| 22 |
+ |
cursor.execute("""CREATE TABLE tosec_main (game_name TEXT, description TEXT, rom_name TEXT, crc TEXT, md5 TEXT, sha1 TEXT, system_id INTEGER NOT NULL, FOREIGN KEY (system_id) REFERENCES no_intro_system(id) )""") |
| 23 |
+ |
|
| 24 |
+ |
|
| 25 |
|
conn.commit() |
