--
-- Host: localhost    Database: oxford2026
-- ------------------------------------------------------


--
-- 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','bf89326ffe2af68b190e374708c04cbb',9,'vamsikrishna.k@zestwings.com','8125117339','','','','',1777029040,1,'ADMIN','319a4c1d5b3ae81aec2585c6be52f62d',1776935474),('vamsi','vamsi@#','4911dba13082bb1be3ddd9990a039255',9,'vamsi1990k@gmail.com','8125117339','asdf','sdfasd','TS','sdhfi',1750057318,1,'VAMSI','32a852124f6abf8f2f715fae3fb0f1ce',1750057242);


