diff options
| author | megamage <none@none> | 2009-01-10 11:11:01 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-01-10 11:11:01 -0600 |
| commit | 3858dab58baebfdf7148eb6b56bea359bcf72526 (patch) | |
| tree | 6f500422be5b41506b0d8799d901e50e013a0361 /sql/updates | |
| parent | 4b5bca4f0a5ae7c888747308697868862c09e783 (diff) | |
*Fix sql bug in 741_characters.sql.
If you already have "closed" column in gm_tickets table, use ALTER TABLE `gm_tickets` CHANGE `closed` `closed` tinyint(1) NOT NULL default '0';
If you do not have that column, use ALTER TABLE `gm_tickets` ADD `closed` tinyint(1) NOT NULL default '0' AFTER `timestamp`;
Also, you should check if you have "assignedto" column.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/741_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/832_characters.sql | 1 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/741_characters.sql b/sql/updates/741_characters.sql index aeba6f8c9ac..4ce094e3e5f 100644 --- a/sql/updates/741_characters.sql +++ b/sql/updates/741_characters.sql @@ -1,4 +1,3 @@ -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 `closed` tinyint(1) NOT NULL default '0' AFTER `timestamp`; ALTER TABLE `gm_tickets` ADD `assignedto` int(10) NOT NULL default '0' AFTER `timestamp`; diff --git a/sql/updates/832_characters.sql b/sql/updates/832_characters.sql new file mode 100644 index 00000000000..1330aef891e --- /dev/null +++ b/sql/updates/832_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` tinyint(1) NOT NULL default '0';
\ No newline at end of file |