· 11 years ago · Jul 15, 2015, 07:31 PM
1DROP TABLE IF EXISTS `Users`;
2SET @saved_cs_client = @@character_set_client;
3SET character_set_client = utf8;
4CREATE TABLE `Users` (
5 `userID` int(11) NOT NULL AUTO_INCREMENT,
6 `username` varchar(45) DEFAULT NULL,
7 `userType` int(11) DEFAULT NULL,
8 `passwd` varchar(45) DEFAULT NULL,
9 `fName` varchar(45) DEFAULT NULL,
10 `lName` varchar(45) DEFAULT NULL,
11 `email` varchar(45) DEFAULT NULL,
12 `phone` varchar(45) DEFAULT NULL,
13 `phone2` varchar(45) DEFAULT NULL,
14 PRIMARY KEY (`userID`)
15) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
16SET character_set_client = @saved_cs_client;
17
18--
19-- Dumping data for table `Users`
20--
21
22LOCK TABLES `Users` WRITE;
23/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
24INSERT INTO `Users` VALUES (1,'rhaake',1,'eca527160079efb0e6a975451266bd8c','Robert','Haake','robert.haake@r-haake.net','715.563.0725','715.874.5259'),(2,'dottum',1,'730b26f52adf766f110a674afb5d2027','Doug','Ottum','doug@rentatcornerstone.com','1-715-839-1029',NULL),(7,'sottum',2,'af7d1b14573ca4717438c17cd8b4102e','sue','Ottum','sue@rentatcornerstone.com','715-839-9418','715-829-7233'),(6,'sirwhat',1,'d6a5c9544eca9b5ce2266d1c34a93222','James','Whatley','james@peace-lutheran.org','715 563-1635','715 834-2486'),(21,'dolson',2,'d1e906490b99b228f65d6d191a3e3c02','Dean','Olson','sueolson2000@yahoo.com','715-828-8790','715-831-2184'),(9,'mklebig',2,'dbb1e154f418bf1c744a5594be509dd4','Mary','Klebig','maryklebigmassage@yahoo.com','7158322813','7155776072'),(10,'jschaller',2,'5cc93c82f4e1538a16e5ddd9827ec762','Justin','Schaller','justin@closeupapparel.com','715-828-2747','715-828-2747'),(11,'lmeyer',2,'7b857c1577f35d0c0bec4d0b56e4e009','Lori','Meyer','lorimeyer1@gmail.com','715-579-2271','715-579-2271'),(12,'banderson',2,'97476a437b3cd48fcbd20f7de68922e6','Ben','Anderson','eauclaire1@gmail.com','715-875-4778','715-529-5270'),(13,'rwilczynski',2,'76b4e961982fe82cf1b04d9c3273a796','Rick','Wilczynski','ramericanpride@aol.com','715-839-8987','715-577-2554'),(20,'banderson',2,'2b4a03ec376fd4f6a674f86a85140f08','Ben','Anderson','eauclaire1@gmail.com','715-875-4778','715-529-5270'),(15,'jmoldenhauer',2,'845673a8bda079209aee716a94598e6c','Jim','Moldenhauer','MoldenhauerLaw@charterinternet.com','715-839-7165','715-579-1571'),(16,'dolinger',2,'584c3541310d1a087968d0d4539f0eea','Dave','Olinger','dosotwo@charter.net','715-839-0105','715-838-5277'),(17,'phurlburt',2,'fed55a3768fd329fed01d865a13d6bf1','phil','hurlburt','phurlburt@ecasd.k12.wi.us','7155798865',''),(18,'sknepper',2,'b56d47eda64cf8aa6fb6f229b7bdc20e','Scott','Knepper','sknepper22@yahoo.com','',''),(22,'kschnack',1,'b6da58bc0274c43e4d395510f00bddf4','Kris','Schnack','kris@peace-lutheran.org',NULL,NULL),(23,'jay',1,'32250170a0dca92d53ec9624f336ca24','Jay',NULL,'jbrettingen@charterbankec.com',NULL,NULL);