PHP Classes

File: tests/_data/dump.sql

Recommend this page to a friend!
  Classes of Thien Tran   Phalcon Cashier   tests/_data/dump.sql   Download  
File: tests/_data/dump.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Phalcon Cashier
Access subscription services provided by Stripe
Author: By
Last change:
Date: 7 years ago
Size: 3,969 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.7.0-dev -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 25, 2016 at 05:26 PM -- Server version: 5.5.47-MariaDB-1ubuntu0.14.04.1 -- PHP Version: 5.6.20-1+deb.sury.org~trusty+1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Database: `phanbook` -- -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL, `stripe_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL, `stripe_plan` varchar(250) COLLATE utf8_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `trial_ends_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `ends_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `uuid` varchar(200) NOT NULL, `username` varchar(50) CHARACTER SET utf8 NOT NULL, `firstname` varchar(100) CHARACTER SET utf8 NOT NULL, `lastname` varchar(100) CHARACTER SET utf8 NOT NULL, `email` varchar(100) CHARACTER SET utf8 NOT NULL, `password` varchar(200) CHARACTER SET utf8 NOT NULL, `register_hash` varchar(200) CHARACTER SET utf8 DEFAULT NULL, `passwd_forgot_hash` varchar(200) CHARACTER SET utf8 DEFAULT NULL, `status` char(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N', `card_last_four` varchar(255) DEFAULT NULL, `card_brand` varchar(255) DEFAULT NULL, `stripe_id` varchar(255) DEFAULT NULL, `trial_ends_at` timestamp NULL DEFAULT NULL, `created` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `uuid`, `username`, `firstname`, `lastname`, `email`, `password`, `register_hash`, `passwd_forgot_hash`, `status`, `card_last_four`, `card_brand`, `stripe_id`, `trial_ends_at`, `created`) VALUES (1, '11--222', 'phanbook', 'Thien', 'Tran', 'hello@phanbook.com', '$2a$12$wCpQq8iqKlKhFdwh7SgKVeEmjkuriZYje20RKq5/lN3HuNKAvb.i2', NULL, NULL, '1', '4242', 'Visa', NULL, NULL, 0), (2, '4cea558b-6455-421a-98a3-5705182157e4', 'fcduythien@gmail.com', 'ddj', 'fc', 'fcduythien@gmail.com', '$2a$12$taYvfYIFExYHpigMztO9Uup4/JBNnA5iUr1Pq4mcZMMcyd2vbi6Mq', '0e31511b12f342fcac58547e723a8282', NULL, '3', NULL, NULL, NULL, NULL, 0), (6, 'eb4ebed7-a57c-4bf6-9fbe-ef7da89fd2c0', 'admin', 'Thien', 'Tran', 'avc@gmail.com', '$2a$12$hRrz3gNegnQ6g4qHss5IiekdBBDAgaCagQtax3dmqW7k11.L.BHpa', '1d024e0fd52710257477a600cf73dc26', NULL, '1', NULL, NULL, NULL, NULL, 0), (7, '2bc205a2-b1b6-4483-9351-c7944532a820', 'google', 'Thien', 'Tran', 'fcduythien@gmail.com', '$2y$12$Fcz35XriokNf88iswhVd0.hbhv4nwVrYENnTNsJGzzVxOdZ1h3ILm', '21d0857e552b65c8acb68e91d5be5d88', NULL, '3', NULL, NULL, NULL, NULL, 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;