Sridhar Basam from our team figured it out - It needs the charset. All the tables in the existing database are using latin1 - changing the CREATE TABLE statement to:
CREATE TABLE ml2_network_segments (
id VARCHAR(36) NOT NULL,
network_id VARCHAR(36) NOT NULL,
network_type VARCHAR(32) NOT NULL,
physical_network VARCHAR(64),
segmentation_id INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE
)
CHARACTER SET latin1;
Sridhar Basam from our team figured it out - It needs the charset. All the tables in the existing database are using latin1 - changing the CREATE TABLE statement to:
CREATE TABLE ml2_network_ segments ( network VARCHAR(64),
id VARCHAR(36) NOT NULL,
network_id VARCHAR(36) NOT NULL,
network_type VARCHAR(32) NOT NULL,
physical_
segmentation_id INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE
)
CHARACTER SET latin1;
Works.