<commit_before>#Meta Plugin for CakePHP 2.x

Meta is an SEO Plugin for CakePHP 2.x which manages title, meta description, and meta keywords for each page in your application.
- - -

##Installation

1.	Put the Meta folder in your App's Plugin folder.
2.	Add the meta table to your database.

		CREATE TABLE `meta` (
		`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
		`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
		`controller` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
		`action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
		`pass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
		`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
		`description` text COLLATE utf8_unicode_ci,
		`keywords` text COLLATE utf8_unicode_ci,
		`created` datetime DEFAULT NULL,
		`modified` datetime DEFAULT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 ;

3.	Call the Meta element in your layout's head.

		<?php echo $this->element('meta', array(), array('plugin' => 'Meta'));?>

##How to Use

Navigate to the Meta admin page: *http://your_domain/admin/meta/meta*

You can add records manually via the form or you can use the link called 'Find New Paths'. This is an initializer which searches your existing pages located under Views/Pages/ and the pages table in your database. The initializer will attempt to extract descriptions as well.

##Meta Record Fields

Given a URL such as *http://your_domain/pages/My-Wonderful-Page-In-Which-I-Explain-All-Things* we can break it down to the following fields stored in the meta table.
<commit_msg>Updated SQL schema to include template field<commit_after>#Meta Plugin for CakePHP 2.x

Meta is an SEO Plugin for CakePHP 2.x which manages title, meta description, and meta keywords for each page in your application.
- - -

##Installation

1.	Put the Meta folder in your App's Plugin folder.
2.	Add the meta table to your database.

		CREATE TABLE `meta` (
		`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
		`template` tinyint(1) NOT NULL DEFAULT '0',
		`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
		`controller` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
		`action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
		`pass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
		`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
		`description` text COLLATE utf8_unicode_ci,
		`keywords` text COLLATE utf8_unicode_ci,
		`created` datetime DEFAULT NULL,
		`modified` datetime DEFAULT NULL,
		PRIMARY KEY (`id`)
		) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 ;

3.	Call the Meta element in your layout's head.

		<?php echo $this->element('meta', array(), array('plugin' => 'Meta'));?>

##How to Use

Navigate to the Meta admin page: *http://your_domain/admin/meta/meta*

You can add records manually via the form or you can use the link called 'Find New Paths'. This is an initializer which searches your existing pages located under Views/Pages/ and the pages table in your database. The initializer will attempt to extract descriptions as well.

##Meta Record Fields

Given a URL such as *http://your_domain/pages/My-Wonderful-Page-In-Which-I-Explain-All-Things* we can break it down to the following fields stored in the meta table.

{'fraction_non_alphanumeric': 0.08533252353477072, 'fraction_numerical': 0.020042514424536896, 'mean_word_length': 4.611584327086883, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '32861', 'n_tokens_mistral': 1128, 'n_tokens_neox': 1006, 'n_words': 418}