 (28, 'Civilizer Custom Markup Commands', STRINGDECODE('{{[clr-y] Civilizer Custom Markup Commands }} provide some extended functionalities for some unique but useful use cases that {{[tag] 1 }} doesn''t support.\r\n##### Syntax\r\nThe syntax is either of the following. ( The syntax form has been burrowed from [Piggydb](http://piggydb.jp/en/d/1#r23) )\r\n- {{[clr-br] &#123;&#123;[ }}command name{{[clr-br] ] }} target text ... {{[clr-br] &#125;&#125; }}\r\n- {{[clr-br] &#123;&#123;{[ }}command name{{[clr-br] ] }} target text ... {{[clr-br] }&#125;&#125; }}\r\n\r\nText inside [ ] denotes name of the command and the command will apply to any content inside double (or triple) curly braces.\r\n\r\ne.g. \r\n- Most apples are &#123;&#123;[clr-r] red &#125;&#125;  \r\n- **Output**:  \r\n - Most apples are {{[clr-r]red }}\r\n\r\n* * *\r\n{{{[fold{\"title\":\"References\",\"hide\":\"true\"}]\r\n- **Colorizing Commands**\r\n - These commands can be used to colorize any text inside it.\r\n - In {{[frgm]15 Fragment Editor }}, when you hover on the toolbar menu located on the far right, a colorful drop down menu will appear.\r\n   - Just clicking one of them is equivalent to manually typing a corresponding command (illustrated below).\r\n - Currently, each command is:\r\n   - &#123;&#123;[clr-c] ... &#125;&#125;  {{[clr-c] Cyan color }}\r\n   - &#123;&#123;[clr-b] ... &#125;&#125;  {{[clr-b] Blue color }}\r\n   - &#123;&#123;[clr-r] ... &#125;&#125;  {{[clr-r] Red color }}\r\n   - &#123;&#123;[clr-g] ... &#125;&#125;  {{[clr-g] Green color }}\r\n   - &#123;&#123;[clr-y] ... &#125;&#125;  {{[clr-y] Yellow color }}\r\n   - &#123;&#123;[clr-m] ... &#125;&#125;  {{[clr-m] Magenta color }}\r\n   - &#123;&#123;[clr-v] ... &#125;&#125;  {{[clr-v] Violet color }}\r\n   - &#123;&#123;[clr-br] ... &#125;&#125;  {{[clr-br] Brown color }}\r\n- **Line Styling Commands**\r\n - **Strike-through**\r\n   - &#123;&#123;[st] ... &#125;&#125;\r\n   - e.g.\r\n     - &#123;&#123;[st] You can make some text deprecated like this &#125;&#125; \r\n     - **Output** : {{[st] You can make some text deprecated like this }}.\r\n - **Underline and Bold**\r\n   - &#123;&#123;[usb] ... &#125;&#125;\r\n   - e.g.\r\n     - &#123;&#123;[usb] You can make some text underlined like this &#125;&#125; \r\n     - **Output** : {{[usb] You can make some text underlined like this }}.\r\n- **Linking Commands**\r\n - **Link to a Fragment**\r\n   - &#123;&#123;[frgm] Fragment-ID ... &#125;&#125;\r\n   - This command can be inserted via the toolbar menu {{[html]<span class=\"fa fa-link fa-lg\"></span> }} in the Fragment Editor.\r\n   - e.g.\r\n     - &#123;&#123;[frgm]28 Link to self &#125;&#125;\r\n     - **Output** : {{[frgm]28 Link to self }} \r\n - **Link to a Tag**\r\n    - &#123;&#123;[tag] Tag-ID ... &#125;&#125;\r\n    - Manually typing this command doesn''t make sense.\r\n    - You should use a dedicated **Drag & Drop** functionality to insert the command.\r\n      - Refer to the section of _**A Link to a Tag**_ in {{[frgm]27 this Fragment }}.\r\n    - e.g.\r\n      - &#123;&#123;[tag]3 &#125;&#125;\r\n      - **Output** : {{[tag]3 }}\r\n - **Link to a File**\r\n    - &#123;&#123;[file] File-ID ... &#125;&#125;\r\n    - Manually typing this command doesn''t make sense.\r\n    - You should use a dedicated **Drag & Drop** functionality to insert the command.\r\n      - Refer to the section of **Inserting a link to a File into a Fragment** on {{[frgm]21 this Fragment }}.\r\n- **Embedding Command**\r\n - &#123;&#123;[frgm-embed] Fragment-ID ... &#125;&#125;\r\n - This command embeds the content of the Fragment denoted by the ID.\r\n - Currently, no UI is provided for the command.\r\n - {{[clr-r] Don''t embed a Fragment into the same Fragment (recursively)!!! }} \r\n   - The resulting behavior is undefined but possibly will crash your browser or make it not responding.\r\n- **Inline HTML Commands**\r\n - {{[clr-v] Markdown basically accepts any HTML tags, however, Civilizer is blocking this feature for various reasons. }}\r\n - Civilizer provides Inline HTML Commands as follow and they will let the browser interpret HTML code inside them.\r\n   - For inserting **inline element ( such as <span> )** HTMLs (double curly braces) : &#123;&#123;[html] ... HTML ... &#125;&#125;\r\n   - For inserting **block element ( such as <div> ) ** HTMLs (triple curly braces) : &#123;&#123;&#123;[html] ... HTML ... &#125;&#125;&#125;\r\n - e.g.\r\n   - &#123;&#123;[html] <i><b>Bold and Italic By HTML</b></i> &#125;&#125;\r\n   - **Output :** {{[html] <i><b>Bold and Italic By HTML</b></i> }}\r\n - Alternatively, select your target HTML code and press the toolbar menu {{[html]<span style=\"font-weight:bold\" class=\"fa fa-code fa-lg\"></span> }} in the Fragment Editor.\r\n\r\n> Sometimes ill-formed HTML code (such as with inconsistent opening and closing tags) might get your browser render very ugly page layout (or nothing at all) so please, be careful.  \r\n> When you copy and paste some external source''s HTML code inside Inline HTML Commands, review the HTML very carefully and {{[clr-r] remove any Javascript code from the HTML. }}  \r\n> Also note that Civilizer will silently ignore any of the following HTML tags even they are placed inside Inline HTML Commands.  \r\n- <html>, <head>, <body>, <link>, <script>  \r\n}}}'), TIMESTAMP '2015-08-25 15:54:34.373', TIMESTAMP '2015-10-07 10:38:00.547');
 
 INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
