-- phpMyAdmin SQL Dump
-- version 4.1.4
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 26, 2016 at 05:30 PM
-- Server version: 5.6.15-log
-- PHP Version: 5.3.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `connect10`
--

--
-- Dumping data for table `cms_groups`
--

INSERT INTO `cms_groups` (`id`, `group_name`, `position`, `published`, `user_privilege`) VALUES
(1, 'General', 1, 1, 'all'),
(2, 'Configurations', 5, 1, 'all'),
(3, 'Setups', 2, 1, 'all'),
(4, 'Contents', 3, 1, 'all'),
(5, 'Admin Setup', 4, 1, 'all');

--
-- Dumping data for table `cms_privileges`
--

INSERT INTO `cms_privileges` (`privilege_id`, `entity_type`, `entity_id`, `view_role_id`, `add_role_id`, `edit_role_id`, `delete_role_id`, `publish_role_id`) VALUES
(1, 'group', 5, 0, 0, 0, 0, 0),
(2, 'group', 2, 0, 0, 0, 0, 0),
(6, 'section', 57, 0, 0, 0, 0, 0);

--
-- Dumping data for table `cms_roles`
--

INSERT INTO `cms_roles` (`role_id`, `role_name`, `parent_role_id`) VALUES
(1, 'admin', 0),
(9, 'Sub Admin', 1),
(10, 'Moderator ', 1);

--
-- Dumping data for table `cms_sections`
--

