Blacktivist

www.Florida-Academy.gov | Website Dump

Oct 31st, 2014
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.82 KB | None | 0 0
  1. This dump is brought to you by Carbonic!
  2. @TeamCarbonic - http://carbonic.in - http://carbonic.pw
  3.  
  4. The true dump is over 13000 lines, Pastebin's limit is a fraction of that. If you would like to see the full database (all 13k lines) head on over here - https://www.dropbox.com/s/jcj9if2whadqr7b/Plain.txt?dl=0
  5.  
  6. -- Host: mysql.florida-academy.edu Database: florida_academy_edu
  7. -- ------------------------------------------------------
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  11. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  12. /*!40101 SET NAMES utf8 */;
  13. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  14. /*!40103 SET TIME_ZONE='+00:00' */;
  15. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  16. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  17. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  18. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  19.  
  20. --
  21. -- Table structure for table `wp_3nhods_app_appointments`
  22. --
  23.  
  24. DROP TABLE IF EXISTS `wp_3nhods_app_appointments`;
  25. /*!40101 SET @saved_cs_client = @@character_set_client */;
  26. /*!40101 SET character_set_client = utf8 */;
  27. CREATE TABLE `wp_3nhods_app_appointments` (
  28. `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  29. `created` datetime DEFAULT NULL,
  30. `user` bigint(20) NOT NULL DEFAULT '0',
  31. `name` varchar(250) DEFAULT NULL,
  32. `email` varchar(250) DEFAULT NULL,
  33. `phone` varchar(250) DEFAULT NULL,
  34. `address` varchar(250) DEFAULT NULL,
  35. `city` varchar(250) DEFAULT NULL,
  36. `location` bigint(20) NOT NULL DEFAULT '0',
  37. `service` bigint(20) NOT NULL DEFAULT '0',
  38. `worker` bigint(20) NOT NULL DEFAULT '0',
  39. `price` bigint(20) DEFAULT NULL,
  40. `status` varchar(35) DEFAULT NULL,
  41. `start` datetime DEFAULT NULL,
  42. `end` datetime DEFAULT NULL,
  43. `sent` text,
  44. `sent_worker` text,
  45. `note` text,
  46. `gcal_ID` varchar(250) DEFAULT NULL,
  47. `gcal_updated` datetime DEFAULT NULL,
  48. PRIMARY KEY (`ID`)
  49. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  50. /*!40101 SET character_set_client = @saved_cs_client */;
  51.  
  52. --
  53. -- Dumping data for table `wp_3nhods_app_appointments`
  54. --
  55.  
  56. LOCK TABLES `wp_3nhods_app_appointments` WRITE;
  57. /*!40000 ALTER TABLE `wp_3nhods_app_appointments` DISABLE KEYS */;
  58. /*!40000 ALTER TABLE `wp_3nhods_app_appointments` ENABLE KEYS */;
  59. UNLOCK TABLES;
  60.  
  61. --
  62. -- Table structure for table `wp_3nhods_app_cache`
  63. --
  64.  
  65. DROP TABLE IF EXISTS `wp_3nhods_app_cache`;
  66. /*!40101 SET @saved_cs_client = @@character_set_client */;
  67. /*!40101 SET character_set_client = utf8 */;
  68. CREATE TABLE `wp_3nhods_app_cache` (
  69. `uri` varchar(255) DEFAULT NULL,
  70. `created` datetime DEFAULT NULL,
  71. `content` longtext,
  72. `script` longtext,
  73. UNIQUE KEY `uri` (`uri`)
  74. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  75. /*!40101 SET character_set_client = @saved_cs_client */;
  76.  
  77. --
  78. -- Dumping data for table `wp_3nhods_app_cache`
  79. --
  80.  
  81. LOCK TABLES `wp_3nhods_app_cache` WRITE;
  82. /*!40000 ALTER TABLE `wp_3nhods_app_cache` DISABLE KEYS */;
  83. /*!40000 ALTER TABLE `wp_3nhods_app_cache` ENABLE KEYS */;
  84. UNLOCK TABLES;
  85.  
  86. --
  87. -- Table structure for table `wp_3nhods_app_exceptions`
  88. --
  89.  
  90. DROP TABLE IF EXISTS `wp_3nhods_app_exceptions`;
  91. /*!40101 SET @saved_cs_client = @@character_set_client */;
  92. /*!40101 SET character_set_client = utf8 */;
  93. CREATE TABLE `wp_3nhods_app_exceptions` (
  94. `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  95. `location` bigint(20) NOT NULL DEFAULT '0',
  96. `service` bigint(20) NOT NULL DEFAULT '0',
  97. `worker` bigint(20) NOT NULL DEFAULT '0',
  98. `status` varchar(30) DEFAULT NULL,
  99. `days` text,
  100. `note` text,
  101. PRIMARY KEY (`ID`)
  102. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  103. /*!40101 SET character_set_client = @saved_cs_client */;
  104.  
  105. --
  106. -- Dumping data for table `wp_3nhods_app_exceptions`
  107. --
  108.  
  109. LOCK TABLES `wp_3nhods_app_exceptions` WRITE;
  110. /*!40000 ALTER TABLE `wp_3nhods_app_exceptions` DISABLE KEYS */;
  111. /*!40000 ALTER TABLE `wp_3nhods_app_exceptions` ENABLE KEYS */;
  112. UNLOCK TABLES;
  113.  
  114. --
  115. -- Table structure for table `wp_3nhods_app_services`
  116. --
  117.  
  118. DROP TABLE IF EXISTS `wp_3nhods_app_services`;
  119. /*!40101 SET @saved_cs_client = @@character_set_client */;
  120. /*!40101 SET character_set_client = utf8 */;
  121. CREATE TABLE `wp_3nhods_app_services` (
  122. `ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  123. `name` varchar(255) DEFAULT NULL,
  124. `capacity` bigint(20) NOT NULL DEFAULT '0',
  125. `duration` bigint(20) NOT NULL DEFAULT '0',
  126. `price` varchar(255) DEFAULT NULL,
  127. `page` bigint(20) NOT NULL DEFAULT '0',
  128. PRIMARY KEY (`ID`)
  129. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  130. /*!40101 SET character_set_client = @saved_cs_client */;
  131.  
  132. --
  133. -- Dumping data for table `wp_3nhods_app_services`
  134. --
  135.  
  136. LOCK TABLES `wp_3nhods_app_services` WRITE;
  137. /*!40000 ALTER TABLE `wp_3nhods_app_services` DISABLE KEYS */;
  138. INSERT INTO `wp_3nhods_app_services` VALUES (1,'Professional 30 minute massage',1,30,'75',0);
  139. /*!40000 ALTER TABLE `wp_3nhods_app_services` ENABLE KEYS */;
  140. UNLOCK TABLES;
  141.  
  142. --
  143. -- Table structure for table `wp_3nhods_app_transactions`
  144. --
  145.  
  146. DROP TABLE IF EXISTS `wp_3nhods_app_transactions`;
  147. /*!40101 SET @saved_cs_client = @@character_set_client */;
  148. /*!40101 SET character_set_client = utf8 */;
  149. CREATE TABLE `wp_3nhods_app_transactions` (
  150. `transaction_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  151. `transaction_app_ID` bigint(20) NOT NULL DEFAULT '0',
  152. `transaction_paypal_ID` varchar(30) DEFAULT NULL,
  153. `transaction_stamp` bigint(35) NOT NULL DEFAULT '0',
  154. `transaction_total_amount` bigint(20) DEFAULT NULL,
  155. `transaction_currency` varchar(35) DEFAULT NULL,
  156. `transaction_status` varchar(35) DEFAULT NULL,
  157. `transaction_note` text,
  158. PRIMARY KEY (`transaction_ID`),
  159. KEY `transaction_app_ID` (`transaction_app_ID`)
  160. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  161. /*!40101 SET character_set_client = @saved_cs_client */;
  162.  
  163. --
  164. -- Dumping data for table `wp_3nhods_app_transactions`
  165. --
  166.  
  167. LOCK TABLES `wp_3nhods_app_transactions` WRITE;
  168. /*!40000 ALTER TABLE `wp_3nhods_app_transactions` DISABLE KEYS */;
  169. /*!40000 ALTER TABLE `wp_3nhods_app_transactions` ENABLE KEYS */;
  170. UNLOCK TABLES;
  171.  
  172. --
  173. -- Table structure for table `wp_3nhods_app_workers`
  174. --
  175.  
  176. DROP TABLE IF EXISTS `wp_3nhods_app_workers`;
  177. /*!40101 SET @saved_cs_client = @@character_set_client */;
  178. /*!40101 SET character_set_client = utf8 */;
  179. CREATE TABLE `wp_3nhods_app_workers` (
  180. `ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  181. `dummy` varchar(255) DEFAULT NULL,
  182. `price` varchar(255) DEFAULT NULL,
  183. `services_provided` text,
  184. `page` bigint(20) NOT NULL DEFAULT '0',
  185. PRIMARY KEY (`ID`)
  186. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  187. /*!40101 SET character_set_client = @saved_cs_client */;
  188.  
  189. --
  190. -- Dumping data for table `wp_3nhods_app_workers`
  191. --
  192.  
  193. LOCK TABLES `wp_3nhods_app_workers` WRITE;
  194. /*!40000 ALTER TABLE `wp_3nhods_app_workers` DISABLE KEYS */;
  195. INSERT INTO `wp_3nhods_app_workers` VALUES (4,'1','5',':1:',2);
  196. /*!40000 ALTER TABLE `wp_3nhods_app_workers` ENABLE KEYS */;
  197. UNLOCK TABLES;
  198.  
  199. --
  200. -- Table structure for table `wp_3nhods_app_working_hours`
  201. --
  202.  
  203. DROP TABLE IF EXISTS `wp_3nhods_app_working_hours`;
  204. /*!40101 SET @saved_cs_client = @@character_set_client */;
  205. /*!40101 SET character_set_client = utf8 */;
  206. CREATE TABLE `wp_3nhods_app_working_hours` (
  207. `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  208. `location` bigint(20) NOT NULL DEFAULT '0',
  209. `service` bigint(20) NOT NULL DEFAULT '0',
  210. `worker` bigint(20) NOT NULL DEFAULT '0',
  211. `status` varchar(30) DEFAULT NULL,
  212. `hours` text,
  213. `note` text,
  214. PRIMARY KEY (`ID`)
  215. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  216. /*!40101 SET character_set_client = @saved_cs_client */;
  217.  
  218. The true dump is over 13000 lines, Pastebin's limit is a fraction of that. If you would like to see the full database (all 13k lines) head on over here - http://carbonic.in/dumps/florida-academy.txt
Add Comment
Please, Sign In to add comment