CakePHP 3 Tutorial - part 2: Databases

Опубликовано: 21 Февраль 2026
на канале: Coffee Coding

66,165

398

** 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.