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
pracro:pracro [2011/01/21 12:01] – devapracro:pracro [2012/11/08 10:36] (current) – deva
Line 1: Line 1:
 ======Pracro - Praxis Macro system ====== ======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===== =====Upgrade from old to new database structure=====
 Remove duplicate entries from fieldnames table: Remove duplicate entries from fieldnames table:
Line 6: Line 13:
 </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.1295607679.txt.gz · Last modified: 2011/01/21 12:01 by deva