def create_actors_movies_table(): query = """CREATE TABLE IF NOT EXISTS actors_movies ( actors_movies_Id INTEGER PRIMARY KEY AUTOINCREMENT, actorsId int, moviesId int, FOREIGN KEY (actorsId) REFERENCES actors(actorsId), FOREIGN KEY (moviesId) REFERENCES movies(moviesId))""" create_table_database(query)
def create_genres_movies_table(): query = """CREATE TABLE IF NOT EXISTS genres ( Id INTEGER PRIMARY KEY AUTOINCREMENT, genresId INTEGER, FOREIGN KEY (genresId) REFERENCES genres(genresId), moviesId INTEGER, FOREIGN KEY (moviesId) REFERENCES movies(moviesId)))""" create_table_database(query)
def create_directors_movie_table(): query = """CREATE TABLE IF NOT EXISTS directors ( Id INTEGER PRIMARY KEY AUTOINCREMENT, moviesId INTEGER, FOREIGN KEY (moviesId) REFERENCES movies(moviesId), directorsId INTEGER FOREIGN KEY (directorsId) REFERENCES directors(directorsId))""" create_table_database(query)
def create_directors_movies_table(): query = """CREATE TABLE IF NOT EXISTS actors_movies ( director_movie_id INTEGER PRIMARY KEY AUTOINCREMENT, director_id int, movie_id int, movie_id FOREIGN KEY (movie_id) REFERENCES actors(movie_id), director_id FOREIGN KEY (director_id) REFERENCES actors(director_id)""" create_table_database(query)
def create_movies_table(): query = """CREATE TABLE IF NOT EXISTS movies( movie_id INTEGER PRIMARY KEY AUTOINCREMENT, movie_name TEXT UNIQUE, release_date DATE, rating REAL, genre TEXT )""" create_table_database(query)
def create_movies_table(): query = """CREATE TABLE IF NOT EXISTS movies ( moviesId INTEGER PRIMARY KEY AUTOINCREMENT, movie_name TEXT, release_date DATE, rating REAL, genre TEXT, studioId INTEGER, boxofficeId INTEGER, FOREIGN KEY (studioId) REFERENCES studios(studioId), FOREIGN KEY (boxofficeId) REFERENCES box_offices(boxofficeId))""" create_table_database(query)
def create_actors_table(): query = """CREATE TABLE IF NOT EXISTS actors ( actorsId INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)""" create_table_database(query)
def create_box_offices_table(): query = """CREATE TABLE IF NOT EXISTS box_offices ( box_office_id INTEGER PRIMARY KEY AUTOINCREMENT, box_office_gross TEXT)""" create_table_database(query)
def create_genres_table(): query = """CREATE TABLE IF NOT EXISTS genres ( genre_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)""" create_table_database(query)
def create_movies_genres_table(): query = """CREATE TABLE IF NOT EXISTS movie_genres ( genre_movie_id INTEGER PRIMARY KEY AUTOINCREMENT, genre_id FOREIGN KEY (genre_id) REFERENCES actors(genre_id), movie_id FOREIGN KEY (movie_id) REFERENCES actors(movie_id)""" create_table_database(query)
def create_studios_table(): query = """CREATE TABLE IF NOT EXISTS studios ( studio_id INTEGER PRIMARY KEY AUTOINCREMENT, studio_name TEXT)""" create_table_database(query)