-- log/auditoria

CREATE TABLE auditoria_movimientos
(
id_mov INT NOT NULL auto_increment,
cod_cuenta VARCHAR(100),
fecha_ant DATETIME,
cantidad_ant INT,
cod_cuenta_n VARCHAR(100),
fecha_n DATETIME,
cantidad_n INT,
usuario VARCHAR(40),
feca_mod DATETIME,
PRIMAR KEY(id_mov))
ENGINE InnoDB;

CREATE TRIGGER t_auditoria
    AFTER UPDATE ON movimientos
    FOR EACH ROW
    BEGIN
        INSERT INTO auditoria_movimientos
        (cod_cuenta_ant, fecha_ant,cantidad_ant
        cod_cuenta_n, fecha_n, cantidad_n,
        usuario, fecha_mod)
        VALUES
        (OLD.cod_cuenta, OLD.fecha, OLD.cantidad,
        NEW.cod_cuenta, NEW.fecha, NEW.cantidad, CURRENT_USER(),NOW());
        END;

-- EVENTOS

-- -Una ocasión

-- -periodicamente

vble -> global event_scheduler (ON | OFF | DISABLE)

CREATE event
ALTER
    [DEFINER = { USER | CURRENT_USER }]
    EVENT event_name
    [ON SCHEDULE schedule]
    [ON COMPLETION [NOT] PRESERVE]
    [RENAME TO new_event_name]
    [ENABLE | DISABLE | DISABLE ON SLAVE]
    [COMMENT 'comment']
    [DO event_body]

SHOW event
DROP event

CREATE
    [DEFINER = { USER | CURRENT_USER }]
    EVENT
    [IF NOT EXISTS]
    event_name
    ON SCHEDULE schedule
    [ON COMPLETION [NOT] PRESERVE]
    [ENABLE | DISABLE | DISABLE ON SLAVE]
    [COMMENT 'comment']
    DO event_body;


schedule:
    AT TIMESTAMP [+ INTERVAL INTERVAL] ...
  | EVERY INTERVAL
    [STARTS TIMESTAMP [+ INTERVAL INTERVAL] ...]
    [ENDS TIMESTAMP [+ INTERVAL INTERVAL] ...]


INTERVAL:
    quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
              WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
              DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

DELIMETER $$
CREATE EVENT bonificacion
ON SCHEDULE AT CURRENT_TIMESTAMP +
    INTERVAL 1 MONTH
DO UPDATE banco.cliente SET saldo=saldo+100 WHERE fecha_creacion BETWEEN NOW() AND date_add (NOW(),INTERVAL -1 MONTH);$$




DELIMETER $$
CREATE EVENT arduino__noticias
ON SCHEDULE EVERY 1 MONTH
STARTS '2014-01-01 00:00:00' ENABLE
DO
BEGIN
INSERT INTO historico_noticias
SELECT * FROM noticias WHERE fecha <=
DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY);
DELETE FROM noticias WHERE fecha <= DATE_SUB (CURRENT_DATE(), INTERVAL 30 DAY);
END;$$


PROCEDIMIENTOS: Tareas sencillas . CALL
FUNCIONES: Parecido a procedimientos, devuelve algo.
VISTAS: INstantaneas de la bd
TRIGGER: AFTER o BEFORE declarando acciones ante modificaciones de la BD.
EVENTOS: Realizan acciones en ciertos moentos temporales.