bikin database antivirus online

-member :
id_member int,
nama varchar (300),
email varchar(300),
password  varchar(300),
status enum ( 'admin','public','premium' )

-virus :

create table virus(

id_virus int,
id_member int,
nama varchar (300),
datavirus text,
deskripsi text,
tgl_buat datetime

)

-dataweb :
id_dataweb int ,
id_member int , ggg
nama varchar (300),
url varchar (300),
user char (8),
password varchar (300)


-backup file :
create table backupfile(
id_backupfile int,
id_dataweb int, ggg
nama varchar(300),
alamatbackup text,
tgl_backup datetime

)


menambahkan primary key

alter table member add primary key (id_member) // cara cek di datebase tabel masing2 apa bila sudah ada garis bawahnya maka udah benar
alter table virus add primary key (id_virus)
alter table dataweb add primary key (id_dataweb)
alter table backupfile add primary key (id_backupfile)

menambahkan foreign key

alter table virus add foreign key  (id_member) references member (id_member)
alter table dataweb add foreign key  (id_member) references member (id_member)
alter table backupfile add foreign key (id_dataweb) references dataweb (id_dataweb)

Read more »