[ Index ] |
PHP Cross Reference of Joomla 4.2.2 documentation |
[Summary view] [Print] [Text view]
1 -- 2 -- Table structure for table `#__associations` 3 -- 4 5 CREATE TABLE IF NOT EXISTS "#__associations" ( 6 "id" int NOT NULL, 7 "context" varchar(50) NOT NULL, 8 "key" char(32) NOT NULL, 9 CONSTRAINT "#__associations_idx_context_id" PRIMARY KEY ("context", "id") 10 ); 11 CREATE INDEX "#__associations_idx_key" ON "#__associations" ("key"); 12 13 COMMENT ON COLUMN "#__associations"."id" IS 'A reference to the associated item.'; 14 COMMENT ON COLUMN "#__associations"."context" IS 'The context of the associated item.'; 15 COMMENT ON COLUMN "#__associations"."key" IS 'The key for the association computed from an md5 on associated ids.'; 16 17 -- 18 -- Table structure for table `#__categories` 19 -- 20 21 CREATE TABLE IF NOT EXISTS "#__categories" ( 22 "id" serial NOT NULL, 23 "asset_id" bigint DEFAULT 0 NOT NULL, 24 "parent_id" integer DEFAULT 0 NOT NULL, 25 "lft" bigint DEFAULT 0 NOT NULL, 26 "rgt" bigint DEFAULT 0 NOT NULL, 27 "level" integer DEFAULT 0 NOT NULL, 28 "path" varchar(255) DEFAULT '' NOT NULL, 29 "extension" varchar(50) DEFAULT '' NOT NULL, 30 "title" varchar(255) DEFAULT '' NOT NULL, 31 "alias" varchar(255) DEFAULT '' NOT NULL, 32 "note" varchar(255) DEFAULT '' NOT NULL, 33 "description" text, 34 "published" smallint DEFAULT 0 NOT NULL, 35 "checked_out" integer, 36 "checked_out_time" timestamp without time zone, 37 "access" bigint DEFAULT 0 NOT NULL, 38 "params" text, 39 "metadesc" varchar(1024) DEFAULT '' NOT NULL, 40 "metakey" varchar(1024) DEFAULT '' NOT NULL, 41 "metadata" varchar(2048) DEFAULT '' NOT NULL, 42 "created_user_id" integer DEFAULT 0 NOT NULL, 43 "created_time" timestamp without time zone NOT NULL, 44 "modified_user_id" integer DEFAULT 0 NOT NULL, 45 "modified_time" timestamp without time zone NOT NULL, 46 "hits" integer DEFAULT 0 NOT NULL, 47 "language" varchar(7) DEFAULT '' NOT NULL, 48 "version" bigint DEFAULT 1 NOT NULL, 49 PRIMARY KEY ("id") 50 ); 51 CREATE INDEX "#__categories_cat_idx" ON "#__categories" ("extension", "published", "access"); 52 CREATE INDEX "#__categories_idx_access" ON "#__categories" ("access"); 53 CREATE INDEX "#__categories_idx_checkout" ON "#__categories" ("checked_out"); 54 CREATE INDEX "#__categories_idx_path" ON "#__categories" ("path"); 55 CREATE INDEX "#__categories_idx_left_right" ON "#__categories" ("lft", "rgt"); 56 CREATE INDEX "#__categories_idx_alias" ON "#__categories" ("alias"); 57 CREATE INDEX "#__categories_idx_language" ON "#__categories" ("language"); 58 59 COMMENT ON COLUMN "#__categories"."asset_id" IS 'FK to the #__assets table.'; 60 COMMENT ON COLUMN "#__categories"."metadesc" IS 'The meta description for the page.'; 61 COMMENT ON COLUMN "#__categories"."metakey" IS 'The keywords for the page.'; 62 COMMENT ON COLUMN "#__categories"."metadata" IS 'JSON encoded metadata properties.'; 63 64 -- 65 -- Dumping data for table `#__categories` 66 -- 67 68 INSERT INTO "#__categories" ("id", "asset_id", "parent_id", "lft", "rgt", "level", "path", "extension", "title", "alias", "note", "description", "published", "access", "params", "metadesc", "metakey", "metadata", "created_user_id", "created_time", "modified_user_id", "modified_time", "hits", "language", "version") VALUES 69 (1, 0, 0, 0, 11, 0, '', 'system', 'ROOT', 'root', '', '', 1, 1, '{}', '', '', '{}', 42, CURRENT_TIMESTAMP, 42, CURRENT_TIMESTAMP, 0, '*', 1), 70 (2, 27, 1, 1, 2, 1, 'uncategorised', 'com_content', 'Uncategorised', 'uncategorised', '', '', 1, 1, '{"category_layout":"","image":"","workflow_id":"use_default"}', '', '', '{"author":"","robots":""}', 42, CURRENT_TIMESTAMP, 42, CURRENT_TIMESTAMP, 0, '*', 1), 71 (3, 28, 1, 3, 4, 1, 'uncategorised', 'com_banners', 'Uncategorised', 'uncategorised', '', '', 1, 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, CURRENT_TIMESTAMP, 42, CURRENT_TIMESTAMP, 0, '*', 1), 72 (4, 29, 1, 5, 6, 1, 'uncategorised', 'com_contact', 'Uncategorised', 'uncategorised', '', '', 1, 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, CURRENT_TIMESTAMP, 42, CURRENT_TIMESTAMP, 0, '*', 1), 73 (5, 30, 1, 7, 8, 1, 'uncategorised', 'com_newsfeeds', 'Uncategorised', 'uncategorised', '', '', 1, 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, CURRENT_TIMESTAMP, 42, CURRENT_TIMESTAMP, 0, '*', 1), 74 (7, 32, 1, 9, 10, 1, 'uncategorised', 'com_users', 'Uncategorised', 'uncategorised', '', '', 1, 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, CURRENT_TIMESTAMP, 42, CURRENT_TIMESTAMP, 0, '*', 1); 75 76 SELECT setval('#__categories_id_seq', 8, false); 77 78 -- 79 -- Table structure for table `#__content_types` 80 -- 81 82 CREATE TABLE IF NOT EXISTS "#__content_types" ( 83 "type_id" serial NOT NULL, 84 "type_title" varchar(255) NOT NULL DEFAULT '', 85 "type_alias" varchar(255) NOT NULL DEFAULT '', 86 "table" varchar(2048) NOT NULL DEFAULT '', 87 "rules" text NOT NULL, 88 "field_mappings" text NOT NULL, 89 "router" varchar(255) NOT NULL DEFAULT '', 90 "content_history_options" varchar(5120) DEFAULT NULL, 91 PRIMARY KEY ("type_id") 92 ); 93 CREATE INDEX "#__content_types_idx_alias" ON "#__content_types" ("type_alias"); 94 95 COMMENT ON COLUMN "#__content_types"."content_history_options" IS 'JSON string for com_contenthistory options'; 96 97 -- 98 -- Dumping data for table `#__content_types` 99 -- 100 101 INSERT INTO "#__content_types" ("type_id", "type_title", "type_alias", "table", "rules", "field_mappings", "router", "content_history_options") VALUES 102 (1, 'Article', 'com_content.article', '{"special":{"dbtable":"#__content","key":"id","type":"ArticleTable","prefix":"Joomla\\\\Component\\\\Content\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"state","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"introtext", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"attribs", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "asset_id":"asset_id", "note":"note"}, "special":{"fulltext":"fulltext"}}', 'ContentHelperRoute::getArticleRoute', '{"formFile":"administrator\\/components\\/com_content\\/forms\\/article.xml", "hideFields":["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits", "ordering"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}'), 103 (2, 'Contact', 'com_contact.contact', '{"special":{"dbtable":"#__contact_details","key":"id","type":"ContactTable","prefix":"Joomla\\\\Component\\\\Contact\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"address", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"image", "core_urls":"webpage", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "asset_id":"null"}, "special":{"con_position":"con_position","suburb":"suburb","state":"state","country":"country","postcode":"postcode","telephone":"telephone","fax":"fax","misc":"misc","email_to":"email_to","default_con":"default_con","user_id":"user_id","mobile":"mobile","sortname1":"sortname1","sortname2":"sortname2","sortname3":"sortname3"}}', 'ContactHelperRoute::getContactRoute', '{"formFile":"administrator\\/components\\/com_contact\\/forms\\/contact.xml","hideFields":["default_con","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"], "displayLookup":[ {"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ] }'), 104 (3, 'Newsfeed', 'com_newsfeeds.newsfeed', '{"special":{"dbtable":"#__newsfeeds","key":"id","type":"NewsfeedTable","prefix":"Joomla\\\\Component\\\\Newsfeeds\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "asset_id":"null"}, "special":{"numarticles":"numarticles","cache_time":"cache_time","rtl":"rtl"}}', 'NewsfeedsHelperRoute::getNewsfeedRoute', '{"formFile":"administrator\\/components\\/com_newsfeeds\\/forms\\/newsfeed.xml","hideFields":["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}'), 105 (4, 'User', 'com_users.user', '{"special":{"dbtable":"#__users","key":"id","type":"User","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"null","core_alias":"username","core_created_time":"registerDate","core_modified_time":"lastvisitDate","core_body":"null", "core_hits":"null","core_publish_up":"null","core_publish_down":"null","access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"null", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"null", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "asset_id":"null"}, "special":{}}', '', ''), 106 (5, 'Article Category', 'com_content.category', '{"special":{"dbtable":"#__categories","key":"id","type":"CategoryTable","prefix":"Joomla\\\\Component\\\\Categories\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', 'ContentHelperRoute::getCategoryRoute', '{"formFile":"administrator\\/components\\/com_categories\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'), 107 (6, 'Contact Category', 'com_contact.category', '{"special":{"dbtable":"#__categories","key":"id","type":"CategoryTable","prefix":"Joomla\\\\Component\\\\Categories\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', 'ContactHelperRoute::getCategoryRoute', '{"formFile":"administrator\\/components\\/com_categories\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'), 108 (7, 'Newsfeeds Category', 'com_newsfeeds.category', '{"special":{"dbtable":"#__categories","key":"id","type":"CategoryTable","prefix":"Joomla\\\\Component\\\\Categories\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', 'NewsfeedsHelperRoute::getCategoryRoute', '{"formFile":"administrator\\/components\\/com_categories\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'), 109 (8, 'Tag', 'com_tags.tag', '{"special":{"dbtable":"#__tags","key":"tag_id","type":"TagTable","prefix":"Joomla\\\\Component\\\\Tags\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"null", "asset_id":"null"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path"}}', 'TagsHelperRoute::getTagRoute', '{"formFile":"administrator\\/components\\/com_tags\\/forms\\/tag.xml", "hideFields":["checked_out","checked_out_time","version", "lft", "rgt", "level", "path", "urls", "publish_up", "publish_down"],"ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}'), 110 (9, 'Banner', 'com_banners.banner', '{"special":{"dbtable":"#__banners","key":"id","type":"BannerTable","prefix":"Joomla\\\\Component\\\\Banners\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"null","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "asset_id":"null"}, "special":{"imptotal":"imptotal", "impmade":"impmade", "clicks":"clicks", "clickurl":"clickurl", "custombannercode":"custombannercode", "cid":"cid", "purchase_type":"purchase_type", "track_impressions":"track_impressions", "track_clicks":"track_clicks"}}', '','{"formFile":"administrator\\/components\\/com_banners\\/forms\\/banner.xml", "hideFields":["checked_out","checked_out_time","version", "reset"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "imptotal", "impmade", "reset"], "convertToInt":["publish_up", "publish_down", "ordering"], "displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"cid","targetTable":"#__banner_clients","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}'), 111 (10, 'Banners Category', 'com_banners.category', '{"special":{"dbtable":"#__categories","key":"id","type":"CategoryTable","prefix":"Joomla\\\\Component\\\\Categories\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "asset_id":"asset_id"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}','','{"formFile":"administrator\\/components\\/com_categories\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"], "convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'), 112 (11, 'Banner Client', 'com_banners.client', '{"special":{"dbtable":"#__banner_clients","key":"id","type":"ClientTable","prefix":"Joomla\\\\Component\\\\Banners\\\\Administrator\\\\Table\\\\"}}', '', '', '', '{"formFile":"administrator\\/components\\/com_banners\\/forms\\/client.xml", "hideFields":["checked_out","checked_out_time"], "ignoreChanges":["checked_out", "checked_out_time"], "convertToInt":[], "displayLookup":[]}'), 113 (12, 'User Notes', 'com_users.note', '{"special":{"dbtable":"#__user_notes","key":"id","type":"NoteTable","prefix":"Joomla\\\\Component\\\\Users\\\\Administrator\\\\Table\\\\"}}', '', '', '', '{"formFile":"administrator\\/components\\/com_users\\/forms\\/note.xml", "hideFields":["checked_out","checked_out_time", "publish_up", "publish_down"],"ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time"], "convertToInt":["publish_up", "publish_down"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}'), 114 (13, 'User Notes Category', 'com_users.category', '{"special":{"dbtable":"#__categories","key":"id","type":"CategoryTable","prefix":"Joomla\\\\Component\\\\Categories\\\\Administrator\\\\Table\\\\","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"Joomla\\\\CMS\\\\Table\\\\","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', '', '{"formFile":"administrator\\/components\\/com_categories\\/forms\\/category.xml", "hideFields":["checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"], "convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'); 115 116 SELECT setval('#__content_types_type_id_seq', 10000, false); 117 118 -- 119 -- Table structure for table `#__contentitem_tag_map` 120 -- 121 122 CREATE TABLE IF NOT EXISTS "#__contentitem_tag_map" ( 123 "type_alias" varchar(255) NOT NULL DEFAULT '', 124 "core_content_id" integer NOT NULL, 125 "content_item_id" integer NOT NULL, 126 "tag_id" integer NOT NULL, 127 "tag_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 128 "type_id" integer NOT NULL, 129 PRIMARY KEY ("type_id", "content_item_id", "tag_id") 130 ); 131 CREATE INDEX "#__contentitem_tag_map_idx_tag_type" ON "#__contentitem_tag_map" ("tag_id", "type_id"); 132 CREATE INDEX "#__contentitem_tag_map_idx_date_id" ON "#__contentitem_tag_map" ("tag_date", "tag_id"); 133 CREATE INDEX "#__contentitem_tag_map_idx_core_content_id" ON "#__contentitem_tag_map" ("core_content_id"); 134 135 COMMENT ON COLUMN "#__contentitem_tag_map"."core_content_id" IS 'PK from the core content table'; 136 COMMENT ON COLUMN "#__contentitem_tag_map"."content_item_id" IS 'PK from the content type table'; 137 COMMENT ON COLUMN "#__contentitem_tag_map"."tag_id" IS 'PK from the tag table'; 138 COMMENT ON COLUMN "#__contentitem_tag_map"."tag_date" IS 'Date of most recent save for this tag-item'; 139 COMMENT ON COLUMN "#__contentitem_tag_map"."type_id" IS 'PK from the content_type table'; 140 141 -- 142 -- Table structure for table `#__fields` 143 -- 144 145 CREATE TABLE IF NOT EXISTS "#__fields" ( 146 "id" serial NOT NULL, 147 "asset_id" bigint DEFAULT 0 NOT NULL, 148 "context" varchar(255) DEFAULT '' NOT NULL, 149 "group_id" bigint DEFAULT 0 NOT NULL, 150 "title" varchar(255) DEFAULT '' NOT NULL, 151 "name" varchar(255) DEFAULT '' NOT NULL, 152 "label" varchar(255) DEFAULT '' NOT NULL, 153 "default_value" text, 154 "type" varchar(255) DEFAULT 'text' NOT NULL, 155 "note" varchar(255) DEFAULT '' NOT NULL, 156 "description" text NOT NULL, 157 "state" smallint DEFAULT 0 NOT NULL, 158 "required" smallint DEFAULT 0 NOT NULL, 159 "only_use_in_subform" smallint DEFAULT 0 NOT NULL, 160 "checked_out" integer, 161 "checked_out_time" timestamp without time zone, 162 "ordering" bigint DEFAULT 0 NOT NULL, 163 "params" text NOT NULL, 164 "fieldparams" text NOT NULL, 165 "language" varchar(7) DEFAULT '' NOT NULL, 166 "created_time" timestamp without time zone NOT NULL, 167 "created_user_id" bigint DEFAULT 0 NOT NULL, 168 "modified_time" timestamp without time zone NOT NULL, 169 "modified_by" bigint DEFAULT 0 NOT NULL, 170 "access" bigint DEFAULT 0 NOT NULL, 171 PRIMARY KEY ("id") 172 ); 173 CREATE INDEX "#__fields_idx_checked_out" ON "#__fields" ("checked_out"); 174 CREATE INDEX "#__fields_idx_state" ON "#__fields" ("state"); 175 CREATE INDEX "#__fields_idx_created_user_id" ON "#__fields" ("created_user_id"); 176 CREATE INDEX "#__fields_idx_access" ON "#__fields" ("access"); 177 CREATE INDEX "#__fields_idx_context" ON "#__fields" ("context"); 178 CREATE INDEX "#__fields_idx_language" ON "#__fields" ("language"); 179 180 -- 181 -- Table structure for table `#__fields_categories` 182 -- 183 184 CREATE TABLE IF NOT EXISTS "#__fields_categories" ( 185 "field_id" bigint DEFAULT 0 NOT NULL, 186 "category_id" bigint DEFAULT 0 NOT NULL, 187 PRIMARY KEY ("field_id", "category_id") 188 ); 189 190 -- 191 -- Table structure for table `#__fields_groups` 192 -- 193 194 CREATE TABLE IF NOT EXISTS "#__fields_groups" ( 195 "id" serial NOT NULL, 196 "asset_id" bigint DEFAULT 0 NOT NULL, 197 "context" varchar(255) DEFAULT '' NOT NULL, 198 "title" varchar(255) DEFAULT '' NOT NULL, 199 "note" varchar(255) DEFAULT '' NOT NULL, 200 "description" text NOT NULL, 201 "state" smallint DEFAULT 0 NOT NULL, 202 "checked_out" integer, 203 "checked_out_time" timestamp without time zone, 204 "ordering" integer DEFAULT 0 NOT NULL, 205 "params" text NOT NULL, 206 "language" varchar(7) DEFAULT '' NOT NULL, 207 "created" timestamp without time zone NOT NULL, 208 "created_by" bigint DEFAULT 0 NOT NULL, 209 "modified" timestamp without time zone NOT NULL, 210 "modified_by" bigint DEFAULT 0 NOT NULL, 211 "access" bigint DEFAULT 1 NOT NULL, 212 PRIMARY KEY ("id") 213 ); 214 CREATE INDEX "#__fields_groups_idx_checked_out" ON "#__fields_groups" ("checked_out"); 215 CREATE INDEX "#__fields_groups_idx_state" ON "#__fields_groups" ("state"); 216 CREATE INDEX "#__fields_groups_idx_created_by" ON "#__fields_groups" ("created_by"); 217 CREATE INDEX "#__fields_groups_idx_access" ON "#__fields_groups" ("access"); 218 CREATE INDEX "#__fields_groups_idx_context" ON "#__fields_groups" ("context"); 219 CREATE INDEX "#__fields_groups_idx_language" ON "#__fields_groups" ("language"); 220 221 -- 222 -- Table structure for table `#__fields_values` 223 -- 224 225 CREATE TABLE IF NOT EXISTS "#__fields_values" ( 226 "field_id" bigint DEFAULT 0 NOT NULL, 227 "item_id" varchar(255) DEFAULT '' NOT NULL, 228 "value" text 229 ); 230 CREATE INDEX "#__fields_values_idx_field_id" ON "#__fields_values" ("field_id"); 231 CREATE INDEX "#__fields_values_idx_item_id" ON "#__fields_values" ("item_id"); 232 233 -- 234 -- Table structure for table `#__overrider` 235 -- 236 237 CREATE TABLE IF NOT EXISTS "#__overrider" ( 238 "id" serial NOT NULL, 239 "constant" varchar(255) NOT NULL, 240 "string" text NOT NULL, 241 "file" varchar(255) NOT NULL, 242 PRIMARY KEY ("id") 243 ); 244 245 COMMENT ON COLUMN "#__overrider"."id" IS 'Primary Key'; 246 247 -- 248 -- Table structure for table `#__postinstall_messages` 249 -- 250 251 CREATE TABLE IF NOT EXISTS "#__postinstall_messages" ( 252 "postinstall_message_id" serial NOT NULL, 253 "extension_id" bigint NOT NULL DEFAULT 700, 254 "title_key" varchar(255) NOT NULL DEFAULT '', 255 "description_key" varchar(255) NOT NULL DEFAULT '', 256 "action_key" varchar(255) NOT NULL DEFAULT '', 257 "language_extension" varchar(255) NOT NULL DEFAULT 'com_postinstall', 258 "language_client_id" smallint NOT NULL DEFAULT 1, 259 "type" varchar(10) NOT NULL DEFAULT 'link', 260 "action_file" varchar(255) DEFAULT '', 261 "action" varchar(255) DEFAULT '', 262 "condition_file" varchar(255) DEFAULT NULL, 263 "condition_method" varchar(255) DEFAULT NULL, 264 "version_introduced" varchar(255) NOT NULL DEFAULT '3.2.0', 265 "enabled" smallint NOT NULL DEFAULT 1, 266 PRIMARY KEY ("postinstall_message_id") 267 ); 268 269 COMMENT ON COLUMN "#__postinstall_messages"."extension_id" IS 'FK to jos_extensions'; 270 COMMENT ON COLUMN "#__postinstall_messages"."title_key" IS 'Lang key for the title'; 271 COMMENT ON COLUMN "#__postinstall_messages"."description_key" IS 'Lang key for description'; 272 COMMENT ON COLUMN "#__postinstall_messages"."language_extension" IS 'Extension holding lang keys'; 273 COMMENT ON COLUMN "#__postinstall_messages"."type" IS 'Message type - message, link, action'; 274 COMMENT ON COLUMN "#__postinstall_messages"."action_file" IS 'RAD URI to the PHP file containing action method'; 275 COMMENT ON COLUMN "#__postinstall_messages"."action" IS 'Action method name or URL'; 276 COMMENT ON COLUMN "#__postinstall_messages"."condition_file" IS 'RAD URI to file holding display condition method'; 277 COMMENT ON COLUMN "#__postinstall_messages"."condition_method" IS 'Display condition method, must return boolean'; 278 COMMENT ON COLUMN "#__postinstall_messages"."version_introduced" IS 'Version when this message was introduced'; 279 280 -- 281 -- Dumping data for table `#__postinstall_messages` 282 -- 283 284 INSERT INTO "#__postinstall_messages" ("extension_id", "title_key", "description_key", "action_key", "language_extension", "language_client_id", "type", "action_file", "action", "condition_file", "condition_method", "version_introduced", "enabled") 285 SELECT "extension_id", 'COM_CPANEL_WELCOME_BEGINNERS_TITLE', 'COM_CPANEL_WELCOME_BEGINNERS_MESSAGE', '', 'com_cpanel', 1, 'message', '', '', '', '', '3.2.0', 1 FROM "#__extensions" WHERE "name" = 'files_joomla'; 286 INSERT INTO "#__postinstall_messages" ("extension_id", "title_key", "description_key", "action_key", "language_extension", "language_client_id", "type", "action_file", "action", "condition_file", "condition_method", "version_introduced", "enabled") 287 SELECT "extension_id", 'COM_CPANEL_MSG_STATS_COLLECTION_TITLE', 'COM_CPANEL_MSG_STATS_COLLECTION_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/statscollection.php', 'admin_postinstall_statscollection_condition', '3.5.0', 1 FROM "#__extensions" WHERE "name" = 'files_joomla'; 288 INSERT INTO "#__postinstall_messages" ("extension_id", "title_key", "description_key", "action_key", "language_extension", "language_client_id", "type", "action_file", "action", "condition_file", "condition_method", "version_introduced", "enabled") 289 SELECT "extension_id", 'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME', 'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME_BODY', 'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME_ACTION', 'plg_system_updatenotification', 1, 'action', 'site://plugins/system/updatenotification/postinstall/updatecachetime.php', 'updatecachetime_postinstall_action', 'site://plugins/system/updatenotification/postinstall/updatecachetime.php', 'updatecachetime_postinstall_condition', '3.6.3', 1 FROM "#__extensions" WHERE "name" = 'files_joomla'; 290 INSERT INTO "#__postinstall_messages" ("extension_id", "title_key", "description_key", "action_key", "language_extension", "language_client_id", "type", "action_file", "action", "condition_file", "condition_method", "version_introduced", "enabled") 291 SELECT "extension_id", 'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_TITLE', 'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_BODY', 'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_ACTION', 'plg_system_httpheaders', 1, 'action', 'site://plugins/system/httpheaders/postinstall/introduction.php', 'httpheaders_postinstall_action', 'site://plugins/system/httpheaders/postinstall/introduction.php', 'httpheaders_postinstall_condition', '4.0.0', 1 FROM "#__extensions" WHERE "name" = 'files_joomla'; 292 INSERT INTO "#__postinstall_messages" ("extension_id", "title_key", "description_key", "action_key", "language_extension", "language_client_id", "type", "action_file", "action", "condition_file", "condition_method", "version_introduced", "enabled") 293 SELECT "extension_id", 'COM_USERS_POSTINSTALL_MULTIFACTORAUTH_TITLE', 'COM_USERS_POSTINSTALL_MULTIFACTORAUTH_BODY', 'COM_USERS_POSTINSTALL_MULTIFACTORAUTH_ACTION', 'com_users', 1, 'action', 'admin://components/com_users/postinstall/multifactorauth.php', 'com_users_postinstall_mfa_action', 'admin://components/com_users/postinstall/multifactorauth.php', 'com_users_postinstall_mfa_condition', '4.2.0', 1 FROM "#__extensions" WHERE "name" = 'files_joomla'; 294 295 -- 296 -- Table structure for table `#__ucm_base` 297 -- 298 299 CREATE TABLE IF NOT EXISTS "#__ucm_base" ( 300 "ucm_id" serial NOT NULL, 301 "ucm_item_id" bigint NOT NULL, 302 "ucm_type_id" bigint NOT NULL, 303 "ucm_language_id" bigint NOT NULL, 304 PRIMARY KEY ("ucm_id") 305 ); 306 CREATE INDEX "#__ucm_base_ucm_item_id" ON "#__ucm_base" ("ucm_item_id"); 307 CREATE INDEX "#__ucm_base_ucm_type_id" ON "#__ucm_base" ("ucm_type_id"); 308 CREATE INDEX "#__ucm_base_ucm_language_id" ON "#__ucm_base" ("ucm_language_id"); 309 310 -- 311 -- Table structure for table `#__ucm_content` 312 -- 313 314 CREATE TABLE IF NOT EXISTS "#__ucm_content" ( 315 "core_content_id" serial NOT NULL, 316 "core_type_alias" varchar(255) DEFAULT '' NOT NULL, 317 "core_title" varchar(255) DEFAULT '' NOT NULL, 318 "core_alias" varchar(255) DEFAULT '' NOT NULL, 319 "core_body" text, 320 "core_state" smallint DEFAULT 0 NOT NULL, 321 "core_checked_out_time" timestamp without time zone, 322 "core_checked_out_user_id" integer, 323 "core_access" bigint DEFAULT 0 NOT NULL, 324 "core_params" text, 325 "core_featured" smallint DEFAULT 0 NOT NULL, 326 "core_metadata" text, 327 "core_created_user_id" bigint DEFAULT 0 NOT NULL, 328 "core_created_by_alias" varchar(255) DEFAULT '' NOT NULL, 329 "core_created_time" timestamp without time zone NOT NULL, 330 "core_modified_user_id" bigint DEFAULT 0 NOT NULL, 331 "core_modified_time" timestamp without time zone NOT NULL, 332 "core_language" varchar(7) DEFAULT '' NOT NULL, 333 "core_publish_up" timestamp without time zone, 334 "core_publish_down" timestamp without time zone, 335 "core_content_item_id" bigint DEFAULT 0 NOT NULL, 336 "asset_id" bigint DEFAULT 0 NOT NULL, 337 "core_images" text, 338 "core_urls" text, 339 "core_hits" bigint DEFAULT 0 NOT NULL, 340 "core_version" bigint DEFAULT 1 NOT NULL, 341 "core_ordering" bigint DEFAULT 0 NOT NULL, 342 "core_metakey" text, 343 "core_metadesc" text, 344 "core_catid" bigint DEFAULT 0 NOT NULL, 345 "core_type_id" bigint DEFAULT 0 NOT NULL, 346 PRIMARY KEY ("core_content_id"), 347 CONSTRAINT "#__ucm_content_idx_type_alias_item_id" UNIQUE ("core_type_alias", "core_content_item_id") 348 ); 349 CREATE INDEX "#__ucm_content_tag_idx" ON "#__ucm_content" ("core_state", "core_access"); 350 CREATE INDEX "#__ucm_content_idx_access" ON "#__ucm_content" ("core_access"); 351 CREATE INDEX "#__ucm_content_idx_alias" ON "#__ucm_content" ("core_alias"); 352 CREATE INDEX "#__ucm_content_idx_language" ON "#__ucm_content" ("core_language"); 353 CREATE INDEX "#__ucm_content_idx_title" ON "#__ucm_content" ("core_title"); 354 CREATE INDEX "#__ucm_content_idx_modified_time" ON "#__ucm_content" ("core_modified_time"); 355 CREATE INDEX "#__ucm_content_idx_created_time" ON "#__ucm_content" ("core_created_time"); 356 CREATE INDEX "#__ucm_content_idx_content_type" ON "#__ucm_content" ("core_type_alias"); 357 CREATE INDEX "#__ucm_content_idx_core_modified_user_id" ON "#__ucm_content" ("core_modified_user_id"); 358 CREATE INDEX "#__ucm_content_idx_core_checked_out_user_id" ON "#__ucm_content" ("core_checked_out_user_id"); 359 CREATE INDEX "#__ucm_content_idx_core_created_user_id" ON "#__ucm_content" ("core_created_user_id"); 360 CREATE INDEX "#__ucm_content_idx_core_type_id" ON "#__ucm_content" ("core_type_id"); 361 362 -- 363 -- Table structure for table `#__history` 364 -- 365 366 CREATE TABLE IF NOT EXISTS "#__history" ( 367 "version_id" serial NOT NULL, 368 "item_id" varchar(50) NOT NULL, 369 "version_note" varchar(255) NOT NULL DEFAULT '', 370 "save_date" timestamp with time zone NOT NULL, 371 "editor_user_id" integer NOT NULL DEFAULT 0, 372 "character_count" integer NOT NULL DEFAULT 0, 373 "sha1_hash" varchar(50) NOT NULL DEFAULT '', 374 "version_data" text NOT NULL, 375 "keep_forever" smallint NOT NULL DEFAULT 0, 376 PRIMARY KEY ("version_id") 377 ); 378 CREATE INDEX "#__history_idx_ucm_item_id" ON "#__history" ("item_id"); 379 CREATE INDEX "#__history_idx_save_date" ON "#__history" ("save_date"); 380 381 COMMENT ON COLUMN "#__history"."version_note" IS 'Optional version name'; 382 COMMENT ON COLUMN "#__history"."character_count" IS 'Number of characters in this version.'; 383 COMMENT ON COLUMN "#__history"."sha1_hash" IS 'SHA1 hash of the version_data column.'; 384 COMMENT ON COLUMN "#__history"."version_data" IS 'json-encoded string of version data'; 385 COMMENT ON COLUMN "#__history"."keep_forever" IS '0=auto delete; 1=keep'; 386 387 -- 388 -- Table structure for table `#__webauthn_credentials` 389 -- 390 391 CREATE TABLE IF NOT EXISTS "#__webauthn_credentials" ( 392 "id" varchar(1000) NOT NULL, 393 "user_id" varchar(128) NOT NULL, 394 "label" varchar(190) NOT NULL, 395 "credential" TEXT NOT NULL, 396 PRIMARY KEY ("id") 397 ); 398 399 CREATE INDEX "#__webauthn_credentials_user_id" ON "#__webauthn_credentials" ("user_id"); 400 401 -- 402 -- Table structure for table `#__mail_templates` 403 -- 404 405 CREATE TABLE IF NOT EXISTS "#__mail_templates" ( 406 "template_id" varchar(127) NOT NULL DEFAULT '', 407 "extension" varchar(127) NOT NULL DEFAULT '', 408 "language" char(7) NOT NULL DEFAULT '', 409 "subject" varchar(255) NOT NULL DEFAULT '', 410 "body" TEXT NOT NULL, 411 "htmlbody" TEXT NOT NULL, 412 "attachments" TEXT NOT NULL, 413 "params" TEXT NOT NULL, 414 CONSTRAINT "#__mail_templates_idx_template_id_language" UNIQUE ("template_id", "language") 415 ); 416 CREATE INDEX "#__mail_templates_idx_template_id" ON "#__mail_templates" ("template_id"); 417 CREATE INDEX "#__mail_templates_idx_language" ON "#__mail_templates" ("language"); 418 419 -- 420 -- Dumping data for table `#__mail_templates` 421 -- 422 423 INSERT INTO "#__mail_templates" ("template_id", "extension", "language", "subject", "body", "htmlbody", "attachments", "params") VALUES 424 ('com_config.test_mail', 'com_config', '', 'COM_CONFIG_SENDMAIL_SUBJECT', 'COM_CONFIG_SENDMAIL_BODY', '', '', '{"tags":["sitename","method"]}'), 425 ('com_contact.mail', 'com_contact', '', 'COM_CONTACT_ENQUIRY_SUBJECT', 'COM_CONTACT_ENQUIRY_TEXT', '', '', '{"tags":["sitename","name","email","subject","body","url","customfields"]}'), 426 ('com_contact.mail.copy', 'com_contact', '', 'COM_CONTACT_COPYSUBJECT_OF', 'COM_CONTACT_COPYTEXT_OF', '', '', '{"tags":["sitename","name","email","subject","body","url","customfields","contactname"]}'), 427 ('com_users.massmail.mail', 'com_users', '', 'COM_USERS_MASSMAIL_MAIL_SUBJECT', 'COM_USERS_MASSMAIL_MAIL_BODY', '', '', '{"tags":["subject","body","subjectprefix","bodysuffix"]}'), 428 ('com_users.password_reset', 'com_users', '', 'COM_USERS_EMAIL_PASSWORD_RESET_SUBJECT', 'COM_USERS_EMAIL_PASSWORD_RESET_BODY', '', '', '{"tags":["name","email","sitename","link_text","link_html","token"]}'), 429 ('com_users.reminder', 'com_users', '', 'COM_USERS_EMAIL_USERNAME_REMINDER_SUBJECT', 'COM_USERS_EMAIL_USERNAME_REMINDER_BODY', '', '', '{"tags":["name","username","sitename","email","link_text","link_html"]}'), 430 ('plg_system_updatenotification.mail', 'plg_system_updatenotification', '', 'PLG_SYSTEM_UPDATENOTIFICATION_EMAIL_SUBJECT', 'PLG_SYSTEM_UPDATENOTIFICATION_EMAIL_BODY', '', '', '{"tags":["newversion","curversion","sitename","url","link","releasenews"]}'), 431 ('plg_user_joomla.mail', 'plg_user_joomla', '', 'PLG_USER_JOOMLA_NEW_USER_EMAIL_SUBJECT', 'PLG_USER_JOOMLA_NEW_USER_EMAIL_BODY', '', '', '{"tags":["name","sitename","url","username","password","email"]}'), 432 ('com_actionlogs.notification', 'com_actionlogs', '', 'COM_ACTIONLOGS_EMAIL_SUBJECT', 'COM_ACTIONLOGS_EMAIL_BODY', 'COM_ACTIONLOGS_EMAIL_HTMLBODY', '', '{"tags":["message","date","extension","username"]}'), 433 ('com_privacy.userdataexport', 'com_privacy', '', 'COM_PRIVACY_EMAIL_DATA_EXPORT_COMPLETED_SUBJECT', 'COM_PRIVACY_EMAIL_DATA_EXPORT_COMPLETED_BODY', '', '', '{"tags":["sitename","url"]}'), 434 ('com_privacy.notification.export', 'com_privacy', '', 'COM_PRIVACY_EMAIL_REQUEST_SUBJECT_EXPORT_REQUEST', 'COM_PRIVACY_EMAIL_REQUEST_BODY_EXPORT_REQUEST', '', '', '{"tags":["sitename","url","tokenurl","formurl","token"]}'), 435 ('com_privacy.notification.remove', 'com_privacy', '', 'COM_PRIVACY_EMAIL_REQUEST_SUBJECT_REMOVE_REQUEST', 'COM_PRIVACY_EMAIL_REQUEST_BODY_REMOVE_REQUEST', '', '', '{"tags":["sitename","url","tokenurl","formurl","token"]}'), 436 ('com_privacy.notification.admin.export', 'com_privacy', '', 'COM_PRIVACY_EMAIL_ADMIN_REQUEST_SUBJECT_EXPORT_REQUEST', 'COM_PRIVACY_EMAIL_ADMIN_REQUEST_BODY_EXPORT_REQUEST', '', '', '{"tags":["sitename","url","tokenurl","formurl","token"]}'), 437 ('com_privacy.notification.admin.remove', 'com_privacy', '', 'COM_PRIVACY_EMAIL_ADMIN_REQUEST_SUBJECT_REMOVE_REQUEST', 'COM_PRIVACY_EMAIL_ADMIN_REQUEST_BODY_REMOVE_REQUEST', '', '', '{"tags":["sitename","url","tokenurl","formurl","token"]}'), 438 ('com_users.registration.user.admin_activation', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_WITH_ADMIN_ACTIVATION_BODY_NOPW', '', '', '{"tags":["name","sitename","activate","siteurl","username"]}'), 439 ('com_users.registration.user.admin_activation_w_pw', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_WITH_ADMIN_ACTIVATION_BODY', '', '', '{"tags":["name","sitename","activate","siteurl","username","password_clear"]}'), 440 ('com_users.registration.user.self_activation', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_WITH_ACTIVATION_BODY_NOPW', '', '', '{"tags":["name","sitename","activate","siteurl","username"]}'), 441 ('com_users.registration.user.self_activation_w_pw', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_WITH_ACTIVATION_BODY', '', '', '{"tags":["name","sitename","activate","siteurl","username","password_clear"]}'), 442 ('com_users.registration.user.registration_mail', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_BODY_NOPW', '', '', '{"tags":["name","sitename","activate","siteurl","username"]}'), 443 ('com_users.registration.user.registration_mail_w_pw', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_BODY', '', '', '{"tags":["name","sitename","activate","siteurl","username","password_clear"]}'), 444 ('com_users.registration.admin.new_notification', 'com_users', '', 'COM_USERS_EMAIL_ACCOUNT_DETAILS', 'COM_USERS_EMAIL_REGISTERED_NOTIFICATION_TO_ADMIN_BODY', '', '', '{"tags":["name","sitename","siteurl","username"]}'), 445 ('com_users.registration.user.admin_activated', 'com_users', '', 'COM_USERS_EMAIL_ACTIVATED_BY_ADMIN_ACTIVATION_SUBJECT', 'COM_USERS_EMAIL_ACTIVATED_BY_ADMIN_ACTIVATION_BODY', '', '', '{"tags":["name","sitename","siteurl","username"]}'), 446 ('com_users.registration.admin.verification_request', 'com_users', '', 'COM_USERS_EMAIL_ACTIVATE_WITH_ADMIN_ACTIVATION_SUBJECT', 'COM_USERS_EMAIL_ACTIVATE_WITH_ADMIN_ACTIVATION_BODY', '', '', '{"tags":["name","sitename","email","username","activate"]}'), 447 ('plg_system_privacyconsent.request.reminder', 'plg_system_privacyconsent', '', 'PLG_SYSTEM_PRIVACYCONSENT_EMAIL_REMIND_SUBJECT', 'PLG_SYSTEM_PRIVACYCONSENT_EMAIL_REMIND_BODY', '', '', '{"tags":["sitename","url","tokenurl","formurl","token"]}'), 448 ('com_messages.new_message', 'com_messages', '', 'COM_MESSAGES_NEW_MESSAGE', 'COM_MESSAGES_NEW_MESSAGE_BODY', '', '', '{"tags":["subject","message","fromname","sitename","siteurl","fromemail","toname","toemail"]}'), 449 ('plg_system_tasknotification.failure_mail', 'plg_system_tasknotification', '', 'PLG_SYSTEM_TASK_NOTIFICATION_FAILURE_MAIL_SUBJECT', 'PLG_SYSTEM_TASK_NOTIFICATION_FAILURE_MAIL_BODY', '', '', '{"tags": ["task_id", "task_title", "exit_code", "exec_data_time", "task_output"]}'), 450 ('plg_system_tasknotification.fatal_recovery_mail', 'plg_system_tasknotification', '', 'PLG_SYSTEM_TASK_NOTIFICATION_FATAL_MAIL_SUBJECT', 'PLG_SYSTEM_TASK_NOTIFICATION_FATAL_MAIL_BODY', '', '', '{"tags": ["task_id", "task_title"]}'), 451 ('plg_system_tasknotification.orphan_mail', 'plg_system_tasknotification', '', 'PLG_SYSTEM_TASK_NOTIFICATION_ORPHAN_MAIL_SUBJECT', 'PLG_SYSTEM_TASK_NOTIFICATION_ORPHAN_MAIL_BODY', '', '', '{"tags": ["task_id", "task_title"]}'), 452 ('plg_system_tasknotification.success_mail', 'plg_system_tasknotification', '', 'PLG_SYSTEM_TASK_NOTIFICATION_SUCCESS_MAIL_SUBJECT', 'PLG_SYSTEM_TASK_NOTIFICATION_SUCCESS_MAIL_BODY', '', '', '{"tags":["task_id", "task_title", "exec_data_time", "task_output"]}'), 453 ('plg_multifactorauth_email.mail', 'plg_multifactorauth_email', '', 'PLG_MULTIFACTORAUTH_EMAIL_EMAIL_SUBJECT', 'PLG_MULTIFACTORAUTH_EMAIL_EMAIL_BODY', '', '', '{"tags":["code","sitename","siteurl","username","email","fullname"]}');
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Wed Sep 7 05:41:13 2022 | Chilli.vc Blog - For Webmaster,Blog-Writer,System Admin and Domainer |