Membuat schema database

[supirman]

No description provided.

[DienastyaGalih]

CREATE TABLE ProfileUser (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
nama VARCHAR(100) NULL ,
pekerjaan VARCHAR(100) NULL ,
email VARCHAR(100) NULL ,
instansi VARCHAR(100) NULL ,
photoProfile VARCHAR(100) NULL ,
note VARCHAR(100) NULL ,
PRIMARY KEY(id));

CREATE TABLE SosmedAkun (
ProfileUser_id INTEGER UNSIGNED NOT NULL ,
link VARCHAR(100) NOT NULL AUTO_INCREMENT,
name VARCHAR(100) NULL ,
FOREIGN KEY(ProfileUser_id)
REFERENCES ProfileUser(id)
ON DELETE NO ACTION
ON UPDATE NO ACTION);

[DienastyaGalih]