pracro:pracro
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
pracro:pracro [2008/12/18 08:52] – 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: | ||
Line 10: | Line 35: | ||
=====Random Stuff===== | =====Random Stuff===== | ||
+ | [[Devas corner]]\\ | ||
+ | [[Senators corner]] | ||
====Open/ | ====Open/ | ||
Line 160: | Line 187: | ||
* < | * < | ||
* < | * < | ||
+ | |||
+ | |||
====Documentation==== | ====Documentation==== | ||
Line 165: | Line 194: | ||
* {{: | * {{: | ||
* {{: | * {{: | ||
- | * {{: | + | * {{: |
* {{: | * {{: | ||
+ | * {{: | ||
+ | * {{: | ||
+ | |||
====Macros (local)==== | ====Macros (local)==== | ||
* {{: | * {{: | ||
* {{: | * {{: |
pracro/pracro.1229586772.txt.gz · Last modified: 2008/12/18 08:52 by deva