[Comoblog-commit] comoblog/_install comoblog_db.xml,1.8,1.9

[iamdecal <iam...@us...>]

Update of /cvsroot/comoblog/comoblog/_install
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv8874/_install

Modified Files:
	comoblog_db.xml 
Log Message:
Initial cache code added, just libraries and base schema, not linked in functionally




Index: comoblog_db.xml
===================================================================
RCS file: /cvsroot/comoblog/comoblog/_install/comoblog_db.xml,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- comoblog_db.xml	15 Aug 2006 16:56:30 -0000	1.8
+++ comoblog_db.xml	16 Aug 2006 16:39:00 -0000	1.9
@@ -9,22 +9,22 @@
       <field name="comment_author_email"        specs="varchar(128) default NULL" />
       <field name="comment_author_url"          specs="varchar(128) default NULL" />      
       <field name="comment_added"               specs="int(10) unsigned default NULL" />
-      <field name="post_id"                     specs="int(10) unsigned NOT NULL default '0'" />
+      <field name="post_id"                     specs="int(10) unsigned NOT NULL default '0'" />
       <field name="comment_live"                specs="varchar(1) default 'N'" />      
       
       <pk name="comment_id" />
    </table>
-
-
-
-   <table name="comoblog_commenters">
-      <field name="commenter_id"               specs="int(10) unsigned NOT NULL auto_increment" />
-      <field name="commenter_author_email"     specs="varchar(128) default NULL" />
-      <field name="commenter_default"          specs="varchar(1) default 'N'" />      
- 
-      
-      <pk name="commenter_id" />
-   </table>
+
+
+
+   <table name="comoblog_commenters">
+      <field name="commenter_id"               specs="int(10) unsigned NOT NULL auto_increment" />
+      <field name="commenter_author_email"     specs="varchar(128) default NULL" />
+      <field name="commenter_default"          specs="varchar(1) default 'N'" />      
+ 
+      
+      <pk name="commenter_id" />
+   </table>
 
    <table name="comoblog_images">
       <field name="img_id"                      specs="int(10) unsigned NOT NULL auto_increment" />
@@ -289,4 +289,52 @@
       <pk name="trackback_id" />
    </table>
 
+   
+   <!-- //ADDED 1.3
+   holds the cached pages
+
+   there is no point haveing caches that all expire at  the same time - you want to be able to clear them when 
+   specific things happen as well, so as well as datas, there are some extra control fields
+   
+   cache_keyphrase = the identifier used to find and save this row i.e. postpage,indexpage or mod_rss
+   cache_post_id = the post id - most of the caching will relate to post pages. this should speed it up.
+   cache_clearcodes - a comma seperated string eg (newpost,byage,oncomment,onedit)
+   cache_added - the date this cached page was added / updated
+   cache_clear - the date this cached page should be cleared (see byage)
+   cache_text  - the content of the text
+
+   a row might look like this...
+   
+   1,"postpage","123","oncomment,onedit","2006-01-01 12:00:00","2009-01-01 12:00:00","foo bah humbug",
+      
+   which would represent the post page for post 123, 
+   as a rule we wont want to change this cache very often, but we will if the post is editied or a comment is added
+   
+   the post edit page will be adapted to clear caches with a cache_clearcode like "onedit"  OR a keyphrase ='postpage-123'
+   
+   or
+   
+   2,"mod_rss,0,"byage","2006-01-01 12:00:00","2006-01-02 12:00:00","foo bah humbug",
+   
+   which will only expire by age (every 1 days)
+   
+   remeber we may also need to clear the index page etc as they may have the cached details if its a post.
+   
+   
+   -->
+
+   <table name="comoblog_cache">
+      <field name="cache_id"                    specs="int(10) unsigned NOT NULL auto_increment" />
+      <field name="cache_keyphrase"             specs="varchar(64) default NULL" />
+      <field name="cache_post_id"              specs="int(10) unsigned NOT NULL " />  
+      <field name="cache_clearcodes"            specs="varchar(255) default NULL" />     
+      <field name="cache_added"               specs="int(14) unsigned not NULL" />      
+      <field name="cache_clear"               specs="int(14) unsigned not NULL" />      
+      <field name="cache_text"                specs="text" />      
+      <pk name="cache_id" />
+      <uk name="cache_keyphrase" />
+   </table>   
+      
+   
+   
 </comoblog_db>