Advertisement
Guest User

SQL export

a guest
Jul 12th, 2014
1,847
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.16 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.10
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: yours
  6. -- Generation Time: yours
  7. -- Server version: 5.1.73-log
  8. -- PHP Version: 5.2.17-pl0-gentoo
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `yours`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `events`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `events` (
  30.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  31.   `NAME` varchar(255) NOT NULL,
  32.   PRIMARY KEY (`ID`)
  33. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
  34.  
  35. --
  36. -- Dumping data for table `events`
  37. --
  38.  
  39. INSERT INTO `events` (`ID`, `NAME`) VALUES
  40. (1, 'Sample event'),
  41. (2, 'Another event'),
  42. (3, 'Third event...');
  43.  
  44. -- --------------------------------------------------------
  45.  
  46. --
  47. -- Table structure for table `events_meta`
  48. --
  49.  
  50. CREATE TABLE IF NOT EXISTS `events_meta` (
  51.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  52.   `event_id` int(11) NOT NULL,
  53.   `repeat_start` date NOT NULL,
  54.   `repeat_interval` varchar(255) NOT NULL,
  55.   `repeat_year` varchar(255) NOT NULL,
  56.   `repeat_month` varchar(255) NOT NULL,
  57.   `repeat_day` varchar(255) NOT NULL,
  58.   `repeat_week` varchar(255) NOT NULL,
  59.   `repeat_weekday` varchar(255) NOT NULL,
  60.   PRIMARY KEY (`ID`),
  61.   UNIQUE KEY `ID` (`ID`)
  62. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
  63.  
  64. --
  65. -- Dumping data for table `events_meta`
  66. --
  67.  
  68. INSERT INTO `events_meta` (`ID`, `event_id`, `repeat_start`, `repeat_interval`, `repeat_year`, `repeat_month`, `repeat_day`, `repeat_week`, `repeat_weekday`) VALUES
  69. (1, 1, '2014-07-04', '7', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL'),
  70. (2, 2, '2014-06-26', 'NULL', '2014', '*', '*', '2', '5'),
  71. (3, 3, '2014-07-04', 'NULL', '*', '*', '*', '*', '1');
  72.  
  73. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  74. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  75. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement