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

ORM Reverse #1051

Open
elvispdosreis opened this issue Jan 31, 2018 · 0 comments
Open

ORM Reverse #1051

elvispdosreis opened this issue Jan 31, 2018 · 0 comments

Comments

@elvispdosreis
Copy link

Error in generating xml with accented fields

ennum 'Chá de Cozinha'

CREATE TABLE listas (
id_lista int(11) NOT NULL AUTO_INCREMENT,
fk_cliente int(11) DEFAULT NULL,
titulo char(50) DEFAULT NULL,
data date DEFAULT NULL,
site varchar(250) DEFAULT NULL,
tipo enum('Casamentos','Amigos Secretos','Chá de Cozinha','Aniversários') DEFAULT NULL,
tipo_residencia char(1) DEFAULT NULL,
endereco varchar(100) DEFAULT NULL,
numero varchar(50) DEFAULT NULL,
bairro varchar(50) DEFAULT NULL,
complemento varchar(50) DEFAULT NULL,
cidade varchar(50) DEFAULT NULL,
fk_estado int(11) DEFAULT NULL,
fk_pais int(11) DEFAULT NULL,
provincia varchar(100) DEFAULT NULL,
referencia text DEFAULT NULL,
entregar_para varchar(100) DEFAULT NULL,
cpfcnpj varchar(20) DEFAULT NULL,
cep char(9) DEFAULT NULL,
fone1 varchar(15) DEFAULT NULL,
fone2 varchar(15) DEFAULT NULL,
image text DEFAULT NULL,
PRIMARY KEY (id_lista),
KEY fk_cliente (fk_cliente),
KEY fk_estado (fk_estado),
KEY fk_pais (fk_pais),
CONSTRAINT listas_ibfk_1 FOREIGN KEY (fk_cliente) REFERENCES clientes (id_cliente) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT listas_ibfk_2 FOREIGN KEY (fk_estado) REFERENCES estados (id_estado) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT listas_ibfk_3 FOREIGN KEY (fk_pais) REFERENCES paises (id_pais) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

No branches or pull requests

1 participant