TEpB0sVT

1CREATE  TABLE IF NOT EXISTS `warrington_main`.`image` (  
2  `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT ,  
3  `user_id` BIGINT(20) UNSIGNED NOT NULL ,  
4  `alias_title` VARCHAR(255) NOT NULL ,  
5  `address_id` BIGINT(20) NULL ,  
6  `geolocation_id` BIGINT(20) NULL ,  
7  `camera_id` MEDIUMINT(8) NULL ,  
8  `title` VARCHAR(100) NOT NULL ,  
9  `description` VARCHAR(2000) NOT NULL ,  
10  `main_image` VARCHAR(50) NOT NULL ,  
11  `thumbnail_image` VARCHAR(50) NOT NULL ,  
12  `thumbnail_image_medium` VARCHAR(50) NOT NULL ,  
13  `thumbnail_image_small` VARCHAR(50) NOT NULL ,  
14  `thumbnail_image_gallery` VARCHAR(50) NOT NULL ,  
15  `hits` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' ,  
16  `show_comment` ENUM('0','1') NOT NULL ,  
17  `feature_in_gallery` ENUM('0','1') NOT NULL ,  
18  `created_on` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,  
19  `date_taken` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,  
20  `updated_on` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,  
21  `updated_by` BIGINT(20) UNSIGNED NOT NULL ,  
22  `approved` ENUM('Inprocess','Yes','No') NOT NULL DEFAULT 'Inprocess' ,  
23  `visible` ENUM('0','1') NOT NULL DEFAULT '0' ,  
24  `account_type_created` ENUM('S','Y', 'G', 'FL', 'FB') NOT NULL ,  
25  PRIMARY KEY (`id`) ,  
26  UNIQUE INDEX `alias_title` (`alias_title` ASC) ,  
27  INDEX `title` (`title` ASC) ,  
28  INDEX `approved` (`approved` ASC) ,  
29  INDEX `visible` (`visible` ASC) ,  
30  INDEX `feature_in_gallery` (`feature_in_gallery` ASC) ,  
31  INDEX `fk_image_image_user1_idx` (`user_id` ASC) ,  
32  INDEX `fk_image_camera1_idx` (`camera_id` ASC) ,  
33  INDEX `fk_image_address1_idx` (`address_id` ASC) ,  
34  INDEX `fk_image_geolocation1_idx` (`geolocation_id` ASC) ,  
35  INDEX `fk_image_user1_idx` (`updated_by` ASC) ,  
36  CONSTRAINT `fk_image_image_user1`  
37    FOREIGN KEY (`user_id` )  
38    REFERENCES `warrington_main`.`user` (`id` )  
39    ON DELETE NO ACTION  
40    ON UPDATE NO ACTION,  
41  CONSTRAINT `fk_image_camera1`  
42    FOREIGN KEY (`camera_id` )    
43    REFERENCES `warrington_main`.`camera` (`id` )  
44    ON DELETE NO ACTION  
45    ON UPDATE NO ACTION,  
46  CONSTRAINT `fk_image_address1`  
47    FOREIGN KEY (`address_id` )  
48    REFERENCES `warrington_main`.`address` (`id` )
49    ON DELETE NO ACTION  
50    ON UPDATE NO ACTION,
51  CONSTRAINT `fk_image_geolocation1`  
52    FOREIGN KEY (`geolocation_id` )  
53    REFERENCES `warrington_main`.`geolocation` (`id` )  
54    ON DELETE NO ACTION  
55    ON UPDATE NO ACTION,  
56  CONSTRAINT `fk_image_user1`    
57    FOREIGN KEY (`updated_by` )    
58    REFERENCES `warrington_main`.`user` (`id` )    
59    ON DELETE NO ACTION    
60    ON UPDATE NO ACTION)    
61ENGINE = InnoDB    
62AUTO_INCREMENT = 23162    
63DEFAULT CHARACTER SET = utf8
64	
65Images
66    ImageDetailsId (PK)
67    ImageSizeId (PK)
68    URL
69    ...
70
71Image_Details
72   ImageDetailsId
73   ...
74
75Image_Sizes (where this table is relatively static - small, medium, large..)
76   ImageSizeID
77   ... (width? height? etc?)
78	
79IMAGE
80    ID
81    IMAGE_ATTRIBUTES
82
83IMAGE_SIZE
84    ID
85    IMAGE_ID
86    SIZE_ATTRIBUTES 
87
88 IMAGE_PATH
89    IMAGE_ID or IMAGE_SIZE_ID (depends)
90    PATH