Created
September 25, 2015 13:49
-
-
Save agustik/1b428019c94a557a2839 to your computer and use it in GitHub Desktop.
Ghost schema for MemSQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- phpMyAdmin SQL Dump | |
| -- version 4.0.10.10 | |
| -- http://www.phpmyadmin.net | |
| -- | |
| -- Host: localhost | |
| -- Generation Time: Sep 25, 2015 at 01:00 PM | |
| -- Server version: 5.1.73 | |
| -- PHP Version: 5.3.3 | |
| 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 utf8 */; | |
| -- | |
| -- Database: `your_database` | |
| -- | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `accesstokens` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `accesstokens` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `token` varchar(255) NOT NULL, | |
| `user_id` int(10) unsigned NOT NULL, | |
| `client_id` int(10) unsigned NOT NULL, | |
| `expires` bigint(20) NOT NULL, | |
| PRIMARY KEY (`id`, `token`), | |
| UNIQUE KEY `accesstokens_token_unique` (`token`, `id`), | |
| KEY `accesstokens_user_id_foreign` (`user_id`), | |
| KEY `accesstokens_client_id_foreign` (`client_id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `apps` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `apps` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `name` varchar(150) NOT NULL, | |
| `slug` varchar(150) NOT NULL, | |
| `version` varchar(150) NOT NULL, | |
| `status` varchar(150) NOT NULL DEFAULT 'inactive', | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`, `name`, `slug`), | |
| UNIQUE KEY `apps_name_unique` (`name`, `id`), | |
| UNIQUE KEY `apps_slug_unique` (`slug`, `id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `app_fields` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `app_fields` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `key` varchar(150) NOT NULL, | |
| `value` text, | |
| `type` varchar(150) NOT NULL DEFAULT 'html', | |
| `app_id` int(10) unsigned NOT NULL, | |
| `relatable_id` int(10) unsigned NOT NULL, | |
| `relatable_type` varchar(150) NOT NULL DEFAULT 'posts', | |
| `active` tinyint(1) NOT NULL DEFAULT '1', | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`), | |
| KEY `app_fields_app_id_foreign` (`app_id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `app_settings` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `app_settings` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `key` varchar(150) NOT NULL, | |
| `value` text, | |
| `app_id` int(10) unsigned NOT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`,`key`), | |
| UNIQUE KEY `app_settings_key_unique` (`key`, `id`), | |
| KEY `app_settings_app_id_foreign` (`app_id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `clients` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `clients` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `name` varchar(150) NOT NULL, | |
| `slug` varchar(150) NOT NULL, | |
| `secret` varchar(150) NOT NULL, | |
| `redirection_uri` varchar(2000) DEFAULT NULL, | |
| `logo` varchar(2000) DEFAULT NULL, | |
| `status` varchar(150) NOT NULL DEFAULT 'development', | |
| `type` varchar(150) NOT NULL DEFAULT 'ua', | |
| `description` varchar(200) DEFAULT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`, `name`, `slug`), | |
| UNIQUE KEY `clients_name_unique` (`name`, `id`), | |
| UNIQUE KEY `clients_slug_unique` (`slug`, `id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; | |
| -- | |
| -- Dumping data for table `clients` | |
| -- | |
| INSERT INTO `clients` (`id`, `uuid`, `name`, `slug`, `secret`, `redirection_uri`, `logo`, `status`, `type`, `description`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES | |
| (1, 'b18f8df6-14c4-4810-a8d9-00e303c08a71', 'Ghost Admin', 'ghost-admin', 'not_available', NULL, NULL, 'enabled', 'ua', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (2, 'bb2b964a-b55f-471b-a829-32e20a827016', 'Ghost Frontend', 'ghost-frontend', 'not_available', NULL, NULL, 'enabled', 'ua', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `client_trusted_domains` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `client_trusted_domains` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `client_id` int(10) unsigned NOT NULL, | |
| `trusted_domain` varchar(2000) DEFAULT NULL, | |
| PRIMARY KEY (`id`), | |
| KEY `client_trusted_domains_client_id_foreign` (`client_id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `permissions` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `permissions` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `name` varchar(150) NOT NULL, | |
| `object_type` varchar(150) NOT NULL, | |
| `action_type` varchar(150) NOT NULL, | |
| `object_id` int(11) DEFAULT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; | |
| -- | |
| -- Dumping data for table `permissions` | |
| -- | |
| INSERT INTO `permissions` (`id`, `uuid`, `name`, `object_type`, `action_type`, `object_id`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES | |
| (1, '0c7a390b-4718-483f-b829-79e86a84db67', 'Export database', 'db', 'exportContent', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (2, '26476bd0-62bd-4af0-94b5-66fa63eec5c5', 'Import database', 'db', 'importContent', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (3, 'b05467ad-8f9e-41f0-ad68-78c9f2f576b6', 'Delete all content', 'db', 'deleteAllContent', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (4, '0f97f917-e4ef-490f-86b1-d8cb142f35fe', 'Send mail', 'mail', 'send', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (5, '236bb73c-3828-4d8c-a8bb-1a155874fb5b', 'Browse notifications', 'notification', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (6, '9a998c8a-ffa9-4f81-9724-0bcb7ad3a554', 'Add notifications', 'notification', 'add', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (7, 'a4d5892d-5b0f-41a5-8808-ed758b6c7928', 'Delete notifications', 'notification', 'destroy', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (8, '21267241-f8f8-493b-affb-d7d9aa7081db', 'Browse posts', 'post', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (9, '40b7a487-0231-46eb-973d-11152e3eddc4', 'Read posts', 'post', 'read', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (10, '888b2976-1066-4ff7-abc7-a82d6a62e72f', 'Edit posts', 'post', 'edit', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (11, 'ba491b56-b430-4d6d-907f-072c7d9b2d53', 'Add posts', 'post', 'add', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (12, '30c258e3-80e1-42d1-8bab-b47b69aa1425', 'Delete posts', 'post', 'destroy', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (13, '580d41c1-533d-4da2-ac82-240258c367d5', 'Browse settings', 'setting', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (14, 'cea8df1e-af8a-4038-9ad5-e130007ab9a2', 'Read settings', 'setting', 'read', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (15, 'e795be9c-ab54-45b1-989a-3055357c782f', 'Edit settings', 'setting', 'edit', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (16, 'd7f4ee97-746a-4afc-bdeb-c5575262bba3', 'Generate slugs', 'slug', 'generate', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (17, '2a0c7e6d-b014-4386-814b-daa76f1d7014', 'Browse tags', 'tag', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (18, 'e0885380-94d8-4d18-8486-1ea2b60d3ec9', 'Read tags', 'tag', 'read', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (19, '25e707d4-038a-4b1f-aa85-95fd3a42fdc2', 'Edit tags', 'tag', 'edit', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (20, 'f2b00c5e-9d18-49cf-90b0-0828b25ebcc6', 'Add tags', 'tag', 'add', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (21, '913e6bd4-fe52-4900-ae55-45e815cff5a0', 'Delete tags', 'tag', 'destroy', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (22, 'd74b4dec-ff3f-4d09-9322-5f7cb3ae2806', 'Browse themes', 'theme', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (23, '3bd7ada1-8b11-46e2-b853-3a3bddab8337', 'Edit themes', 'theme', 'edit', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (24, 'b0202c86-3d6d-4f40-9094-fde095c86f87', 'Browse users', 'user', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (25, 'b6a0bc6d-b1d7-4592-9b06-3303ff44c13c', 'Read users', 'user', 'read', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (26, '610893da-e92e-45c3-bf5a-f4b5dc942dd7', 'Edit users', 'user', 'edit', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (27, '49c1672e-b562-473e-ab95-fd4f37b2195d', 'Add users', 'user', 'add', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (28, '9a787f47-7d73-4230-a716-580a65610dd2', 'Delete users', 'user', 'destroy', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (29, '108fac9e-8064-4d46-8eed-e3bf95c95679', 'Assign a role', 'role', 'assign', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (30, 'c5fb67a5-8305-4a50-a79c-7148b5978eff', 'Browse roles', 'role', 'browse', NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `permissions_apps` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `permissions_apps` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `app_id` int(11) NOT NULL, | |
| `permission_id` int(11) NOT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `permissions_roles` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `permissions_roles` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `role_id` int(11) NOT NULL, | |
| `permission_id` int(11) NOT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ; | |
| -- | |
| -- Dumping data for table `permissions_roles` | |
| -- | |
| INSERT INTO `permissions_roles` (`id`, `role_id`, `permission_id`) VALUES | |
| (1, 1, 2), | |
| (2, 1, 3), | |
| (3, 1, 1), | |
| (4, 1, 4), | |
| (5, 1, 5), | |
| (6, 1, 6), | |
| (7, 1, 7), | |
| (8, 1, 8), | |
| (9, 1, 9), | |
| (10, 1, 10), | |
| (11, 1, 11), | |
| (12, 1, 12), | |
| (13, 1, 13), | |
| (14, 1, 14), | |
| (15, 1, 15), | |
| (16, 1, 16), | |
| (17, 1, 17), | |
| (18, 1, 18), | |
| (19, 1, 19), | |
| (20, 1, 20), | |
| (21, 1, 21), | |
| (22, 1, 22), | |
| (23, 1, 23), | |
| (24, 1, 24), | |
| (25, 1, 25), | |
| (26, 1, 26), | |
| (27, 1, 27), | |
| (28, 1, 28), | |
| (29, 1, 29), | |
| (30, 1, 30), | |
| (31, 2, 8), | |
| (32, 2, 9), | |
| (33, 2, 10), | |
| (34, 2, 11), | |
| (35, 2, 12), | |
| (36, 2, 13), | |
| (37, 2, 14), | |
| (38, 2, 16), | |
| (39, 2, 17), | |
| (40, 2, 18), | |
| (41, 2, 19), | |
| (42, 2, 20), | |
| (43, 2, 21), | |
| (44, 2, 24), | |
| (45, 2, 25), | |
| (46, 2, 26), | |
| (47, 2, 27), | |
| (48, 2, 28), | |
| (49, 2, 29), | |
| (50, 2, 30), | |
| (51, 3, 8), | |
| (52, 3, 9), | |
| (53, 3, 11), | |
| (54, 3, 13), | |
| (55, 3, 14), | |
| (56, 3, 16), | |
| (57, 3, 17), | |
| (58, 3, 18), | |
| (59, 3, 20), | |
| (60, 3, 24), | |
| (61, 3, 25), | |
| (62, 3, 30); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `permissions_users` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `permissions_users` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `user_id` int(11) NOT NULL, | |
| `permission_id` int(11) NOT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `posts` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `posts` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `title` varchar(150) NOT NULL, | |
| `slug` varchar(150) NOT NULL, | |
| `markdown` mediumtext, | |
| `html` mediumtext, | |
| `image` text, | |
| `featured` tinyint(1) NOT NULL DEFAULT '0', | |
| `page` tinyint(1) NOT NULL DEFAULT '0', | |
| `status` varchar(150) NOT NULL DEFAULT 'draft', | |
| `language` varchar(6) NOT NULL DEFAULT 'en_US', | |
| `meta_title` varchar(150) DEFAULT NULL, | |
| `meta_description` varchar(200) DEFAULT NULL, | |
| `author_id` int(11) NOT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| `published_at` datetime DEFAULT NULL, | |
| `published_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`, `slug`), | |
| UNIQUE KEY `posts_slug_unique` (`slug`, `id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; | |
| -- | |
| -- Dumping data for table `posts` | |
| -- | |
| INSERT INTO `posts` (`id`, `uuid`, `title`, `slug`, `markdown`, `html`, `image`, `featured`, `page`, `status`, `language`, `meta_title`, `meta_description`, `author_id`, `created_at`, `created_by`, `updated_at`, `updated_by`, `published_at`, `published_by`) VALUES | |
| (1, '4d58c4b1-fa4f-4401-999f-d26ad320dd0c', 'Welcome to Ghost', 'welcome-to-ghost', 'You''re live! Nice. We''ve put together a little post to introduce you to the Ghost editor and get you started. You can manage your content by signing in to the admin area at `<your blog URL>/ghost/`. When you arrive, you can select this post from a list on the left and see a preview of it on the right. Click the little pencil icon at the top of the preview to edit this post and read the next section!\n\n## Getting Started\n\nGhost uses something called Markdown for writing. Essentially, it''s a shorthand way to manage your post formatting as you write!\n\nWriting in Markdown is really easy. In the left hand panel of Ghost, you simply write as you normally would. Where appropriate, you can use *shortcuts* to **style** your content. For example, a list:\n\n* Item number one\n* Item number two\n * A nested item\n* A final item\n\nor with numbers!\n\n1. Remember to buy some milk\n2. Drink the milk\n3. Tweet that I remembered to buy the milk, and drank it\n\n### Links\n\nWant to link to a source? No problem. If you paste in a URL, like http://ghost.org - it''ll automatically be linked up. But if you want to customise your anchor text, you can do that too! Here''s a link to [the Ghost website](http://ghost.org). Neat.\n\n### What about Images?\n\nImages work too! Already know the URL of the image you want to include in your article? Simply paste it in like this to make it show up:\n\n\n\nNot sure which image you want to use yet? That''s ok too. Leave yourself a descriptive placeholder and keep writing. Come back later and drag and drop the image in to upload:\n\n![A bowl of bananas]\n\n\n### Quoting\n\nSometimes a link isn''t enough, you want to quote someone on what they''ve said. Perhaps you''ve started using a new blogging platform and feel the sudden urge to share their slogan? A quote might be just the way to do it!\n\n> Ghost - Just a blogging platform\n\n### Working with Code\n\nGot a streak of geek? We''ve got you covered there, too. You can write inline `<code>` blocks really easily with back ticks. Want to show off something more comprehensive? 4 spaces of indentation gets you there.\n\n .awesome-thing {\n display: block;\n width: 100%;\n }\n\n### Ready for a Break? \n\nThrow 3 or more dashes down on any new line and you''ve got yourself a fancy new divider. Aw yeah.\n\n---\n\n### Advanced Usage\n\nThere''s one fantastic secret about Markdown. If you want, you can write plain old HTML and it''ll still work! Very flexible.\n\n<input type="text" placeholder="I''m an input field!" />\n\nThat should be enough to get you started. Have fun - and let us know what you think :)', '<p>You''re live! Nice. We''ve put together a little post to introduce you to the Ghost editor and get you started. You can manage your content by signing in to the admin area at <code><your blog URL>/ghost/</code>. When you arrive, you can select this post from a list on the left and see a preview of it on the right. Click the little pencil icon at the top of the preview to edit this post and read the next section!</p>\n\n<h2 id="gettingstarted">Getting Started</h2>\n\n<p>Ghost uses something called Markdown for writing. Essentially, it''s a shorthand way to manage your post formatting as you write!</p>\n\n<p>Writing in Markdown is really easy. In the left hand panel of Ghost, you simply write as you normally would. Where appropriate, you can use <em>shortcuts</em> to <strong>style</strong> your content. For example, a list:</p>\n\n<ul>\n<li>Item number one</li>\n<li>Item number two\n<ul><li>A nested item</li></ul></li>\n<li>A final item</li>\n</ul>\n\n<p>or with numbers!</p>\n\n<ol>\n<li>Remember to buy some milk </li>\n<li>Drink the milk </li>\n<li>Tweet that I remembered to buy the milk, and drank it</li>\n</ol>\n\n<h3 id="links">Links</h3>\n\n<p>Want to link to a source? No problem. If you paste in a URL, like <a href="http://ghost.org">http://ghost.org</a> - it''ll automatically be linked up. But if you want to customise your anchor text, you can do that too! Here''s a link to <a href="http://ghost.org">the Ghost website</a>. Neat.</p>\n\n<h3 id="whataboutimages">What about Images?</h3>\n\n<p>Images work too! Already know the URL of the image you want to include in your article? Simply paste it in like this to make it show up:</p>\n\n<p><img src="https://ghost.org/images/ghost.png" alt="The Ghost Logo" /></p>\n\n<p>Not sure which image you want to use yet? That''s ok too. Leave yourself a descriptive placeholder and keep writing. Come back later and drag and drop the image in to upload:</p>\n\n<h3 id="quoting">Quoting</h3>\n\n<p>Sometimes a link isn''t enough, you want to quote someone on what they''ve said. Perhaps you''ve started using a new blogging platform and feel the sudden urge to share their slogan? A quote might be just the way to do it!</p>\n\n<blockquote>\n <p>Ghost - Just a blogging platform</p>\n</blockquote>\n\n<h3 id="workingwithcode">Working with Code</h3>\n\n<p>Got a streak of geek? We''ve got you covered there, too. You can write inline <code><code></code> blocks really easily with back ticks. Want to show off something more comprehensive? 4 spaces of indentation gets you there.</p>\n\n<pre><code>.awesome-thing {\n display: block;\n width: 100%;\n}\n</code></pre>\n\n<h3 id="readyforabreak">Ready for a Break?</h3>\n\n<p>Throw 3 or more dashes down on any new line and you''ve got yourself a fancy new divider. Aw yeah.</p>\n\n<hr />\n\n<h3 id="advancedusage">Advanced Usage</h3>\n\n<p>There''s one fantastic secret about Markdown. If you want, you can write plain old HTML and it''ll still work! Very flexible.</p>\n\n<p><input type="text" placeholder="I''m an input field!" /></p>\n\n<p>That should be enough to get you started. Have fun - and let us know what you think :)</p>', NULL, 0, 0, 'published', 'en_US', NULL, NULL, 1, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `posts_tags` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `posts_tags` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `post_id` int(10) unsigned NOT NULL, | |
| `tag_id` int(10) unsigned NOT NULL, | |
| `sort_order` int(10) unsigned NOT NULL DEFAULT '0', | |
| PRIMARY KEY (`id`), | |
| KEY `posts_tags_post_id_foreign` (`post_id`), | |
| KEY `posts_tags_tag_id_foreign` (`tag_id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; | |
| -- | |
| -- Dumping data for table `posts_tags` | |
| -- | |
| INSERT INTO `posts_tags` (`id`, `post_id`, `tag_id`, `sort_order`) VALUES | |
| (1, 1, 1, 0); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `refreshtokens` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `refreshtokens` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `token` varchar(255) NOT NULL, | |
| `user_id` int(10) unsigned NOT NULL, | |
| `client_id` int(10) unsigned NOT NULL, | |
| `expires` bigint(20) NOT NULL, | |
| PRIMARY KEY (`id`, `token`), | |
| UNIQUE KEY `refreshtokens_token_unique` (`token`, `id`), | |
| KEY `refreshtokens_user_id_foreign` (`user_id`), | |
| KEY `refreshtokens_client_id_foreign` (`client_id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `roles` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `roles` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `name` varchar(150) NOT NULL, | |
| `description` varchar(200) DEFAULT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; | |
| -- | |
| -- Dumping data for table `roles` | |
| -- | |
| INSERT INTO `roles` (`id`, `uuid`, `name`, `description`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES | |
| (1, '8fd70fcf-41a0-4c7d-8dbc-d663a1e7dd22', 'Administrator', 'Administrators', '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (2, 'e9b246c0-eb47-47ed-a9f8-e9ead7231c71', 'Editor', 'Editors', '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (3, '364b6f95-5ecd-4a07-a121-bcfcd33cc288', 'Author', 'Authors', '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1), | |
| (4, 'c159fe7d-ad0a-40f1-96a3-0f38daea8c74', 'Owner', 'Blog Owner', '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `roles_users` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `roles_users` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `role_id` int(11) NOT NULL, | |
| `user_id` int(11) NOT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; | |
| -- | |
| -- Dumping data for table `roles_users` | |
| -- | |
| INSERT INTO `roles_users` (`id`, `role_id`, `user_id`) VALUES | |
| (1, 4, 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `settings` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `settings` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `key` varchar(150) NOT NULL, | |
| `value` text, | |
| `type` varchar(150) NOT NULL DEFAULT 'core', | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`, `key`), | |
| UNIQUE KEY `settings_key_unique` (`key`, `id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ; | |
| -- | |
| -- Dumping data for table `settings` | |
| -- | |
| INSERT INTO `settings` (`id`, `uuid`, `key`, `value`, `type`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES | |
| (1, '2ddfc4a6-22e9-46fd-8890-9b9130a7ddb9', 'nextUpdateCheck', NULL, 'core', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (2, '38645960-13f1-482a-93c9-9752eee6d833', 'displayUpdateNotification', NULL, 'core', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (3, 'f340a0db-7c4e-47a4-a571-9bf4b23ee58a', 'dbHash', '1f713c0a-4664-43b9-8640-4dc086cf7a64', 'core', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (4, '486f5579-81db-41f3-89ba-cfe443e82cc9', 'databaseVersion', '004', 'core', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (5, '15e593df-adbf-48ed-bae6-1e1a8fa4c8fc', 'title', 'Ghost', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (6, 'f230edb0-1610-4943-bc78-a4637dfa2893', 'description', 'Just a blogging platform.', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (7, '68373fd9-937d-4e20-8198-5d7ce59948c5', 'defaultLang', 'en_US', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (8, 'fee06fe5-c9f6-4d35-81a3-8e21df10e498', 'postsPerPage', '5', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (9, '9519a399-1bef-402c-90bc-1fa0e20ba430', 'logo', '', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (10, '4e8e92bd-0131-471b-95d5-8b54dce9c2bc', 'cover', '', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (11, '8f37bfb3-2bc3-4277-aee4-ac3af6e48710', 'forceI18n', 'true', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (12, '83a5fc8e-c96f-4119-b422-c43efdde11d2', 'permalinks', '/:slug/', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (13, '73bdba47-a6b5-42d6-bfc3-c103e9433a8e', 'ghost_head', '', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (14, 'c8903581-8bd0-4855-af4a-f1c836ff7458', 'ghost_foot', '', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (15, '619b01c0-8b12-48ed-8306-e84ac02c3e3f', 'labs', '{}', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (16, '905e00f6-9d0e-4b52-a39f-89d919f20d34', 'navigation', '[{"label":"Home", "url":"/"}]', 'blog', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (17, '3f5492ac-76c2-4488-86f6-18920e12f5ba', 'activeApps', '[]', 'app', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (18, '37e6f8d1-0d93-414e-a4f5-234a43659fef', 'installedApps', '[]', 'app', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (19, 'e1165398-68ab-4061-aa3e-a09350109826', 'isPrivate', 'false', 'private', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (20, '5e1c4e3e-c28b-4048-92c2-b167b87c7ca6', 'password', '', 'private', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1), | |
| (21, '33924acc-7cef-4cf5-950c-424ba639c535', 'activeTheme', 'casper', 'theme', '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `tags` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `tags` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `name` varchar(150) NOT NULL, | |
| `slug` varchar(150) NOT NULL, | |
| `description` varchar(200) DEFAULT NULL, | |
| `image` text, | |
| `hidden` tinyint(1) NOT NULL DEFAULT '0', | |
| `parent_id` int(11) DEFAULT NULL, | |
| `meta_title` varchar(150) DEFAULT NULL, | |
| `meta_description` varchar(200) DEFAULT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`, `slug`), | |
| UNIQUE KEY `tags_slug_unique` (`slug`, `id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; | |
| -- | |
| -- Dumping data for table `tags` | |
| -- | |
| INSERT INTO `tags` (`id`, `uuid`, `name`, `slug`, `description`, `image`, `hidden`, `parent_id`, `meta_title`, `meta_description`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES | |
| (1, '3a38b44e-6826-41e1-ba44-ea9fb44b5366', 'Getting Started', 'getting-started', NULL, NULL, 0, NULL, NULL, NULL, '2015-09-25 13:00:38', 1, '2015-09-25 13:00:38', 1); | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `users` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `users` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `uuid` varchar(36) NOT NULL, | |
| `name` varchar(150) NOT NULL, | |
| `slug` varchar(150) NOT NULL, | |
| `password` varchar(60) NOT NULL, | |
| `email` varchar(254) NOT NULL, | |
| `image` text, | |
| `cover` text, | |
| `bio` varchar(200) DEFAULT NULL, | |
| `website` text, | |
| `location` text, | |
| `accessibility` text, | |
| `status` varchar(150) NOT NULL DEFAULT 'active', | |
| `language` varchar(6) NOT NULL DEFAULT 'en_US', | |
| `meta_title` varchar(150) DEFAULT NULL, | |
| `meta_description` varchar(200) DEFAULT NULL, | |
| `tour` text, | |
| `last_login` datetime DEFAULT NULL, | |
| `created_at` datetime NOT NULL, | |
| `created_by` int(11) NOT NULL, | |
| `updated_at` datetime DEFAULT NULL, | |
| `updated_by` int(11) DEFAULT NULL, | |
| PRIMARY KEY (`id`, `slug`, `email`), | |
| UNIQUE KEY `users_slug_unique` (`slug`, `id`), | |
| UNIQUE KEY `users_email_unique` (`email`, `id`), | |
| SHARD KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; | |
| -- | |
| -- Dumping data for table `users` | |
| -- | |
| INSERT INTO `users` (`id`, `uuid`, `name`, `slug`, `password`, `email`, `image`, `cover`, `bio`, `website`, `location`, `accessibility`, `status`, `language`, `meta_title`, `meta_description`, `tour`, `last_login`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES | |
| (1, 'b77b5c89-309b-43a9-aeb4-cfd1e912a981', 'Ghost Owner', 'ghost-owner', '$2a$10$0hbcCfVlUohHMdVsTI5fueGV8Vu2637lziZB7GFrotjCCYhOTEHk2', 'ghost@ghost.org', NULL, NULL, NULL, NULL, NULL, NULL, 'inactive', 'en_US', NULL, NULL, NULL, NULL, '2015-09-25 13:00:40', 1, '2015-09-25 13:00:40', 1); | |
| /*!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 */; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment