Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- CREATE TABLE IF NOT EXISTS `pages` (
- `id` int(11) unsigned NOT NULL,
- `name` varchar(255) NOT NULL,
- `slug` varchar(255) NOT NULL,
- `content` text NOT NULL,
- `draft` tinyint(1) NOT NULL,
- `order` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- INSERT INTO `pages` (`id`, `name`, `slug`, `content`, `draft`, `order`) VALUES
- (1, 'Home', 'home', '<p>This is home page.</p>\r\n', 0, 0),
- (4, 'About me', 'about-me', '<p>This is about me page.</p>\r\n', 0, 1),
- (5, 'Offer', 'offer', '<p>This is offer page.</p>\r\n', 0, 2),
- (6, 'Contact', 'contact', '<p>This is contact page.</p>\r\n', 0, 3);
- CREATE TABLE IF NOT EXISTS `settings` (
- `id` int(11) unsigned NOT NULL,
- `name` varchar(255) NOT NULL,
- `value` varchar(255) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- INSERT INTO `settings` (`id`, `name`, `value`) VALUES
- (1, 'website_name', 'Website name'),
- (2, 'website_author', 'Website author');
- CREATE TABLE IF NOT EXISTS `users` (
- `id` int(11) unsigned NOT NULL,
- `email` varchar(255) NOT NULL,
- `password` varchar(255) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- INSERT INTO `users` (`id`, `email`, `password`) VALUES
- (1, 'user@email.com', '$2a$10$U1R37XKk1b3R7vdzi9jkiu/gcqkfH0ZGOWelPn9Vdm7LKPg//PS0K'); # password123
- ALTER TABLE `pages`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `settings`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `pages`
- MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
- ALTER TABLE `settings`
- MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
- ALTER TABLE `users`
- MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement