Differences

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

--- pracro:pracro [2009/01/15 11:20] – 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]]\\
+[[Senators corner]]
 ====Open/Close logic====
@@ Line 160: / Line 187: @@
   * <del>{{:uncheck.png}} Make startup criteria. Design the startpage macro, with deps as colours.</del>
   * <del>{{:uncheck.png}} Automatic generation of continue button based on 'completed' and deps.</del>
@@ Line 168: / Line 196: @@
   * {{:uncheck.png}} ''storechildren'' in metawidget
   * {{:uncheck.png}} Header tags in course.
-  * {{:uncheck.png}} ''service'' attribute on request.
+  * {{:uncheck.png}} ''service'' attribute on query tags.
   * {{:uncheck.png}} DateTime widget