arteria / cmsplugin-contact-plus

With cmsplugin-contact-plus building custom forms for your django-cms project is a breeze. Now it's so easy to build the forms with exactly the fields you want in the order you want - with a minimal effort.
https://github.com/arteria/cmsplugin-contact-plus
BSD 3-Clause "New" or "Revised" License
30 stars 33 forks source link

Manual migration command (MySQL) #25

Open philippeowagner opened 9 years ago

philippeowagner commented 9 years ago

These are some manual migration hints...

CREATE TABLE `cmsplugin_contact_plus_contactrecord` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `contact_form_id` integer,
    `date_of_entry` datetime NOT NULL,
    `date_processed` datetime,
    `data` longtext
);

ALTER TABLE cmsplugin_contactplus add `title` varchar(100) after `cmsplugin_ptr_id`;
ALTER TABLE cmsplugin_contactplus add `email_subject` varchar(256) NOT NULL after `title`;
ALTER TABLE cmsplugin_contactplus add `collect_records` bool NOT NULL after `email_subject`;
ALTER TABLE cmsplugin_contactplus add `template` varchar(255) NOT NULL after `submit`;
philippeowagner commented 9 years ago

There was a typo in a previous version

ALTER TABLE cmsplugin_contactplus CHANGE `reciepient_email` `recipient_email`  varchar(75) NOT NULL; ```