PHP Classes

File: twitter.sql

Recommend this page to a friend!
  Classes of Stefan Ninic   PHP Twitter Clone   twitter.sql   Download  
File: twitter.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Twitter Clone
Social network application similar to Twitter
Author: By
Last change:
Date: 1 year ago
Size: 2,260 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.4.15.8 -- https://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Jun 21, 2017 at 05:54 AM -- Server version: 5.6.31 -- PHP Version: 7.0.10 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: `twitter` -- CREATE DATABASE IF NOT EXISTS `twitter` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `twitter`; -- -------------------------------------------------------- -- -- Table structure for table `posts` -- CREATE TABLE IF NOT EXISTS `posts` ( `id` int(11) NOT NULL, `email` tinytext NOT NULL, `post` longtext NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `posts` -- INSERT INTO `posts` (`id`, `email`, `post`) VALUES (1, 'acczatube@gmail.com', 'Hello there'), (2, 'ninicstefan94@gmail.com', 'Test, no delete'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL, `email` tinytext NOT NULL, `password` tinytext NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `email`, `password`) VALUES (4, 'admin@twitter.com', '$2y$08$cUM3NjJaOFpTRlhlajVYM.wga2/jO0xTusn7U9W.6ctSjxG/kIuxS'); -- -- Indexes for dumped tables -- -- -- Indexes for table `posts` -- ALTER TABLE `posts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `posts` -- ALTER TABLE `posts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; /*!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 */;