nazwa bazy: ipprojectdb
user: server password: pass

DROP TABLE personal_data;
CREATE TABLE personal_data (
    id              INTEGER AUTO_INCREMENT PRIMARY KEY,
    username        VARCHAR(30) NOT NULL UNIQUE,
    password        VARCHAR(30) NOT NULL,
    name            VARCHAR(30),
    surname         VARCHAR(30),
    pesel           VARCHAR(11) DEFAULT NULL,
    birth_date      DATE,
    address         VARCHAR(40),
    bank_account    VARCHAR(26),
    id_card_number  VARCHAR(10),
    status          VARCHAR(8) NOT NULL
);

INSERT INTO ipprojectdb.personal_data (username, password, `name`, surname, pesel, birth_date, address, bank_account, id_card_number, status)
    VALUES ('Jan', 'pass', 'Jan', 'Kapusta', '93080909699', '1993-08-09', 'Kielce, Wrzosowa 258', '699658458712543652', 'AUC235154', 'customer');


INSERT INTO ipprojectdb.personal_data (username, password, `name`, surname, pesel, birth_date, address, bank_account, id_card_number, status)
    VALUES ('Ignacy', 'ignas', 'Ignacy', 'Klata', '88092098456', '1988-09-20', 'Zabrze, Ubezpieczeniowa 10', '231456236585694587', 'ALK6969960', 'worker');