# MySQL
#
# Host: localhost Database: hyperscore
#--------------------------------------------------------
# Server version 3.23.46a

USE hyperscore3;

#
# Table structure for table 'users'
#

CREATE TABLE users
( user_id int(5) unsigned NOT NULL auto_increment,
	user_name varchar(16) NOT NULL,
	user_password varchar(16) NOT NULL,
	user_email varchar(100),
	user_country varchar(50),
	user_admin bool DEFAULT 0,
	PRIMARY KEY (user_id)
);

#
# Table structure for table 'scores'
#

CREATE TABLE scores
( score_id int(5) unsigned NOT NULL auto_increment,
	user_id int(5),
	score_title varchar(50),
	score_date datetime,
	score_length int(5),
	score_downloads int(5),
	score_desc text,
	score_featured tinyint unsigned,
  	score_filename varchar(100),
	PRIMARY KEY (score_id)
);

INSERT INTO users VALUES ('00000','admin','pasbood','info@toysymphony.com','usa','1');