SQLize | PHPize | SQLtest

create table addresses( id int, house_number int, city varchar(20), postcode varchar(7) ); describe addresses; create table people( id int, first_name varchar(20), last_name varchar(20), address_id int ); describe people; create table pets( id int, name varchar(20), species varchar(20), owner_id int ); describe pets; show tables; alter table addresses add primary key(id); describe addresses; alter table addresses drop primary key; describe addresses; alter table addresses modify id int; describe addresses; alter table addresses add primary key(id); describe addresses; alter table people add primary key(id); describe people; alter table pets add primary key(id); describe pets; alter table people add constraint fk_peopleaddress foreign key(address_id) references addresses(id); describe people; alter table people drop foreign key fk_peopleaddress, drop index fk_peopleaddress; describe people; alter table people add constraint fk_peopleaddress foreign key(address_id) references addresses(id); describe people; alter table pets add constraint fk_petowner foreign key(owner_id) references people(id); describe pets;