--
-- Host: localhost    Database: oxford2027
-- ------------------------------------------------------


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `username` varchar(30) NOT NULL,
  `password` varchar(32) DEFAULT NULL,
  `userid` varchar(32) DEFAULT NULL,
  `userlevel` tinyint(1) unsigned NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `mobile` varchar(20) NOT NULL,
  `alerttypes` text NOT NULL,
  `sidenav` longtext NOT NULL,
  `state` varchar(72) NOT NULL,
  `constituency` varchar(72) NOT NULL,
  `timestamp` int(11) unsigned NOT NULL,
  `valid` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) DEFAULT NULL,
  `hash` varchar(32) NOT NULL,
  `hash_generated` int(11) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES ('admin','admin','8966995ffb7e3758ae8f4f014b433baf',9,'vamsikrishna.k@zestwings.com','8125117339','','','','',1786529646,1,'ADMIN','c2b22d4e33b9a14bc6cac41659147ecb',1786428150),('vamsi','vamsi@#','91cb2337bd932ba919ec3845e360615e',9,'vamsi1990k@gmail.com','8125117339','asdf','sdfasd','TS','sdhfi',1784109308,1,'VAMSI','11cf979dd6e2fe67df796b940a2cff3e',1784109244);


