Closed supirman closed 7 years ago
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);
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);