Comment 12 for bug 1332564

Revision history for this message
Sean M. Collins (scollins) wrote :

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;

Works.