-- removing credit card type
DELETE FROM `mn_EventFormFieldValue` WHERE `id_fmf` = 16;
DELETE FROM `mn_EventFormFieldValid` WHERE `id_fmf` = 16;
DELETE FROM `mn_EventFormFieldLabel` WHERE `id_parent` = 16;
DELETE FROM `mn_EventFormField` WHERE `id` = 16;

-- adding cvv
INSERT INTO `mn_EventFormField` (
`id` ,
`id_fm` ,
`type` ,
`show_in_list` ,
`sorter` ,
`added` ,
`changed`
)
VALUES (
19 , '1', 'text', 'n', '3', '2012-03-09 14:54:00', '2012-03-09 14:54:00'
);


-- ATTENTION!!!! verify, is previous id 19
INSERT INTO `mn_EventFormFieldLabel` (
`id_parent` ,
`lang` ,
`label` ,
`added` ,
`changed`
)
VALUES (
'19', 'eng', 'Security Code', '2012-03-09 14:54:00', '2012-03-09 14:54:00'
);

INSERT INTO `mn_EventFormFieldValid` (
`id_fmf` ,
`validator` ,
`sorter`
)
VALUES (
'19', 'required', '0'
);

CREATE TABLE `mn_TransactionLog` (
`event_id` INT NOT NULL ,
`member_id` INT NOT NULL ,
`response` TEXT NOT NULL ,
`added` DATETIME NOT NULL
) ENGINE = MYISAM ;



INSERT INTO `mn_EventFormFieldType` (
`name` ,
`title`
)
VALUES (
'extended_text', 'Extended Text'
);


UPDATE `mn_EventFormField` SET `type` = 'extended_text' WHERE `mn_EventFormField`.`id` =19 LIMIT 1 ;