diff options
author | msquare <msquare@notrademark.de> | 2017-12-23 11:59:13 +0100 |
---|---|---|
committer | msquare <msquare@notrademark.de> | 2017-12-23 11:59:13 +0100 |
commit | fbbea4eb5f8e72386a78c3b4639147b6e82a8535 (patch) | |
tree | 2d4b4b6f0aee8c69c3c9828cd03d292b5fefb8ae /db | |
parent | 16a8b0e2fabe3dc632ae2e8dfcf9cc7a6f0c6aaa (diff) |
add show on dashboard flag for angeltypes
Diffstat (limited to 'db')
-rw-r--r-- | db/update.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql index b36ea522..6e1c6dc5 100644 --- a/db/update.sql +++ b/db/update.sql @@ -45,3 +45,7 @@ update Room set `from_frab`=(`FromPentabarf`='Y'); ALTER TABLE `Room` DROP `FromPentabarf`; ALTER TABLE `Room` ADD `map_url` VARCHAR(300) NULL AFTER `from_frab`; ALTER TABLE `Room` ADD `description` TEXT NULL AFTER `map_url`; + +-- Dashboard +ALTER TABLE `AngelTypes` ADD `show_on_dashboard` BOOLEAN NOT NULL AFTER `contact_email`; +UPDATE `AngelTypes` SET `show_on_dashboard`=TRUE; |