FwT1EmKB

1CREATE TABLE IF NOT EXISTS "image_e"
2(
3    "id"    int unsigned NOT NULL AUTO_INCREMENT,
4    "title" varchar(32),
5    "alt"   varchar(16)  NOT NULL,
6
7    PRIMARY KEY ("id")
8
9)   ENGINE = MyISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
10
11CREATE TABLE IF NOT EXISTS "image_version_e"
12(
13    "id"      int unsigned      NOT NULL AUTO_INCREMENT,
14    "imageId" int unsigned      NOT NULL,
15    "format"  varchar(4)        NOT NULL,
16    "size"    int unsigned      NOT NULL,
17    "width"   smallint unsigned NOT NULL,
18    "height"  smallint unsigned NOT NULL,
19    "src"     varchar(64)       NOT NULL,
20
21    PRIMARY KEY ("id")
22
23)   ENGINE = MyISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
24
25ALTER TABLE "image_version_e"
26    ADD UNIQUE KEY ("imageId", "format", "width", "height"),
27    ADD UNIQUE KEY ("src");
28	
29SELECT *
30FROM image_e
31LEFT JOIN image_version_e
32    ON image_version_e.imageId = image_e.id
33	
34SELECT *
35FROM image_version_e
36LEFT JOIN image_e
37    ON image_e.id = image_version_e.id
38	
39SELECT *
40FROM image_e inner join
41     image_version_e
42     ON image_version_e.imageId = image_e.id;