source: migration/rc4-to-rc5.sql @ 32

-- XTS [http://www.opentheatre.co.uk]
--
--          file: rc4-to-rc5.sql
--   description: Migration SQL script to upgrade the RC4 database schema to RC5
--       creator: Alex Macmillan
--       created: 2009
--
-- The contents of this file are subject to the Mozilla Public License
-- Version 1.1 (the "License"); you may not use this file except in
-- compliance with the License. You may obtain a copy of the License at
-- http://www.mozilla.org/MPL/
-- 
-- Software distributed under the License is distributed on an "AS IS"
-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-- License for the specific language governing rights and limitations
-- under the License.
-- 
-- The Original Code is XTS eXtensible Ticketing System, unreleased.
-- 
-- The Initial Developer of the Original Code is Alexander Macmillan.
-- Portions created by Alexander Macmillan are Copyright (C) 2009
-- Alexander Macmillan. All Rights Reserved.
-- 
-- Contributor(s): ______________________________________.

-- Create the snewts_paymenttype table
CREATE TABLE `snewts_paymenttype` (
    `id` int(11) NOT NULL auto_increment,
    `name` varchar(24) NOT NULL,
    `enabled` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Create the two payment types available by default in RC4
INSERT INTO `snewts_paymenttype` (`id`,`name`,`enabled`) VALUES ('1','Cash','1');
INSERT INTO `snewts_paymenttype` (`id`,`name`,`enabled`) VALUES ('2','Card','1');

-- Rename the paymenttype column in the ticket table to paymenttype_id
ALTER TABLE `snewts_ticket` CHANGE COLUMN `paymenttype` `paymenttype_id` INT;

-- Add a key to the paymenttype_id column
ALTER TABLE `snewts_ticket` ADD KEY `snewts_ticket_paymenttype_id` (`paymenttype_id`);