42 lines
684 B
SQL
42 lines
684 B
SQL
CREATE DATABASE IF NOT EXISTS Items;
|
|
|
|
CREATE TABLE IF NOT EXISTS 'Laptop' (
|
|
'Model' ,
|
|
'CPU_Count' ,
|
|
'RAM_Amount' ,
|
|
'Operating_System' ,
|
|
'Battery_Size'
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS 'Redbull' (
|
|
'Size' ,
|
|
'Flavour' ,
|
|
'Caffeine_Count' ,
|
|
'Sugar_Count' ,
|
|
'Measurement_Unit'
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS 'Car' (
|
|
'Make' ,
|
|
'Model' ,
|
|
'Engine_Size' ,
|
|
'Passenger_Count' ,
|
|
'Feul_Eco'
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS 'Chair' (
|
|
'Style' ,
|
|
'Condition' ,
|
|
'Manufacturer' ,
|
|
'Type' ,
|
|
'Colour'
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS 'Sweater' (
|
|
'Purchased_From' ,
|
|
'Size' ,
|
|
'Zippered' ,
|
|
'Material' ,
|
|
'Fitment'
|
|
);
|