CREATE DATABASE IF NOT EXISTS testdb;
USE testdb;
CREATE TABLE IF NOT EXISTS tbl_users (
userID int(11) NOT NULL AUTO_INCREMENT,
userName varchar(20) NOT NULL,
userProfession varchar(50) NOT NULL,
userPic varchar(200) NOT NULL,
dni varchar(200)DEFAULT '12345678',
telefono varchar(200)DEFAULT '900150503',
PRIMARY KEY (userID)
) ENGINE=INNODB;
CREATE DATABASE IF NOT EXISTS testdb;
USE testdb;
CREATE TABLE IF NOT EXISTS tbl_trabajos (
workID int(11) NOT NULL AUTO_INCREMENT,
userID int(11) NOT NULL,
fechatrabajo TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
incidencias varchar(50) NOT NULL,
notas varchar(50),
firma varchar(200) NOT NULL,
PRIMARY KEY (workID),
FOREIGN KEY (userID) REFERENCES tbl_users(userID)
) ENGINE=INNODB;