   ORDER_ID INTEGER,
   ACTIVE_FLG varchar(1) DEFAULT 'Y'
 );
-
 
 CREATE TABLE message (
   ID VARCHAR(120) PRIMARY KEY,

  MESSAGE_ID VARCHAR(120),
  PRIMARY KEY(CONSUMER_ID, MESSAGE_ID)
);

CREATE SCHEMA IF NOT EXISTS todo_db;
SET SCHEMA todo_db;
DROP table IF EXISTS TODO;
DROP table IF EXISTS message;
DROP table IF EXISTS received_messages;


CREATE  TABLE TODO (
  ID varchar(255) PRIMARY KEY,
