Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Manual migration command (MySQL) #25

Open
philippeowagner opened this issue Jun 10, 2015 · 1 comment
Open

Manual migration command (MySQL) #25

philippeowagner opened this issue Jun 10, 2015 · 1 comment
Labels

Comments

@philippeowagner
Copy link
Member

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
Copy link
Member Author

There was a typo in a previous version

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant