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 [2009/01/15 11:21] – 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=====
 +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===== =====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.
Line 10: Line 34:
  
 =====Random Stuff===== =====Random Stuff=====
 +[[Devas corner]]\\
 +[[Senators corner]]
  
 ====Open/Close logic==== ====Open/Close logic====
pracro/pracro.txt · Last modified: 2012/11/08 10:36 by deva