 
 INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
 (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'),
-(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');         
-
-INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
-(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] Types of Search }}\r\nWhen the Search Dialog appears, you will find multiple 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  - 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.\r\n- _**Search History**_\r\n - Since version 0.9.0.RC2\r\n - You can search with search phrases with which you searched previously at least once.\r\n - You can edit and remove the specific entity of the history.\r\n - To kick the search, you need to click one of the icons on the left ( {{[html] <i class=\"fa fa-search fa-lg\"></i>}}) or press ENTER while one of the input boxes has focus.\r\n   - {{[clr-v] Clicking the submit button at the bottom won''t work when using Search History tab }}.'), TIMESTAMP '2015-07-17 14:30:30.754', TIMESTAMP '2015-10-15 10:04:51.105'),
-(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-g] Unlike other category operators, tag: and anytag: can accept comma-separated list. }}\r\n     - so the above query is equivalent to {{[clr-br] tag:xml, html }}.\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> **[ About Colon (:) ]**  \r\n> {{[clr-v] Note that a colon (:) has a significant meaning for Civilizer Search Operators; }}  \r\n> If your search phrase happens to have a colon **literally**, wrap it with double quotation marks (\") such as {{[clr-br] \"some-keyword:\" }}.  \r\n>&nbsp;  \r\n> **[ Search considering Tag Hierarchy ]**  \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 Fragments that satisfy the following conditions at the same time:   \r\n1. Fragments whose content or title contains one or more words of {{[clr-br] big data }}:\r\n - Case MATTERS because of the {{[clr-v] c }} Flag Operator\r\n - The search will match a word {{[clr-br] big data}} ( ''big'' and space and ''data'' altogether ) because of the {{[clr-v] double quotation marks }}  \r\n    - Read {{[frgm] 23 Basic Operations for Search Dialog }} about how double quotes work.\r\n1. Fragments whose Tags contain a word {{[clr-br] databases }}.'), TIMESTAMP '2015-07-17 15:33:38.34', TIMESTAMP '2015-09-29 08:06:56.973');          
+(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.\r\n\r\n###### File Info (Since 0.9.0.RC4)\r\n1. Right click on the file/folder you''d like to check out.\r\n1. This will bring up the information window for the file/folder.\r\n  - You have a path to the file/folder at the top.\r\n      - If the target is a file, the path is clickable.\r\n      - So you can download or view the file based on your browser''s setting on the file type. \r\n  - You''ll see \"{{[usb] Get Fragments Containing This File }}\" link in the middle.\r\n      - By clicking the link, all Fragments linked with that file will be fetched up.\r\n  - If the file is a image format that Civilizer recognizes, then the window will display the image.\r\n\r\n###### Limitations of File Box\r\n1. You can''t update any of existing files in File Box through Civilizer UI interface.\r\n  - When you try to upload a file to the location where a file with the same name already has been placed, an error will occur.\r\n  - You can do either of the following workarounds:\r\n      - Delete or move the existing file first, then upload the new file.\r\n      - Highly likely, you may have access to the underling file system if you run Civilizer on your desktop. So you can replace the target file via the native file system.\r\n          - To figure out the File Box location on your file system, refer to {{[frgm]34 civilizer.file_box_home }} option in your _app-options.properties_ file '), TIMESTAMP '2015-07-15 17:43:44.624', TIMESTAMP '2016-01-13 15:49:00.191');        
+
+INSERT INTO PUBLIC.FRAGMENT(FRAGMENT_ID, TITLE, CONTENT, CREATION_DATETIME, UPDATE_DATETIME) VALUES
+(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] Types of Search }}\r\nWhen the Search Dialog appears, you will find multiple 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  - 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.\r\n- _**Search History**_\r\n - Since version 0.9.0.RC2\r\n - You can search with search phrases with which you searched previously at least once.\r\n - You can edit and remove the specific entity of the history.\r\n - To kick the search, you need to click one of the icons on the left ( {{[html] <i class=\"fa fa-search fa-lg\"></i>}}) or press ENTER while one of the input boxes has focus.\r\n   - {{[clr-v] Clicking the submit button at the bottom won''t work when using Search History tab }}.'), TIMESTAMP '2015-07-17 14:30:30.754', TIMESTAMP '2015-10-15 10:04:51.105');          
+
+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-g] Unlike other category operators, tag: and anytag: can accept comma-separated list. }}\r\n     - so the above query is equivalent to {{[clr-br] tag:xml, html }}.\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> **[ About Colon (:) ]**  \r\n> {{[clr-v] Note that a colon (:) has a significant meaning for Civilizer Search Operators; }}  \r\n> If your search phrase happens to have a colon **literally**, wrap it with double quotation marks (\") such as {{[clr-br] \"some-keyword:\" }}.  \r\n>&nbsp;  \r\n> **[ Search considering Tag Hierarchy ]**  \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 Fragments that satisfy the following conditions at the same time:   \r\n1. Fragments whose content or title contains one or more words of {{[clr-br] big data }}:\r\n - Case MATTERS because of the {{[clr-v] c }} Flag Operator\r\n - The search will match a word {{[clr-br] big data}} ( ''big'' and space and ''data'' altogether ) because of the {{[clr-v] double quotation marks }}  \r\n    - Read {{[frgm] 23 Basic Operations for Search Dialog }} about how double quotes work.\r\n1. Fragments whose Tags contain a word {{[clr-br] databases }}.'), TIMESTAMP '2015-07-17 15:33:38.34', TIMESTAMP '2015-09-29 08:06:56.973');    
 
 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'),

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


(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 '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
