CREATE DATABASE hotel ;
USE hotel;
CREATE TABLE customer(
customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
first_name VARCHAR(60) NOT NULL,
last_name VARCHAR(60) NOT NULL,
customer_age MEDIUMINT NOT NULL,
address VARCHAR(100) NOT NULL,
pass VARCHAR(50) NOT NULL,
phone VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL,
PRIMARY KEY(customer_id)
);
USE hotel;
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)     VALUES ('Alex','Papadopoulos',22,'Stadiou 9','22','2013847577','ap@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)     VALUES ('Kostas','Papadopoulos',21,'Panepistimiou 9','32','2013447567','kp@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)    VALUES ('Alex','Kostopoulos',35,'Stadiou 19','42','2013847546','ak@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)     VALUES ('Efi','Papagianni',49,'Stadiou 59','52','2013847598','ep@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)    VALUES ('Giannis','Xristopoulos',55,'Stadiou 89','62','2013847523','gx@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)    VALUES ('Maria','Xronaki',68,'Panepistimiou 9','89','2013847529','mx@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)     VALUES ('Christina','Papadopoulou',17,'Akadimias 19','pr23','2013847539','chp@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)   VALUES ('Despina','Hliopoulou',77,' Akadimias 9','bd28','20138475649','dh@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)     VALUES ('Marianna','Papadaki',45,'Solonos 9','rs29','2013847559','mp@ua.gr');
INSERT INTO customer (first_name,last_name,customer_age,address,pass, phone,email)    VALUES ('Vasilis','Papadakis',55,' Solonos 35','gb100','2013847567','vp@ua.gr');