Musa Kazim musakazim989
musakazim989
/ Musa_Kazim_01676780800.sql
Created
December 5, 2023 17:57
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE DATABASE cloud_kitchen; | |
| USE cloud_kitchen; | |
| CREATE TABLE menu_items ( | |
| id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, | |
| created_at DATETIME DEFAULT CURRENT_TIMESTAMP, | |
| updated_at DATETIME ON UPDATE CURRENT_TIMESTAMP, | |
| name VARCHAR(60), |
musakazim989
/ Assignment_1.sql
Created
December 5, 2023 15:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE DATABASE book_store; | |
| CREATE TABLE authors ( | |
| id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, | |
| created_at DATETIME DEFAULT CURRENT_TIMESTAMP, | |
| updated_at DATETIME ON UPDATE CURRENT_TIMESTAMP, | |
| date_of_birth DATETIME, | |
| name VARCHAR(50), | |
| avatar_url VARCHAR(200) |