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: by deva
