diff options
Diffstat (limited to 'util/updates/update_1.14.sql')
| -rw-r--r-- | util/updates/update_1.14.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/util/updates/update_1.14.sql b/util/updates/update_1.14.sql index 70ae8ef0..77f9ee71 100644 --- a/util/updates/update_1.14.sql +++ b/util/updates/update_1.14.sql @@ -17,6 +17,14 @@ DROP FUNCTION get_new_id(text); +-- remove users.p* columns (Why haven't I done so earlier?) +ALTER TABLE users DROP COLUMN pvotes; +ALTER TABLE users DROP COLUMN pfind; +ALTER TABLE users DROP COLUMN plist; +ALTER TABLE users DROP COLUMN pign_nsfw; + + + -- relation graphs get ID numbers CREATE SEQUENCE relgraph_seq; ALTER TABLE vn ALTER COLUMN rgraph DROP NOT NULL; |