Differences

This shows you the differences between two versions of the page.

--- pracro:pracro [2009/09/07 15:43] – deva
+++ pracro:pracro [2012/11/08 10:36] (current) – deva
@@ Line 1: / Line 1: @@
 ======Pracro - Praxis Macro system ======
+=====New concepts=====
+[[pracro:speed-key concepts]]\\
+[[pracro:post-commit-hook]]\\
+[[pracro:course]]\\
+[[pracro:praxisd]]\\
+[[pracro:acl]]\\
+[[pracro:template_concept_redesign]]
+=====Upgrade from old to new database structure=====
+Remove duplicate entries from fieldnames table:
+<code>
+delete from fieldnames where ctid not in (select max(dup.ctid) from fieldnames as dup group by dup.name);
+</code>
+Remove duplicates from fields:
+<code>
+delete from fields where ctid not in (select max(dup.ctid) from fields as dup group by dup.transaction, dup.name, dup.value);
+</code>
+<code>
+ALTER TABLE transactions RENAME TO transactions_old;
+</code>
+<code>
+CREATE TYPE session_status AS ENUM ('active', 'idle', 'committed');
+</code>
 =====Roadmap=====
 See the [[pracro:roadmap]] page for details on how and when releases are made.
@@ Line 10: / Line 35: @@
 =====Random Stuff=====
-[[Devas corner]]
+[[Devas corner]]\\
 [[Senators corner]]