diff options
| author | Machiavelli <none@none> | 2009-01-01 18:25:56 +0100 |
|---|---|---|
| committer | Machiavelli <none@none> | 2009-01-01 18:25:56 +0100 |
| commit | 68015c4e94eff0ae5fd0c165e09d88a97fd9cefd (patch) | |
| tree | 6bfb30554eb2d826fced0ab7b4a19615ca1e5d0e /sql/updates/741_characters.sql | |
| parent | ae0ce19a7fc964b62eea136c806cd29ab182f0fa (diff) | |
* Fix Crash issue caused by closing a ticket.
* Fix potential crash issue caused by improper datatype, SQL included to alter column (Thanks Paradox)
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/741_characters.sql')
| -rw-r--r-- | sql/updates/741_characters.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/741_characters.sql b/sql/updates/741_characters.sql new file mode 100644 index 00000000000..aeba6f8c9ac --- /dev/null +++ b/sql/updates/741_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` tinyint(1) NOT NULL default '0'; +ALTER TABLE `gm_tickets` ADD `closed` bit(1) NOT NULL AFTER `timestamp`; +ALTER TABLE `gm_tickets` ADD `assignedto` int(10) NOT NULL default '0' AFTER `timestamp`; + |