PRIMARY KEY, title VARCHAR(50), body TEXT, created DATETIME DEFAULT NULL, modified DATETIME DEFAULT NULL ); /* Then insert some posts for testing: */ INSERT INTO posts (title, body, created) VALUES ('The title', 'This is the post body.', NOW()); INSERT INTO posts (title, body, created) VALUES ('A title once again', 'And the post body follows.', NOW()); INSERT INTO posts (title, body, created) created) VALUES ('Title strikes back', 'This is really exciting! Not.', NOW()); The choices on table and column names are not arbitrary. If you follow CakePHP’s database naming conventions, and CakePHP’s

AUTO_INCREMENT PRIMARY KEY, title VARCHAR(50), body TEXT, created DATETIME DEFAULT NULL, modified DATETIME DEFAULT NULL ); /* Then insert some posts for testing: */ INSERT INTO posts (title, body, created) VALUES VALUES ('The title', 'This is the post body.', NOW()); INSERT INTO posts (title, body, created) VALUES ('A title once again', 'And the post body follows.', NOW()); INSERT INTO posts (title, body, created) created) VALUES ('Title strikes back', 'This is really exciting! Not.', NOW()); The choices on table and column names are not arbitrary. If you follow CakePHP’s database naming conventions, and CakePHP’s class

this->Html->link(), you can use the following conventions for the url array: $this->Html->link('link-title', [ 'prefix' => 'MyPrefix' // CamelCased 'plugin' => 'MyPlugin', // CamelCased 'controller' ); CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE CREATE TABLE tags ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(191), created DATETIME, modified DATETIME, UNIQUE KEY (title) ) CHARSET=utf8mb4; CREATE TABLE articles_tags ( article_id

this->Html->link(), you can use the following conventions for the url array: $this->Html->link('link-title', [ 'prefix' => 'MyPrefix' // CamelCased 'plugin' => 'MyPlugin', // CamelCased 'controller' => 'ControllerName' modified DATETIME ); CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE, created REFERENCES users(id) ) CHARSET=utf8mb4; CREATE TABLE tags ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(191), (continues on next page) CMS Tutorial - Creating the Database 17 CakePHP Cookbook

this->Html->link(), you can use the following conventions for the url array: $this->Html->link('link-title', [ 'prefix' => 'MyPrefix' // PascalCased 'plugin' => 'MyPlugin', // PascalCased 'controller' DATETIME ); CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE CREATE TABLE tags ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(191), created DATETIME, modified DATETIME, UNIQUE KEY (title) ) CHARSET=utf8mb4; CREATE TABLE articles_tags ( article_id

this->Html->link(), you can use the following conventions for the url array: $this->Html->link('link-title', [ 'prefix' => 'MyPrefix' // PascalCased 'plugin' => 'MyPlugin', // PascalCased 'controller' => modified DATETIME ); CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE, created (user_id) REFERENCES users(id) ) CHARSET=utf8mb4; CREATE TABLE tags ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(191), created DATETIME, modified DATETIME, (continues on next page) CMS Tutorial - Creating

this->Html->link(), you can use the following conventions for the url array: $this->Html->link('link-title', [ 'prefix' => 'MyPrefix' // CamelCased 'plugin' => 'MyPlugin', // CamelCased 'controller' DATETIME ); CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE CREATE TABLE tags ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(191), created DATETIME, modified DATETIME, UNIQUE KEY (title) ) CHARSET=utf8mb4; CREATE TABLE articles_tags ( article_id

this->Html->link(), you can use the following conventions for the url array: $this->Html->link('link-title', [ 'prefix' => 'MyPrefix' // CamelCased 'plugin' => 'MyPlugin', // CamelCased 'controller' => 'ControllerName' modified DATETIME ); CREATE TABLE articles ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, title VARCHAR(255) NOT NULL, slug VARCHAR(191) NOT NULL, body TEXT, published BOOLEAN DEFAULT FALSE, created REFERENCES users(id) ) CHARSET=utf8mb4; CREATE TABLE tags ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(191), created DATETIME, modified DATETIME, (continues on next page) CMS Tutorial - Creating

' 'as part of the request.') raise falcon.HTTPUnauthorized(title='Auth token required', description=description, 'Please request a new token and try again.') raise falcon.HTTPUnauthorized(title='Authentication required', description=description, not in req.content_type: raise falcon.HTTPUnsupportedMediaType( title='This API only supports requests encoded as JSON.', href='http://docs.examples

' 'as part of the request.') raise falcon.HTTPUnauthorized(title='Auth token required', description=description, 'Please request a new token and try again.') raise falcon.HTTPUnauthorized(title='Authentication required', description=description, not in req.content_type: raise falcon.HTTPUnsupportedMediaType( title='This API only supports requests encoded as JSON.', href='http://docs.examples