INSERT INTO `cms_sections` (`id`, `group_id`, `section_name`, `section_alias`, `table_name`, `section_config`, `visibilty`, `display_order`, `user_privilege`, `module`, `db_type`, `smb_id`) VALUES
	(1, 2, 'Manage Groups', 'groups', 'cms_groups', '{\r\n"keyColumn":"id",\r\n"orderBy":{"id":"ASC"},\r\n"publishColumn":"published",\r\n"listColumns":["id","group_name","user_privilege"],\r\n"showColumns":["id","group_name","position","user_privilege"],\r\n"detailColumns":["id","group_name","position","user_privilege"],\r\n"detailHeaderColumns":["group_name"],\r\n"columns":{\r\n    "id":{"name":"ID","sortable":"true","searchable":"searchable","editoptions":{"type":"hidden"}},\r\n    "group_name":{"name":"Group Name","sortable":"true","searchable":"searchable","editoptions":{"type":"textbox","label":"Group Name","class":"textbox"}},\r\n    "position":{"name":"Display Order","sortable":"true","editoptions":{"type":"textbox","label":"Display Order","class":"textbox"}},\r\n    "user_privilege":{"name":"Privilege","sortable":"true","searchable":"searchable","editoptions":{"type":"select","source":{"all":"All","s":"Superadmin"},"source_type":"array","label":"Privilege","class":"select","enumvalues":{"all":"All","s":"Superadmin"}}}\r\n    },\r\n"opertations":["add","edit","delete","view","publish"]\r\n}', '1', 2, '', 'admin', 'main', NULL),
	(2, 2, 'Manage Sections', 'sections', 'cms_sections', '{\r\n"keyColumn":"id",\r\n"orderBy":{"id":"ASC"},\r\n"listColumns":["group_id","section_name","section_alias","visibilty","display_order"],\r\n"showColumns":["id","group_id","section_name","section_alias","table_name","section_config","visibilty","display_order"],\r\n"detailColumns":["id","group_id","section_name","section_alias","table_name","section_config","visibilty","display_order"],\r\n"detailHeaderColumns":["section_name"],\r\n"columns":{\r\n    "id":{"name":"ID","sortable":"true","editoptions":{"type":"hidden"}},\r\n    "group_id":{"name":"Group ID","sortable":"true","searchable":"searchable","editoptions":{"validations":["required"],"type":"select","source":"Cms::getAllGroups","source_type":"function","label":"Group Name","class":"select"},"external":"true","externalOptions":{"externalTable":"cms_groups","externalColumn":"id","externalShowColumn":"group_name"}},\r\n    "section_name":{"name":"Section Name","sortable":"true","searchable":"searchable","editoptions":{"validations":["required"],"type":"textbox","label":"Section Name","class":"textbox"}},\r\n    "section_alias":{"name":"Section Alias","sortable":"true","searchable":"searchable","editoptions":{"validations":["required"],"type":"textbox","label":"Section Alias","class":"textbox"}},\r\n    "table_name":{"name":"Table Name","editoptions":{"validations":["required"],"type":"textbox","label":"Table Name","class":"textbox"}},\r\n    "section_config":{"name":"Section Config","editoptions":{"validations":["required"],"type":"textarea","label":"Section Config","class":"textarea"}},\r\n    "visibilty":{"name":"Make Visible","sortable":"true","searchable":"searchable","editoptions":{"type":"checkbox","label":"Make Visible","class":"inline","default":"yes","enumvalues":{"1":"Visible","0":"Invisible"}}},\r\n    "display_order":{"name":"Display Order","sortable":"true","searchable":"searchable","editoptions":{"type":"textbox","label":"Display Order","class":"textbox"}}\r\n    },\r\n"opertations":["add","edit","delete","view","publish"]\r\n}', '1', 3, '', 'admin', 'main', NULL),
	(3, 2, 'Manage Settings', 'manage_settings', 'tbl_cms_settings', '{\r\n"keyColumn":"id",\r\n"listColumns":["cms_set_name","cms_set_value"],\r\n"showColumns":["cms_set_name","cms_set_value"],\r\n"detailColumns":["id","cms_set_name","cms_set_value"],\r\n"detailHeaderColumns":["cms_set_name"],\r\n"columns":{\r\n    "id":{"name":"ID","sortable":"true","editoptions":{"type":"hidden"}},\r\n    "cms_set_name":{"name":"Name","sortable":"true","searchable":"searchable","editoptions":{"type":"disabled","label":"Name"}},\r\n    "cms_set_value":{"name":"Value","sortable":"true","searchable":"searchable","editoptions":{"width":"400px","type":"textbox","label":"Value","class":"textbox"}}\r\n},\r\n"opertations":["edit","view"]\r\n}', '1', 1, '', 'admin', 'main', NULL),
	(56, 1, 'Users', 'users', 'tbl_users', '{\r\n	"keyColumn": "user_id",\r\n	"wildsearch": "true",\r\n	"includeJsFiles": [\r\n		"cms_select_state_user.js"\r\n	],\r\n	"detailHeaderColumnPrefix": "Users: ",\r\n	"detailHeaderColumns": [\r\n		"user_email"\r\n	],\r\n	"where": "user_status!=\'D\' ",\r\n	"breadCrumbColumn": "user_firstname,user_lastname",\r\n	"handleFile": "true",\r\n	"orderBy": {\r\n		"user_id": "DESC"\r\n	},\r\n	"listColumns": [\r\n		"user_image_id",\r\n		"user_firstname",\r\n		"user_lastname",\r\n		"user_email",\r\n		"user_status",\r\n		"Login"\r\n	],\r\n	"showColumns": [\r\n		"user_id",\r\n		"user_image_id",\r\n		"user_firstname",\r\n		"user_lastname",\r\n		"user_email",\r\n		"user_password",\r\n		"user_gender",\r\n		"user_date_of_birth",\r\n		"user_address",\r\n		"user_city",\r\n		"user_state",\r\n		"user_country",\r\n		"user_phone",\r\n		"user_zipcode",\r\n		"user_created_on",\r\n		"user_last_login"\r\n	],\r\n	"detailColumns": [\r\n		"user_id",\r\n		"user_image_id",\r\n		"user_firstname",\r\n		"user_lastname",\r\n		"user_email",\r\n		"user_password",\r\n		"user_gender",\r\n		"user_date_of_birth",\r\n		"user_address",\r\n		"user_city",\r\n		"user_state",\r\n		"user_country",\r\n		"user_phone",\r\n		"user_zipcode",\r\n		"user_created_on",\r\n		"user_last_login",\r\n		"user_status",\r\n		"Login"\r\n	],\r\n	"columns": {\r\n		"user_id": {\r\n			"name": "ID",\r\n			"editoptions": {\r\n				"type": "hidden"\r\n			}\r\n		},\r\n		"user_image_id": {\r\n			"name": "Profile Picture",\r\n			"editoptions": {\r\n				"type": "file",\r\n				"label": "Profile Picture",\r\n				"class": "file",\r\n				"hint": "Ideal size 300 x 300. Allowed file types are jpg,jpeg,gif and png.",\r\n				"file_types": "gif,png,jpg,jpeg",\r\n				"validations": [\r\n					"file_type"\r\n				]\r\n\r\n			},\r\n			"external": "true",\r\n			"externalOptions": {\r\n				"externalTable": "tbl_files",\r\n				"externalColumn": "file_id",\r\n				"externalShowColumn": "file_id"\r\n			}\r\n		},\r\n		"user_firstname": {\r\n			"name": "First Name",\r\n			"searchable": "true",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "First Name",\r\n				"class": "textbox",\r\n				"validations": [\r\n					"required"\r\n				]\r\n			}\r\n		},\r\n		"user_lastname": {\r\n			"name": "Last Name",\r\n			"searchable": "true",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "Last Name",\r\n				"class": "textbox",\r\n				"validations": [\r\n					"required"\r\n				]\r\n			}\r\n		},\r\n		"user_email": {\r\n			"name": "Email",\r\n			"sortable": "true",\r\n			"searchable": "true",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "Email",\r\n				"class": "textbox",\r\n				"validations": [\r\n					"required",\r\n					"email"\r\n				]\r\n			}\r\n		},\r\n		"user_password": {\r\n			"name": "Password",\r\n			"editoptions": {\r\n				"type": "password",\r\n				"label": "Password",\r\n				"class": "textbox",\r\n				"validations": [\r\n					"required"\r\n				]\r\n			}\r\n		},\r\n		"user_gender": {\r\n			"name": "Gender",\r\n			"editoptions": {\r\n				"type": "radio",\r\n				"options": {\r\n					"M": "Male",\r\n					"F": "Female"\r\n				},\r\n				"label": "Gender",\r\n				"class": "radio",\r\n				"enumvalues": {\r\n					"M": "Male",\r\n					"F": "Female"\r\n				}\r\n			}\r\n		},\r\n		"user_date_of_birth": {\r\n			"name": "Date of Birth",\r\n			"dbFormat": "date",\r\n			"displayFormat": "m/d/Y",\r\n			"editoptions": {\r\n				"type": "datepicker",\r\n				"label": "Date of Birth"\r\n			}\r\n		},\r\n		"user_address": {\r\n			"name": "Address",\r\n			"editoptions": {\r\n				"type": "textarea",\r\n				"label": "Address",\r\n				"class": "textarea"\r\n			}\r\n		},\r\n		"user_city": {\r\n			"name": "City",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "City",\r\n				"class": "textbox"\r\n			}\r\n		},\r\n		"user_zipcode": {\r\n			"name": "Zip",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "Zip",\r\n				"class": "textbox"\r\n			}\r\n		},\r\n		"user_state": {\r\n			"name": "State",\r\n			"editoptions": {\r\n				"type": "select",\r\n				"source": "Cmshelper::getAllStates",\r\n				"source_type": "function",\r\n				"label": "State",\r\n				"class": "select"\r\n			},\r\n			"external": "true",\r\n			"externalOptions": {\r\n				"externalTable": "tbl_state",\r\n				"externalColumn": "ts_code",\r\n				"externalShowColumn": "ts_name"\r\n			}\r\n		},\r\n		"user_country": {\r\n			"name": "Country",\r\n			"editoptions": {\r\n				"type": "select",\r\n				"source": "Cmshelper::getAllCountries",\r\n				"source_type": "function",\r\n				"label": "Country",\r\n				"class": "select"\r\n			},\r\n			"external": "true",\r\n			"externalOptions": {\r\n				"externalTable": "tbl_country",\r\n				"externalColumn": "tc_code",\r\n				"externalShowColumn": "tc_name"\r\n			}\r\n		},\r\n		"user_phone": {\r\n			"name": "Telephone",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "Telephone",\r\n				"class": "textbox"\r\n			}\r\n		},\r\n		"user_status": {\r\n			"name": "Status",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n\r\n			"listoptions": {\r\n				"type": "button",\r\n				"customaction": "Cmshelper::changeUserStatus",\r\n				"enumvalues": {\r\n					"A": "Active",\r\n					"I": "Inactive"\r\n				},\r\n				"buttonColors": {\r\n					"A": "green",\r\n					"I": "red"\r\n				}\r\n			}\r\n		},\r\n		"user_created_on": {\r\n			"name": "Joined On",\r\n			"sortable": "true",\r\n			"dbFormat": "timestamp",\r\n			"displayFormat": "m/d/Y"\r\n		},\r\n		"user_last_login": {\r\n			"name": "Last Logged In On",\r\n			"dbFormat": "timestamp",\r\n			"displayFormat": "m/d/Y"\r\n		},\r\n		"user_points": {\r\n			"name": "User Points",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "User Points",\r\n				"class": "textbox"\r\n			}\r\n		},\r\n		"Login": {\r\n			"name": "Login",\r\n			"customColumn": "true",\r\n			"customaction": "Cmshelper::getUserLoginUrl"\r\n		}\r\n	},\r\n	"relations": {\r\n		"Friends List": {\r\n			"name": "Friends List",\r\n			"section": "friends_list",\r\n			"child_table": "tbl_friends_list",\r\n			"parent_join_column": "user_id",\r\n			"child_join_column": "friends_list_user_id",\r\n			"where": "child.friends_list_status!=\'D\' "\r\n		},\r\n		"Community": {\r\n			"name": "Group List",\r\n			"section": "user_community",\r\n			"child_table": "tbl_community_member",\r\n			"parent_join_column": "user_id",\r\n			"child_join_column": "cmember_id",\r\n			"where": "child.cmember_status!=\'D\' "\r\n		}\r\n	},\r\n	"customActions": {\r\n		"afterAddRecord": "User::updateUserRegisterTime",\r\n		"beforeAddRecord": "Cmshelper::userUpdate",\r\n		"beforeEditRecord": "Cmshelper::userUpdate",\r\n		"afterEditRecord": "User::updateUserFile"\r\n	},\r\n	"opertations": [\r\n		"add",\r\n		"view",\r\n		"edit",\r\n		"customdelete"\r\n	],\r\n	"customDeleteOperation": "Cmshelper::deleteUser"\r\n}', '1', 2, 'all', 'admin', 'main', NULL),
	(57, 4, 'Meta Tags', 'meta_tags', 'fw_metadata', '{\r\n "keyColumn": "id",\r\n "detailHeaderColumnPrefix": "Meta Tag : ",\r\n    "detailHeaderColumns": [\r\n        "url"\r\n    ],\r\n    "orderBy": {\r\n        "id": "ASC"\r\n    },\r\n    "listColumns": [\r\n        "url",\r\n        "title",\r\n        "keyword"\r\n    ],\r\n    "showColumns": [\r\n        "id",\r\n        "url",\r\n        "title",\r\n        "keyword",\r\n        "description"\r\n    ],\r\n    "detailColumns": [\r\n        "id",\r\n        "url",\r\n        "title",\r\n        "keyword",\r\n        "description"\r\n    ],\r\n    "columns": {\r\n        "id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "title": {\r\n            "name": "Meta Title",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Meta Title",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "keyword": {\r\n            "name": "Meta Keywords",\r\n            "editoptions": {\r\n                "type": "textarea",\r\n                "label": "Meta Keywords",\r\n                "class": "textarea"\r\n            }\r\n        },\r\n        "description": {\r\n            "name": "Meta Description",\r\n            "editoptions": {\r\n                "type": "textarea",\r\n                "label": "Meta Description",\r\n                "class": "textarea"\r\n            }\r\n        },\r\n        "url": {\r\n            "name": "Page Url",\r\n            "sortable": "true",\r\n            "searchable": "searchable",\r\n            "editoptions": {\r\n                "label": "Page Url",\r\n                "type": "textbox",\r\n                "class": "textbox",\r\n                "hint":"<b>Url combinations can be : </b><br/><b style=\'color:red\'> /abc/</b> [exact location abc after your domain name] eg : www.domainname.com/abc/ ,<br/> <b style=\'color:red\'>/abc/* </b> [any combination after location abc after your domain name] eg : www.domainname.com/abc/test1,<br/> <b style=\'color:red\'>* </b>[default value] ",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "delete"\r\n    ]\r\n}', '1', 2, 'all', 'admin', 'main', NULL),
	(58, 4, 'Static Content', 'static_content', 'tbl_content', '{\r\n	"keyColumn": "content_id",\r\n	"detailHeaderColumns": [\r\n		"content_title"\r\n	],\r\n	"orderBy": {\r\n		"content_id": "ASC"\r\n	},\r\n	"listColumns": [\r\n		"content_title",\r\n		"content_description"\r\n	],\r\n	"showColumns": [\r\n		"content_id",\r\n		"content_title",\r\n		"content_description"\r\n	],\r\n	"detailColumns": [\r\n		"content_id",\r\n		"content_title",\r\n		"content_description"\r\n	],\r\n	"columns": {\r\n		"content_id": {\r\n			"name": "ID",\r\n			"sortable": "true",\r\n			"editoptions": {\r\n				"type": "hidden"\r\n			}\r\n		},\r\n		"content_title": {\r\n			"name": "Title",\r\n			"sortable": "true",\r\n			"searchable": "searchable",\r\n			"editoptions": {\r\n				"validations": [\r\n					"required"\r\n				],\r\n				"type": "textbox",\r\n				"label": "Title",\r\n				"class": "textbox"\r\n			}\r\n		},\r\n		"content_description": {\r\n			"name": "Content",\r\n			"editoptions": {\r\n				"validations": [\r\n					"required"\r\n				],\r\n				"type": "textarea",\r\n                "label": "Content",\r\n                "class": "textarea",\r\n                "editorType": "ckeditor"\r\n				\r\n			}\r\n		}\r\n	},\r\n	"opertations": [\r\n		"edit",\r\n		"view", "add"\r\n	]\r\n}', '1', 1, 'all', 'admin', 'main', NULL),
	(59, 4, 'Help Content', 'help_content', 'tbl_Help', '{\r\n    "keyColumn": "help_id",\r\n"detailHeaderColumns":[ "help_id"],\r\n    "orderBy": {\r\n        "help_id": "ASC"\r\n    },\r\n    "listColumns": [\r\n     \r\n        "help_category_id",\r\n        "help_title",\r\n        "help_description",\r\n        "help_position",\r\n        "help_active"\r\n    ],\r\n    "showColumns": [\r\n         "help_id",\r\n        "help_category_id",\r\n        "help_title",\r\n        "help_description",\r\n        "help_position",\r\n        "help_active"\r\n    ],\r\n    "detailColumns": [\r\n        "help_id",\r\n        "help_category_id",\r\n        "help_title",\r\n        "help_description",\r\n        "help_position",\r\n        "help_active"\r\n    ],\r\n    "columns": {\r\n        "help_id": {\r\n            "name": "ID",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n                \r\n            }\r\n        },"help_category_id": {\r\n           "name": "Category",\r\n           "sortable": "true",\r\n           "searchable": "true",\r\n           "editoptions": {\r\n               "validations": [\r\n                   "required"\r\n               ],\r\n                "type": "select",\r\n                "source": "Cmshelper::getAllHelpCategories",\r\n                "source_type": "function",\r\n                "label": "Category",\r\n                "class": "select"\r\n           },\r\n           "external": "true",\r\n           "externalOptions": {\r\n               "externalTable": "tbl_HelpCategory",\r\n               "externalColumn": "help_category_id",\r\n               "externalShowColumn": "help_category_title"\r\n           }\r\n       },\r\n        "help_title": {\r\n            "name": "Title",\r\n            "sortable": "true",\r\n            "searchable": "searchable",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                \r\n                \r\n                "label": "Title",\r\n                "class": "textbox",\r\n                \r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "help_description": {\r\n            "name": "Description",\r\n            "editoptions": {\r\n                "type": "htmlEditor",\r\n                "label": "Description",\r\n                "class": "textarea",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "help_position": {\r\n            "name": "Sort Order",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Sort Order",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "help_active": {\r\n            "name": "Status",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "1": "Active",\r\n                    "0": "Deactive"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "1": "Active",\r\n                    "0": "Deactive"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "delete"\r\n    ]\r\n}', '0', 3, 'all', 'admin', 'main', NULL),
	(60, 4, 'Help Category', 'help_category', 'tbl_HelpCategory', '{\r\n    "keyColumn": "help_category_id",\r\n"detailHeaderColumns":["help_category_id"],\r\n    "orderBy": {\r\n        "help_category_id": "ASC"\r\n    },\r\n    "listColumns": [\r\n        \r\n        "help_category_type",\r\n        "help_category_title",\r\n        "help_category_position",\r\n        "help_category_active"\r\n    ],\r\n    "showColumns": [\r\n        "help_category_id",\r\n        "help_category_type",\r\n        "help_category_title",\r\n        "help_category_position",\r\n        "help_category_active"\r\n    ],\r\n    "detailColumns": [\r\n        "help_category_id",\r\n        "help_category_type",\r\n        "help_category_title",\r\n        "help_category_position",\r\n        "help_category_active"\r\n    ],\r\n    "columns": {\r\n        "help_category_id": {\r\n            "name": "ID",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n               \r\n            }\r\n        },\r\n        "help_category_type": {\r\n            "name": "User Type",\r\n            "sortable": "true",\r\n            "searchable": "searchable",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "admin": "Admin",\r\n                    "user": "User"\r\n                },\r\n                "source_type": "array",\r\n                "label": "User Type",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "admin": "Admin",\r\n                    "user": "User"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "help_category_title": {\r\n            "name": "Title",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Title",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "help_category_position": {\r\n            "name": "Sort Order",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Sort Order",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "help_category_active": {\r\n            "name": "Status",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "1": "Active",\r\n                    "0": "Deactive"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "1": "Active",\r\n                    "0": "Deactive"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "delete"\r\n    ]\r\n}', '0', 4, 'all', 'admin', 'main', NULL),
	(61, 4, 'Mail Templates', 'mail_templates', 'tbl_mail_template', '{\r\n    "keyColumn": "id",\r\n    "detailHeaderColumns": [\r\n        "id"\r\n    ],\r\n    "orderBy": {\r\n        "id": "ASC"\r\n    },\r\n    "listColumns": [\r\n        "mail_template_name",\r\n        "mail_template_sub",\r\n        "mail_template_status"\r\n    ],\r\n    "showColumns": [\r\n        "id",\r\n        "mail_template_name",\r\n        "mail_template_sub",\r\n        "mail_template_body",\r\n        "mail_template_status",\r\n        "created_on"\r\n    ],\r\n    "detailColumns": [\r\n        "id",\r\n        "mail_template_name",\r\n        "mail_template_sub",\r\n        "mail_template_body",\r\n        "mail_template_status",\r\n        "created_on "\r\n    ],\r\n    "columns": {\r\n        "id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "mail_template_name": {\r\n            "name": "Name",\r\n            "sortable": "true",\r\n            "searchable": "searchable",\r\n            "editoptions": {\r\n            \r\n                "type": "textbox",\r\n                "label": "Template Name",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "mail_template_sub": {\r\n            "name": "Subject",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Subject",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "mail_template_body": {\r\n            "name": "Body",\r\n            "editoptions": {\r\n                "type": "htmlEditor",\r\n                "label": "Body",\r\n                "class": "textarea",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "mail_template_status": {\r\n            "name": "Status",\r\n            "sortable": "true",\r\n            "searchable": "searchable",\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeMailTemplateStatus",\r\n                "enumvalues": {\r\n                    "0": "Inactive",\r\n                    "1": "Active"\r\n                },\r\n                "buttonColors": {\r\n                    "0": "red",\r\n                    "1": "green"\r\n                }\r\n            }\r\n        },\r\n        "created_on": {\r\n            "name": "Created On",\r\n            "dbFormat": "date",\r\n            "displayFormat": "m/d/Y"\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view",\r\n        "edit",\r\n        "add"\r\n    ]\r\n}', '0', 1, 'all', 'admin', 'main', NULL),
	(62, 1, 'Classifieds', 'classifieds', 'tbl_classifieds', '{\r\n    "keyColumn": "classifieds_id",\r\n    "wildsearch": "true",\r\n    "detailHeaderColumnPrefix": "Classifieds: ",\r\n    "detailHeaderColumns": [\r\n        "classifieds_title"\r\n    ],\r\n    "orderBy": {\r\n        "classifieds_id": "DESC"\r\n    },\r\n    "where": "classifieds_status!=\'D\' ",\r\n    "breadCrumbColumn": "classifieds_title",\r\n    "handleFile": "true",\r\n    "listColumns": [\r\n        "classifieds_image_id",\r\n        "classifieds_title",\r\n        "classifieds_description",\r\n        "classifieds_created_by",\r\n        "classifieds_created_on",\r\n        "classifieds_status"\r\n    ],\r\n    "showColumns": [\r\n        "classifieds_image_id",\r\n        "classifieds_id",\r\n        "classifieds_title",\r\n        "classifieds_description",\r\n        "classifieds_category_id",\r\n        "classifieds_created_by",\r\n        "classifieds_created_on"\r\n    ],\r\n    "detailColumns": [\r\n        "classifieds_image_id",\r\n        "classifieds_id",\r\n        "classifieds_title",\r\n        "classifieds_description",\r\n        "classifieds_category_id",\r\n        "classifieds_created_by",\r\n        "classifieds_created_on",\r\n        "classifieds_status"\r\n    ],\r\n    "columns": {\r\n        "classifieds_id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "classifieds_title": {\r\n            "name": "Title",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Title",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "classifieds_description": {\r\n            "name": "Description",\r\n            "editoptions": {\r\n                "type": "htmlEditor",\r\n                "label": "Description",\r\n                "class": "textarea",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "classifieds_image_id": {\r\n            "name": "Image",\r\n            "editoptions": {\r\n                "type": "file",\r\n                "label": "Image",\r\n                "class": "file",\r\n                "hint": "Ideal size 300 x 300. Allowed file types are jpg,jpeg,gif and png.",\r\n                "file_types": "gif,png,jpg,jpeg",\r\n                "validations": [\r\n                    "file_type"\r\n                ]\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_files",\r\n                "externalColumn": "file_id",\r\n                "externalShowColumn": "file_id"\r\n            }\r\n        },\r\n        "classifieds_category_id": {\r\n            "name": "Category Name",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": "Cmshelper::getAllCategoryName",\r\n                "source_type": "function",\r\n                "label": "Category Name",\r\n                "defaulttext": "Nil",\r\n                "class": "select",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_categories",\r\n                "externalColumn": "category_id",\r\n                "externalShowColumn": "category_name"\r\n            }\r\n        },\r\n        "classifieds_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeClassifiedsStatus",\r\n                "enumvalues": {\r\n                    "A": "Approved",\r\n                    "I": "Not Approved"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        },\r\n        "classifieds_created_on": {\r\n            "name": "Posted On",\r\n            "sortable": "true",\r\n            "dbFormat": "date",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n        "classifieds_created_by": {\r\n            "name": "Posted By",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getClassifiedsCreatorName"\r\n        }\r\n    },\r\n    "relations": {\r\n        "Comments": {\r\n            "name": "Comments Posted",\r\n            "section": "classifieds_comments",\r\n            "child_table": "tbl_comments",\r\n            "parent_join_column": "classifieds_id",\r\n            "child_join_column": "comment_entity_id",\r\n            "where": "child.comment_entity_type=\'CF\' AND child.comment_status!=\'D\' "\r\n        }\r\n    },\r\n    "customActions": {\r\n        "afterAddRecord": "Classifieds::updateClassifiedsRegisterTime",\r\n        "afterEditRecord": "Classifieds::updateClassifiedsFile"\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "customdelete"\r\n    ],\r\n    "customDeleteOperation": "Cmshelper::deleteClassifieds"\r\n}', '0', 4, 'all', 'admin', 'main', NULL),
	(63, 3, 'Industries', 'industry', 'tbl_industry', '{\r\n    "keyColumn": "industry_id",\r\n    "wildsearch": "true",\r\n    "detailHeaderColumnPrefix": "Indusrties: ",\r\n    "detailHeaderColumns": [\r\n        "industry_name"\r\n    ],\r\n    "orderBy": {\r\n        "industry_parent_id": "ASC"\r\n    },\r\n    "listColumns": [\r\n        "industry_name",\r\n        "industry_parent_id",\r\n        "industry_status"\r\n    ],\r\n    "showColumns": [\r\n        "industry_name",\r\n        "industry_parent_id",\r\n        "industry_status"\r\n    ],\r\n    "detailColumns": [\r\n        "industry_name",\r\n        "industry_parent_id",\r\n        "industry_status",\r\n        "industry_id"\r\n    ],\r\n    "columns": {\r\n        "industry_id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "industry_name": {\r\n            "name": "Industry Name",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Industry Name",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "industry_parent_id": {\r\n            "name": "Parent Industry",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": "Cmshelper::getAllIndustryName",\r\n                "source_type": "function",\r\n                "label": "Parent Industry",\r\n                "defaulttext": "Nil",\r\n                "class": "select"\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_industry",\r\n                "externalColumn": "industry_id",\r\n                "externalShowColumn": "industry_name"\r\n            }\r\n        },\r\n        "industry_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "default": "A",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            },\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeIndustryStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "delete"\r\n    ]\r\n}', '0', 6, 'all', 'admin', 'main', NULL),
	(64, 1, 'Friends List', 'friends_list', 'tbl_friends_list', '{\r\n    "keyColumn": "friends_list_id",\r\n    "wildsearch": "true",\r\n    "reference": {\r\n        "referenceTable": " tbl_users",\r\n        "referenceColumn": "friends_list_user_id",\r\n        "referenceTableForiegnKey": "user_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Friends list: ",\r\n    "detailHeaderColumns": [\r\n        "friends_list_friend_id"\r\n    ],\r\n    "orderBy": {\r\n        "friends_list_id": "DESC"\r\n    },\r\n    "where": "friends_list_status!=\'D\'",\r\n    "listColumns": [\r\n  "Image",   \r\n        "friends_list_friend_id",    \r\n "Name",      \r\n        "Gender",\r\n        "Country"\r\n    ],\r\n    "detailColumns": [\r\n"friends_list_id",\r\n  "Image",\r\n        "friends_list_friend_id",\r\n        "Name",      \r\n        "Gender",\r\n        "Country"\r\n\r\n    ],\r\n    "columns": {\r\n        "friends_list_id": {\r\n            "name": "ID",\r\n            "type": "hidden"\r\n        },\r\n        "friends_list_friend_id": {\r\n            "name": "Email",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_users",\r\n                "externalColumn": "user_id",\r\n                "externalShowColumn": "user_email"\r\n            }\r\n        },\r\n        "Name": {\r\n            "name": "Name",\r\n           \r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getFriendName"\r\n        },\r\n        "Image": {\r\n            "name": "Profile Picture",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getFriendImage"\r\n        },\r\n        "Gender": {\r\n            "name": "Gender",\r\n         \r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getFriendGender",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "M": "Male",\r\n                    "F": "Female"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "M": "Male",\r\n                    "F": "Female"\r\n                }\r\n            }\r\n        },\r\n        "Country": {\r\n            "name": "Country",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getFriendCountry"\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view"\r\n    ]\r\n}', '0', 2, 'all', 'admin', 'main', NULL),
	(75, 3, 'Settings', 'settings', 'tbl_lookup', '{\r\n    "siteSettings": "true",\r\n    "settingStyle": "tab",\r\n    "beforeEditRecord": "Cmshelper::changeLogo",\r\n    "hints": {\r\n        "vadmin_email": "Email where all site notifications, alerts and notifications are sent",\r\n        "sitelogo": "This is where you can change the logo of your site.",\r\n        "perpage": "Number of records to be displayed in all the listing pages.",\r\n        "ADMIN_APPROVE_BUSINESS_AUTO": "Uncheck to manually approve new business",\r\n        "ADMIN_APPROVE_CLASSIFIEDS_AUTO": "Uncheck to manually approve new classifieds",\r\n        "ADMIN_APPROVE_BIZCOM_AUTO": "Check to Auto Enable Approval of new groups",\r\n        "auto_approval": "Check to Auto Enable Approval of new pages",\r\n        "ADMIN_APPROVE_USER_AUTO": "Uncheck to manually activate new users",\r\n        "group_display": "Check to display groups as a widget in the user feed",\r\n        "friend_display": "Check to display friends as a widget in the user feed",\r\n        "organization_display": "Check to display Pages as a widget in the user feed",\r\n        "galleryForUsers": "Check to display Gallery as a widget in the user feed",\r\n        "pageGroupRelation": "Check to relate the page & group"\r\n    }\r\n}', '1', 1, 'all', 'admin', 'main', NULL),
	(76, 1, 'Dashboard', 'dashboard', 'tbl_lookup', '{\r\n    "dashboardPanel2": "true",\r\n    "rows": "3",\r\n    "row2": {\r\n        "columns": "1",\r\n        "column1": {\r\n            "display": "listing",\r\n            "title": "Recent Users",\r\n            "titlelink": "View All",\r\n            "titlelinkSection": "Cmshelper::getNewUsersLink",\r\n            "fetchValue": "Cmshelper::getNewUsers",\r\n            "listcolumns": {\r\n                "username": {\r\n                    "name": "Name"\r\n                },\r\n                "email": {\r\n                    "name": "Email"\r\n                },\r\n                "joined_on": {\r\n                    "name": "Joined On"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "row3": {\r\n        "columns": "2",\r\n        "column1": {\r\n            "display": "listing",\r\n            "title": "Recent Group",\r\n            "titlelink": "View All",\r\n            "titlelinkSection": "Cmshelper::getNewCommunityLink",\r\n            "fetchValue": "Cmshelper::getNewCommunity",\r\n            "listcolumns": {\r\n                "communityname": {\r\n                    "name": "Name"\r\n                },\r\n                "created_by": {\r\n                    "name": "Owner"\r\n                },\r\n                "created_on": {\r\n                    "name": "Created On"\r\n                }\r\n            }\r\n        },\r\n        "column2": {\r\n            "display": "listing",\r\n            "title": "Recent Page",\r\n            "titlelink": "View All",\r\n            "titlelinkSection": "Cmshelper::getNewBusinessLink",\r\n            "fetchValue": "Cmshelper::getNewBusiness",\r\n            "listcolumns": {\r\n                "businessname": {\r\n                    "name": "Name"\r\n                },\r\n                "created_by": {\r\n                    "name": "Created By"\r\n                },\r\n                "industry": {\r\n                    "name": "Industry"\r\n                },\r\n                "created_on": {\r\n                    "name": "Created On"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "row1": {\r\n        "columns": "1",\r\n        "column1": {\r\n            "display": "listing",\r\n            "title": "Monthly Overview",\r\n            "fetchValue": "Cmshelper::getStatistics",\r\n            "listcolumns": {\r\n                "title": {\r\n                    "name": "Title"\r\n                },\r\n                "count": {\r\n                    "name": "Count"\r\n                }\r\n            }\r\n        }\r\n    }\r\n}', '1', 1, 'all', 'admin', 'main', NULL),
	(74, 1, 'Comments Posted', 'classifieds_comments', 'tbl_comments', '{\r\n    "keyColumn": "comment_id",\r\n"wildsearch":"true",\r\n    "reference": {\r\n        "referenceTable": " tbl_classifieds",\r\n        "referenceColumn": "comment_entity_id",\r\n        "referenceTableForiegnKey": "classifieds_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Comments Posted: ",\r\n    "detailHeaderColumns": [\r\n        "comment_id"\r\n    ],\r\n    "orderBy": {\r\n        "comment_id": "DESC"\r\n    },\r\n    "where": "comment_entity_type=\'CF\' AND comment_status!=\'D\' ",\r\n    "listColumns": [\r\n        "comment_content",\r\n"comment_created_by",\r\n        "comment_status"\r\n    ],\r\n  "showColumns": [\r\n      "comment_content",\r\n        "comment_status"\r\n    ],\r\n    "detailColumns": [\r\n"comment_id",\r\n        "comment_content",\r\n        "comment_created_on",\r\n "comment_created_by",\r\n        "comment_status"\r\n    ],\r\n    "columns": {\r\n        "comment_id": {\r\n            "name": "ID",\r\n   "editoptions": {\r\n            "type": "hidden"\r\n}\r\n        },\r\n        "comment_content": {\r\n            "name": "Comment",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n"editoptions":{\r\n"type": "textarea",\r\n"label": "Comment",\r\n"class":"textarea"\r\n}\r\n        },\r\n        "comment_created_on": {\r\n            "name": "Posted On",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "dbFormat": "date",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n  "comment_created_by": {\r\n            "name": "Posted By",       \r\n    "sortable": "true",\r\n            "searchable": "true", \r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getCommentCreatorName"\r\n        },\r\n        "comment_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Active",\r\n                    "I": "Inactive",\r\n                    "D": "Delete"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive",\r\n                    "D": "Delete"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            },\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeCommentStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view",\r\n        "edit",\r\n        "customdelete"\r\n    ],\r\n    "customDeleteOperation": "Cmshelper::deleteComment"\r\n}', '0', 0, 'all', 'admin', 'main', NULL),
	(66, 1, 'Page', 'business', 'tbl_businesses', '{\r\n    "keyColumn": "business_id",\r\n    "wildsearch": "true",\r\n    "includeJsFiles": [\r\n        "cms_select_state_business.js"\r\n    ],\r\n    "detailHeaderColumnPrefix": "Page : ",\r\n    "detailHeaderColumns": [\r\n        "business_name"\r\n    ],\r\n    "breadCrumbColumn": "business_name",\r\n    "handleFile": "true",\r\n    "orderBy": {\r\n        "business_id": "DESC"\r\n    },\r\n    "where": "business_status != \'D\' ",\r\n    "listColumns": [\r\n        "business_image_id",\r\n        "business_name",\r\n        "business_url",\r\n        "business_created_by",\r\n        "business_type",\r\n        "business_status"\r\n    ],\r\n    "showColumns": [\r\n        "business_id",\r\n        "business_name",\r\n        "business_url",\r\n        "business_email",\r\n        "business_description",\r\n        "business_type",\r\n        "business_address",\r\n        "business_city",\r\n        "business_state",\r\n        "business_country",\r\n        "business_phone",\r\n        "business_zipcode",\r\n        "business_image_id",\r\n        "business_created_on"\r\n        \r\n    ],\r\n    "detailColumns": [\r\n        "business_id",\r\n        "business_image_id",\r\n        "business_name",\r\n        "business_url",\r\n        "business_email",\r\n        "business_description",\r\n        "business_type",\r\n        "business_address",\r\n        "business_city",\r\n        "business_state",\r\n        "business_country",\r\n        "business_phone",\r\n        "business_zipcode",\r\n        "business_created_by",\r\n        "business_created_on",\r\n        "business_status"\r\n    ],\r\n    "columns": {\r\n        "business_id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "business_image_id": {\r\n            "name": "Logo",\r\n            "editoptions": {\r\n                "type": "file",\r\n                "label": "Logo",\r\n                "class": "file",\r\n                "hint": "Ideal size 300 x 300. Allowed file types are jpg,jpeg,gif and png.",\r\n"file_types":"gif,png,jpg,jpeg",\r\n"validations": [\r\n                    "file_type"\r\n                ]\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_files",\r\n                "externalColumn": "file_id",\r\n                "externalShowColumn": "file_id"\r\n            }\r\n        },\r\n        "business_name": {\r\n            "name": "Name",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Name",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "business_url": {\r\n            "name": "Site URL",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Site URL",\r\n                "class": "textbox",\r\n                "placeholder": "http://www.example.com",\r\n                "validations": [\r\n                    "required",\r\n                    "url"\r\n                ]\r\n            }\r\n        },\r\n        "business_email": {\r\n            "name": "Email",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Email",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required",\r\n                    "email"\r\n                ]\r\n            }\r\n        },\r\n        "business_description": {\r\n            "name": "Description",\r\n            "editoptions": {\r\n                "type": "textarea",\r\n                "label": "Description",\r\n                "class": "textarea",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "business_type": {\r\n            "name": "Type",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "P": "Product",\r\n                    "S": "Service"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Type",\r\n                "class": "select",\r\n                "validations": [\r\n                    "required"\r\n                ],\r\n                "enumvalues": {\r\n                    "P": "Product",\r\n                    "S": "Service"\r\n                }\r\n            }\r\n        },\r\n        "business_address": {\r\n            "name": "Address",\r\n            "editoptions": {\r\n                "type": "textarea",\r\n                "label": "Address",\r\n                "class": "textarea"\r\n            }\r\n        },\r\n        "business_city": {\r\n            "name": "City",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "City",\r\n                "class": "textbox"\r\n            }\r\n        },\r\n        "business_zipcode": {\r\n            "name": "Zip",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Zip",\r\n                "class": "textbox"\r\n            }\r\n        },\r\n        "business_state": {\r\n            "name": "State",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": "Cmshelper::getAllStates",\r\n                "source_type": "function",\r\n                "label": "State",\r\n                "class": "select"\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_state",\r\n                "externalColumn": "ts_code",\r\n                "externalShowColumn": "ts_name"\r\n            }\r\n        },\r\n        "business_country": {\r\n            "name": "Country",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": "Cmshelper::getAllCountries",\r\n                "source_type": "function",\r\n                "label": "Country",\r\n                "class": "select"\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_country",\r\n                "externalColumn": "tc_code",\r\n                "externalShowColumn": "tc_name"\r\n            }\r\n        },\r\n        "business_phone": {\r\n            "name": "Telephone",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Telephone",\r\n                "class": "textbox"\r\n            }\r\n        },\r\n        "business_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            \r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeBusinessStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        },\r\n        "business_created_by": {\r\n            "name": "Created By",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getBusinessCreatorName"\r\n        },\r\n        "business_created_on": {\r\n            "name": "Joined On",\r\n            "sortable": "true",\r\n            "dbFormat": "timestamp",\r\n            "displayFormat": "m/d/Y"\r\n        }\r\n    },\r\n     "customActions": {\r\n        "afterAddRecord": "Business::updateBusinessRegisterTime",\r\n        "afterEditRecord": "Business::updateBusinessFile"\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "customdelete"\r\n    ],\r\n    "customDeleteOperation": "Cmshelper::deleteBusiness"\r\n}', '1', 2, 'all', 'admin', 'main', NULL),
	(73, 1, 'Comments Posted', 'bizcom_comments', 'tbl_comments', '{\r\n    "keyColumn": "comment_id",\r\n"wildsearch":"true",\r\n    "reference": {\r\n        "referenceTable": " tbl_communities",\r\n        "referenceColumn": "comment_entity_id",\r\n        "referenceTableForiegnKey": "community_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Comments Posted: ",\r\n    "detailHeaderColumns": [\r\n        "comment_id"\r\n    ],\r\n    "orderBy": {\r\n        "comment_id": "DESC"\r\n    },\r\n    "where": "comment_entity_type=\'C\' AND comment_status!=\'D\' ",\r\n    "listColumns": [\r\n        "comment_content",\r\n        "comment_created_by",\r\n        "comment_status"\r\n    ],\r\n    "showColumns": [\r\n"comment_id",\r\n        "comment_content",\r\n        "comment_status"\r\n    ],\r\n    "detailColumns": [\r\n"comment_id",\r\n        "comment_content",\r\n        "comment_created_on",\r\n        "comment_created_by",\r\n        "comment_status"\r\n    ],\r\n    "columns": {\r\n        "comment_id": {\r\n    "name": "ID",     \r\n "editoptions": {   \r\n            "type": "hidden" }\r\n        },\r\n        "comment_content": {\r\n            "name": "Comment",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "editoptions": {\r\n                "type": "textarea",\r\n                "label": "Comment",\r\n                "class": "textarea"\r\n            }\r\n        },\r\n        "comment_created_on": {\r\n            "name": "Posted On",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "dbFormat": "date",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n        "comment_created_by": {\r\n            "name": "Posted By",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getCommentCreatorName"\r\n        },\r\n        "comment_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Active",\r\n                    "I": "Inactive",\r\n                    "D": "Delete"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive",\r\n                    "D": "Delete"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            },\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeCommentStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view",\r\n        "edit",\r\n        "customdelete"\r\n    ],\r\n    "customDeleteOperation": "Cmshelper::deleteComment"\r\n}', '0', 0, 'all', 'admin', 'main', NULL),
	(70, 1, 'Comments Posted', 'business_comments', 'tbl_comments', '{\r\n    "keyColumn": "comment_id",\r\n"wildsearch":"true",\r\n    "reference": {\r\n        "referenceTable": " tbl_businesses",\r\n        "referenceColumn": "comment_entity_id",\r\n        "referenceTableForiegnKey": "business_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Comments Posted: ",\r\n    "detailHeaderColumns": [\r\n        "comment_id"\r\n    ],\r\n    "orderBy": {\r\n        "comment_id": "DESC"\r\n    },\r\n    "where": "comment_entity_type=\'B\' AND comment_status!=\'D\' ",\r\n    "listColumns": [\r\n        "comment_content",\r\n"comment_created_by",\r\n        "comment_status"\r\n    ],\r\n  "showColumns": [\r\n      "comment_content",\r\n        "comment_status"\r\n    ],\r\n    "detailColumns": [\r\n"comment_id",\r\n        "comment_content",\r\n        "comment_created_on",\r\n "comment_created_by",\r\n        "comment_status"\r\n    ],\r\n    "columns": {\r\n        "comment_id": {\r\n            "name": "ID",\r\n"editoptions":{\r\n            "type": "hidden"\r\n}\r\n        },\r\n        "comment_content": {\r\n            "name": "Comment",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n"editoptions":{\r\n"type": "textarea",\r\n"label": "Comment",\r\n"class":"textarea"\r\n}\r\n        },\r\n        "comment_created_on": {\r\n            "name": "Posted On",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "dbFormat": "date",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n  "comment_created_by": {\r\n            "name": "Posted By",        \r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getCommentCreatorName"\r\n        },\r\n        "comment_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Active",\r\n                    "I": "Inactive",\r\n                    "D": "Delete"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive",\r\n                    "D": "Delete"\r\n                },\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            },\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeCommentStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view",\r\n        "edit",\r\n        "customdelete"\r\n    ],\r\n    "customDeleteOperation": "Cmshelper::deleteComment"\r\n}', '0', 0, 'all', 'admin', 'main', NULL),
	(71, 1, 'Members List', 'bizcom_member', 'tbl_community_member', '{\r\n    "keyColumn": "cmember_list_id",\r\n    "wildsearch": "true",\r\n    "reference": {\r\n        "referenceTable": " tbl_communities",\r\n        "referenceColumn": "cmember_community_id",\r\n        "referenceTableForiegnKey": "community_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Members list: ",\r\n    "detailHeaderColumns": [\r\n        "cmember_id"\r\n    ],\r\n    "orderBy": {\r\n        "cmember_list_id": "DESC"\r\n    },\r\n    "where": "cmember_status!=\'D\'",\r\n    "listColumns": [\r\n        "Image",\r\n        "cmember_id",\r\n        "Name",\r\n        "cmember_joined_on",\r\n        "cmember_type"\r\n    ],\r\n    "detailColumns": [\r\n        "cmember_list_id",\r\n        "Image",\r\n        "cmember_id",\r\n        "Name",\r\n        "cmember_joined_on",\r\n        "cmember_type"\r\n    ],\r\n    "columns": {\r\n        "cmember_list_id": {\r\n            "name": "ID",\r\n            "type": "hidden"\r\n        },\r\n        "cmember_id": {\r\n            "name": "Email",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_users",\r\n                "externalColumn": "user_id",\r\n                "externalShowColumn": "user_email"\r\n            }\r\n        },\r\n        "Name": {\r\n            "name": "Name",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getMemberName"\r\n        },\r\n        "Image": {\r\n            "name": "Profile Picture",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getCommunityMemberImage"\r\n        },\r\n        "cmember_joined_on": {\r\n            "name": "Joined On",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "dbFormat": "timestamp",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n        "cmember_type": {\r\n            "name": "Member Type",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Owner",\r\n                    "U": "Member"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Member Type",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "A": "Owner",\r\n                    "U": "Member"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "relations": {\r\n        "business1": {\r\n            "name": "Business",\r\n            "section": "business",\r\n            "child_table": "tbl_businesses",\r\n            "parent_join_column": "cmember_id",\r\n            "child_join_column": "business_created_by"\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view"\r\n    ]\r\n}', '0', 0, 'all', 'admin', 'main', NULL),
	(72, 1, 'Group', 'bizcom', 'tbl_communities', '{\r\n	"keyColumn": "community_id",\r\n	"wildsearch": "true",\r\n	"detailHeaderColumnPrefix": "Group: ",\r\n	"detailHeaderColumns": [\r\n		"community_name"\r\n	],\r\n	"breadCrumbColumn": "community_name",\r\n	"handleFile": "true",\r\n	"orderBy": {\r\n		"community_id": "DESC"\r\n	},\r\n	"where": "community_status!=\'D\'",\r\n	"listColumns": [\r\n		"community_image_id",\r\n		"community_name",\r\n		"community_created_by",\r\n		"community_type",\r\n		"community_status"\r\n	],\r\n	"showColumns": [\r\n		"community_id",\r\n		"community_image_id",\r\n		"community_name",\r\n		"community_description",\r\n		"community_created_on",\r\n		"community_type"\r\n\r\n	],\r\n	"detailColumns": [\r\n		"community_id",\r\n		"community_image_id",\r\n		"community_name",\r\n		"community_created_by",\r\n		"community_created_on",\r\n		"community_description",\r\n		"community_type",\r\n		"community_status"\r\n	],\r\n	"columns": {\r\n		"community_id": {\r\n			"name": "ID",\r\n			"editoptions": {\r\n				"type": "hidden"\r\n			}\r\n		},\r\n		"community_image_id": {\r\n			"name": "Logo",\r\n			"editoptions": {\r\n				"type": "file",\r\n				"label": "Logo",\r\n				"class": "file",\r\n				"hint": "Ideal size 300 x 300. Allowed file types are jpg,jpeg,gif and png.",\r\n				"file_types": "gif,png,jpg,jpeg",\r\n				"validations": [\r\n					"file_type"\r\n				]\r\n			},\r\n			"external": "true",\r\n			"externalOptions": {\r\n				"externalTable": "tbl_files",\r\n				"externalColumn": "file_id",\r\n				"externalShowColumn": "file_id"\r\n			}\r\n		},\r\n		"community_name": {\r\n			"name": "Name",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "Name",\r\n				"class": "textbox",\r\n				"validations": [\r\n					"required"\r\n				]\r\n			}\r\n		},\r\n		"community_description": {\r\n			"name": "Description",\r\n			"editoptions": {\r\n				"type": "textarea",\r\n				"label": "Description",\r\n				"class": "textarea"\r\n			}\r\n		},\r\n		"community_created_by": {\r\n			"name": " Owner",\r\n			"sortable": "true",\r\n			"customColumn": "true",\r\n			"customaction": "Cmshelper::getCommunityOwner"\r\n		},\r\n		"community_type": {\r\n			"name": "Type",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n			"editoptions": {\r\n				"type": "select",\r\n				"source": {\r\n					"PUBLIC": "Public",\r\n					"PRIVATE": "Private"\r\n				},\r\n				"source_type": "array",\r\n				"label": "Type",\r\n				"class": "select",\r\n				"default": "PUBLIC",\r\n				"enumvalues": {\r\n					"PUBLIC": "Public",\r\n					"PRIVATE": "Private"\r\n				},\r\n				"validations": [\r\n					"required"\r\n				]\r\n			}\r\n		},\r\n		"community_status": {\r\n			"name": "Status",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n			"listoptions": {\r\n				"type": "button",\r\n				"customaction": "Cmshelper::changeCommunityStatus",\r\n				"enumvalues": {\r\n					"A": "Active",\r\n					"I": "Inactive"\r\n				},\r\n				"buttonColors": {\r\n					"A": "green",\r\n					"I": "red"\r\n				}\r\n			}\r\n		},\r\n		"community_created_on": {\r\n			"name": "Created On",\r\n			"sortable": "true",\r\n			"dbFormat": "timestamp",\r\n			"displayFormat": "m/d/Y"\r\n		}\r\n	},\r\n	"relations": {\r\n		"Group Members": {\r\n			"name": "Group Members",\r\n			"section": "bizcom_member",\r\n			"child_table": "tbl_community_member",\r\n			"parent_join_column": "community_id",\r\n			"child_join_column": "cmember_community_id",\r\n			"where": "child.cmember_status!=\'D\' "\r\n		}\r\n	},\r\n	"customActions": {\r\n		"afterAddRecord": "Communities::updateCommunityRegisterTime",\r\n		"afterEditRecord": "Communities::updateCommunityFile"\r\n	},\r\n	"opertations": [\r\n		"add",\r\n		"view",\r\n		"edit",\r\n		"customdelete"\r\n	],\r\n\r\n	"customDeleteOperation": "Cmshelper::deleteCommunity"\r\n}', '1', 4, 'all', 'admin', 'main', NULL),
	(77, 1, 'Group List', 'user_community', 'tbl_community_member', '{\r\n    "keyColumn": "cmember_list_id",\r\n    "wildsearch": "true",\r\n    "reference": {\r\n        "referenceTable": " tbl_users",\r\n        "referenceColumn": "cmember_id",\r\n        "referenceTableForiegnKey": "user_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Members list: ",\r\n    "detailHeaderColumns": [\r\n        "cmember_community_id"\r\n    ],\r\n    "orderBy": {\r\n        "cmember_list_id": "DESC"\r\n    },\r\n    "where": "cmember_status!=\'D\'",\r\n    "listColumns": [\r\n        "Image",\r\n        "cmember_community_id",\r\n        "cmember_joined_on",\r\n        "cmember_type"\r\n    ],\r\n    "detailColumns": [\r\n"cmember_list_id",\r\n        "Image",\r\n        "cmember_community_id",\r\n        "cmember_joined_on",\r\n        "cmember_type"\r\n    ],\r\n    "columns": {\r\n        "cmember_list_id": {\r\n            "name": "ID",\r\n            "type": "hidden"\r\n        },\r\n        "cmember_community_id": {\r\n            "name": "Name",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_communities",\r\n                "externalColumn": "community_id",\r\n                "externalShowColumn": "community_name"\r\n            }\r\n        },\r\n        "Image": {\r\n            "name": "Logo",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getCommunityImage"\r\n        },\r\n        "cmember_joined_on": {\r\n            "name": "Joined On",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "dbFormat": "timestamp",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n        "cmember_type": {\r\n            "name": "Member Type",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Owner",\r\n                    "U": "Member"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Member Type",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "A": "Owner",\r\n                    "U": "Member"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view"\r\n    ]\r\n}', '0', 2, 'all', 'admin', 'main', NULL),
	(78, 5, 'Manage Roles', 'manage_roles', 'cms_roles', '{"customCmsAction":"true","controller":"cms","method":"manageroles","module":"cms"}', '1', 1, 'all', 'admin', 'main', NULL),
	(90, 5, 'Manage Privileges ', 'cms_privileges', 'cms_privileges', '{"customCmsAction":"true","controller":"cms","method":"manageprivilege","module":"cms"}', '1', 1, 'all', 'admin', 'main', NULL),
	(91, 5, 'CMS users', 'cms_users', 'cms_users', '{"customCmsAction":"true","controller":"cms","method":"manageusers","module":"cms"}', '1', 3, 'all', 'admin', 'main', NULL),
	(94, 3, 'Banners', 'banners', 'tbl_banners', '{\r\n    "keyColumn": "banner_id",\r\n    "detailHeaderColumnPrefix": "Banner: ",\r\n    "detailHeaderColumns": [\r\n        "banner_title"\r\n    ],\r\n    "handleFile": "true",\r\n    "orderBy": {\r\n        "banner_id": "DESC"\r\n    },\r\n    "where": "banner_status != \'D\'",\r\n    "listColumns": [\r\n        "banner_title",\r\n        "banner_image_id",\r\n        "banner_status"\r\n    ],\r\n    "showColumns": [\r\n        "banner_id",\r\n        "banner_title",\r\n        "banner_image_id",\r\n        "banner_description",\r\n        "banner_link",\r\n        "banner_link_text",\r\n        "banner_status"\r\n    ],\r\n    "detailColumns": [\r\n        "banner_id",\r\n        "banner_title",\r\n        "banner_image_id",\r\n        "banner_description",\r\n        "banner_link",\r\n        "banner_link_text",\r\n        "banner_status"\r\n    ],\r\n    "columns": {\r\n        "banner_id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "banner_title": {\r\n            "name": "Title",\r\n            "searchable": "true",\r\n            "editoptions": {\r\n                "validations": [\r\n                    "required"\r\n                ],\r\n                "type": "textbox",\r\n                "label": "Title",\r\n                "class": "textbox",\r\n  "hint": "Title to be displayed on the banner"\r\n            }\r\n        },\r\n        "banner_link_text": {\r\n            "name": "Button Text",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Button Text",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ],\r\n                "hint": "Text to be displayed in the button on the banner"\r\n            }\r\n        },\r\n        "banner_link": {\r\n            "name": "External Link",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "External Link",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                   \r\n                ],\r\n                "hint": "Page to go to on clicking the button in the banner"\r\n            }\r\n        },\r\n        "banner_image_id": {\r\n            "name": "Image",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "validations": [\r\n                    "required"\r\n                ],\r\n                "type": "file",\r\n                "label": "Image",\r\n                "class": "file",\r\n                "hint": "Ideal size 560 x 446. Allowed file types are jpg,jpeg,gif and png. Image to be displayed on the banner.",\r\n"file_types":"gif,png,jpg,jpeg",\r\n"validations": [\r\n                    "file_type"\r\n                ]\r\n            },\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_files",\r\n                "externalColumn": "file_id",\r\n                "externalShowColumn": "file_id"\r\n            }\r\n        },\r\n        "banner_description": {\r\n            "name": "Description",\r\n            "editoptions": {\r\n                "validations": [\r\n                    "required"\r\n                ],\r\n                "type": "textarea",\r\n                "label": "Description",\r\n                "class": "textarea",\r\n                "hint": "Text to be displayed on the banner"\r\n            }\r\n        },\r\n        "banner_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "editoptions": {\r\n                "validations": [\r\n                    "required"\r\n                ],\r\n                "type": "select",\r\n                "source": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                }\r\n            },\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeBannerStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "customActions": {\r\n        "afterEditRecord": "Cmshelper::updateBanner",\r\n        "afterAddRecord": "Cmshelper::updateBanner"\r\n    },\r\n    "opertations": [\r\n        "view",\r\n        "edit",\r\n        "delete",\r\n        "add"\r\n    ]\r\n}', '0', 2, 'all', 'admin', 'main', NULL),
	(93, 3, 'Categories', 'categories', 'tbl_categories', '{\r\n    "keyColumn": "category_id",\r\n    "wildsearch": "true",\r\n    "detailHeaderColumnPrefix": "Categories: ",\r\n    "detailHeaderColumns": [\r\n        "category_name"\r\n    ],\r\n    "orderBy": {\r\n        "category_name": "ASC"\r\n    },\r\n    "listColumns": [\r\n        "category_name",\r\n        "category_status"\r\n    ],\r\n    "showColumns": [\r\n        "category_name"\r\n    ],\r\n    "detailColumns": [\r\n        "category_id",\r\n        "category_name",\r\n        "category_status"\r\n    ],\r\n    "columns": {\r\n        "category_id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "category_name": {\r\n            "name": "Category Name",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "textbox",\r\n                "label": "Category Name",\r\n                "class": "textbox",\r\n                "validations": [\r\n                    "required"\r\n                ]\r\n            }\r\n        },\r\n        "category_status": {\r\n            "name": "Status",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            \r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeCategoryStatus",\r\n                "enumvalues": {\r\n                    "A": "Active",\r\n                    "I": "Inactive"\r\n                },\r\n                "buttonColors": {\r\n                    "A": "green",\r\n                    "I": "red"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "customActions": {\r\n        "afterAddRecord": "Cmshelper::getCategoryAlias"\r\n    },\r\n    "opertations": [\r\n        "add",\r\n        "view",\r\n        "edit",\r\n        "delete"\r\n    ]\r\n}', '0', 4, 'all', 'admin', 'main', NULL),
	(95, 1, 'Invitations Sent', 'bizcom_invitations', 'tbl_invitation', '{\r\n    "keyColumn": "invitation_id",\r\n    "wildsearch": "true",\r\n    "reference": {\r\n        "referenceTable": " tbl_communities",\r\n        "referenceColumn": "invitation_entity_id",\r\n        "referenceTableForiegnKey": "community_id"\r\n    },\r\n    "detailHeaderColumnPrefix": "Invitations sent: ",\r\n    "detailHeaderColumns": [\r\n        "invitation_entity_id"\r\n    ],\r\n    "orderBy": {\r\n        "invitation_id": "DESC"\r\n    },\r\n    "where": "invitation_entity = \'C\'",\r\n    "listColumns": [\r\n        "Name",\r\n        "invitation_sender_email",\r\n        "invitation_receiver_email",\r\n        "invitation_created_on",\r\n        "invitation_status"\r\n    ],\r\n    "detailColumns": [\r\n        "invitation_id",\r\n        "invitation_entity_id",\r\n        "Name",\r\n        "invitation_sender_email",\r\n        "invitation_receiver_email",\r\n        "invitation_created_on",\r\n        "invitation_status"\r\n    ],\r\n    "columns": {\r\n        "invitation_id": {\r\n            "name": "ID",\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "invitation_entity_id": {\r\n            "name": "Community",\r\n            "external": "true",\r\n            "externalOptions": {\r\n                "externalTable": "tbl_communities",\r\n                "externalColumn": "community_id",\r\n                "externalShowColumn": "community_name"\r\n            },\r\n            "editoptions": {\r\n                "type": "hidden"\r\n            }\r\n        },\r\n        "Name": {\r\n            "name": "Name",\r\n            "customColumn": "true",\r\n            "customaction": "Cmshelper::getInvitationSenderName"\r\n        },\r\n        "invitation_sender_email": {\r\n            "name": "Sender Email",\r\n            "sortable": "true",\r\n            "searchable": "true"\r\n        },\r\n        "invitation_receiver_email": {\r\n            "name": "Receiver Email",\r\n            "sortable": "true",\r\n            "searchable": "true"\r\n        },\r\n        "invitation_created_on": {\r\n            "name": "Sent On",\r\n            "sortable": "true",\r\n            "searchable": "true",\r\n            "dbFormat": "timestamp",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n        "invitation_status": {\r\n            "name": "Invitation Status",\r\n            "sortable": "true",\r\n            "editoptions": {\r\n                "type": "select",\r\n                "source": {\r\n                    "P": "Pending",\r\n                    "A": "Accepted",\r\n                    "R": "Rejected",\r\n                    "DJ": "Disjoined"\r\n                },\r\n                "source_type": "array",\r\n                "label": "Invitation Status",\r\n                "class": "select",\r\n                "enumvalues": {\r\n                    "P": "Pending",\r\n                    "A": "Accepted",\r\n                    "R": "Rejected",\r\n                    "DJ": "Disjoined"\r\n                }\r\n            }\r\n        }\r\n    },\r\n    "opertations": [\r\n        "view"\r\n    ]\r\n}', '0', 0, 'all', 'admin', 'main', NULL),
	(96, 1, 'Reconcile Charity', 'reconcilecharity', 'tbl_charity_reconcilation_details', '{\r\n    "keyColumn": "reconcilation_id",\r\n    "wildsearch": "true",\r\n    "detailHeaderColumnPrefix": "Reconcile Charity: ",\r\n    "detailHeaderColumns": [\r\n        "user_email"\r\n    ],\r\n   \r\n    "breadCrumbColumn": "username",\r\n    "orderBy": {\r\n        "campaign_name": "ASC"\r\n    },\r\n    "listColumns": [\r\n        "campaign_name",\r\n        "charity_organisation_name",\r\n        "user_name",\r\n        "reconcilation_amount",\r\n        "reconcilation_invoice_number",\r\n        "reconcilation_submit_date",\r\n        "reconcilation_settle_status"\r\n    ],\r\n    "showColumns": [\r\n        "reconcilation_id",\r\n        "campaign_name",\r\n        "charity_organisation_name",\r\n        "user_name",\r\n        "reconcilation_amount",\r\n        "reconcilation_invoice_number",\r\n        "reconcilation_submit_date",\r\n        "reconcilation_settle_status"\r\n    ],\r\n    "detailColumns": [\r\n        "campaign_name",\r\n        "charity_organisation_name",\r\n        "user_name",\r\n        "reconcilation_amount",\r\n        "reconcilation_invoice_number",\r\n        "reconcilation_submit_date",\r\n        "reconcilation_settle_status"\r\n    ],\r\n    "columns": {\r\n        "campaign_name": {\r\n            "name": "Campaign Name",\r\n            "searchable": "true",\r\n            "sortable": "true"\r\n        },\r\n        "charity_organisation_name": {\r\n            "name": "Charity Organisation",\r\n            "searchable": "true",\r\n            "sortable": "true"\r\n        },\r\n        "user_name": {\r\n            "name": "User Name",\r\n            "searchable": "true",\r\n            "sortable": "true"\r\n        },\r\n        "reconcilation_amount": {\r\n            "name": "Amount(GBP)",\r\n            "searchable": "true",\r\n            "sortable": "true"\r\n        },\r\n        "reconcilation_invoice_number": {\r\n            "name": "Invoice Number",\r\n            "searchable": "true",\r\n            "sortable": "true"\r\n        },\r\n        "reconcilation_submit_date": {\r\n            "name": "Date",\r\n            "searchable": "true",\r\n            "sortable": "true",\r\n            "dbFormat": "date",\r\n            "displayFormat": "m/d/Y"\r\n        },\r\n        "reconcilation_settle_status": {\r\n            "name": "Reconcile Status",\r\n	"sortable": "true",\r\n            "searchable": "true",\r\n            "listoptions": {\r\n                "type": "button",\r\n                "customaction": "Cmshelper::changeReconcileStatus",\r\n                "enumvalues": {\r\n                    "Y": "Complete",\r\n                    "N": "Incomplete"\r\n                },\r\n                "buttonColors": {\r\n                    "Y": "green",\r\n                    "N": "red"\r\n                }\r\n            }\r\n        }\r\n    }\r\n}', '0', 6, 'all', 'admin', 'main', NULL),
	(97, 1, 'Announcements', 'announcements', 'tbl_admin_announcements', '{\r\n	"keyColumn": "admin_announcement_id",\r\n	"wildsearch": "true",\r\n	"detailHeaderColumnPrefix": "Communities: ",\r\n	"detailHeaderColumns": ["admin_announcement_title"],\r\n	"breadCrumbColumn": "admin_announcement_title",\r\n	"handleFile": "true",\r\n	"orderBy": {\r\n		"admin_announcement_id": "DESC"\r\n	},\r\n	"where": "admin_announcement_status!=\'D\'",\r\n	"listColumns": ["admin_announcement_title", "admin_announcement_content", "admin_announcement_type", "admin_announcement_created_date", "admin_announcement_expiry_date", "admin_announcement_status", "admin_announcement_image_id"],\r\n	"showColumns": ["admin_announcement_id", "admin_announcement_title", "admin_announcement_content", "admin_announcement_type", "admin_announcement_created_date", "admin_announcement_expiry_date", "admin_announcement_status", "admin_announcement_image_id", "admin_announcement_description"],\r\n	"detailColumns": ["admin_announcement_id", "admin_announcement_title", "admin_announcement_content", "admin_announcement_type", "admin_announcement_created_date", "admin_announcement_expiry_date", "admin_announcement_status", "admin_announcement_image_id", "admin_announcement_description"],\r\n	"columns": {\r\n		"admin_announcement_id": {\r\n			"name": "ID",\r\n			"editoptions": {\r\n				"type": "hidden"\r\n			}\r\n		},\r\n		"admin_announcement_image_id": {\r\n			"name": "Announcement Picture",\r\n			"editoptions": {\r\n				"type": "file",\r\n				"label": "Announcement Picture",\r\n				"class": "file",\r\n				"hint": "Ideal size 300 x 300. Allowed file types are jpg,jpeg,gif and png.",\r\n				"file_types": "gif,png,jpg,jpeg",\r\n				"validations": [\r\n					"file_type"\r\n				]\r\n\r\n			},\r\n			"external": "true",\r\n			"externalOptions": {\r\n				"externalTable": "tbl_files",\r\n				"externalColumn": "file_id",\r\n				"externalShowColumn": "file_id"\r\n			}\r\n		},\r\n		"admin_announcement_title": {\r\n			"name": "Announcement Title",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n			"editoptions": {\r\n				"type": "textbox",\r\n				"label": "Announcement Title",\r\n				"class": "textbox",\r\n				"validations": ["required"]\r\n			}\r\n		},\r\n		"admin_announcement_content": {\r\n			"name": "Content",\r\n			"editoptions": {\r\n				"type": "textarea",\r\n				"label": "Description",\r\n				"class": "textarea"\r\n			}\r\n		},\r\n		"admin_announcement_type": {\r\n			"name": "Display Type",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n			"editoptions": {\r\n				"type": "select",\r\n				"source": {\r\n					"A": "All Users",\r\n					"N": "New Users"\r\n				},\r\n				"source_type": "array",\r\n				"label": "Display Type",\r\n				"class": "select",\r\n				"default": "A",\r\n				"enumvalues": {\r\n					"A": "All Users",\r\n					"N": "New Users"\r\n				},\r\n				"validations": ["required"]\r\n			}\r\n		},\r\n		"admin_announcement_status": {\r\n			"name": "Status",\r\n			"searchable": "true",\r\n			"sortable": "true",\r\n			"editoptions": {\r\n				"type": "select",\r\n				"source": {\r\n					"A": "Active",\r\n					"I": "Inactive"\r\n				},\r\n				"source_type": "array",\r\n				"label": "Status",\r\n				"class": "select",\r\n				"default": "A",\r\n				"enumvalues": {\r\n					"A": "Active",\r\n					"I": "Inactive",\r\n					"D": "Delete"\r\n				},\r\n				"validations": ["required"]\r\n			}\r\n		},\r\n		"admin_announcement_created_date": {\r\n			"name": "Created On",\r\n			"sortable": "true",\r\n			"dbFormat": "date",\r\n			"displayFormat": "m/d/Y"\r\n		},\r\n		"admin_announcement_expiry_date": {\r\n			"name": "Expired On",\r\n			"sortable": "true",\r\n			"searchable": "true",\r\n			"dbFormat": "date",\r\n			"displayFormat": "m/d/Y",\r\n			"editoptions": {\r\n				"type": "datepicker",\r\n				"label": "Expiry Date",\r\n				"class": "datepicker",\r\n				"validations": ["required"]\r\n			}\r\n		},\r\n		"admin_announcement_description": {\r\n			"name": "Admin Announcemnet Description",\r\n			"editoptions": {\r\n				"type": "htmlEditor",\r\n				"label": "Admin Announcemnet Description",\r\n				"class": "textarea",\r\n				"editorType": "ckeditor",\r\n				"validations": [\r\n					"required"\r\n				]\r\n			}\r\n		}\r\n	},\r\n	"customActions": {\r\n		"afterAddRecord": "User::updateAdminFile",\r\n		"afterEditRecord": "User::updateAdminFile"\r\n	},\r\n\r\n	"opertations": ["add", "view", "edit", "delete"]\r\n}', '0', 7, 'all', 'admin', 'main', NULL);


