CREATE SCHEMA mydb;
CREATE USER appuser;
SET PASSWORD FOR 'appuser'@'%'=password('123456');
GRANT ALL PRIVILEGES ON mydb.* TO 'appuser'@'%';

CREATE TABLE `mydb`.`application` (
  `id` INT NOT NULL,
  `name` VARCHAR(45) NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `mydb`.`application` VALUES (1, 'test');

CREATE KEYSPACE mydb WITH replication = {'class': 'SimpleStrategy'};

CREATE TABLE mydb.application (
   id int,
   name text,
   PRIMARY KEY (id)
);