Ticket #20: alteracoes.sql
| File alteracoes.sql, 429 bytes (added by , 10 years ago) |
|---|
| Line | |
|---|---|
| 1 | CREATE TABLE `tconfirmacaoemailcursotranferido` ( |
| 2 | `ID_Turma` int( 11 ) NOT NULL DEFAULT '0', |
| 3 | `ID_Aluno` int( 11 ) NOT NULL DEFAULT '0', |
| 4 | `ID_Agente` int( 11 ) NOT NULL, |
| 5 | `Obs` text NOT NULL , |
| 6 | `Data_Confirmado` datetime NOT NULL DEFAULT NOW(), |
| 7 | PRIMARY KEY ( `ID_Turma` , `ID_Aluno` ) |
| 8 | ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4; |
| 9 | |
| 10 | UPDATE `tstatusturma` SET `Desc_StatusTurma` = 'EM ESPERA' WHERE `tstatusturma`.`ID_StatusTurma` =2; |
| 11 |