--
-- Dumping data for table `cms_users`
--

INSERT INTO `cms_users` (`id`, `type`, `username`, `password`, `email`, `role_id`, `status`) VALUES
(1, 'sadmin', 'sadmin', 'c5edac1b8c1d58bad90a246d8f08f53b', '', 0, 'active'),
(11, 'admin', 'saneesh', '52f5972aee0aa1a446e711bd9407ab72', 'saneeshbaby@gmail.com', 5, 'active'),
(9, 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'armiatest05@gmail.com', 1, 'active'),
(12, 'admin', 'subadmin', 'e10adc3949ba59abbe56e057f20f883e', 'armiatest05@gmail.com', 9, 'active');

--
-- Dumping data for table `fw_metadata`
--

INSERT INTO `fw_metadata` (`id`, `url`, `title`, `keyword`, `description`) VALUES
(1, '/aboutus', 'Socialware : About Us', 'Socialware - About Us', 'Socialware  - About Us'),
(2, '/features', 'Socialware : Features', 'Socialware - Features', 'Socialware - Features'),
(3, '/contact', 'Socialware : Contact Us', 'Socialware - Contact Us', 'Socialware - Contact Us'),
(4, '/terms', 'Socialware : Terms of Service', 'Socialware - Terms of Service', 'Socialware - Terms of Service'),
(5, '/privacy-policy', 'Socialware : Privacy Policy', 'Socialware - Privacy Policy', 'Socialware - Privacy Policy'),
(18, '/pending-request', 'Socialware : Pending Requests', 'Socialware : Pending Requests', 'Socialware : Pending Requests'),
(15, '/join', 'Socialware : Sign Up', 'Socialware : Sign Up', 'Socialware : Sign Up'),
(16, '/login', 'Socialware : Sign In', 'Socialware : Sign In', 'Socialware : Sign In'),
(20, '/index/searchprofile', 'Socialware : Search Results', 'Socialware : Search Results', 'Socialware : Search Results'),
(24, '/faq', 'Socialware : FAQ', 'Socialware : FAQ', 'Socialware : FAQ'),
(25, '/disclaimer', 'Socialware : Disclaimer', 'Socialware : Disclaimer', 'Socialware : Disclaimer');

