Aasimon.org Wiki

User Tools

Site Tools

Trace:
pracro:pracro

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
pracro:pracro [2011/01/21 12:01] – devapracro:pracro [2011/12/02 08:32] – deva
Line 1: Line 1:
 ======Pracro - Praxis Macro system ====== ======Pracro - Praxis Macro system ======
 +=====New concepts=====
 +[[pracro:post-commit-hook]]\\
 +[[pracro:course]]\\
 +[[pracro:praxisd]]\\
 +[[pracro:acl]]\\
 +[[pracro:template_concept_redesign]]
 =====Upgrade from old to new database structure===== =====Upgrade from old to new database structure=====
 Remove duplicate entries from fieldnames table: Remove duplicate entries from fieldnames table:
Line 6: Line 12:
 </code> </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===== =====Roadmap=====
 See the [[pracro:roadmap]] page for details on how and when releases are made. See the [[pracro:roadmap]] page for details on how and when releases are made.
pracro/pracro.txt · Last modified: 2012/11/08 10:36 by deva