VeryFatBoy

CREATE DATABASE IF NOT EXISTS acme;

USE acme;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

VeryFatBoy

CREATE DATABASE IF NOT EXISTS acme;

USE acme;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

VeryFatBoy

CREATE DATABASE IF NOT EXISTS acme;

USE acme;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

VeryFatBoy

CREATE DATABASE IF NOT EXISTS acme;

USE acme;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

VeryFatBoy

create database maps;
use maps;

create table countries (
  boundary geography,
  name_short varchar(3),
  name varchar(50),
  name_long varchar(50),
  abbrev varchar(10),
  postal varchar(4),

VeryFatBoy

-- Create database
create database if not exists acme;
use acme;

-- Create table
create rowstore table `record` (
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  SHARD KEY () 

VeryFatBoy

create database db1;
use db1;

create table t(a int not null, shard(a), sort key());

insert t values(1);

delimiter //
/* Fill table t with n or more rows, doubling the size until
 the goal is reached. */

VeryFatBoy

-- TIME SERIES
-- ===========

-- setup schema
CREATE DATABASE temp_history;

USE temp_history;

CREATE TABLE temperatures (
  location VARCHAR(200) NOT NULL,

VeryFatBoy

-- FULL TEXT SEARCH
-- ================

-- setup schema
CREATE DATABASE library;

USE library;

CREATE TABLE books (
  title VARCHAR(200) not null,

VeryFatBoy

license: YOUR_LICENSE_KEY
memsql_server_version: 7.1.8
package_type: rpm
hosts:
- hostname: 127.0.0.1
  localhost: true
  nodes:
  - register: false
    role: Master
    config: