//////////////////////////////////Oracle///////////////////////////////////////////

drop table credit_cards;
drop table user_accounts;

create table user_accounts
(
ID number,
fname varchar2(50),
lname varchar2(50),
username varchar2(20),
password varchar2(20)
);

create table credit_cards
(
ID number,
cc_number varchar(20),
exp_date date
);

alter table user_accounts add constraint pk_id primary key(ID) ;
alter table user_accounts add constraint unique_username unique(username);
alter table credit_cards add constraint fk_id foreign key(ID) references user_accounts(ID) on delete CASCADE;

insert into user_accounts values(1,'John','Smith','jsmith','j123$');
insert into credit_cards values(1,'3243242342','07-JUN-04')



///////////////////////////////////////SQL Server ///////////////////////////////////////////


drop table user_accounts;
drop table credit_cards;
create table user_accounts
(
ID int not null,
fname varchar(50),
lname varchar(50),
username varchar(20),
password varchar(20)
);


create table credit_cards
(
ID int not null,
cc_number varchar(20),
exp_date datetime
);

alter table user_accounts add constraint pk_id primary key(ID) ;
alter table user_accounts add constraint unique_username unique(username);
alter table credit_cards add constraint fk_id foreign key(ID) references user_accounts(ID) on delete set default;
insert into user_accounts values(1,'John','Smith','jsmith','j123$');
insert into credit_cards values(1,'3243242342','06/07/2004')