pracro:pracro
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
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 ====== | ======Pracro - Praxis Macro system ====== | ||
+ | =====New concepts===== | ||
+ | [[pracro: | ||
+ | [[pracro: | ||
+ | [[pracro: | ||
+ | [[pracro: | ||
+ | [[pracro: | ||
+ | [[pracro: | ||
+ | =====Upgrade from old to new database structure===== | ||
+ | Remove duplicate entries from fieldnames table: | ||
+ | < | ||
+ | delete from fieldnames where ctid not in (select max(dup.ctid) from fieldnames as dup group by dup.name); | ||
+ | </ | ||
+ | |||
+ | Remove duplicates from fields: | ||
+ | < | ||
+ | delete from fields where ctid not in (select max(dup.ctid) from fields as dup group by dup.transaction, | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | ALTER TABLE transactions RENAME TO transactions_old; | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | CREATE TYPE session_status AS ENUM (' | ||
+ | </ | ||
=====Roadmap===== | =====Roadmap===== | ||
See the [[pracro: | See the [[pracro: |
pracro/pracro.1252331030.txt.gz · Last modified: 2009/09/07 15:43 by deva