From 3858dab58baebfdf7148eb6b56bea359bcf72526 Mon Sep 17 00:00:00 2001 From: megamage Date: Sat, 10 Jan 2009 11:11:01 -0600 Subject: *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 --- sql/updates/832_characters.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/832_characters.sql (limited to 'sql/updates/832_characters.sql') 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 -- cgit v1.2.3