• Home
• io.stargate.it
• testing
• 1.0.85
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

t.testing.1.0.85.source-code.betterbotz.cql Maven / Gradle / Ivy

-- Used to create the cql schema to generate the schema.json file
-- See GraphqlTest.java

CREATE KEYSPACE IF NOT EXISTS betterbotz
WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1 };

CREATE TABLE IF NOT EXISTS betterbotz."Products" (
    id uuid,
    name text,
    price decimal,
    created timestamp,
    "prodName" text,
    "customerName" text,
    description text,
    PRIMARY KEY ((id), name, price, created)
);

CREATE TABLE IF NOT EXISTS betterbotz."Orders" (
    "prodName" text,
    "customerName" text,
    id uuid,
    "prodId" uuid,
    address text,
    description text,
    price decimal,
    "sellPrice" decimal,
    "value_int" int,
    "value_double" double,
    "value_bigint" bigint,
    "value_varint" varint,
    "value_float" float,
    "value_smallint" smallint,
    "value_tinyint" tinyint,

    PRIMARY KEY (("prodName"), "customerName")
);