--
-- Dumping data for table `tbl_cms_settings`
--

INSERT INTO `tbl_cms_settings` (`id`, `cms_set_name`, `cms_set_value`, `created_on`) VALUES
(1, 'admin_logo', 'project/themes/default/images/tbl_logo.png', '2016-07-19 20:30:26'),
(2, 'admin_copyright', '<div style=''text-align: center;''>Â© Copyright 2016. Socialware. All rights reserved</div>', '2016-07-21 00:18:57'),
(4, 'admin_page_count', '8', '2012-10-03 16:33:33'),
(5, 'site_logo', 'Cmshelper::bindSiteLogo', '2013-01-04 19:34:39');

--
-- Dumping data for table `tbl_content`
--

INSERT INTO `tbl_content` (`content_id`, `content_alias`, `content_title`, `content_description`) VALUES
(1, 'aboutus', 'About Us ', 'Lorem\\''kk Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\\''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions dfgfg \\"gfg\\" cvcv cfdf \\''fgfg\\'' cvcvrtyu cvcvcv'),
(2, 'features', 'Features', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare, nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non sollicitudin felis. Integer lobortis massa semper augue adipiscing, vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit nunc laoreet non. Mauris sapien eros, blandit vitae urna sed, consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet ultricies erat placerat et. Etiam a sem varius, placerat diam vel, congue neque. Vestibulum varius dignissim nulla sit amet adipiscing. Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque quam nec porttitor.\r\n\r\n    Lorem ipsum dolor sit amet, consectetur adipiscing elit.\r\n    Donec viverra nisl vitae viverra vulputate. D\\"fdf\\" cvcvcv \\''dcfcv\\''  cvcvcv\r\n    Nullam aliquet metus vitae neque sagittis, eget rutrum leo gravida.\r\n\r\n    Cras fermentum quam vitae elit scelerisque, ac ornare quam facilisis.\r\n    Donec pharetra risus vitae turpis mattis, eget scelerisque orci auctor.\r\n    Morbi eu neque viverra, scelerisque nisl eu, sodales leo.'),
(3, 'contact', 'Contact Us', 'DieSachbearbeiter <br>SchÃƒÂ¶nhauser Allee <br>167c 10435<br> Berlin <br>Germany <br>Telephone: +49 30 47373795 <br>E-mail: moin@blindtextgenerator.de ccc'),
(4, 'terms', 'Terms of Service', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare, nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non sollicitudin felis. Integer lobortis massa semper augue adipiscing, vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit nunc laoreet non. Mauris sapien eros, blandit vitae urna sed, consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet ultricies erat placerat et. Etiam a sem varius, placerat diam vel, congue neque. Vestibulum varius dignissim nulla sit amet adipiscing. Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque quam nec porttitor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec viverra nisl vitae viverra vulputate. Nullam aliquet metus vitae neque sagittis, eget rutrum leo gravida. Cras fermentum quam vitae elit scelerisque, ac ornare quam facilisis. Donec pharetra risus vitae turpis mattis, eget scelerisque orci auctor. Morbi eu neque viverra, scelerisque nisl eu, sodales leo.<br> ssdsd vbdvfbhd \\"FfG\\" cnvcbv  dsd \\''fvfg\\''fg cvvbvb'),
(5, 'privacy-policy', 'Privacy Policy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare,  nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu  purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non  sollicitudin felis. Integer lobortis massa semper augue adipiscing,  vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit  nunc laoreet non. Mauris sapien eros, blandit vitae urna sed,  consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet  ultricies erat placerat et. Etiam a sem varius, placerat diam vel,  congue neque. Vestibulum varius dignissim nulla sit amet adipiscing.  Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque  quam nec porttitor. Lorem ipsum dolor sit amet, consectetur adipiscing  elit. Donec viverra nisl vitae viverra vulputate. Nullam aliquet metus  vitae neque sagittis, eget rutrum leo gravida. Cras fermentum quam vitae  elit scelerisque, ac ornare quam facilisis. Donec pharetra risus vitae  turpis mattis, eget scelerisque orci auctor. Morbi eu neque viverra,  scelerisque nisl eu, sodales leo.'),
(6, 'faq', 'FAQ', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare,  nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu  purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non  sollicitudin felis. Integer lobortis massa semper augue adipiscing,  vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit  nunc laoreet non. Mauris sapien eros, blandit vitae urna sed,  consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet  ultricies erat placerat et. Etiam a sem varius, placerat diam vel,  congue neque. Vestibulum varius dignissim nulla sit amet adipiscing.  Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque  quam nec porttitor. Lorem ipsum dolor sit amet, consectetur adipiscing  elit. Donec viverra nisl vitae viverra vulputate. Nullam aliquet metus  vitae neque sagittis, eget rutrum leo gravida. Cras fermentum quam vitae  elit scelerisque, ac ornare quam facilisis. Donec pharetra risus vitae  turpis mattis, eget scelerisque orci auctor. Morbi eu neque viverra,  scelerisque nisl eu, sodales leo.'),
(7, 'site-map', 'Sitemap', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare,  nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu  purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non  sollicitudin felis. Integer lobortis massa semper augue adipiscing,  vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit  nunc laoreet non. Mauris sapien eros, blandit vitae urna sed,  consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet  ultricies erat placerat et. Etiam a sem varius, placerat diam vel,  congue neque. Vestibulum varius dignissim nulla sit amet adipiscing.  Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque  quam nec porttitor. Lorem ipsum dolor sit amet, consectetur adipiscing  elit. Donec viverra nisl vitae viverra vulputate. Nullam aliquet metus  vitae neque sagittis, eget rutrum leo gravida. Cras fermentum quam vitae  elit scelerisque, ac ornare quam facilisis. Donec pharetra risus vitae  turpis mattis, eget scelerisque orci auctor. Morbi eu neque viverra,  scelerisque nisl eu, sodales leo.'),
(8, 'disclaimer', 'Disclaimer', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare,  nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu  purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non  sollicitudin felis. Integer lobortis massa semper augue adipiscing,  vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit  nunc laoreet non. Mauris sapien eros, blandit vitae urna sed,  consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet  ultricies erat placerat et. Etiam a sem varius, placerat diam vel,  congue neque. Vestibulum varius dignissim nulla sit amet adipiscing.  Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque  quam nec porttitor. Lorem ipsum dolor sit amet, consectetur adipiscing  elit. Donec viverra nisl vitae viverra vulputate. Nullam aliquet metus  vitae neque sagittis, eget rutrum leo gravida. Cras fermentum quam vitae  elit scelerisque, ac ornare quam facilisis. Donec pharetra risus vitae  turpis mattis, eget scelerisque orci auctor. Morbi eu neque viverra,  scelerisque nisl eu, sodales leo.'),
(9, 'specialterms', 'Special Terms of Service', 'Special Terms of Service for payment.<br>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare,  nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu  purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non  sollicitudin felis. Integ'),
(10, 'pifterms', 'PIF Terms and Condition', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ornare, nisi sit amet bibendum viverra, eros justo mollis erat, vel rhoncus arcu purus vitae magna. Mauris feugiat arcu eu egestas pharetra. In non sollicitudin felis. Integer lobortis massa semper augue adipiscing, vitae vulputate magna rutrum. Sed porta mollis ligula, sit amet suscipit nunc laoreet non. Mauris sapien eros, blandit vitae urna sed, consectetur sagittis mauris. Maecenas hendrerit erat erat, sit amet ultricies erat placerat et. Etiam a sem varius, placerat diam vel, congue neque. Vestibulum varius dignissim nulla sit amet adipiscing. Suspendisse porta mattis erat vel dignissim. Proin congue scelerisque quam nec porttitor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec viverra nisl vitae viverra vulputate.');

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`tc_id`, `tc_code`, `tc_name`, `tc_status`) VALUES
(1, 'US', 'USA', 'A'),
(2, 'IN', 'India', 'A'),
(3, 'CA', 'Canada', 'A'),
(4, 'AU', 'Australia', 'A'),
(5, 'AF', 'Afghanistan', 'A'),
(6, 'AL', 'Albania', 'A'),
(7, 'DZ', 'Algeria', 'A'),
(8, 'GB', 'UK', 'A'),
(9, 'AD', 'Andorra', 'A'),
(10, 'AO', 'Angola', 'A'),
(11, 'AE', 'UAE', 'A'),
(14, 'AR', 'Argentina', 'A'),
(15, 'AM', 'Armenia', 'A'),
(16, 'AW', 'Aruba', 'A'),
(18, 'AT', 'Austria', 'A'),
(19, 'AZ', 'Azerbaijan', 'A'),
(20, 'BS', 'Bahama', 'A'),
(21, 'BH', 'Bahrain', 'A'),
(22, 'BD', 'Bangladesh', 'A'),
(23, 'BB', 'Barbados', 'A'),
(24, 'BY', 'Belarus', 'A'),
(25, 'BE', 'Belgium', 'A'),
(26, 'BZ', 'Belize', 'A'),
(28, 'BM', 'Bermuda', 'A'),
(29, 'BT', 'Bhutan', 'A'),
(30, 'BO', 'Bolivia', 'A'),
(31, 'BA', 'BosniaandHerzegovina', 'A'),
(32, 'BW', 'Botswana', 'A'),
(33, 'BV', 'BouvetIsland', 'A'),
(34, 'BR', 'Brazil', 'A'),
(35, 'VG', 'BritishVirginIslands', 'A'),
(36, 'BN', 'BruneiDarussalam', 'A'),
(37, 'BG', 'Bulgaria', 'A'),
(39, 'BI', 'Burundi', 'A'),
(40, 'KH', 'Cambodia', 'A'),
(41, 'CM', 'Cameroon', 'A'),
(43, 'KY', 'CaymanIslands', 'A'),
(44, 'TD', 'Chad', 'A'),
(45, 'CL', 'Chile', 'A'),
(46, 'CN', 'China', 'A'),
(49, 'CO', 'Colombia', 'A'),
(51, 'CG', 'Congo', 'A'),
(52, 'CK', 'CookIslands', 'A'),
(53, 'CR', 'CostaRica', 'A'),
(54, 'HR', 'Croatia', 'A'),
(55, 'CU', 'Cuba', 'A'),
(56, 'CY', 'Cyprus', 'A'),
(57, 'CZ', 'CzechRepublic', 'A'),
(58, 'DK', 'Denmark', 'A'),
(61, 'DO', 'DominicanRepublic', 'A'),
(63, 'EC', 'Ecuador', 'A'),
(64, 'EG', 'Egypt', 'A'),
(65, 'SV', 'ElSalvador', 'A'),
(67, 'ER', 'Eritrea', 'A'),
(68, 'EE', 'Estonia', 'A'),
(69, 'ET', 'Ethiopia', 'A'),
(71, 'FJ', 'Fiji', 'A'),
(72, 'FI', 'Finland', 'A'),
(73, 'FR', 'France', 'A'),
(74, 'GF', 'FrenchGuiana', 'A'),
(76, 'GA', 'Gabon', 'A'),
(77, 'GM', 'Gambia', 'A'),
(78, 'GE', 'Georgia', 'A'),
(79, 'DE', 'Germany', 'A'),
(80, 'GH', 'Ghana', 'A'),
(81, 'GI', 'Gibraltar', 'A'),
(82, 'GR', 'Greece', 'A'),
(83, 'GL', 'Greenland', 'A'),
(84, 'GD', 'Grenada', 'A'),
(85, 'GP', 'Guadeloupe', 'A'),
(87, 'GT', 'Guatemala', 'A'),
(88, 'GN', 'Guinea', 'A'),
(89, 'GW', 'Guinea-Bissau', 'A'),
(90, 'GY', 'Guyana', 'A'),
(91, 'HT', 'Haiti', 'A'),
(92, 'HN', 'Honduras', 'A'),
(93, 'HK', 'HongKong', 'A'),
(94, 'HU', 'Hungary', 'A'),
(95, 'IS', 'Iceland', 'A'),
(96, 'ID', 'Indonesia', 'A'),
(97, 'IQ', 'Iraq', 'A'),
(98, 'IE', 'Ireland', 'A'),
(99, 'IR', 'Iran', 'A'),
(100, 'IL', 'Israel', 'A'),
(101, 'IT', 'Italy', 'A'),
(102, 'JM', 'Jamaica', 'A'),
(103, 'JP', 'Japan', 'A'),
(104, 'JO', 'Jordan', 'A'),
(105, 'KZ', 'Kazakhstan', 'A'),
(106, 'KE', 'Kenya', 'A'),
(108, 'KR', 'Korea', 'A'),
(109, 'KW', 'Kuwait', 'A'),
(110, 'KG', 'Kyrgyzstan', 'A'),
(111, 'LV', 'Latvia', 'A'),
(112, 'LB', 'Lebanon', 'A'),
(114, 'LR', 'Liberia', 'A'),
(115, 'LY', 'Libya', 'A'),
(116, 'LI', 'Liechtenstein', 'A'),
(117, 'LT', 'Lithuania', 'A'),
(118, 'LU', 'Luxembourg', 'A'),
(120, 'MG', 'Madagascar', 'A'),
(121, 'MW', 'Malawi', 'A'),
(122, 'MY', 'Malaysia', 'A'),
(123, 'MV', 'Maldives', 'A'),
(124, 'ML', 'Mali', 'A'),
(125, 'MT', 'Malta', 'A'),
(129, 'MU', 'Mauritius', 'A'),
(131, 'MX', 'Mexico', 'A'),
(133, 'MC', 'Monaco', 'A'),
(134, 'MN', 'Mongolia', 'A'),
(136, 'MA', 'Morocco', 'A'),
(137, 'MZ', 'Mozambique', 'A'),
(138, 'MM', 'Myanmar', 'A'),
(139, 'NA', 'Nambia', 'A'),
(140, 'NR', 'Nauru', 'A'),
(141, 'NP', 'Nepal', 'A'),
(143, 'NL', 'Netherlands', 'A'),
(145, 'NZ', 'NewZealand', 'A'),
(146, 'NI', 'Nicaragua', 'A'),
(147, 'NE', 'Niger', 'A'),
(148, 'NG', 'Nigeria', 'A'),
(153, 'NO', 'Norway', 'A'),
(154, 'OM', 'Oman', 'A'),
(155, 'PK', 'Pakistan', 'A'),
(157, 'PA', 'Panama', 'A'),
(158, 'PG', 'PapuaNewGuinea', 'A'),
(159, 'PY', 'Paraguay', 'A'),
(160, 'PE', 'Peru', 'A'),
(161, 'PH', 'Philippines', 'A'),
(163, 'PL', 'Poland', 'A'),
(164, 'PT', 'Portugal', 'A'),
(166, 'QA', 'Qatar', 'A'),
(168, 'RO', 'Romania', 'A'),
(169, 'RU', 'Russia', 'A'),
(170, 'RW', 'Rwanda', 'A'),
(175, 'SA', 'SaudiArabia', 'A'),
(176, 'SN', 'Senegal', 'A'),
(177, 'SC', 'Seychelles', 'A'),
(178, 'SL', 'SierraLeone', 'A'),
(179, 'SG', 'Singapore', 'A'),
(180, 'SK', 'Slovakia', 'A'),
(181, 'SI', 'Slovenia', 'A'),
(182, 'SB', 'SolomonIslands', 'A'),
(183, 'SO', 'Somalia', 'A'),
(184, 'ZA', 'SouthAfrica', 'A'),
(185, 'ES', 'Spain', 'A'),
(186, 'LK', 'SriLanka', 'A'),
(187, 'SH', 'St.Helena', 'A'),
(190, 'SD', 'Sudan', 'A'),
(191, 'SR', 'Suriname', 'A'),
(192, 'SZ', 'Swaziland', 'A'),
(193, 'SE', 'Sweden', 'A'),
(194, 'CH', 'Switzerland', 'A'),
(195, 'SY', 'Syria', 'A'),
(196, 'TW', 'Taiwan', 'A'),
(197, 'TJ', 'Tajikistan', 'A'),
(198, 'TZ', 'Tanzania', 'A'),
(199, 'TH', 'Thailand', 'A'),
(202, 'TO', 'Tonga', 'A'),
(203, 'TT', 'TrinidadandTobago', 'A'),
(204, 'TN', 'Tunisia', 'A'),
(205, 'TR', 'Turkey', 'A'),
(208, 'TV', 'Tuvalu', 'A'),
(209, 'UG', 'Uganda', 'A'),
(210, 'UA', 'Ukraine', 'A'),
(212, 'UY', 'Uruguay', 'A'),
(213, 'UZ', 'Uzbekistan', 'A'),
(214, 'VU', 'Vanuatu', 'A'),
(215, 'VE', 'Venezuela', 'A'),
(216, 'VN', 'VietNam', 'A'),
(217, 'EH', 'WesternSahara', 'A'),
(218, 'YE', 'Yemen', 'A'),
(219, 'YU', 'Yugoslavia', 'A'),
(220, 'ZR', 'Zaire', 'A'),
(221, 'ZM', 'Zambia', 'A'),
(222, 'ZW', 'Zimbabwe', 'A');

--
-- Dumping data for table `tbl_lookup`
--

INSERT INTO `tbl_lookup` (`settingfield`, `value`, `settinglabel`, `groupLabel`, `type`, `parent_settingfield`, `display_order`) VALUES
('perpage', '8', 'Number of records per page', 'General', '', '', 14),
('vadmin_email', 'neha.t@armiasystems.com', 'Admin Email', 'General', '', '', 6),
('vsecure_server', 'http://dev.iscripts.com/products/connect10', 'Secure URL', 'General', '', '', 3),
('vsite_url', 'http://dev.iscripts.com/products/connect10', 'Site URL', 'General', '', '', 2),
('sitename', 'Socialware', 'Site Name', 'General', '', '', 1),
('sitelogo', 'logo.png', 'Site Logo', 'General', 'file', '', 4),
('GoogleMapValue', 'www', 'Google Map Key', '', '', 'GoogleMap', 9),
('allowedimagetypes', 'gif,jpg,jpeg,png,image/gif,image/pjpeg ,image/jpeg,image/png,image/x-png,image/pjpeg,image/bmp', 'Recommended Image Formats', '', 'textarea', '', 10),
('metatagKey', 'Socialware', 'Default Meta Keywords', 'General', 'textarea', '', 12),
('metatagDes', 'Socialware', 'Default Meta Description', 'General', 'textarea', '', 13),
('GoogleMap', '1', 'Enable Google Map', '', 'checkbox', '', 8),
('googleaddemo', '0', 'Enable Google Advertisement', '', 'checkbox', '', 9),
('googleadvalue', '', 'Invocation Code for Advertisement', '', 'textarea', 'googleaddemo', 9),
('email_logo', 'logo.png', 'Email Logo', '', 'file', '', 5),
('metaTitle', 'Socialware', 'Default Page/Meta Title', 'General', '', '', 11),
('addressfromemail', 'armiaqa112@gmail.com', '', '', '', '', 100),
('search_filter_min_value', '0', 'Search Filter Minimum Value', '', '', '', 100),
('addressfromemailname', 'armiaqa112@gmail.com', '', '', '', '', 100),
('addressreplyemail', 'armiaqa112@gmail.com', '', '', '', '', 100),
('addressreplyemailname', 'armiaqa112@gmail.com', '', '', '', '', 100),
('EnableSMTP', '1', 'Enable SMTP', '', 'checkbox', '', 100),
('SMTPHost', '', 'SMTP Host', 'Advanced', '', 'EnableSMTP', 100),
('SMTPUsername', '', 'SMTP Username', 'Advanced', '', 'EnableSMTP', 100),
('SMTPPassword', '', 'SMTP Password', 'Advanced', 'password', 'EnableSMTP', 100),
('SMTPPort', '', 'SMTP PORT', 'Advanced', '', 'EnableSMTP', 100),
('SSLEnabled', '0', 'SSL Enabled Or Not', 'Advanced', 'checkbox', '', 100),
('groupLabelOrder', '', '', '', '', '', 0),
('twitter_app_id', '', 'Twitter App ID', 'General', '', '', 16),
('ADMIN_APPROVE_BIZCOM_AUTO', '1', 'Enable Auto Approval of Group', 'General', 'checkbox', '', 17),
('enable_fb', '1', 'Enable Facebook', 'General', 'checkbox', '', 15),
('fb_app_id', '', 'Facebook App ID', 'General', '', '', 15),
('organization_display', '1', 'Display Page Widget', 'General', 'checkbox', '', 21),
('friend_display', '1', 'Display Friends Widget', 'General', 'checkbox', '', 20),
('group_display', '1', 'Display Group Widget', 'General', 'checkbox', '', 19),
('auto_approval', '1', 'Enable Auto Approval for Page', 'General', 'checkbox', '', 18),
('license', 'dfsdfsdf', 'License Key', 'General', '', '', 16),
('innerlogo', 'innerlogo.png', 'Inner Logo', 'General', 'file', '', 4),
('theme', 'corporate', '', 'General', '', '', 16),
('pageGroupRelation', '1', 'Relation between Page and Group', 'General', 'checkbox', '', 22),
('galleryForUsers', '1', 'Display Gallery Widget', 'General', 'checkbox', '', 21),
('fb_app_secret', '', 'Facebook App Secret', 'General', '', '', 15),
('sitelabel', 'SocialWare', 'SiteLabel', 'General', '', '', 24),
('sitedescription', 'Your Personalised Social Network Is Here', 'Site Description', 'General', '', '', 25);


--
-- Dumping data for table `tbl_mail_template`
--

INSERT INTO `tbl_mail_template` (`id`, `mail_template_name`, `mail_template_sub`, `mail_template_body`, `mail_template_status`, `created_on`) VALUES
(1, 'invite', 'Invitation to join [SITE_NAME]', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi </span><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"> [EMAIL]</span>,</span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">You have been invited to join [SITE_NAME] by [NAME].<br> <br> </span><br> <br> Login at [SITE_URL].</p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,</span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]Team.</span></p>', 1, '2016-07-21 01:12:58'),
(2, 'user_registration', 'Registration Successful', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi [FIRST_NAME] [LAST_NAME],<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Thank you for registering with&#160; [SITE_NAME]. The login credentials are as follows :<br><br></span><br><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Login : [LOGIN_NAME]<br><br></span></span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.<br> </span></p>', 1, '2014-06-26 11:03:32'),
(3, 'registration_info_admin', 'New Account Created', '<p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">&#160;</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi Administrator,</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">A new user&#160;<strong> [FIRST_NAME] [LAST_NAME]</strong> &#160;is registered with [SITE_NAME].<br><br>Email Address: <strong>[USER_EMAIL]</strong></p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Regards,</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.</p>', 1, '2013-11-21 12:15:08'),
(4, 'forgot_password', 'New Password', '<p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi [FIRST_NAME] [LAST_NAME],</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Your password on [SITE_NAME] has been reset.</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Your new password is:&#160; [PASSWORD]</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Regards,</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.</p>', 1, '2014-07-30 11:15:20'),
(5, 'mailcontainer', 'mailcontainer', '<table width="600" cellspacing="0" cellpadding="0" border="0" style="border:1px solid #ccc; background-color:#FDFDFD; "> <tbody>  <tr> <td width="5">&#160;</td> <td width="586"><table width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td height="56"><table width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td width="2%" height="80">&#160;</td> <td width="37%">[SITE_LOGO]</td> <td width="61%"><p style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#CCCCCC; text-align:right; padding:0 15px 0 0; ">[DATE]</p></td> </tr> </tbody> </table></td> </tr>   <tr> <td>[MAIL_BODY]</td> </tr> <tr> <td><table width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td height="30"><p style="color:#CCC; font-family:Arial, Helvetica, sans-serif; font-size:12px; padding:0 0 0 15px; ">[COPYRIGHT]</p></td> </tr> </tbody> </table></td> </tr> </tbody> </table></td> <td width="4">&#160;</td> </tr> </tbody> </table> <p>&#160;</p>', 1, '2013-11-22 16:18:57'),
(6, 'admin_user_registration', 'Welcome to [SITE_NAME]', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi [FIRST_NAME] &#160;[LAST_NAME],<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">You have been registering with&#160; [SITE_NAME].&#160;<br><br>Login : [EMAIL]<br><br>You Can Login at [SITE_URL]</span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.<br> </span></p>', 1, '2014-06-26 07:10:41'),
(7, 'friend_request', 'Friend request from [NAME]', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi </span><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"> [USER_NAME]</span>,<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">You have a friend request from [NAME].<br><br><a href="[SITE_URL]accept-invitation/[INVITE_ID]/[INVITE_TYPE]/1" target="_blank" src="[SITE_URL]accept-invitation/[INVITE_ID]/[INVITE_TYPE]/1"> Accept Friend Request</a>.<br><br></span>Login at [SITE_URL].</p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]Team.</span>', 1, '2015-10-30 17:25:53'),
(8, 'community_invite', 'Invitation to join [COMMUNITY]', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi </span><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"> [USER_NAME]</span>,<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">You have been invited to join [COMMUNITY] by [NAME].<br><br><a href="[SITE_URL]accept-invitation/[INVITE_ID]/[INVITE_TYPE]/1" target="_blank" src="[SITE_URL]accept-invitation/[INVITE_ID]/[INVITE_TYPE]/1"> <img alt="Accept" src="[IMG_URL]accept.png"></a>&#160;&#160; Invitation<br><br></span>Login at [SITE_URL].</p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]Team.</span>', 1, '2014-07-29 12:33:38'),
(9, 'community_join_invite', 'Invitation to join [COMMUNITY] in [SITE_NAME] ', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi </span><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"> [EMAIL]</span>,<br> </span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><br></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">You have been invited to join [COMMUNITY] in </span></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME] </span>by [NAME].</span><br><br><a href="[SITE_URL]accept-invitation/[INVITE_ID]/[INVITE_TYPE]/1" target="_blank" src="http://ubuntu.armia/bbf/public/fckeditor/editor/[SITE_URL]accept-invitation/[INVITE_ID]/[INVITE_TYPE]/1"> Accept </a> OR <a href="[SITE_URL]accept-invitation/[INVITE_ID]/reject/1" target="_blank" src="http://ubuntu.armia/bbf/public/fckeditor/editor/[SITE_URL]accept-invitation/[INVITE_ID]/reject/1"> Reject </a> invitation.<br><br></span>Login at [SITE_URL].</p>  <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]Team.</span>', 1, '2014-07-17 10:32:06'),
(10, 'admin_approval', 'New [ENTITY] created with [SITE_NAME] pending approval', '<p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi Administrator,<span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"> <br><br>A new&#160;</span><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong>[ENTITY]&#160;</strong> </span><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;">named<strong> [TITLE]</strong> has been created by </span><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong> [NAME] </strong>needs your approval.</span></p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Regards,</p> <p style="font-size: 12;font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.</p>', 1, '2013-12-24 17:20:59'),
(11, 'admin_approved', 'Your [ENTITY] has been approved', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi [FIRST_NAME] &#160;[LAST_NAME],<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Your </span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong>[ENTITY] </strong></span></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;">named<strong> [TITLE]</strong> has been approved by </span></strong></span></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME] Adminstrator.</span></span></strong></span> <br></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><br></span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.</span>', 1, '0000-00-00 00:00:00'),
(12, 'admin_account_activated', 'Your account has been activated', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi [FIRST_NAME] &#160;[LAST_NAME],<br> </span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Your<strong> </strong>account</span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong> </strong></span></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;">has been activated by </span></strong></span></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><strong><span style="color: rgb(51, 51, 51); font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 21px; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; display: inline ! important; float: none;"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME] Adminstrator.</span></span></strong></span> <br></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><br></span></p> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]&#160;Team.</span>', 1, '0000-00-00 00:00:00'),
(13, 'community_join_invite_moderator', 'Invitation to join [COMMUNITY]', '<p><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif">Hi </span><span style="font-size: 12;font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"> </span>,<br> </span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><br></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">An Invitation has been sent to join [COMMUNITY] in </span></span><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif"><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME] </span>by [NAME].</span> <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,<br> </span></p> <span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]Team.</span>', 1, '2014-07-11 05:21:01'),
(37, 'contactus_mail', 'New Contact From [SITE_NAME]', 'Hi,<br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;New contact &#160;from  [SITE_NAME]. Following are the details:<br><br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;E-MAIL &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160; : &#160; [SENDER_EMAIL]<br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;TITLE &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;: &#160;&#160;<strong style="text-align: center;">[SUBJECT]</strong><br><div style="text-align: center;"></div><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;DESCRIPTION &#160; : &#160; [BODY]<br><br><br><p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,</span></p>  <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME] Team.</span></p><br><br><br>', 1, '2016-07-25 19:31:34'),
(38, 'join_private_community', 'Join Request', '<p style="margin: 0px 0px 10px; color: rgb(51, 51, 51); font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 20px;"><span style="font-family: Arial, Helvetica, sans-serif;">Hi [FIRST_NAME] [LAST_NAME],<br></span></p><p style="margin: 0px 0px 10px; color: rgb(51, 51, 51); font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 20px;"><span style="font-family: Arial, Helvetica, sans-serif;">Youn have got a join request from a user named [USER_NAME] in your &#160;[COMMUNITY_NAME]<br></span><br><span style="font-family: Arial, Helvetica, sans-serif;"><br></span></p><p style="margin: 0px 0px 10px; color: rgb(51, 51, 51); font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 20px;"><span style="font-family: Arial, Helvetica, sans-serif;">Regards,<br></span></p><p style="margin: 0px 0px 10px; color: rgb(51, 51, 51); font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 20px;"><span style="font-family: Arial, Helvetica, sans-serif;">[SITE_NAME]Team.</span></p>', 1, '2015-11-27 14:25:49'),
(39, 'referafriend_mail', 'Welcome To [SITE_NAME]', '&#160; Hi,<br><br>[SENDER_NAME]<font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">&#160; invited to join [SITE_NAME]</span></font>,&#160;<span style="font-size: 12px;">Socially connected Business Media that drives relevant business conversations.<br><span style="color: rgb(34, 34, 34); font-family: Consolas, ''Lucida Console'', monospace; font-size: 12px; white-space: pre-wrap;"><br>&#160; </span></span>Please cli<span style="font-size: 12px;"><span style="font-size: 12px;">ck the following link to view more details.</span></span><br>&#160; &#160; &#160; &#160; &#160; <br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;[SITE_URL]<br><br><br>[SITE_LOGO]<br><br>Regards,<br>&#160; &#160; &#160; &#160; &#160;[SITE_NAME] &#160;Team<br><br><br>', 1, '2015-12-16 16:42:35'),
(40, 'refer_friend_community', 'Welcome To [SITE_NAME]', '&#160;Hi,<br><br><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;">You have been invited to join&#160; ''</span><strong><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;">[COMMUNITY_NAME]''</span></strong>. Please <a href="[PAGE_URL]">click here</a> to view more details.<br><br><br>&#160;&#160;<br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; [SITE_LOGO]<br><br><br><br>&#160; &#160; &#160; &#160; &#160;Regards,<br><br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;[SITE_NAME] Team<br>', 1, '2015-12-18 17:11:36'),
(41, 'feedback_mail', 'New Feedback From [SITE_NAME]', 'Hi,<br><br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160; New&#160; feedback from &#160; [SITE_NAME]. Following are the details:<br><br>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; NAME &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160;&#160; : &#160; [SENDER_NAME]<br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;E-MAIL &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160; : &#160; [SENDER_EMAIL]<br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;TITLE &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;: &#160;&#160;<strong style="text-align: center;">[SUBJECT]</strong><br><br>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;DESCRIPTION &#160; : &#160; [BODY]<br><br><p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">Regards,</span></p>  <p><span style="font-size: 12; font-family:Arial, Helvetica, sans-serif">[SITE_NAME]Team.</span></p><br><br>', 1, '2016-07-25 19:24:46'),
(42, 'wertet', 'wrtrwetert', '<p><img alt="" src="http://localhost/bbf/public/ckeditor/plugins/imageuploader/uploads/3a20e80.png" style="width: 365px; height: 138px;" /></p>\r\n\r\n<p>hguhgihui</p>\r\n', 0, '0000-00-00 00:00:00');

--
-- Dumping data for table `tbl_state`
--

INSERT INTO `tbl_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES
(1, 1, 'AL', 'ALABAMA', 'A'),
(2, 1, 'AK', 'ALASKA', 'A'),
(4, 1, 'AZ', 'ARIZONA', 'A'),
(5, 1, 'AR', 'ARKANSAS', 'A'),
(6, 1, 'CA', 'CALIFORNIA', 'A'),
(7, 1, 'CO', 'COLORADO', 'A'),
(8, 1, 'CT', 'CONNECTICUT', 'A'),
(9, 1, 'DE', 'DELAWARE', 'A'),
(10, 1, 'DC', 'DISTRICT OF COLUMBIA', 'A'),
(12, 1, 'FL', 'FLORIDA', 'A'),
(13, 1, 'GA', 'GEORGIA', 'A'),
(15, 1, 'HI', 'HAWAII', 'A'),
(16, 1, 'ID', 'IDAHO', 'A'),
(17, 1, 'IL', 'ILLINOIS', 'A'),
(18, 1, 'IN', 'INDIANA', 'A'),
(19, 1, 'IA', 'IOWA', 'A'),
(20, 1, 'KS', 'KANSAS', 'A'),
(21, 1, 'KY', 'KENTUCKY', 'A'),
(22, 1, 'LA', 'LOUISIANA', 'A'),
(23, 1, 'ME', 'MAINE', 'A'),
(25, 1, 'MD', 'MARYLAND', 'A'),
(26, 1, 'MA', 'MASSACHUSETTS', 'A'),
(27, 1, 'MI', 'MICHIGAN', 'A'),
(28, 1, 'MN', 'MINNESOTA', 'A'),
(29, 1, 'MS', 'MISSISSIPPI', 'A'),
(30, 1, 'MO', 'MISSOURI', 'A'),
(31, 1, 'MT', 'MONTANA', 'A'),
(32, 1, 'NE', 'NEBRASKA', 'A'),
(33, 1, 'NV', 'NEVADA', 'A'),
(34, 1, 'NH', 'NEW HAMPSHIRE', 'A'),
(35, 1, 'NJ', 'NEW JERSEY', 'A'),
(36, 1, 'NM', 'NEW MEXICO', 'A'),
(37, 1, 'NY', 'NEW YORK', 'A'),
(38, 1, 'NC', 'NORTH CAROLINA', 'A'),
(39, 1, 'ND', 'NORTH DAKOTA', 'A'),
(40, 1, 'MP', 'NORTHERN MARIANA ISLANDS', 'A'),
(41, 1, 'OH', 'OHIO', 'A'),
(42, 1, 'OK', 'OKLAHOMA', 'A'),
(43, 1, 'OR', 'OREGON', 'A'),
(44, 1, 'PW', 'PALAU', 'A'),
(45, 1, 'PA', 'PENNSYLVANIA', 'A'),
(46, 1, 'PR', 'PUERTO RICO', 'A'),
(47, 1, 'RI', 'RHODE ISLAND', 'A'),
(48, 1, 'SC', 'SOUTH CAROLINA', 'A'),
(49, 1, 'SD', 'SOUTH DAKOTA', 'A'),
(50, 1, 'TN', 'TENNESSEE', 'A'),
(51, 1, 'TX', 'TEXAS', 'A'),
(52, 1, 'UT', 'UTAH', 'A'),
(53, 1, 'VT', 'VERMONT', 'A'),
(54, 1, 'VI', 'VIRGIN ISLANDS', 'A'),
(55, 1, 'VA', 'VIRGINIA', 'A'),
(56, 1, 'WA', 'WASHINGTON', 'A'),
(57, 1, 'WV', 'WEST VIRGINIA', 'A'),
(58, 1, 'WI', 'WISCONSIN', 'A'),
(59, 1, 'WY', 'WYOMING', 'A'),
(61, 3, 'AB', 'Alberta', 'A'),
(62, 3, 'BC', 'British Columbia', 'A'),
(63, 3, 'MB', 'Manitoba', 'A'),
(64, 3, 'NB', 'New Brunswick', 'A'),
(65, 3, 'NL', 'Newfoundland and Labrador', 'A'),
(67, 3, 'NS', 'Nova Scotia', 'A'),
(69, 3, 'PE', 'Prince Edward Island', 'A'),
(70, 3, 'SK', 'Saskatchewan', 'A'),
(71, 3, 'ON', 'Ontario', 'A'),
(72, 3, 'QC', 'Quebec', 'A'),
(74, 2, 'AP', 'Andhra Pradesh', 'A'),
(75, 2, 'ARP', 'Arunachal Pradesh', 'A'),
(76, 2, 'AM', 'Assam', 'A'),
(77, 2, 'BM', 'Bihar', 'A'),
(78, 2, 'CHH', 'Chhattisgarh', 'A'),
(79, 2, 'ND', 'New Delhi', 'A'),
(80, 2, 'GO', 'Goa', 'A'),
(81, 2, 'GJ', 'Gujarat', 'A'),
(82, 2, 'HA', 'Haryana', 'A'),
(83, 2, 'HP', 'Himachal Pradesh', 'A'),
(84, 2, 'JK', 'Jammu and Kashmir', 'A'),
(85, 2, 'JD', 'Jharkhand', 'A'),
(86, 2, 'KT', 'Karnataka', 'A'),
(87, 2, 'KL', 'Kerala', 'A'),
(88, 2, 'MP', 'Madhya Pradesh', 'A'),
(89, 2, 'MH', 'Maharashtra', 'A'),
(90, 2, 'MN', 'Manipur', 'A'),
(91, 2, 'MG', 'Meghalaya', 'A'),
(93, 2, 'MZ', 'Mizoram', 'A'),
(94, 2, 'NG', 'Nagaland', 'A'),
(95, 2, 'OR', 'Orissa', 'A'),
(96, 2, 'PN', 'Punjab', 'A'),
(97, 2, 'RJ', 'Rajasthan', 'A'),
(98, 2, 'SK', 'Sikkim', 'A'),
(99, 2, 'TN', 'Tamil Nadu', 'A'),
(100, 2, 'TP', 'Tripura', 'A'),
(101, 2, 'UT', 'Uttaranchal', 'A'),
(102, 2, 'UP', 'Uttar Pradesh', 'A'),
(103, 2, 'WB', 'West Bengal', 'A');
INSERT INTO `tbl_lookup` (`settingfield`, `value`, `settinglabel`, `groupLabel`, `type`, `display_order`) VALUES ('chat_display', '0', 'Display Chat', 'General', 'checkbox', 23);


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
