1S1uXE2H

1ALTER TABLE `cad_compras`
2	COMMENT='Todos os pregões feitos no portal';
3RENAME TABLE `cad_compras` TO `pregao_pedidos`;
4RENAME TABLE `cad_compras_movimentacoes` TO `pregao_movimentacoes`;
5RENAME TABLE `cad_ganhadores` TO `orders`;
6RENAME TABLE `compras_canceladas` TO `pregoes_cancelados`;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8DROP TABLE `compras_boletos`;
9SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
10RENAME TABLE `recuperar_senha` TO `user_recuperar_senha`;
11RENAME TABLE `cad_usuarios_condominos` TO `users_condominos`;
12RENAME TABLE `cad_usuarios` TO `users`;
13RENAME TABLE `cad_pregao` TO `pregao_ofertas_enviadas`;
14
15RENAME TABLE `cad_pregao_comentarios` TO `pregao_chat`;
16
17RENAME TABLE `compras_documentos` TO `order_documentos`;
18RENAME TABLE `compras_timeline_cotacao` TO `order_timeline_cotacao`;
19RENAME TABLE `compras_reportadas` TO `order_reportadas`;
20ALTER TABLE `compras_timeline`
21	COMMENT='timeline do pregao';
22RENAME TABLE `compras_timeline` TO `order_timeline`;
23RENAME TABLE `tb_layouts_emails` TO `system_layouts_emails`;
24RENAME TABLE `logs_acoes` TO `user_logs_acoes`;
25RENAME TABLE `cad_categorias` TO `system_categorias`;
26RENAME TABLE `tb_layouts_emails` TO `system_layouts_emails`;
27RENAME TABLE `itens_formularios` TO `system_itens_formularios`;
28RENAME TABLE `users_condominos` TO `user_condomino`;
29RENAME TABLE `cad_cotacao_comentarios` TO `order_cotacao_comentarios`;
30SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
31DROP TABLE `orcamento_contraoferta`;
32SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
33RENAME TABLE `orcamentos_novo` TO `orcamento_itens`;
34RENAME TABLE `orcamentos_principal` TO `orcamentos`;
35RENAME TABLE `orcamentos_ofertas_dadas` TO `orcamento_ofertas_dadas`;
36RENAME TABLE `lista_condominio` TO `lista_cotacao`;
37
38ALTER TABLE `orcamentos`
39	ADD COLUMN `temvisita` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `qtdParcela`,
40	ADD COLUMN `temvisita_responsavel` VARCHAR(100) NULL DEFAULT '0' AFTER `temvisita`,
41	ADD COLUMN `temvisita_telresponsavel` VARCHAR(100) NULL DEFAULT '0' AFTER `temvisita_responsavel`;
42
43CREATE TABLE IF NOT EXISTS `pregao_chat` (
44	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
45	`id_usuario` INT(10) UNSIGNED NOT NULL,
46	`id_pregao` INT(10) UNSIGNED NOT NULL,
47	`comentario` TEXT NOT NULL,
48	`data_comentario` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
49	PRIMARY KEY (`id`),
50	UNIQUE INDEX `id` (`id`)
51)
52COMMENT='Fica os comentários que o comprador/fornecedor trocam na página de detalhes.'
53COLLATE='utf8_general_ci'
54ENGINE=InnoDB
55;
56
57CREATE TABLE `order_opcoes` (
58	`id` INT(11) NOT NULL AUTO_INCREMENT,
59	`id_orc_preg` INT(11) NOT NULL,
60	`tipo` ENUM('1','2') NOT NULL COMMENT '1 = pregao 2 = orcamento',
61	`customdata` VARCHAR(255) NOT NULL,
62	PRIMARY KEY (`id`)
63)
64COLLATE='latin1_swedish_ci'
65ENGINE=InnoDB;
66
67CREATE TABLE `orcamento_perguntas` (
68	`id` INT(11) NOT NULL AUTO_INCREMENT,
69	`id_cotacao` INT(11) NOT NULL,
70	`id_usuario` INT(11) NOT NULL,
71	`replyid` INT(11) NULL DEFAULT NULL,
72	`mensagem` VARCHAR(255) NOT NULL,
73	`data` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
74	`tipo` ENUM('0','1') NOT NULL COMMENT '0 = comentario fornecedor (pergunta principal), 1 = reply (respostas)',
75	PRIMARY KEY (`id`),
76	INDEX `id_cotacao` (`id_cotacao`),
77	INDEX `id_user` (`id_usuario`)
78)
79COLLATE='utf8_general_ci'
80ENGINE=InnoDB
81AUTO_INCREMENT=1
82;
83
84
85CREATE TABLE `administradoras_condominios` (
86	`id_administradora` INT(11) NULL DEFAULT NULL,
87	`id_condominio` INT(11) UNSIGNED NULL DEFAULT NULL,
88	UNIQUE INDEX `id_administradora_id_condominio` (`id_administradora`, `id_condominio`),
89	INDEX `FKcondominio` (`id_condominio`),
90	CONSTRAINT `FKadministradora` FOREIGN KEY (`id_administradora`) REFERENCES `administradoras` (`id`),
91	CONSTRAINT `FKcondominio` FOREIGN KEY (`id_condominio`) REFERENCES `users` (`id`)
92)
93COLLATE='utf8_general_ci'
94ENGINE=InnoDB
95;
96
97
98ALTER TABLE `users`
99	CHANGE COLUMN `tp_perfil` `tp_perfil` ENUM('F','C','A') NOT NULL AFTER `tipo`;