Differences from version 1 to 3



@@ -6,4 +6,24 @@

 
 Another use of this facility would be to either crop images or create new images by cropping an element of a larger picture. Thumbnails for each tagged element. One of the pictures I have digitized is a large secondary school picture, and showing each pupil individually would be a nice addition.
 
+[http://www.lsces.co.uk/wiki/index.php?page=Image+Tagging+Software|Source material for image tagging]
 
+!!!Initial proposal for table
+
+CREATE TABLE LIBERTY_ATTACHMENT_TAGS
+(
+ ATTACHMENT_ID Integer NOT NULL,
+ COMMENT_ID Integer NOT NULL,
+ TAG_TOP Integer DEFAULT 0 NOT NULL,
+ TAG_LEFT Integer DEFAULT 0 NOT NULL,
+ TAG_WIDTH Integer DEFAULT 100 NOT NULL,
+ TAG_HEIGHT Integer DEFAULT 100 NOT NULL,
+ PRIMARY KEY (ATTACHMENT_ID,COMMENT_ID)
+);
+
+ALTER TABLE LIBERTY_ATTACHMENT_TAGS ADD CONSTRAINT LIB_ATTACHMENT_TAGS_ID_REF
+ FOREIGN KEY (ATTACHMENT_ID) REFERENCES LIBERTY_ATTACHMENTS (ATTACHMENT_ID);
+ALTER TABLE LIBERTY_ATTACHMENT_TAGS ADD CONSTRAINT LIB_ATTACHMENT_TAGS_CID_REF
+ FOREIGN KEY (COMMENT_ID) REFERENCES LIBERTY_COMMENTS (COMMENT_ID);
+
+I have added a new mime handler for taggedimage, and am slowly working through getting it to update things to this table. The intention would be that we could 'edit' an existing image to add area tags, and that would simply change it's mime type to 'mimetaggedimage'. The tagged items would then be displayed using an alternative template file, and tags would be loaded via the handler.
Page History
Date/CommentUserIPVersion
13 May 2010 (11:37 UTC)
Lester Caine81.138.11.1363
Current • Source
Lester Caine81.138.11.1362
View • Compare • Difference • Source
Lester Caine81.138.11.1361
View • Compare • Difference • Source