SQLize | PHPize | SQLtest

CREATE TABLE competition (competition_id INTEGER PRIMARY KEY, competition_name VARCHAR(30), world_record INTEGER, set_date DATE); CREATE TABLE results (competition_id INTEGER PRIMARY KEY, sportsman_id INTEGER, result INTEGER, city VARCHAR(30), hold_date DATE); CREATE TABLE sportsman (sportsman_id INTEGER PRIMARY KEY, sportsman_name TEXT, rank INTEGER, year_of_birth YEAR, personal_record INTEGER, country TEXT); INSERT INTO results(competition_id, sportsman_id, result, city, hold_date) VALUES (1, 18, 75, "California", "1983-05-08"); INSERT INTO results(competition_id, sportsman_id, result, city, hold_date) VALUES (2, 20, 30, "NY", "1984-06-10"); INSERT INTO results(competition_id, sportsman_id, result, city, hold_date) VALUES (3, 4, 50, "LA", "1990-02-15"); INSERT INTO sportsman (sportsman_id, sportsman_name,rank, year_of_birth,personal_record, country) VALUES (1, "Paolo", 3, "1988", 90, "Argentina"); INSERT INTO sportsman (sportsman_id, sportsman_name,rank, year_of_birth,personal_record, country) VALUES (2, "Alehandro", 4, "1982", 76, "Malasia"); INSERT INTO sportsman (sportsman_id, sportsman_name,rank, year_of_birth,personal_record, country) VALUES (3, "Maek", 5, "1985", 55, "Marakesh"); ALTER TABLE competition MODIFY COLUMN world_record TIME; INSERT INTO competition (competition_id, competition_name, world_record, set_date) VALUES (1, "skuing", "00:00:50", "1983-05-08"); INSERT INTO competition (competition_id, competition_name, world_record, set_date) VALUES (2, "dancing", "00:00:28", "1984-06-10"); INSERT INTO competition (competition_id, competition_name, world_record, set_date) VALUES (3, "hiking", "00:00:59", "1990-02-15"); UPDATE sportsman SET personal_record = '15' WHERE personal_record = '90'; UPDATE sportsman SET personal_record = '16' WHERE personal_record = '76'; ALTER TABLE sportsman MODIFY COLUMN personal_record TIME; SELECT * FROM sportsman; UPDATE results SET result = "25" WHERE competition_id = "1"; ALTER TABLE results MODIFY COLUMN result TIME; SELECT * FROM results; SELECT * FROM competition; ALTER TABLE results ADD FOREIGN KEY(competition_id) REFERENCES competition(competition_id); ALTER TABLE results ADD FOREIGN KEY(sportsman_id) REFERENCES sportsman(sportsman_id);