jaryer.blogg.se

REFERENCES language (language_id) ON DELETE RESTRICT ON UPDATE CASCADE,ĬONSTRAINT fk_film_language_original FOREIGN KEY (original_language_id) 99,ĬONSTRAINT fk_film_language FOREIGN KEY (language_id)

Replacement_cost DECIMAL( 5, 2) NOT NULL DEFAULT 19. Rental_rate DECIMAL( 4, 2) NOT NULL DEFAULT 4. Rental_duration TINYINT UNSIGNED NOT NULL DEFAULT 3, Original_language_id TINYINT UNSIGNED DEFAULT NULL, REFERENCES store (store_id) ON DELETE RESTRICT ON UPDATE CASCADEįilm_id INTEGER PRIMARY KEY AUTOINCREMENT, REFERENCES address (address_id) ON DELETE RESTRICT ON UPDATE CASCADE,ĬONSTRAINT fk_customer_store FOREIGN KEY (store_id) REFERENCES country (country_id) ON DELETE RESTRICT ON UPDATE CASCADEĬountry_id INTEGER PRIMARY KEY AUTOINCREMENT,Ĭustomer_id INTEGER PRIMARY KEY AUTOINCREMENT,ĬONSTRAINT fk_customer_address FOREIGN KEY (address_id) REFERENCES city (city_id) ON DELETE RESTRICT ON UPDATE CASCADEĬategory_id INTEGER PRIMARY KEY AUTOINCREMENT,Ĭity_id INTEGER PRIMARY KEY AUTOINCREMENT,ĬONSTRAINT `fk_city_country ` FOREIGN KEY (country_id) Actor_id INTEGER PRIMARY KEY AUTOINCREMENT,Īddress_id INTEGER PRIMARY KEY AUTOINCREMENT,ĬONSTRAINT `fk_address_city ` FOREIGN KEY (city_id)