diff options
Diffstat (limited to 'updates/2.00-to-x.xx.sql')
| -rw-r--r-- | updates/2.00-to-x.xx.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql index da1b0bd05..f4c9d3bad 100644 --- a/updates/2.00-to-x.xx.sql +++ b/updates/2.00-to-x.xx.sql @@ -219,3 +219,21 @@ ALTER TABLE node ADD attribute varchar(255) DEFAULT '' NOT NULL; # 10/06/01 ALTER TABLE node DROP cid; ALTER TABLE node DROP tid; + +# 11/06/01 +UPDATE users SET access = REPLACE(access, ':', '='); +UPDATE users SET access = REPLACE(access, ';', ','); +UPDATE comments SET users = REPLACE(users, ';', ','); +UPDATE comments SET users = REPLACE(users, ':', '='); +UPDATE node SET users = REPLACE(users, ';', ','); +UPDATE node SET users = REPLACE(users, ':', '='); +UPDATE node SET attributes = REPLACE(attributes, ';', ','); +UPDATE node SET attributes = REPLACE(attributes, ':', '='); +UPDATE entry SET attributes = REPLACE(attributes, ';', ','); +UPDATE entry SET attributes = REPLACE(attributes, ':', '='); + +ALTER TABLE entry CHANGE keyword attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE node CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE bundle CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE feed CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE item CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; |