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 PRIMARY KEY AUTOINCREMENT,
"user_id" integer NOT NULL,
"title" text NULL,
"description" text NULL,
"url" text NULL,
"created" text NULL,
"modified" text NULL,
FOREIGN KEY ("user_id") REFERENCES "users" ("id")
);
CREATE TABLE "bookmarks_tags" (
"bookmark_id" integer NOT NULL,
"tag_id" integer NOT NULL,
PRIMARY KEY (bookmark_id, tag_id),
FOREIGN KEY (tag_id) REFERENCES tags(id),
FOREIGN KEY (bookmark_id) REFERENCES bookmarks(id)
);
CREATE TABLE "tags" (
"id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"title" text NOT NULL UNIQUE,
"created" text,
"modified" text
);
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
