 (70, 2, 11),
 (76, 1, 12),
 (77, 2, 12),
-(78, 1, 8),
 (187, 3, 18),
 (188, 4, 18),
-(239, 3, 21),
-(240, 5, 21),
-(261, 3, 14),
-(262, 4, 14),
 (281, 3, 20),
 (282, 4, 20),
 (297, 3, 22),

(33, 26, 25),
(34, 25, 26),
(35, 17, 15),
(36, 15, 17);     



INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(7, 'markdown - image', STRINGDECODE('    Inline style:\r\n        ![alternative text](URL_to_image \"optional title\")\r\n\r\n    Example:\r\n        ![Linux Penguin](https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRwUqkWOMq9PEo1qZUyjjaMcToXvwNjJyYH1w982alY0iivYo0k)\r\n###### Output:\r\n![Linux Penguin](https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRwUqkWOMq9PEo1qZUyjjaMcToXvwNjJyYH1w982alY0iivYo0k)\r\n* * *\r\n    Reference style:\r\n        ![alternative text][label]\r\n\r\n\r\n        [label]: URL_to_image \"optional title\"\r\n\r\nExample:  \r\n`![Batman][000]`\r\n\r\n`[000]: https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTk-E0CVdOAiWPGhFwNQKUuTX-qZM2E0PQAebU0U45sl-6mt69h1w \"Batman\"`  \r\n\r\n###### Output:\r\n![Batman][000]\r\n\r\n[000]: https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTk-E0CVdOAiWPGhFwNQKUuTX-qZM2E0PQAebU0U45sl-6mt69h1w \"Batman\"'), TIMESTAMP '2015-06-13 17:43:09.831', TIMESTAMP '2015-06-13 17:54:44.339'),
(8, 'markdown - Manual Line Breaks', STRINGDECODE('End a line with two or more spaces:  \r\n({{[clr-br] {space} }} denotes a space character for the below examples )\r\n\r\n        This line has two spaces at the end,{{[clr-br] {space}{space} }}\r\n        So the next line will break like this;\r\n\r\n        Without spaces at the end,\r\n        it won''t break at all.\r\n###### Output:\r\nThis line has two spaces at the end,    \r\nSo the next line will break like this;\r\n\r\nWithout spaces at the end,\r\nit won''t break at all.\r\n\r\n* * *\r\nSometimes you want blank lines between data (paragraph, table, image, ...) but Markdown won''t allow it.  \r\nInsert {{[clr-br] `&nbsp;{space}{space}` }} in that case.\r\n    \r\n        ###### This line is followed by a blank line and a line of sentence{{[clr-br] {space}{space} }}\r\n        {{[clr-br]&nbsp;{space}{space} }}\r\n        ###### Note the above blank line\r\n        \r\n###### Output:\r\n###### This line is followed by a blank line and a line of sentence\r\n&nbsp;  \r\n###### Note the above blank line'), TIMESTAMP '2015-06-13 18:02:00.926', TIMESTAMP '2015-08-25 10:38:39.934'),
(9, 'markdown - Table (standard style)', STRINGDECODE('    First Header  | Second Header\r\n    ------------- | -------------\r\n    Content Cell  | Content Cell\r\n    Content Cell  | Content Cell\r\n###### Output:\r\nFirst Header  | Second Header\r\n------------- | -------------\r\nContent Cell  | Content Cell\r\nContent Cell  | Content Cell\r\n'), TIMESTAMP '2015-06-13 18:29:20.161', TIMESTAMP '2015-06-13 18:37:16.392'),
(10, 'markdown - Table (Github style)', STRINGDECODE('    | Left align | Right align | Center align |\r\n    |:-----------|------------:|:------------:|\r\n    |This        |This         |This     \r\n    |column      |column       |column    \r\n    |will        |will         |will     \r\n    |be          |be           |be      \r\n    |left        |right        |center    \r\n    |aligned     |aligned      |aligned\r\n\r\n###### Output:\r\n| Left align | Right align | Center align |\r\n|:-----------|------------:|:------------:|\r\n|This        |This         |This     \r\n|column      |column       |column    \r\n|will        |will         |will     \r\n|be          |be           |be      \r\n|left        |right        |center    \r\n|aligned     |aligned      |aligned'), TIMESTAMP '2015-06-13 18:31:43.561', TIMESTAMP '2015-06-13 18:37:31.893'),
(11, 'markdown - Backslash escapes', STRINGDECODE('Markdown provides backslash escapes for the following characters:\r\n\r\n    \\   backslash\r\n    `   backtick\r\n    *   asterisk\r\n    _   underscore\r\n    {}  curly braces\r\n    []  square brackets\r\n    ()  parentheses\r\n    #   hash mark\r\n    +   plus sign\r\n    -   minus sign (hyphen)\r\n    .   dot\r\n    !   exclamation mark'), TIMESTAMP '2015-06-24 17:01:38.77', TIMESTAMP '2015-07-12 14:05:41.954'),
(12, 'markdown - How to insert a literal | character inside table cells', STRINGDECODE('{{[clr-r] The | character is used to format tables in Markdown, but it is not escapable by backslash. }}\r\n\r\nFor instance, the following table won''t be rendered correctly\r\n\r\n###### Input:  \r\n\r\n    AND  | OR\r\n    -----|----\r\n    &&   | \\|\\|\r\n\r\n###### Output:\r\n\r\nAND  | OR\r\n-----|----\r\n&&   | \\|\\|\r\n&nbsp;  \r\n* * *\r\n**[Solution]** You can use a HTML entity number {{[clr-b] `&#124;` }} for the literal | in this case.\r\n\r\n###### Input:  \r\n\r\n    AND  | OR\r\n    -----|----\r\n    &&   | &#124;&#124;\r\n\r\n###### Output:\r\n\r\nAND  | OR\r\n-----|----\r\n&&   | &#124;&#124;'), TIMESTAMP '2015-07-09 07:58:13.305', TIMESTAMP '2015-07-14 10:12:42.235');            

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(13, 'markdown - Horizontal Lines', STRINGDECODE('Horizontal Lines:\r\n    * * *\r\n    - - -\r\n\r\n###### Output:\r\n* * *\r\n- - -\r\n'), TIMESTAMP '2015-07-12 14:03:36.466', TIMESTAMP '2015-07-12 14:05:02.605'),
(14, 'Fragment', STRINGDECODE('###### What is a Fragment?\r\n{{[clr-b] Fragment }} is a unit of data Civilizer manages for you.  \r\n\r\n>[Notice] The concept and idea of Fragment have been borrowed from [Piggydb](http://piggydb.jp/en/d/1#r23 \"\").   \r\n>Some details are different, but I think the overall idea is almost identical with that of Piggydb.\r\n\r\n* * *\r\n###### Examples of Fragment\r\nFor instance, following things can be Fragments:\r\n- knowledge/expertise for your job\r\n- temporary memo/notes\r\n- schedule/plan\r\n- detailed procedures you often forget for infrequent tasks\r\n  - e.g. installing printer drivers on your computers, submitting a tax return\r\n- expressions/vocabularies (e.g. when you learn a foreign language)\r\n- ideas/inspirations\r\n- todo list for your job or life\r\n- insightful maxims/proverbs\r\n- humors and etc.  \r\nWhat you are reading right now is a Fragment too.\r\n* * *\r\n###### Content of a Fragment.\r\n- Fragments contain text mostly, but it can contain any format of data current Web technology (and your particular web browser) can deal with such as hyper links, images, videos, audio, etc.\r\n- You can edit a Fragment in {{[clr-y] Markdown }} markup language.  \r\n  - Civilizer comes with a sample exemplar database where explanations of basic Markdown rules are included as Fragment forms.\r\n    - Click {{[tag] 1 }} to read them.\r\n- Also Civilizer has its own {{[frgm]28 Custom Markup Commands }} to provide some unique functionalities  and accomplish some of application-specific needs.\r\n* * *\r\n###### Structuring Fragments\r\nFragments can be structured form of data (most of time, structured data is a lot more efficient than non-structured data) with:\r\n- {{[frgm]16 Tagging }}\r\n  - e.g. This Fragment is tagged with two terms. (civilizer, concepts)\r\n- Relating one with another\r\n  - If you find two or more of Fragments that have similarities/contrasts or share some properties, you can relate them.\r\n  - See {{[frgm]17 Basic Operations for Fragments }} for how to do it.\r\n* * *\r\n{{[clr-g] Recommendations in editing and managing a Fragment: }}\r\n- Keep it as concise as possible.\r\n  - If a Fragment gets too big, divide it into several smaller ones and relate them.\r\n- Attach meaningful tags.\r\n- Relate Fragments if you find any semantic relationship among them.\r\n- Bookmark Fragments you can think you access frequently.\r\n\r\n'), TIMESTAMP '2015-07-12 14:55:07.81', TIMESTAMP '2015-08-26 12:29:31.179'),
(15, 'Fragment Editor', STRINGDECODE('Fragments can be edited with Fragment Editor which is basically a Markdown editor.\r\n\r\n##### Trigger the Fragment Editor for a new Fragment\r\n>Click a button {{[html] <span class=\"new-fragment-editor-trigger-on-toolbar\"><span class=\"fa fa-plus-square fa-1x\"></span></span> }} at the upper-left corner or bottom-left corner of the page.  \r\nThose buttons are visible all the time.\r\n\r\n##### Trigger the Fragment Editor for an existing Fragment\r\n> 1. {{[clr-y] Right click }} on the header of each Fragment.  \r\n>   - The header has a message such as {{[html] <span class=\"fa fa-wrench\"> Right Click for Menu</span> }} on it.  \r\n> 1. It will show you a context menu.  \r\n> 1. Then click _**Edit**_.  \r\n\r\n##### The editor consists of the following components (in a top to bottom order)\r\n1. Input for a Fragment Title\r\n1. Input for Tag names\r\n1. Toolbar to assist you in inserting {{[tag] 1 }} commands or {{[frgm]28 Civilizer Custom Markup commands }}.\r\n1. Textarea for your content\r\n  - See {{[frgm]27 this }} for details regarding how to edit your content.\r\n1. Buttons\r\n  1. Preview button\r\n    - It allows you to preview the HTML output from your editing prior to saving the content.\r\n    - Frequent preview is recommended.\r\n  1. Save button\r\n    - It saves the Fragment into the database.\r\n\r\n##### Extra features\r\n- You can drag around the editor by grabbing either of:\r\n  - Title bar (where the close button {{[html]<span class=\"fa fa-close warning-color\" ></span> is located }})\r\n  - Bottom section in gray color where Preview and Save buttons are located.\r\n- You can resize the editor.\r\n- You can quickly minimize/restore the editor by double clicking on its title bar.\r\n'), TIMESTAMP '2015-07-13 11:03:27.823', TIMESTAMP '2015-08-26 12:28:50.496');     

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(16, 'Tags on Civilizer', STRINGDECODE('https://en.wikipedia.org/wiki/Tag_(metadata)\r\n\r\nIn Civilizer, a {{[clr-b] Tag }} is a metadata assigned to each Fragment and it lets you know what property that Fragment has or what category it belongs to.\r\n\r\n> [Notice] Every Fragment has to be tagged with at least one tag.    \r\n> As a rule, Civilizer does not allow non-tagged Fragments.    \r\n> If you omit tagging when you save a Fragment, Civilizer will tag it with a special tag named  {{[clr-v] #untagged }}.  \r\n\r\nAccording to the Wikipedia''s [definition](https://en.wikipedia.org/wiki/Tag_(metadata) \"\"), a tag is a non-hierarchical keyword or term, but in Civilizer, tags can have hierarchy, which means that they can have parent or children.\r\n\r\nTagging doesn''t have any special rule so assigning which terms or words as your tags can be entirely up to you except {{[frgm]25 these rules }}.'), TIMESTAMP '2015-07-14 11:40:19.495', TIMESTAMP '2015-08-21 15:17:08.395'),
