Advertisement
Albert221

Basalt MySQL export

Dec 20th, 2015
287
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.80 KB | None | 0 0
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. SET time_zone = "+00:00";
  3.  
  4. CREATE TABLE IF NOT EXISTS `pages` (
  5.   `id` int(11) unsigned NOT NULL,
  6.   `name` varchar(255) NOT NULL,
  7.   `slug` varchar(255) NOT NULL,
  8.   `content` text NOT NULL,
  9.   `draft` tinyint(1) NOT NULL,
  10.   `order` int(11) NOT NULL
  11. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  12.  
  13. INSERT INTO `pages` (`id`, `name`, `slug`, `content`, `draft`, `order`) VALUES
  14. (1, 'Home', 'home', '<p>This is home page.</p>\r\n', 0, 0),
  15. (4, 'About me', 'about-me', '<p>This is about me page.</p>\r\n', 0, 1),
  16. (5, 'Offer', 'offer', '<p>This is offer page.</p>\r\n', 0, 2),
  17. (6, 'Contact', 'contact', '<p>This is contact page.</p>\r\n', 0, 3);
  18.  
  19. CREATE TABLE IF NOT EXISTS `settings` (
  20.   `id` int(11) unsigned NOT NULL,
  21.   `name` varchar(255) NOT NULL,
  22.   `value` varchar(255) NOT NULL
  23. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  24.  
  25. INSERT INTO `settings` (`id`, `name`, `value`) VALUES
  26. (1, 'website_name', 'Website name'),
  27. (2, 'website_author', 'Website author');
  28.  
  29. CREATE TABLE IF NOT EXISTS `users` (
  30.   `id` int(11) unsigned NOT NULL,
  31.   `email` varchar(255) NOT NULL,
  32.   `password` varchar(255) NOT NULL
  33. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  34.  
  35. INSERT INTO `users` (`id`, `email`, `password`) VALUES
  36. (1, 'user@email.com', '$2a$10$U1R37XKk1b3R7vdzi9jkiu/gcqkfH0ZGOWelPn9Vdm7LKPg//PS0K'); # password123
  37.  
  38.  
  39. ALTER TABLE `pages`
  40.   ADD PRIMARY KEY (`id`);
  41.  
  42. ALTER TABLE `settings`
  43.   ADD PRIMARY KEY (`id`);
  44.  
  45. ALTER TABLE `users`
  46.   ADD PRIMARY KEY (`id`);
  47.  
  48.  
  49. ALTER TABLE `pages`
  50.   MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
  51. ALTER TABLE `settings`
  52.   MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
  53. ALTER TABLE `users`
  54.   MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement