-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------





--
-- Create schema member
--

CREATE DATABASE IF NOT EXISTS member;
USE member;

--
-- Definition of table `member`
--

CREATE TABLE `member` (
  `mem_id` int(11) unsigned NOT NULL auto_increment,
  `Username` varchar(45) NOT NULL,
  `Password` varchar(45) NOT NULL,
  `Gender` varchar(45) NOT NULL,
  `Fav_band` varchar(45) NOT NULL,
  PRIMARY KEY  (`mem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `member`
--

INSERT INTO `member` (`mem_id`,`Username`,`Password`,`Gender`,`Fav_band`) VALUES 
 (1,'jam','pajama','female','5sos'),
 (2,'rossana','chuchay','female','theVamps'),
 (3,'sehun','exo','male','beforeyouexit');




