Zen Follower
- Join Date:
- Jan 2018
- Posts:
- 157
- Plugin Contributions:
- 0
Mysql?
I am updating a plugin and question about updating MySQL to MYISAM and utf8_general_ci
here is the code:
CREATE TABLE zipcodezone (
zipcode_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
zipcode_start char(3) NOT NULL default '0',
zipcode_end char(3) NOT NULL default '0',
zipcodezone int(1) NOT NULL default '0');
INSERT INTO zipcodezone
(zipcode_id ,zipcode_start ,zipcode_end ,zipcodezone)