From 4e7ceb1dde219d03e577c7c038e19f977c9abc29 Mon Sep 17 00:00:00 2001
From: "David A. Madore" <david+git@madore.org>
Date: Sun, 12 Oct 2014 17:59:13 +0200
Subject: Separate the "has_cut" property from "do_single_page".

Note: the following SQL should be used to upgrade the database:

ALTER TABLE entries ADD COLUMN has_cut boolean NOT NULL DEFAULT FALSE ;
UPDATE entries SET has_cut = (array_length(xpath('.//d:cut-here', content, ARRAY[ARRAY['d', 'http://www.madore.org/~david/NS/daml/']]), 1) NOTNULL) ;
-- Check that the following returns nothing:
SELECT edate , id FROM entries WHERE has_cut != ( do_single_page NOTNULL ) ;
---
 org/madore/damlengine/weblog-database.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'org/madore/damlengine/weblog-database.sql')

diff --git a/org/madore/damlengine/weblog-database.sql b/org/madore/damlengine/weblog-database.sql
index ebf8e0c..f5ec56d 100644
--- a/org/madore/damlengine/weblog-database.sql
+++ b/org/madore/damlengine/weblog-database.sql
@@ -9,7 +9,8 @@ CREATE TABLE entries (
 	title_xml xml ,
 	content xml NOT NULL ,
 	sha1 text NOT NULL ,
-	do_single_page text
+	do_single_page text ,
+	has_cut boolean NOT NULL DEFAULT FALSE
 ) ;
 CREATE INDEX entries_edate_key ON entries ( edate ) ;
 CREATE TABLE incat (
-- 
cgit v1.2.3

