CakePHP 3 Tutorial - part 2: Databases

Published: 20 August 2015
on channel: Coffee Coding

66,168

397

** UPDATED FOR CAKEPHP 4.0 **
• CakePHP 4 Tutorial - #1 Installation

SQL script for tables:

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
created DATETIME,
modified DATETIME
);

CREATE TABLE bookmarks (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
title VARCHAR(50),
description TEXT,
url TEXT,
created DATETIME,
modified DATETIME,
FOREIGN KEY user_key (user_id) REFERENCES users(id)
);

CREATE TABLE tags (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255),
created DATETIME,
modified DATETIME,
UNIQUE KEY (title)
);

CREATE TABLE bookmarks_tags (
bookmark_id INT NOT NULL,
tag_id INT NOT NULL,
PRIMARY KEY (bookmark_id, tag_id),
FOREIGN KEY tag_key(tag_id) REFERENCES tags(id),
FOREIGN KEY bookmark_key(bookmark_id) REFERENCES bookmarks(id)
);
------------------------------------------------------------------

Thanks so much for watching! Please comment, like or subscribe in order to support me. Also, please consider donating here:

http://jbjcode.com/donations/

Donations are whats keeping me going, as the financial aid helps justify the amount of time spent + to buy new equipment for recording and editing.

Thank you!
/J.B.J.

On this page of the site you can watch the video online CakePHP 3 Tutorial - part 2: Databases with a duration of hours minute second in good quality, which was uploaded by the user Coffee Coding 20 August 2015, share the link with friends and acquaintances, this video has already been watched 66,168 times on youtube and it was liked by 397 viewers. Enjoy your viewing!

43,825

776