SQLite format 3@  kx i55wtableBlogPostBlogCategoryBlogPostBlogCategory CREATE TABLE BlogPostBlogCategory (categoryId,postId)]1{indexblogpost_unique_idBlogPostCREATE UNIQUE INDEX blogpost_unique_id on BlogPost (id)utableBlogPostBlogPostCREATE TABLE BlogPost (id,blogId,title,url,author,date,content,tags,commentsEnabled,lastModified,type,attachmentUrl)n9% indexblogcategory_unique_idBlogCategoryCREATE UNIQUE INDEX blogcategory_unique_id on BlogCategory (id)N%%atableBlogCategoryBlogCategoryCREATE TABLE BlogCategory (id,name,blogId)S-sindexblog_unique_nameBlogCREATE UNIQUE INDEX blog_unique_name on Blog (name)M)kindexblog_unique_idBlogCREATE UNIQUE INDEX blog_unique_id on Blog (id)/CtableBlogBlogCREATE TABLE Blog (id, 'M8a49866a24a22e070124a4fab2f72786blog $M8a49866a24a22e070124a4fab2f72786 blog   cc MM%3' 38a4986c824a22dad0124a4fb7eef21f78a49866a24a22e070124a4fab2f72786TesttestHadge Hughes2009-10-30 10:26:35Test Page
2009-10-30 10:26:35null $M8a4986c824a22dad0124a4fb7eef21f7   __4R[/CtableBlogBlogCREATE TABLE Blog (id,name)M)kindexblog_unique_idBlogCREATE UNIQUE INDEX blog_unique_id on Blog (id)S-sindexblog_unique_nameBlogCREATE UNIQUE INDEX blog_unique_name on Blog (name)N%%atableBlogCategoryBlogCategoryCREATE TABLE BlogCategory (id,name,blogId)n9% indexblogcategory_unique_idBlogCategoryCREATE UNIQUE INDEX blogcategory_unique_id on BlogCategory (id)utableBlogPostBlogPostCREATE TABLE BlogPost (id,blogId,title,url,author,date,content,tags,commentsEnabled,lastModified,type,attachmentUrl)]1{indexblogpost_unique_idBlogPostCREATE UNIQUE INDEX blogpost_unique_id on BlogPost (id)i55wtableBlogPostBlogCategoryBlogPostBlogCategory CREATE TABLE BlogPostBlogCategory (categoryId,postId)+ W5Windexblogpostcategory_unique_category_postBlogPostBlogCategory CREATE UNIQUE INDEX blogpostcategory_unique_category_post on BlogPostBlogCategory (categoryId,postId)  e Q##kviewBlogTagViewBlogTagViewCREATE VIEW BlogTagView as select T.id as id,T.name as name,T.blogId as blogId,count(BT.tagId) as count from BlogTag T join BlogPostBlogTag BT on T.id = BT.tagId group by T.idU ++ctableBlogPostBlogTagBlogPostBlogTag CREATE TABLE BlogPostBlogTag (tagId,postId) C+/indexblogposttag_unique_tag_postBlogPostBlogTagCREATE UNIQUE INDEX blogposttag_unique_tag_post on BlogPostBlogTag (tagId,postId)? WtableBlogTagBlogTagCREATE TABLE BlogTag (id,name,blogId)Y /windexblogtag_unique_idBlogTagCREATE UNIQUE INDEX blogtag_unique_id on BlogTag (id)|---viewBlogCategoryViewBlogCategoryViewCREATE VIEW BlogCategoryView as select C.id as id, C.blogId as blogId, C.name as name, count(BC.categoryId) as count from BlogCategory C left join BlogPostBlogCategory BC on C.id = BC.categoryId group by C.id