 (55, 35, 34),
 (56, 34, 35),
 (57, 30, 29),
-(58, 29, 30);   
-
+(58, 29, 30),
+(59, 36, 35),
+(60, 35, 36),
+(61, 32, 34),
+(62, 34, 32),
+(63, 22, 14),
+(64, 14, 22);               
+

(3, 'civilizer'),
(4, 'concepts'),
(5, 'manual'),
(6, 'table of contents'); 

INSERT INTO PUBLIC.TAG2FRAGMENT(TAG2FRAGMENT_ID, TAG_ID, FRAGMENT_ID) VALUES
(3, 1, 2),
(4, 1, 1),
(5, 1, 3),
(8, 1, 4),
(14, 1, 5),
(20, 1, 6),
(24, 1, 7),
(31, 1, 9),
(32, 1, 10),
(66, 1, 13),
(69, 1, 11),
(70, 2, 11),
(76, 1, 12),
(77, 2, 12),
(401, 3, 24),
(402, 5, 24),
(405, 3, 25),
(406, 5, 25),
(423, 3, 26),
(424, 4, 26),
(437, 3, 17),
(438, 5, 17),
(449, 3, 19),
(450, 5, 19),
(467, 1, 8),
(498, 3, 21),
(499, 5, 21),
(680, 3, 15),
(681, 5, 15),
(682, 3, 14),
(683, 4, 14),
(690, 3, 27),
(691, 5, 27),
(724, 3, 23),
(725, 5, 23),
(762, 1, 30),
(763, 6, 30),
(770, 3, 28),
(771, 5, 28),
(772, -1, 30),
(785, 3, 16),
(786, 4, 16),
(789, 3, 20),
(790, 4, 20),
(833, 3, 18),
(834, 4, 18),
(869, 3, 32),
(870, 5, 32),
(871, 3, 31),
(872, 5, 31),
(903, 3, 33),
(904, 4, 33),
(913, 3, 35),
(914, 5, 35),
(921, 3, 29),
(922, 5, 29),
(923, 6, 29),
(924, -1, 29),
(929, 3, 34),
(930, 5, 34),
(931, 2, 22),
(932, 3, 22),
(933, 4, 22),
(934, 5, 22);            

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

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(1, 'markdown - Phrase Emphasis', STRINGDECODE('    **bold** or __bold__\r\n\r\n    *italic* or _italic_\r\n\r\n    ***bold_and_italic*** or ___bold_and_italic___ \r\n\r\n* * *\r\n##### Output:\r\n\r\n**bold** or __bold__\r\n\r\n*italic* or _italic_\r\n\r\n***bold_and_italic*** or ___bold_and_italic___ '), TIMESTAMP '2015-06-13 16:37:54.137', TIMESTAMP '2015-09-22 07:59:28.213'),
(2, 'markdown - Headers', STRINGDECODE('    Big Header\r\n    =======\r\n    \r\n    Smaller Header \r\n    --------\r\n    \r\n    # Header 1\r\n    ## Header 2\r\n    ### Header 3\r\n    #### Header 4\r\n    ##### Header 5\r\n    ###### Header 6\r\n\r\n* * *\r\n##### Output:\r\n\r\nBig Header\r\n=======\r\n\r\nSmaller Header \r\n--------\r\n\r\n# Header 1\r\n## Header 2\r\n### Header 3\r\n#### Header 4\r\n##### Header 5\r\n###### Header 6\r\n'), TIMESTAMP '2015-06-13 16:44:38.168', TIMESTAMP '2015-09-22 08:00:04.302'),
(3, 'markdown - Lists', STRINGDECODE('    Ordered, without paragraphs: \r\n        1.  Foo\r\n        1.  Bar\r\n\r\n    Unordered, with paragraphs: (''*'' or ''+'' or ''-'' can be used)\r\n        - Foo.  \r\n          With multiple paragraphs.\r\n        - Bar\r\n\r\n    You can nest them:\r\n        -   An unordered list item\r\n          - A nested unordered list item\r\n        -   Another list item\r\n            1.  The first nested ordered list item\r\n            1.  A second nested ordered list item\r\n                * A nested unordered list\r\n            1. This is the last nested ordered list item\r\n        -   The last unordered list item\r\n\r\n* * *\r\n##### Output:\r\n\r\nOrdered, without paragraphs: \r\n1.  Foo\r\n1.  Bar\r\n\r\nUnordered, with paragraphs: (''*'' or ''+'' or ''-'' can be used)\r\n- Foo.  \r\n  With multiple paragraphs.\r\n- Bar\r\n\r\nYou can nest them:\r\n-   An unordered list item\r\n  - A nested unordered list item\r\n-   Another list item\r\n    1.  The first nested ordered list item\r\n    1.  A second nested ordered list item\r\n        * A nested unordered list\r\n    1. This is the last nested ordered list item\r\n-   The last unordered list item'), TIMESTAMP '2015-06-13 16:51:45.537', TIMESTAMP '2015-09-22 08:01:06.091'),
(4, 'markdown - Blockquotes', STRINGDECODE('    > Email-style angle brackets  \r\n    > are used for blockquotes.\r\n    > > And, they can be nested.\r\n    >\r\n    > * You can quote a list.\r\n    > * Etc.\r\n\r\n* * *\r\n##### Output:\r\n\r\n> Email-style angle brackets  \r\n> are used for blockquotes.\r\n> > And, they can be nested.\r\n>\r\n> * You can quote a list.\r\n> * Etc.'), TIMESTAMP '2015-06-13 16:54:05.735', TIMESTAMP '2015-09-22 08:01:58.769'),
(5, 'markdown - Literal (preformatted) text', STRINGDECODE('    Text surrounded by backticks will be rendered literally:  \r\n    `*** not bold, just shows as it is ***`  \r\n    ( You can include literal backticks like `` `this` `` )\r\n\r\n    Alternatively, you can just indent every line by at least 4 spaces like so:\r\n\r\n        ##### This text will not be rendered as headers\r\n        ##### This one neither\r\n\r\n##### Output:\r\nText surrounded by backticks will be rendered literally:  \r\n`*** not bold, just shows as it is ***`  \r\n( You can include literal backticks like `` `this` `` )\r\n\r\nAlternatively, you can just indent every line by at least 4 spaces like so:\r\n\r\n    ##### This text will not be rendered as headers\r\n    ##### This one neither'), TIMESTAMP '2015-06-13 17:09:23.397', TIMESTAMP '2015-09-22 08:12:34.774'),
(6, 'markdown - Links', STRINGDECODE('    Inline style:  [text](URL \"optional title\")  \r\n\r\n    Example:  \r\n      Go to [Google](http://www.google.com \"Google Page\")\r\n##### Output:\r\nGo to [Google](http://www.google.com \"Google Page\")\r\n* * *\r\n    Reference style: [text][label]\r\n    Then, anywhere else in the doc, define the links like so:\r\n        [label]: URL \"optional title\"\r\n\r\n    Example:  \r\n      Go to [Google][0]\r\n\r\n      [0]: http://www.google.com\r\n\r\n##### Output:\r\nGo to [Google][0]\r\n\r\n\r\n[0]: http://www.google.com'), TIMESTAMP '2015-06-13 17:27:30.349', TIMESTAMP '2015-09-22 08:09:38.008');   

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 to break lines manually:  \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\r\n* * *\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> [Tip]  \r\n> Sometimes you want blank lines between data (paragraph, table, image, ...) but Markdown won''t allow it.    \r\n> Insert {{[clr-br] `&nbsp;{space}{space}` }} in that case.  \r\n>       \r\n>         ###### This line is followed by a blank line {{[clr-br] {space}{space} }}  \r\n>         {{[clr-br]&nbsp;{space}{space} }}  \r\n>         ###### Note the above blank line  \r\n>           \r\n> * * *  \r\n> ##### Output:  \r\n> ###### This line is followed by a blank line\r\n> &nbsp;    \r\n> ###### Note the above blank line  '), TIMESTAMP '2015-06-13 18:02:00.926', TIMESTAMP '2015-09-22 08:33:15.58'),
(9, 'markdown - Table (standard style)', STRINGDECODE('\r\n    First Header  | Second Header\r\n    ------------- | -------------\r\n    Content Cell  | Content Cell\r\n    Content Cell  | Content Cell\r\n\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-09-22 08:11:05.748'),
(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-09-22 08:11:18.703'),
(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 an _**HTML entity number**_ {{[clr-b] `&#124;` }} for the literal |.\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;\r\n\r\n&nbsp;  \r\n> You can find HTML entity numbers for each Ascii code at the following site:    \r\n> http://www.ascii-code.com  '), TIMESTAMP '2015-07-09 07:58:13.305', TIMESTAMP '2015-09-22 08:23:01.762');          

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-09-22 08:09:12.38'),
(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 overall concept and idea of Fragment have been borrowed from [Piggydb](http://piggydb.jp/en/d/1#r23 \"\").   \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 {{[clr-y] structured }} form of 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###### Searching Fragments\r\nFast access on your Fragments is vital.  \r\nThe key is, **the more structure your Fragments have, the more efficiently you can search the right Fragments at the right time**.  \r\nRead {{[frgm] 22 Searching Fragments on Civilizer }} for details.\r\n'), TIMESTAMP '2015-07-12 14:55:07.81', TIMESTAMP '2015-09-22 08:40:26.724'),
(15, 'Fragment Editor', STRINGDECODE('Fragments can be edited with {{[clr-g] Fragment Editor }} which is basically a {{[frgm]30 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 screen.  \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 style=\"color:blue\" 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 user interface components (in a top to bottom order)\r\n1. Input for a Fragment Title\r\n1. Input for Tag names\r\n - _**Multiple Tag names should be comma-separated.**_\r\n - This input widget has **autocomplete** capability so as you type a portion of an existing Tag name, it will present you one or multiple suggestions.\r\n1. Toolbar to assist you in inserting {{[tag] 1 }} commands or {{[frgm]28 Civilizer Custom Markup commands }}.\r\n1. Textarea for your main 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 content prior to saving it.\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.'), TIMESTAMP '2015-07-13 11:03:27.823', TIMESTAMP '2015-09-22 09:47:12.139');      

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&#41;), a Tag is a non-hierarchical keyword or term, but {{[clr-y] in Civilizer, Tags can have hierarchy }}, which means that they can have parents or children.\r\n\r\nA few special characters are not allowed to be used for your Tag names.\r\nRefer to {{[frgm]25 this Fragment }} for details.'), TIMESTAMP '2015-07-14 11:40:19.495', TIMESTAMP '2015-09-22 08:46:07.66'),
(17, 'Basic Operations for Fragments', STRINGDECODE('Note that most of operations for Fragments are executed through its _**Context Menu**_, which can be invoked by {{[clr-b] Right Clicking on each of the Fragment headers }}. \r\n\r\n###### Creating a new Fragment\r\nSee {{[frgm]15 Fragment Editor }}.\r\n###### Editing an existing Fragment\r\nSee {{[frgm]15 Fragment Editor }}.\r\n* * *\r\n###### Peeking a Fragment\r\nSome Fragments show only its ID and title such as those in {{[html] <span style=\"color:orange\" class=\"fa fa-bookmark\" >Bookmarks</span> }} and {{[html] <span style=\"color:coral\" class=\"fa fa-list-alt\" >&nbsp;Selection Box</span> }}.  \r\nYou can view content of a Fragment by clicking on the ID of the Fragment.  \r\n\r\n        An ID of a Fragment consists of a leading hash mark (#) and a ID number as in {{[clr-b] ''#20'' }})\r\n \r\nBy clicking on the ID, a pop-up window will appear at the lower-right corner of the screen.  \r\nThe pop-up window is sticky so it will appear even when you scroll the page up and down.\r\n> [Tip] Double clicking on the title bar of the pop-up window will make the window minimized.    \r\n> Double clicking on the title once again will restore the window to the normal size.\r\n\r\n* * *\r\n###### Trashing a Fragment\r\nWhen you trash a Fragment, the Fragment will be sent to the Trashcan.  \r\n{{[clr-v] Trashed Fragments still exist on the database }} so you can simply restore it later if you want to.  \r\n\r\n1. Right Click on the header of the Fragment you''d like to trash.\r\n1. Click _**Trash**_.\r\n\r\n###### Deleting a Fragment\r\nYou can delete a Fragment already trashed into the Trashcan.  \r\n{{[clr-r] Deleting a Fragment means it will disappear from the database permanently. }}  \r\nYou need to go to the Trashcan prior to performing this operation.  \r\n\r\n1. Go to the Trashcan.\r\n  - Click the icon {{[html]<span style=\"color:gray\" class=\"fa fa-trash fa-lg\"></span> }}on {{[html] <span style=\"color:green\" class=\"fa fa-tags\">&nbsp;&nbsp;Tag Palette</span> }} on your right side.\r\n1. Right Click on the header of Fragment you''d like to delete.\r\n1. Click _**Delete**_.\r\n\r\n###### Restoring Fragments from the Trashcan\r\n1. Go to the Trashcan\r\n  - Click the icon {{[html]<span style=\"color:gray\" class=\"fa fa-trash fa-lg\"></span> }}on {{[html] <span style=\"color:green\" class=\"fa fa-tags\">&nbsp;&nbsp;Tag Palette</span> }} on your right side.\r\n1. Right Click on the header of Fragment you''d like to restore.\r\n1. Click _**Restore**_\r\n* * *\r\n###### Relating Fragments\r\n1. By Drag & Drop:\r\n  1. Drag a _**title**_ of a Fragment you''d like to relate.\r\n  1. Drop that title on the header of the other Fragment.\r\n1. By Selecting Fragments:\r\n  1. First, select Fragments you''d like to relate with one another.\r\n    - Refer to the section of **''Selecting a Fragment''** below.\r\n  1. The selected Fragments will appear on the {{[html] <span style=\"color:coral\" class=\"fa fa-list-alt\" >&nbsp;Selection Box</span> }} on your right side.\r\n  1. **Right click anywhere on the empty area** in the Selection Box.\r\n  1. Click _**Relate All**_ from the context menu.\r\n\r\n###### Bookmarking a Fragment\r\nYou can bookmark a Fragment that you think you access relatively more frequently.  \r\n\r\n1. Right Click on the header of Fragment you''d like to bookmark.\r\n1. Click _**Bookmark**_\r\n1. Then the title of your bookmarked Fragment will appear on the {{[html] <span style=\"color:orange\" class=\"fa fa-bookmark\" >Bookmarks</span> }} panel on your right side.\r\n\r\n###### Selecting a Fragment\r\nYou can select Fragments by checking the checkbox which is the leftmost component on each Fragment''s header.  \r\n- By selecting a Fragment, it will appear on the {{[html] <span style=\"color:coral\" class=\"fa fa-list-alt\" >&nbsp;Selection Box</span> }} on your right side.\r\n- By unchecking the checkbox, the Fragment will disappear from the Selection Box.\r\n - Alternatively, you can make all selected Fragments disappear from the Selection Box at once:\r\n    1. Right click anywhere on the empty area in the Selection Box\r\n    1. Click _**Unselect All**_ from the context menu.\r\n\r\nYou can perform a few operations for multiple selected Fragments by right clicking anywhere on the empty area in the Selection Box:\r\n- Trashing selected Fragments at once.\r\n- Relating selected Fragments with one another.\r\n- Accessing selected Fragments like you can do with Bookmarks.\r\n\r\n> [NOTE] Selected Fragments will be stored in your browser''s storage NOT in the server storage.    \r\n> For instance, if your session expires, they will be gone.    \r\n> To capture Fragments in a persistent manner (storing them into the server), use Bookmaring.'), TIMESTAMP '2015-07-14 11:49:21.584', TIMESTAMP '2015-09-22 09:32:11.175');          

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(18, 'Panels on Civilizer', STRINGDECODE('In Civilizer, a {{[clr-y] Panel }} is a rectangular layout containing Fragments.  \r\n\r\nThe main purposes of Panels are :\r\n- To show two or more Fragments simultaneously on the same screen.\r\n- Thus, to greatly reduce the needs to go back and forth across the pages.\r\n- And to greatly help you when you need to review many Fragments at once.\r\n\r\nCivilizer has a maximum of 3 Panels (it shows only one by default).\r\n\r\nFor instance, you can manage a maximum of 3 categories of Fragments simultaneously as follows:\r\n1. On Panel 0, you can view or edit Fragments from a specific search phrase.\r\n1. On Panel 1, you can view other related Fragments for a reference purpose.\r\n1. On Panel 2, you can view results from another related search phrase.\r\n\r\nClicking each {{[clr-b] Panel Toggle Button }} {{[html] <span class=\"fa fa-desktop fa-lg\"></span>}} on the header will toggle each Panel.\r\n\r\nAlso each Panel has its {{[frgm]31 Panel Toolbar }} which is always visible at the bottom of it. You can quickly access functionalities related to the Panel via the toolbar menus.\r\n\r\nAnd each Panel has its own scroll bar so scrolling one Panel doesn''t affect the other Panels.'), TIMESTAMP '2015-07-14 15:03:23.841', TIMESTAMP '2015-09-22 08:56:21.042'),
(19, 'Basic Operations for Tags', STRINGDECODE('###### Adding a Tag to a Fragment\r\n- Open {{[frgm]15 Fragment Editor }} for a Fragment you want to tag.\r\n- You''ll see the **tag input box** located just above the toolbar.\r\n  - When you type any **existing** Tag name, autocomplete list box will appear.\r\n   - Press UP/DOWN keys to focus name to name when you have multiple candidates.\r\n   - Press ENTER key to select and add the focused name.\r\n   - Press ESC key to make the autocomplete list box disappear.\r\n  - Also by typing a new (non existent) name, you can add a new Tag to the Fragment.\r\n- Note that typed Tags will be added to the Fragment _**after you save the Fragment**_.\r\n  - Also note that a new Tag will be created and stored in the database after you save the Fragment.\r\n* * *\r\n###### Creating a Tag\r\n- Click the icon {{[html] <span class=\"fa fa-tag ui-panel ui-widget-content ui-corner-all\">+</span> }} on {{[html] <span style=\"color:green\" class=\"fa fa-tags\">&nbsp;&nbsp;Tag Palette</span> }} on your right side.\r\n  - A _**Tag Editor**_ will appear.\r\n  - Refer to **Editing a Tag** section for operations of Tag Editor.\r\n\r\n###### Editing a Tag\r\n1. {{[clr-b] Right click on the tag }} you''d like to edit.\r\n1. Click _**Edit**_.\r\n1. A _**Tag Editor**_ will appear.\r\n  - You can rename the tag by clicking the tag name at the top.\r\n  - You can change the hierarchy of the tag.\r\n    - There are two panels in the middle denoting parent tags on the left and child tags on the right.\r\n    - By clicking ''**+**'', a listbox of selectable tags will appear.\r\n    - You can insert a new parent or child by:\r\n      1. Selecting a tag from the listbox.\r\n      1. Then, click the {{[html]<span class=\"fa fa-check fa-lg\"></span> }} button.\r\n      1. When you have too many tags to select from, just type a portion of the name in the input box to filter out to a few, which will be easier to pick from.\r\n* * *\r\n###### Trashing a Tag\r\n1. Right click on the tag you''d like to edit.\r\n1. Click _**Trash**_.\r\n1. Click OK button on the confirm dialog\r\n  - If the tag contains one or more Fragments, the Fragments will be trashed too.\r\n    - But the tag itself will remain.\r\n  - {{[clr-r] If the tag contains no Fragment, the tag will disappear from the storage }}.\r\n\r\n> [Tip] You can also perform the above operations for tag icons located on other areas such as Fragment headers.'), TIMESTAMP '2015-07-14 15:22:02.941', TIMESTAMP '2015-09-22 09:58:15.053'),
(20, 'File Box', STRINGDECODE('You can manage arbitrary **files** (especially **files you personally own**, not any file on the Web) via {{[clr-y] File Box }} in Civilizer.\r\n\r\nSometimes you want a Fragment to have a link to a certain file you own.  \r\nTo do that, you first need to upload that file into File Box.\r\n\r\nThough File box''s primary purpose is managing files that may be linked to Fragments,  \r\nyou can let File Box manage any files you have whether or not the files having relationships to Fragments.\r\n\r\nFile Box''s structure looks like a regular file system of common operating systems.  \r\nIt provides a hierarchy of folders/files and also common operations such as renaming/moving/deleting those folders/files.\r\n'), TIMESTAMP '2015-07-15 17:25:05.635', TIMESTAMP '2015-09-22 08:48:22.269');     

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(21, 'Basic Operations for File Box', STRINGDECODE('###### Uploading a File\r\n1. Right click anywhere on the empty space in {{[html] <span style=\"color:brown\" class=\"fa fa-floppy-o\">&nbsp;&nbsp;File Box</span> }}.\r\n1. Click _**Upload File**_ from the context menu.\r\n1. The **Upload Dialog** will appear.\r\n1. Select the destination folder where your file will be placed in File Box.\r\n1. Click _**Choose**_ button.\r\n - This will bring up the file upload dialog of your browser.\r\n - Choose the file you''d like to upload and confirm it.\r\n - Then **OK** button will appear at the bottom with some _shake animation_.\r\n1. Click the OK button.\r\n\r\n###### Inserting a link to a File into a Fragment\r\nThis operation can be performed with a simple {{[clr-v] Drag & Drop }}.  \r\nThe Fragment that you want to have a link to a file needs to be in edit mode.\r\n\r\n1. Open {{[frgm]15 Fragment Editor }} to edit the Fragment that you want to have a link to a file.\r\n1. Grab the target file in {{[html] <span style=\"color:brown\" class=\"fa fa-floppy-o\">&nbsp;&nbsp;File Box</span> }} with your mouse.\r\n1. Drag and drop it to the content textarea in Fragment Editor.\r\n1. A {{[frgm]28 Civilizer Custom Markup Command }} will be generated at the place where the caret was located.\r\n1. After saving the Fragment, you can see a link to the file generated.\r\n1. What will happen by clicking the link depends on:\r\n  - the type of file.\r\n  - behavior of your browser specified for that type of file. (mostly downloading)\r\n* * *\r\n###### Renaming a File/Folder\r\n1. Right click on the file/folder you''d like to rename.\r\n1. A dialog appears.\r\n1. Rename it.\r\n1. Click OK.\r\n\r\n###### Moving a File/Folder\r\n1. Right click on the file/folder you''d like to move.\r\n1. A Move Dialog appears.\r\n1. Select the destination folder.\r\n  - When moving a folder, You can''t move it to certain destinations in a logical sense.\r\n    - Such as to a folder which is the moving folder''s sub folder. \r\n    - In such cases, a warning message will appear and you won''t be able to proceed.\r\n  - When moving a folder, all of its sub folders and files will be moved.\r\n1. Click OK.\r\n\r\n###### Deleting a File/Folder\r\n1. Right click on the file/folder you''d like to delete.\r\n1. Click OK on the confirm dialog.'), TIMESTAMP '2015-07-15 17:43:44.624', TIMESTAMP '2015-09-22 10:12:43.877'),
(22, 'Searching Fragments on Civilizer', STRINGDECODE('Civilizer has a focus on implementing efficient and user-friendly search capability.\r\n\r\nJust click an icon {{[html] <span class=\"fa fa-search fa-lg\"></span> }} on the header ( alternatively, {{[frgm]31 Panel Toolbar }} at the bottom of the screen ).  \r\nA {{[clr-y] Search Dialog }} will show up.\r\n\r\nEach icon is connected to each different {{[frgm]18 Panel }} so the search result will be shown at each corresponding Panel. (But the destination panel can be changed even when the dialog is running)  \r\nThat means you can do the maximum of 3 different searches simultaneously without jumping across different pages.\r\n\r\nYou can just type any search phrase to match Fragments and that''s it.  \r\nOr sometimes you may want to perform a more fine-grained search and that is also possible.  \r\nSee {{[frgm] 23 Basic Operations for Search Dialog }}\r\n\r\n> [_**Tip**_]  \r\n> Pressing the shortcut {{[clr-y] Control + Shift + Space }} will show you Search Dialog from anywhere on the page.  \r\n> After the dialog appears, pressing the same key sequence will get the target panel shifted.\r\n'), TIMESTAMP '2015-07-17 14:25:56.537', TIMESTAMP '2015-09-22 09:00:16.685'),
(23, 'Basic Operations for Search Dialog', STRINGDECODE('##### {{[clr-g] Default Rules for Search Phrase }}\r\n- You can **separate** multiple Search keywords with one or more **spaces**.\r\n- If you have a search phrase with some spaces in it and you want Civilizer to treat it as one single search phrase, surround the phrase with **double quotation marks (\")**.\r\n  - For instance, if you type {{[clr-br] big data }}, the result may match both of the following.\r\n    1. What you have is a {{[clr-br]big}} chunk of useless {{[clr-br]data}}. \r\n    1. {{[clr-br]Big data}} will improve our society.\r\n  - On the other hand, if you type {{[clr-br] \"big data\" }}, the result will match only 2.\r\n  - _**Note that using single quotation marks ('') won''t work.**_\r\n- By default, when you type **multiple search keywords**, Civilizer finds you Fragments that **match all of the words**. \r\n\r\n##### {{[clr-g] Two types of Search }}\r\nWhen the Search Dialog appears, you will find two separate vertically placed tabs sitting on the dialog.  \r\n\r\n- _**Quick Search (Default)**_\r\n  - This tab has only one text input component.\r\n  - Just type search phrase you''d like and press Enter or click the submit button below.\r\n  - Over Quick Search, you can specify your search phrase in a more detailed way using {{[frgm]24 Civilizer Search Operators }}.\r\n- _**Normal Search**_\r\n  - When you click this tab, you''ll see more of UI components.\r\n  - You can type specific search phrase for each specific category.\r\n    - This will highly likely get more specific and exact search results.\r\n  - As stated above, when you type multiple search keywords, the search result will match all of the words.\r\n    - For instance, a trivial search phrase such as {{[clr-br] big data }} will match phrases that contain all of those two words like so:\r\n       - What you have is a {{[clr-br] big }} chunk of useless {{[clr-br] data }}.\r\n  - But if you check a checkbox saying ''_**Any**_'', Fragments that match any of the words would be fetched as the result.\r\n    - For instance, with **Any** checkbox checked, a search phrase such as {{[clr-br] big data }} will match phrases that contain any of those two words as follows:\r\n        - He is a real {{[clr-br] big }}!\r\n        - {{[clr-br] data }} science \r\n        - {{[clr-br] big data }} technology\r\n        - etc.\r\n  - After completing your search phrase, you can click the submit button below to kick the search.'), TIMESTAMP '2015-07-17 14:30:30.754', TIMESTAMP '2015-09-22 10:14:26.614');      

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(24, 'Civilizer Search Operators', STRINGDECODE('{{[clr-y] Civilizer Search Operators }} have been implemented to help users tune their search phrases so that they can get more fine-grained search results.\r\nThis kind of concept already has been out there for a long time such as [Google Search Operators](http://www.googleguide.com/advanced_operators_reference.html \"\"). \r\n\r\nFor instance, the 1st search phrase will likely match more Fragments ( thus, inefficient ) than 2nd search phrase.    \r\n1. big data databases\r\n1. \"big data\"/c tag:databases\r\n  - Just don''t care about the meaning of this search phrase for now.\r\n\r\n{{[clr-m] More Fragments of the search results usually mean less efficiency and mostly it would take more time until you reach exact information you would''ve targeted. }}  \r\nUsing the search operators usually will filter out irrelevant Fragments from your result so your search will be more efficient.\r\n* * *\r\nThere are two types of operator : _Category Operators_ and _Flag Operators_:\r\n\r\n{{{[fold{\"title\":\"Category Operators\",\"hide\":\"true\"}]\r\nThese operators make your search keywords match only a specific category (content, title, tag, etc.) of Fragments.  \r\nYou can always combine two or more of these operators.\r\n\r\n- {{[clr-b] : }}\r\n  - will match all of words for Fragment contents and titles.\r\n  - ex){{[clr-br]: big data }} --> will match Fragments whose content or title contains phrases such as --> {{[clr-br] data is big, big data, Big data, etc }}.\r\n- {{[clr-b] any: }}\r\n  - will match any of words for Fragment contents and titles.\r\n  - ex) {{[clr-br] any: big data }} --> will match Fragments whose content or title contain phrases such as --> {{[clr-br] big animal, database, big data, etc }}.\r\n- {{[clr-b] tag: }}\r\n  - will match Fragments whose tags contain all of the words.\r\n  - ex) {{[clr-br] tag:xml html }} --> will match Fragments having tags of {{[clr-br] xml and html altogether }}.\r\n- {{[clr-b] anytag: }}\r\n  - will match Fragments having any of the specified tags.\r\n  - ex) {{[clr-br] anytag:xml html }} --> will match Fragments having tags of {{[clr-br] xml or html or both }}.\r\n- {{[clr-b] title: }}\r\n  - will match Fragments with a title that contains all of the words.\r\n  - ex) {{[clr-br] title:install printer }} --> will match Fragments with a title that contains {{[clr-br] install and printer altogether }}.\r\n- {{[clr-b] anytitle: }}\r\n  - will match Fragments with a title containing any of the specified words.\r\n  - ex) {{[clr-br] anytitle:android ios }} --> will match Fragments with a title that contains any of {{[clr-br] android or ios or both }}.\r\n- {{[clr-b] text: }}\r\n  - will match all of words for Fragment contents.\r\n  - ex){{[clr-br] text: big data }} --> will match Fragments whose content contains phrases such as --> {{[clr-br] data is big, big data, Big data, etc }}.\r\n- {{[clr-b] anytext: }}\r\n  - will match any of words for Fragment contents.\r\n  - ex) {{[clr-br] anytext: big data }} --> will match Fragments whose content contains phrases such as --> {{[clr-br] big animal, database, big data, etc }}.\r\n- {{[clr-b] id: }}\r\n  - will match Fragment id numbers.\r\n  - ex) {{[clr-br] id: 1 3 5 9 }} --> will match 4 {{[clr-br] Fragments with id of 1, 3, 5, 9 }}.\r\n\r\n> {{[clr-v] By default, tag keywords won''t consider their hierarchies. }}    \r\n> But targeting Fragments tagged by a specific tag or any of its descendants is possible using a ''/h'' flag operator. (See below)  \r\n}}}\r\n\r\n{{{[fold{\"title\":\"Flag Operators\",\"hide\":\"true\"}]\r\nThese operators may be appended to the tail of a word (with slash) and let you control specific match requirements for that word.  \r\n\r\n- {{[clr-b] /c }}\r\n  - Case Sensitive\r\n  - ex) {{[clr-br] \"Big Data\"/c }} will match {{[clr-br] Big Data NOT big data }}\r\n- {{[clr-b] /w }}\r\n  - Whole Word\r\n  - ex) {{[clr-br] device/w }} will match {{[clr-br] device NOT devices }}\r\n- {{[clr-b] /b }} \r\n  - Beginning with\r\n  - ex) {{[clr-br] html/b }} will match {{[clr-br] html or html5 NOT xhtml }}\r\n- {{[clr-b] /e }} \r\n  - Ending with\r\n  - ex){{[clr-br] mail/e }} will match {{[clr-br] email or Gmail NOT mails }}\r\n- {{[clr-b] /r }}\r\n  - Regular Expression\r\n  - ex) {{[clr-br] https?/r }} will match {{[clr-br] http or https or https:// NOT ftp }}\r\n- {{[clr-b] /- }} \r\n  - Inverse; \r\n  - will return results not matching the pattern.\r\n  - ex) {{[clr-br] android/- }} will match {{[clr-br] any word not containing android }} \r\n- {{[clr-b] /h }}\r\n  - Considering Tag Hierarchy\r\n  - will work only with Tag Category Operators ( such as {{[clr-b] :tag }} or {{[clr-b] :anytag }} ).\r\n  - will consider each Tag''s hierarchy when performing searches.\r\n  - ex) {{[clr-br] tag:business/h }} will match any {{[clr-br]Fragment tagged by a tag ''business'' or any of its descendant tags}}\r\n\r\n> You can always combine two or more of these operators.    \r\n> ex) {{[clr-br] Down/bc }} will match {{[clr-br] Download or Downside NOT download either UpsideDown }}\r\n}}}\r\n\r\n* * *\r\nThe above example of search phrase {{[clr-br] \"big data\"/c tag:databases }} will match:   \r\n- Fragments whose content or title contains {{[clr-br] big data }}:\r\n - case DOES matter because of {{[clr-v] c }} Flag Operator\r\n - a word {{[clr-br] big }} needs to be followed by a space and word {{[clr-br] data }} because of the {{[clr-v] double quotation marks }}  \r\n   - Read {{[frgm] 23 Basic Operations for Search Dialog }} about how double quotes work.\r\n- and Fragments whose Tags contain a word {{[clr-br] databases }}.'), TIMESTAMP '2015-07-17 15:33:38.34', TIMESTAMP '2015-09-24 13:55:29.978');             

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(25, 'Rules for your tag names', STRINGDECODE('As a rule, any of the following characters is NOT allowed to be used inside any tag name.\r\n\r\n- Double Quotation mark\r\n  - {{[clr-br] \" }}\r\n- Colon \r\n  - {{[clr-br] : }}\r\n- Comma\r\n  - {{[clr-br] , }}\r\n- Back Slash\r\n  - {{[clr-br] \\ }}\r\n\r\n\r\nBy convention, Civilizer uses a leading # (Hash mark) to denote {{[frgm]26 Special Tags }} such as #trash, etc.  \r\nNotice that using a leading # in your tag names is OK technically, but not so recommended.\r\n'), TIMESTAMP '2015-07-17 15:42:51.938', TIMESTAMP '2015-09-22 09:59:42.951'),
(26, 'Special Tags On Civilizer', STRINGDECODE('Civilizer has special tags to denote some Fragments having special properties.\r\n\r\n###### \\#trash\r\nFragments with this tag denote that they have been trashed.  \r\nOnly Fragments tagged with #trash can be deleted from the database.\r\n\r\n###### \\#bookmark\r\nFragments with this tag denote that they have been bookmarked.\r\n\r\n###### \\#untagged\r\nFragments with this tag denote that they have not been tagged at all by the user.\r\n> Fragments without being tagged will do you no good at all.  \r\n> So if you find one, please tag it with one or more meaningful names.   '), TIMESTAMP '2015-07-17 15:52:07.649', TIMESTAMP '2015-08-21 17:30:55.243'),
(27, 'Editing Content on Fragment Editor', STRINGDECODE('#### Toolbar Menu Basics\r\n- Toolbar Menus are provided to help users do the following and others:\r\n - styling the text\r\n   - Heading, Bold, Italic, Strike-through, Underline, Colorizing.\r\n - structuring the text\r\n   - Unordered list(Bulleted list), Ordered list(Numeric list)\r\n   - Quoting\r\n   - Line indenting/outdenting\r\n - Adding links to images/web pages/Fragments.\r\n- You need to first **select text (or multiple lines of text)** before executing the menus.\r\n- Each menu corresponds to one of{{[tag] 1 }} commands or {{[frgm]28 Civilizer Custom Markup commands }}.\r\n - So alternatively, you can type the underling commands directly without using toolbar menus and sometimes it is more faster.\r\n- Also most of the menus have their own shortcut keys assigned.\r\n - When you hover on each menu, a simple tooltip message will appear to let you know which shortcut key sequence it is assigned to.\r\n\r\n* * *\r\n#### Advanced Functionalities\r\n- **_Line Indenting/Outdenting_**\r\n - Indenting or outdenting lines by a single space can be done using the following toolbar menus:\r\n   - Indent (Move Right) : {{[html] <span class=\"fa fa-indent\"></span> }} \r\n   - Outdent (Move Left) : {{[html] <span class=\"fa fa-outdent\"></span> }} \r\n - Also you can indent/outdent lines by 4 spaces using the TAB/SHIFT key press:\r\n    - {{[clr-b] Indent by 4 spaces : press the _**Tab**_ key }}\r\n    - {{[clr-b] Outdent by 4 spaces : press the _**Shift + Tab**_ key }}\r\n    - These functions are not associated with any toolbar menu.\r\n    - These functions are useful if you want {{[frgm]5 preformat }} multiple lines at once.\r\n- **_Text Colorizing_**\r\n - By Colorizing some of your text, you can make it more distinguishable than just styling it with bold or italic.\r\n - Drop down menus for colorizing can appear by hovering on the toolbar menu located on the far right. ( an icon of a small triangle )\r\n - First select the text ( or multiple lines ) you want to colorize, and then click one of the menu.\r\n - No shortcut keys are associated with the menus.\r\n - This function is provided via one of {{[frgm]28 Civilizer Custom Markup commands }}.\r\n   - Markdown doesn''t provide any native syntax for styling of colorizing.\r\n- **Vertical Line Moving**\r\n - By pressing _**Shift + Up/Down**_, you can vertically move a line under the caret upward or downward.\r\n - Also by pressing the same key combination after selecting multiple lines, you can vertically move those lines upward or downward.\r\n- **Duplicating Lines**\r\n - By pressing _**Control + Shift + Up/Down**_, you can duplicate a line under the caret.\r\n - Also by pressing the same key combination after selecting multiple lines, you can duplicate those lines.  \r\n- **Folding**\r\n - Folding can make some block of your content togglable, which means you can make it show/hide by clicking a button or title attached to it.\r\n - You can fold some block of your content as the following instruction: (  Also note that _the instruction itself is folded_ to show you what a _Fold_ looks like.  )  \r\n{{{[fold{\"title\":\"How to Fold\",\"hide\":\"\"}]\r\n   1. Select multiple lines of text you want to fold.\r\n   1. Click the toolbar menu {{[html] <span class=\"fa fa-plus-square-o fa-lg\"></span> }}\r\n   1. A simple dialog will ask you a title of the fold.\r\n      - _The title is optional_.\r\n      - The default : ... ( just 3 periods )\r\n   1. Click OK.\r\n}}}\r\n- **_A Link to an image or web page_**\r\n - {{[clr-b] Full URLs to any web page will become clickable automatically. }}\r\n   - Any text starting with `http://` or `https://` will be recognized as a link to a web page.\r\n     - e.g. just typing `http://www.google.com` will result in http://www.google.com\r\n     - To prevent a specific URL from being clickable, do either of the following:\r\n       - Wrap the URL text with Markdown literal syntax (`` `...` ``). (Refer to {{[frgm]5 this }})\r\n         - e.g. `` `http://www.google.com` ``\r\n         - **Output** : `http://www.google.com`\r\n       - Or select the URL text and click the toolbar menu of **\"Code\"** (a book icon)\r\n  - {{[clr-b] Any link to any of the following image file types will be rendered as the image itself automatically. }}\r\n     - _**PNG, JPG, GIF, BMP, ICO**_\r\n     - The image type will be identified by the file extension.\r\n     - Any image URL with no file extension or neither of the above won''t get rendered as image and will get rendered simply as a clickable URL.\r\n       - In this case, use the Markdown image link syntax as illustrated {{[frgm]7 here }}.\r\n- **_A Link to a Fragment_**\r\n - Click the toolbar menu {{[html]<span class=\"fa fa-link\"></span> }}\r\n- **_A Link to a File_**\r\n - When you have some files stored in your {{[frgm]20 File Box }}, you can insert links to them.\r\n - Refer to the section of **Inserting a link to a File into a Fragment** on {{[frgm]21 this Fragment }}.\r\n- **_A Link to a Tag_**\r\n - You can add a link to a Tag by the similar way you add a link to a file. \r\n   1. Grab the target Tag in the {{[html] <span style=\"color:green\" class=\"fa fa-tags\">&nbsp;&nbsp;Tag Palette</span> }} with your mouse.\r\n   1. Drag and drop it to the content textarea in Fragment Editor.\r\n   1. A custom markup text will be generated at the place where the caret was located.\r\n   1. After saving the Fragment, you can see a link to the Tag generated.\r\n\r\n* * *\r\n#### Limitations\r\n- {{[clr-r] No current support for redo/undo }}'), TIMESTAMP '2015-08-25 10:01:07.256', TIMESTAMP '2015-09-24 13:57:36.645');          

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(28, 'Civilizer Custom Markup Commands', STRINGDECODE('{{[clr-y] Civilizer Custom Markup Commands }} provides 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-09-24 16:00:48.452');               

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'), TIMESTAMP '2015-08-26 14:04:59.806', TIMESTAMP '2015-09-01 17:23:39.726'),
(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-08-27 12:19:58.321'),
(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- **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-09-22 10:20:30.259');        

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(32, 'Pagination inside Panel', STRINGDECODE('##### Pagination\r\n- The number of Fragments that a {{[frgm]18 Panel }} can hold is 10 at most by default.\r\n - This value is configurable via _**civilizer.items_per_page**_ Application Option.\r\n- If the number of Fragments exceeds this limit, the Fragments will get broken down to a number of Pages.\r\n- And you are always limited to view one Page per Panel at a time.\r\n\r\n##### Page Summary\r\n- A simple page summary will be always visible at the top of each Panel.\r\n- For example:\r\n \r\n         {{[html]<span class=\"fa fa-file-text-o\"></span> Total : 32[0-9]  Page : 1 / 4\r\n \r\n   - _32[0-9]_ \r\n    - The Panel is prepared to serve 32 Fragments in total.\r\n    - And the first 10 Fragments are visible for the current page.\r\n   - _Page : 1 / 4_ \r\n    - The first Page of 4 Pages in total is currently shown for the Panel.\r\n\r\n##### Navigating from page to page\r\n- **Navigation Buttons** on each of the {{[frgm]31 Panel Toolbars }} are available for you to navigate across pages.\r\n- By clicking **Previous Page Button** {{[html] <span class=\"fa fa-step-backward fa-lg\"></span> }}, you can navigate to the previous page.\r\n- By clicking **Next Page Button** {{[html] <span class=\"fa fa-step-forward fa-lg\"></span> }}, you can navigate to the next page.\r\n- The navigation buttons will automatically disappear under every situation when clicking the buttons don''t make sense.\r\n - e.g. when you are with the 1st page, then {{[html] <span class=\"fa fa-step-backward fa-lg\"></span> }} will disappear.'), TIMESTAMP '2015-08-27 08:46:52.778', TIMESTAMP '2015-09-21 15:56:50.407'),
(33, 'Private Home Directory for Civilizer', STRINGDECODE('The _**Private Home Directory**_ is where Civilizer keeps various application related or user related data/parameters.\r\n\r\nBy default, Civilizer will create a PHD to _**\"~/.civilizer\"**_\r\n> **\"~\"** denotes your home directory.\r\n\r\nAlternatively, you can switch to a different PHD by providing one as an application parameter.\r\n\r\nThe most important file the PHD keeps is _**\"app-options.properties\"**_.  \r\nThis file contains:\r\n- A path to your database file.\r\n- A path to the {{[frgm]20 File Box }} storage.\r\n- A user locale.\r\n- And other optional parameters.\r\n\r\nSee {{[frgm] 34 Application Options for Civilizer }} for details.'), TIMESTAMP '2015-08-27 10:23:40.758', TIMESTAMP '2015-09-01 17:23:27.027'),
(34, 'Application Options for Civilizer', STRINGDECODE('_**\"app-options.properties\"**_ file (which is located under the {{[frgm]33 Private Home Directory }}) contains application options to control various application behaviors.\r\n\r\n###### civilizer.db_file_prefix\r\n- A path to your database file.\r\n- The default value : _database/civilizer_.\r\n - So the database file will be automatically created to _**\"[path to your Private Home Directory]/database/civilizer.h2.db\"**_ by default.\r\n- It''s OK that you copy this database file to other machines or a cloud file system for backups or sharing it with your other devices.\r\n- Note that Civilizer only communicates to a single database file after it starts running.\r\n- So managing multiple different database files will become tricky (and not so recommended). \r\n - To switch to another database file, you need to switch this option to point to that location and restart Civilizer.\r\n\r\n###### civilizer.file_box_home\r\n- A path to {{[frgm] 20 File Box }} storage.\r\n- The default value : _files_.\r\n - So the File Box directory will be automatically created to _**\"[path to your Private Home Directory]/files\"**_ by default.\r\n\r\n> {{[frgm-embed]36 }}\r\n\r\n###### civilizer.items_per_page\r\n- The maximum number of Fragments that a single page of a single Panel can present.\r\n- The default value : 10.\r\n- Increasing this value will retrieve more Fragments at a time, but your browser will consume more memory to render and manage them.\r\n- Read {{[frgm]32 this }} for more about pagination.\r\n\r\n###### civilizer.locale\r\n- Specifies your locale parameter.\r\n- {{[clr-r] This option is yet to be supported. }}\r\n'), TIMESTAMP '2015-08-27 10:55:46.433', TIMESTAMP '2015-09-24 13:54:48.651');        

INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
(35, 'Importing/Exporting Data to/from Civilizer', STRINGDECODE('##### Exporting Data when Civilizer is online\r\n1. Click on the icon {{[html]<span class=\"fa fa-user fa-lg\"></span>}} at the top-right corner.\r\n1. Click {{[clr-br] Export Data }}.\r\n1. Type your login password and press ENTER.\r\n1. Download the file by clicking the button {{[html]<span class=\"fa fa-download fa-lg\"></span>}}\r\n\r\n##### Importing Data when Civilizer is online\r\n> {{[clr-r] [NOTE] This functionality is not currently supported on Windows due to some technical limitation. }}    \r\n> Use Offline data import as described below.\r\n\r\n1. Click on the icon {{[html]<span class=\"fa fa-user fa-lg\"></span>}} at the top-right corner.\r\n1. Click {{[clr-br] Import Data }}.\r\n1. Type your login password and press ENTER.\r\n1. Upload the file you''d like to import.\r\n - _**The file to import should be what Civilizer would''ve exported earlier.**_\r\n - {{[clr-r] [CAUTION!!!] Unless you make a backup of it, your current data will completely disappear at the time of clicking OK button on the file upload dialog of your browser.}}\r\n    - If you have no copy of the current data at all, it would be recommended that you export it somewhere before uploading any file. \r\n1. Click the button saying \"Refresh Page\" to refresh the application.\r\n\r\n##### Offline Data Export/Import\r\nThe above explanations describe how you can import/export your data when Civilizer is running ( online ).  \r\nAlternatively, you can import/export data while Civilizer is {{[clr-br] NOT }} running ( offline ).  \r\nYou will find the following script files at the root of your Civilizer installation package.  By executing those script files from the command line, you can import/export data.\r\n\r\n- _export-data.bat, import-data.bat_\r\n - Batch script files for Windows users\r\n- _export-data.sh, import-data.sh_\r\n - Shell script files for Other OS users\r\n\r\n{{{[fold{\"title\":\"How to use:\",\"hide\":\"true\"}]\r\n- Use -h option to see the help message.\r\n - e.g)  export-data.sh -h\r\n- Exporting data:\r\n - Run export-data.sh or export-data.bat (on Windows) without an option.\r\n   - This will export your current data to the predefined location.\r\n - Alternatively, run **export-data.sh -to path/to/location** or **export-data.bat -to c:\\path\\to\\location** (on Windows) to specify where to export the data.\r\n- Importing data:\r\n - Run import-data.sh or import-data.bat (on Windows) without an option.\r\n   - This will import data from the predefined location.\r\n - Alternatively, run **import-data.sh -from path/to/location** or **import-data.bat -from c:\\path\\to\\location** (on Windows) to specify where to import the data from.\r\n}}}\r\n\r\n'), TIMESTAMP '2015-08-27 12:00:01.021', TIMESTAMP '2015-09-24 13:57:22.998'),
(36, 'Unit of data Civilizer manages', STRINGDECODE('Basically, the data Civilizer manages are the following:\r\n- the database file denoted by _**civilizer.db_file_prefix**_ option \r\n- File Box directory denoted by _**civilizer.file_box_home**_ option.\r\n\r\n_**The two entities together are one single unit of your data.**_  \r\n_**Thus, when making a backup of your data, you need to backup the pair together.**_\r\n\r\nNote that Civilizer provides native functionalities for {{[frgm]35 exporting/importing data }} as a means of backup or restore support.'), TIMESTAMP '2015-09-01 16:58:12.365', TIMESTAMP '2015-09-22 09:13:04.606');       

INSERT INTO PUBLIC.TAG(TAG_ID, TAG_NAME) VALUES
(1, 'markdown'),
