Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- This dump is brought to you by Carbonic!
- @TeamCarbonic - http://carbonic.in - http://carbonic.pw
- 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
- -- Host: mysql.florida-academy.edu Database: florida_academy_edu
- -- ------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `wp_3nhods_app_appointments`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_appointments`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_appointments` (
- `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `created` datetime DEFAULT NULL,
- `user` bigint(20) NOT NULL DEFAULT '0',
- `name` varchar(250) DEFAULT NULL,
- `email` varchar(250) DEFAULT NULL,
- `phone` varchar(250) DEFAULT NULL,
- `address` varchar(250) DEFAULT NULL,
- `city` varchar(250) DEFAULT NULL,
- `location` bigint(20) NOT NULL DEFAULT '0',
- `service` bigint(20) NOT NULL DEFAULT '0',
- `worker` bigint(20) NOT NULL DEFAULT '0',
- `price` bigint(20) DEFAULT NULL,
- `status` varchar(35) DEFAULT NULL,
- `start` datetime DEFAULT NULL,
- `end` datetime DEFAULT NULL,
- `sent` text,
- `sent_worker` text,
- `note` text,
- `gcal_ID` varchar(250) DEFAULT NULL,
- `gcal_updated` datetime DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `wp_3nhods_app_appointments`
- --
- LOCK TABLES `wp_3nhods_app_appointments` WRITE;
- /*!40000 ALTER TABLE `wp_3nhods_app_appointments` DISABLE KEYS */;
- /*!40000 ALTER TABLE `wp_3nhods_app_appointments` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `wp_3nhods_app_cache`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_cache`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_cache` (
- `uri` varchar(255) DEFAULT NULL,
- `created` datetime DEFAULT NULL,
- `content` longtext,
- `script` longtext,
- UNIQUE KEY `uri` (`uri`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `wp_3nhods_app_cache`
- --
- LOCK TABLES `wp_3nhods_app_cache` WRITE;
- /*!40000 ALTER TABLE `wp_3nhods_app_cache` DISABLE KEYS */;
- /*!40000 ALTER TABLE `wp_3nhods_app_cache` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `wp_3nhods_app_exceptions`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_exceptions`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_exceptions` (
- `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `location` bigint(20) NOT NULL DEFAULT '0',
- `service` bigint(20) NOT NULL DEFAULT '0',
- `worker` bigint(20) NOT NULL DEFAULT '0',
- `status` varchar(30) DEFAULT NULL,
- `days` text,
- `note` text,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `wp_3nhods_app_exceptions`
- --
- LOCK TABLES `wp_3nhods_app_exceptions` WRITE;
- /*!40000 ALTER TABLE `wp_3nhods_app_exceptions` DISABLE KEYS */;
- /*!40000 ALTER TABLE `wp_3nhods_app_exceptions` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `wp_3nhods_app_services`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_services`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_services` (
- `ID` bigint(20) unsigned NOT NULL DEFAULT '0',
- `name` varchar(255) DEFAULT NULL,
- `capacity` bigint(20) NOT NULL DEFAULT '0',
- `duration` bigint(20) NOT NULL DEFAULT '0',
- `price` varchar(255) DEFAULT NULL,
- `page` bigint(20) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `wp_3nhods_app_services`
- --
- LOCK TABLES `wp_3nhods_app_services` WRITE;
- /*!40000 ALTER TABLE `wp_3nhods_app_services` DISABLE KEYS */;
- INSERT INTO `wp_3nhods_app_services` VALUES (1,'Professional 30 minute massage',1,30,'75',0);
- /*!40000 ALTER TABLE `wp_3nhods_app_services` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `wp_3nhods_app_transactions`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_transactions`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_transactions` (
- `transaction_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `transaction_app_ID` bigint(20) NOT NULL DEFAULT '0',
- `transaction_paypal_ID` varchar(30) DEFAULT NULL,
- `transaction_stamp` bigint(35) NOT NULL DEFAULT '0',
- `transaction_total_amount` bigint(20) DEFAULT NULL,
- `transaction_currency` varchar(35) DEFAULT NULL,
- `transaction_status` varchar(35) DEFAULT NULL,
- `transaction_note` text,
- PRIMARY KEY (`transaction_ID`),
- KEY `transaction_app_ID` (`transaction_app_ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `wp_3nhods_app_transactions`
- --
- LOCK TABLES `wp_3nhods_app_transactions` WRITE;
- /*!40000 ALTER TABLE `wp_3nhods_app_transactions` DISABLE KEYS */;
- /*!40000 ALTER TABLE `wp_3nhods_app_transactions` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `wp_3nhods_app_workers`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_workers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_workers` (
- `ID` bigint(20) unsigned NOT NULL DEFAULT '0',
- `dummy` varchar(255) DEFAULT NULL,
- `price` varchar(255) DEFAULT NULL,
- `services_provided` text,
- `page` bigint(20) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `wp_3nhods_app_workers`
- --
- LOCK TABLES `wp_3nhods_app_workers` WRITE;
- /*!40000 ALTER TABLE `wp_3nhods_app_workers` DISABLE KEYS */;
- INSERT INTO `wp_3nhods_app_workers` VALUES (4,'1','5',':1:',2);
- /*!40000 ALTER TABLE `wp_3nhods_app_workers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `wp_3nhods_app_working_hours`
- --
- DROP TABLE IF EXISTS `wp_3nhods_app_working_hours`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wp_3nhods_app_working_hours` (
- `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `location` bigint(20) NOT NULL DEFAULT '0',
- `service` bigint(20) NOT NULL DEFAULT '0',
- `worker` bigint(20) NOT NULL DEFAULT '0',
- `status` varchar(30) DEFAULT NULL,
- `hours` text,
- `note` text,
- PRIMARY KEY (`ID`)
- ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- 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