ViewVC Help

View File | Revision Log | Show Annotations | View Changeset | Root Listing

root/ns_dev/Python/NinoCode/Active_prgs/Gromulus/GromulusDatabaseUtilities.py

Comparing Python/NinoCode/Active_prgs/Gromulus/CreateGromulusDB.py (file contents):
Revision 795 by nino.borges, Fri Sep 8 15:11:11 2023 UTC vs.
Revision 805 by nino.borges, Thu Dec 14 02:42:16 2023 UTC

#	Line 12 | Line 12 | cursor = conn.cursor()
12
13		cursor.execute("""CREATE TABLE main_app(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, game_name TEXT, game_name_scraped TEXT, file_name TEXT, relative_file_path TEXT, description TEXT, description_scraped TEXT, system_console INTEGER, system_console_scraped TEXT, path_to_screenshot TEXT, path_to_video TEXT, user_notes TEXT, md5 TEXT, version text)""")
14
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()
19

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines (old)
>	Changed lines (new)