If you use the migrations plugin, there is no need to use the correct SQL
for creating the database, as cake will take care of generating everything
correctly for you.
Check the sections of the tutorial about using the migrations plugin.
On Monday, September 21, 2015 at 3:38:11 AM UTC+2,
Thankyou, I'll look into that and learn the migrations system in PART 3 of
the Blog tutorial. My perspective at this point, was as someone new to
cake just trying to follow the turorials to see if cakephp was something
within my grasp. The mysql above with instructions to execute the
This seems to work for the bookmarks app in SQLITE. ( Except for a
cascadeing delete).
CREATE TABLE "users" (
"id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"email" text NOT NULL,
"password" text NOT NULL,
"created" text,
"modified" text
);
CREATE TABLE "bookmarks" (
"id" integer NOT NULL
I ahev successfully installed cake and Mysql and completed the tutorials
for bookmarks and blog. Now I want to use SQlite. I can successfully
connect to my sqlite database. I tried using the same Mysql statements
found on page 13 of the cookbook that were successful with Mysql; however,
I
