github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/importccl/testdata/mysqldump/everything.cockroach-schema.sql (about)

     1  CREATE TABLE everything (
     2    i     INT4 PRIMARY KEY,
     3  
     4    c     CHAR(10) NOT NULL,
     5    s     VARCHAR(100) NULL DEFAULT e'this is s\'s default value':::STRING,
     6    tx    TEXT,
     7    e     STRING,
     8  
     9    bin   BYTEA NOT NULL,
    10    vbin  BYTEA,
    11    bl    BLOB,
    12  
    13    dt    TIMESTAMPTZ NOT NULL DEFAULT '2000-01-01 00:00:00+00:00':::TIMESTAMPTZ,
    14    d     DATE,
    15    ts    TIMESTAMPTZ NOT NULL DEFAULT current_timestamp(),
    16    t     TIME,
    17    -- TODO(dt): Fix year parsing.
    18    -- y  SMALLINT,
    19  
    20    de    DECIMAL(10, 0),
    21    nu    NUMERIC(10, 0),
    22    d53   DECIMAL(5,3),
    23  
    24    iw    INT4 NOT NULL,
    25    iz    INT8,
    26    ti    SMALLINT DEFAULT 5:::INT,
    27    si    SMALLINT,
    28    mi    INT4,
    29    bi    BIGINT,
    30  
    31    fl    FLOAT4 NOT NULL,
    32    rl    DOUBLE PRECISION,
    33    db    DOUBLE PRECISION,
    34  
    35    f17   FLOAT4,
    36    f47   DOUBLE PRECISION,
    37    f75   FLOAT4,
    38    j     JSON,
    39    CONSTRAINT imported_from_enum_e CHECK (e IN ('Small':::STRING, 'Medium':::STRING, 'Large':::STRING))
    40  )