core_api/bd_modify at master · comuREDE/core_api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
ALTER TABLE `comuna`.`acessos`
CHANGE COLUMN `no_acesso` `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ;


ALTER TABLE `comuna`.`cadastros`
CHANGE COLUMN `no_cadastro` `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE COLUMN `email` `email` VARCHAR(100) NULL DEFAULT NULL ,
CHANGE COLUMN `nome` `nome` VARCHAR(100) NULL DEFAULT NULL ;


ALTER TABLE `comuna`.`sensores_agua`
CHANGE COLUMN `no_evento` `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ;

ALTER TABLE `comuna`.`sensores_luz`
CHANGE COLUMN `no_evento` `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ;

ALTER TABLE `comuna`.`cadastros`
CHANGE COLUMN `cep` `cep` CHAR(5) NULL DEFAULT NULL ;


ALTER TABLE `comuna`.`sensores_agua`
CHANGE COLUMN `localizacao` `cep` CHAR(5) NULL DEFAULT NULL ;

ALTER TABLE `comuna`.`sensores_luz`
CHANGE COLUMN `localizacao` `cep` CHAR(5) NULL DEFAULT NULL ;

ALTER TABLE `comuna`.`relatorios`
CHANGE COLUMN `sensor` `sensor` INT UNSIGNED NULL DEFAULT NULL ;


alter table relatorios add column
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

alter table relatorios add column
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP


ALTER SCHEMA `comuna`  DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_general_ci ;

alter table sensores_agua add column
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

alter table sensores_agua add column
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

alter table sensores_luz add column
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

alter table sensores_luz add column
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;


ALTER TABLE `comuna`.`relatorios`
ADD COLUMN `sensores_id` INT UNSIGNED NOT NULL AFTER `updated_at`;


ALTER TABLE `comuna`.`triagem`
ADD COLUMN `sensores_id` INT UNSIGNED NOT NULL AFTER `updated_at`;


ALTER TABLE `comuna`.`sensores_agua`
CHANGE COLUMN `status` `status` VARCHAR(5) NULL DEFAULT 0 ;

ALTER TABLE `comuna`.`sensores_luz`
CHANGE COLUMN `status` `status` VARCHAR(5) NULL DEFAULT 0 ;

ALTER TABLE `comuna`.`triagem`
CHANGE COLUMN `status` `status` VARCHAR(5) NULL DEFAULT 0 ;


ALTER TABLE `comuna`.`relatorios`
CHANGE COLUMN `status` `status` VARCHAR(5) NULL DEFAULT 0 ,
CHANGE COLUMN `sensores_id` `triagem_id` INT(10) UNSIGNED NOT NULL ;