CREATE DATABASE `nasdaq`;

USE `nasdaq`;

CREATE TABLE Company(
       ticker VARCHAR (5) NOT NULL,
       name VARCHAR (50),
       description TEXT,
       PRIMARY KEY (ticker)
);

CREATE TABLE Stock (
	stock_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
	ticker VARCHAR(5),
	date VARCHAR(10),
	open FLOAT UNSIGNED,
	max FLOAT UNSIGNED,
	min FLOAT UNSIGNED,
	close FLOAT UNSIGNED,
	vol INTEGER UNSIGNED,
	PRIMARY KEY (stock_id)
);