CREATE DATABASE guias;
USE guias;
CREATE TABLE soliguias (
	id INT AUTO_INCREMENT NOT NULL,
	mineral VARCHAR(60) NOT NULL,
	cantiguias INT NOT NULL,
	montcance BOOLEAN NOT NULL,
	tipodetransa VARCHAR(20) NOT NULL,
	numdetransa VARCHAR(30) NOT NULL,
	fechdetransa DATETIME NOT NULL,
	bancrecep VARCHAR(30) NOT NULL,
	observ TEXT NOT NULL,

       PRIMARY KEY(id)

);

CREATE TABLE empresa (
	nomempre VARCHAR(50) NOT NULL,
	rif VARCHAR(20),
	cantfuse VARCHAR(25) NOT NULL,
	municipio VARCHAR(30) NOT NULL,
	parroquia VARCHAR(20) NOT NULL,
	nderereg INT(25) NOT NULL,
	nprovi INT(25) NOT NULL,
	telefonos INT NOT NULL,
	fax INT(25),
	correo VARCHAR(30) NOT NULL,

       PRIMARY KEY(rif)

);

CREATE TABLE usuario (
	nombres VARCHAR(50) NOT NULL,
	apellidos VARCHAR(50) NOT NULL,
	ci INT(15) NOT NULL,
	//rif VARCHAR(20),
	telefonos INT(15) NOT NULL,
	fax INT(15),
	correo VARCHAR(30) NOT NULL,
	sericarnet VARCHAR(25),
	codcarnet VARCHAR(25),
	recon VARCHAR(15) NOT NULL,

       PRIMARY KEY(ci)

);