-(29, 'Civilizer Manual : Table of Contents', STRINGDECODE('Civilizer Manual\r\n----------------\r\n\r\n##### Concepts:\r\n- {{[frgm] 14 Fragment }}\r\n- {{[frgm] 16 Tags on Civilizer }}\r\n - {{[frgm] 26 Special Tags On Civilizer }}\r\n- {{[frgm] 20 File Box }}\r\n- {{[frgm] 18 Panels on Civilizer }}\r\n- {{[frgm] 22 Searching Fragments on Civilizer }}\r\n- {{[frgm] 33 Private Home Directory for Civilizer }}\r\n\r\n##### Basic How-To:\r\n- {{[frgm] 17 Basic Operations for Fragments }}\r\n - {{[frgm] 15 Fragment Editor }}\r\n- {{[frgm] 19 Basic Operations for Tags }}\r\n - {{[frgm] 25 Rules for your tag names }}\r\n- {{[frgm] 21 Basic Operations for File Box }}\r\n- {{[frgm] 23 Basic Operations for Search Dialog }}\r\n- {{[frgm] 31 Panel Toolbar Menus }}\r\n\r\n##### More Advanced How-To:\r\n- {{[frgm] 27 Editing Content on Fragment Editor }}\r\n- {{[frgm] 24 Civilizer Search Operators }}\r\n- {{[frgm] 28 Civilizer Custom Markup Commands }}\r\n- {{[frgm] 34 Application Options for Civilizer }}\r\n- {{[frgm] 35 Importing/Exporting Data to/from Civilizer }}\r\n- {{[frgm] 37 Running Civilizer in a more customized way }}\r\n'), TIMESTAMP '2015-08-26 14:04:59.806', TIMESTAMP '2015-11-30 10:28:46.124'),
-(30, 'Markdown Syntax : Table of Contents', STRINGDECODE('Basic Markdown Syntax\r\n---------------------\r\n\r\n##### Emphasis\r\n- {{[frgm] 2 markdown - Headers }}\r\n- {{[frgm] 1 markdown - Phrase Emphasis }}\r\n\r\n##### Structuring\r\n- {{[frgm] 3 markdown - Lists }}\r\n- {{[frgm] 4 markdown - Blockquotes }}\r\n- {{[frgm] 8 markdown - Manual Line Breaks }}\r\n- {{[frgm] 13 markdown - Horizontal Lines }}\r\n\r\n##### Linking\r\n- {{[frgm] 6 markdown - Links }}\r\n- {{[frgm] 7 markdown - image }}\r\n\r\n##### Table\r\n- {{[frgm] 9 markdown - Table (standard style) }}\r\n- {{[frgm] 10 markdown - Table (Github style) }}\r\n\r\n##### Escaping\r\n- {{[frgm] 5 markdown - Literal (preformatted) text }}\r\n- {{[frgm] 11 markdown - Backslash escapes }}\r\n\r\n'), TIMESTAMP '2015-08-26 16:50:55.342', TIMESTAMP '2015-11-30 10:28:41.567'),
+(29, 'Civilizer Manual : Table of Contents', STRINGDECODE('Civilizer Manual\r\n----------------\r\n\r\n##### Concepts:\r\n- {{[frgm] 14 Fragment }}\r\n- {{[frgm] 16 Tags on Civilizer }}\r\n - {{[frgm] 26 Special Tags On Civilizer }}\r\n- {{[frgm] 20 File Box }}\r\n- {{[frgm] 18 Panels on Civilizer }}\r\n- {{[frgm] 22 Searching Fragments on Civilizer }}\r\n- {{[frgm] 33 Private Home Directory for Civilizer }}\r\n\r\n##### Basic How-To:\r\n- {{[frgm] 17 Basic Operations for Fragments }}\r\n - {{[frgm] 15 Fragment Editor }}\r\n- {{[frgm] 19 Basic Operations for Tags }}\r\n - {{[frgm] 25 Rules for your tag names }}\r\n- {{[frgm] 21 Basic Operations for File Box }}\r\n- {{[frgm] 23 Basic Operations for Search Dialog }}\r\n- {{[frgm] 31 Panel Toolbar Menus }}\r\n\r\n##### More Advanced How-To:\r\n- {{[frgm] 27 Editing Content on Fragment Editor }}\r\n- {{[frgm] 24 Civilizer Search Operators }}\r\n- {{[frgm] 28 Civilizer Custom Markup Commands }}\r\n- {{[frgm] 34 Application Options for Civilizer }}\r\n- {{[frgm] 35 Importing/Exporting Data to/from Civilizer }}\r\n- {{[frgm] 37 Running Civilizer in a more customized way }}\r\n'), TIMESTAMP '2015-08-26 14:04:59.806', TIMESTAMP '2016-01-13 16:55:29.499'),
+(30, 'Markdown Syntax : Table of Contents', STRINGDECODE('Basic Markdown Syntax\r\n---------------------\r\n\r\n##### Emphasis\r\n- {{[frgm] 2 markdown - Headers }}\r\n- {{[frgm] 1 markdown - Phrase Emphasis }}\r\n\r\n##### Structuring\r\n- {{[frgm] 3 markdown - Lists }}\r\n- {{[frgm] 4 markdown - Blockquotes }}\r\n- {{[frgm] 8 markdown - Manual Line Breaks }}\r\n- {{[frgm] 13 markdown - Horizontal Lines }}\r\n\r\n##### Linking\r\n- {{[frgm] 6 markdown - Links }}\r\n- {{[frgm] 7 markdown - image }}\r\n\r\n##### Table\r\n- {{[frgm] 9 markdown - Table (standard style) }}\r\n- {{[frgm] 10 markdown - Table (Github style) }}\r\n\r\n##### Escaping\r\n- {{[frgm] 5 markdown - Literal (preformatted) text }}\r\n- {{[frgm] 11 markdown - Backslash escapes }}\r\n\r\n'), TIMESTAMP '2015-08-26 16:50:55.342', TIMESTAMP '2016-01-13 16:55:25.886'),
 (31, 'Panel Toolbar Menus', STRINGDECODE('Each of {{[frgm]18 Panels }} has its own **Panel Toolbar**.  \r\nThis toolbar will be always visible unless the owner Panel gets toggled off.\r\n\r\nEach of menus (in left to right order) is as follows: \r\n- **Fragment Selection Checkbox**\r\n - Selects or deselects all Fragments on the Panel.\r\n - Selected Fragments will appear on {{[html] <span style=\"color:coral\" class=\"fa fa-list-alt\" >&nbsp;Selection Box</span> }} on the sidebar.\r\n- **New Fragment Button** {{[html] <span class=\"new-fragment-editor-trigger-on-toolbar\"><span class=\"fa fa-plus-square fa-lg\"></span></span> }}\r\n - Opens {{[frgm] 15 Fragment Editor }} for creating and editing a new Fragment.\r\n- **Search Button** {{[html] <span class=\"fa fa-search fa-lg\"></span> }}\r\n - Opens {{[frgm]23 Search Dialog }}\r\n- **Previous Page Button** {{[html] <span class=\"fa fa-step-backward fa-lg\"></span> }}\r\n - Navigates to the previous page.\r\n - See {{[frgm] 32 Pagination inside Panel }} for details.\r\n- **Next Page Button** {{[html] <span class=\"fa fa-step-forward fa-lg\"></span> }}\r\n - Navigates to the next page.\r\n - See {{[frgm] 32 Pagination inside Panel }} for details.\r\n- **Home Button** {{[html] <span class=\"fa fa-home fa-lg\"></span> }}\r\n - Fetches all the Fragments.\r\n - This will be the default state whenever you start or refresh the application.\r\n- **Empty Panel Button** {{[html] <span class=\"fa fa-eraser fa-lg\"></span> }}\r\n - Since version 0.9.0.RC2\r\n - Empties the Panel, which means clearing all Fragments on the Panel.\r\n - This button will be invisible when the panel has no Fragment from the first place.\r\n- **Sort Button** {{[html] <span class=\"fa fa-sort fa-lg\"></span> }}\r\n - Opens Sort Options Dialog\r\n- **Fragment Scale Slider**\r\n - Tunes how many Fragments are visible within the screen. \r\n - Moving the slider button to the far left will show as many Fragments as possible in the screen by reducing size of an individual Fragment.\r\n   - Only the header of each Fragment will be visible.\r\n   - But double clicking on the header will get all of the clicked Fragment visible again.\r\n - Moving the slider button to the far right will show each individual Fragment at the full scale size ( which is default ).\r\n   - That means only small number of Fragments will be visible in the screen.\r\n   - Double clicking on the header will get the clicked Fragment invisible but its header.\r\n - Moving the slider button anywhere in-between will show the Fragments of some intermediate state.\r\n - _**Note that the header of each Fragment is always visible**_.'), TIMESTAMP '2015-08-26 17:32:38.217', TIMESTAMP '2015-10-15 09:50:10.699');     
 
 INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES

(65, 33, 37),
(66, 37, 33),
(67, 34, 37),
(68, 37, 34);       


(1443, 3, 23),
(1444, 5, 23),
(1459, 3, 19),
(1460, 5, 19),
(1469, 3, 21),
(1470, 5, 21);   

INSERT INTO PUBLIC.FRAGMENT2FRAGMENT(FRAGMENT2FRAGMENT_ID, FROM_ID, TO_ID) VALUES
(1, 7, 6),
