PHP Classes
elePHPant
Icontem

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: 3 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 */;