Recent MySQL query & server results

I've set up SQL on my site so that I can make and share generic examples for recruters to take a look at. As well as to highlight some of the tools in my toolbox. These are intended to be a generic exersice.

Creating a Table called tickets

Query

	CREATE TABLE tickets ( 

	ticket_id INT AUTO_INCREMENT PRIMARY KEY,

	project_name VARCHAR(255),

	member_id INT,

	subject VARCHAR(255) NOT NULL,

	description TEXT,

	intent VARCHAR(255),

	status ENUM('open', 'closed', 'pending') NOT NULL DEFAULT 'open',

	priority ENUM('low', 'medium', 'high') NOT NULL DEFAULT 'medium',

	assignedto INT,

	updatedby INT,

	channel VARCHAR(255),

	created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

	first_response DATETIME,

	update_response DATETIME,

	resolved DATETIME,

	member VARCHAR(255),

	sv_month decimal(10,2),

	sv_quarter decimal(10,2),

	sv_life decimal(10,2), 

	tags longtext, 

	csat DECIMAL(3,2),

	sentiment VARCHAR(255),  

	INDEX (member_id),

	INDEX (assignedto),

	INDEX (updatedby)

	);

Result

Mouse over the images to zoom in/out

Creating a Table called tickets

Query 2

	CREATE TABLE tickets ( 

	ticket_id INT AUTO_INCREMENT PRIMARY KEY,

	project_name VARCHAR(255),

	member_id INT,

	subject VARCHAR(255) NOT NULL,

	description TEXT,

	intent VARCHAR(255),

	status ENUM('open', 'closed', 'pending') NOT NULL DEFAULT 'open',

	priority ENUM('low', 'medium', 'high') NOT NULL DEFAULT 'medium',

	assignedto INT,

	updatedby INT,

	channel VARCHAR(255),

	created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

	first_response DATETIME,

	update_response DATETIME,

	resolved DATETIME,

	member VARCHAR(255),

	sv_month decimal(10,2),

	sv_quarter decimal(10,2),

	sv_life decimal(10,2), 

	tags longtext, 

	csat DECIMAL(3,2),

	sentiment VARCHAR(255),  

	INDEX (member_id),

	INDEX (assignedto),

	INDEX (updatedby)

	);

Result

Mouse over the images to zoom in/out