CREATE TABLE test(i INTEGER, j TIMESTAMP TIME INDEX);

DESC TABLE test;

INSERT INTO test VALUES (1, 1), (2, 2);

ALTER TABLE test ADD COLUMN k INTEGER;

ALTER TABLE test ADD COLUMN IF NOT EXISTS k INTEGER;

SELECT * FROM test;

DESC TABLE test;

ALTER TABLE test ADD COLUMN host STRING PRIMARY KEY;

SELECT * FROM test;

DESC TABLE test;

ALTER TABLE test ADD COLUMN idc STRING default 'idc' PRIMARY KEY;

SELECT * FROM test;

DESC TABLE test;

ALTER TABLE test ADD COLUMN "IdC" STRING default 'idc' PRIMARY KEY;

DESC TABLE test;

ALTER TABLE test ADD COLUMN "foo" STRING default 'foo' PRIMARY KEY, ADD COLUMN "bar" STRING default 'bar' PRIMARY KEY;

ALTER TABLE test ADD COLUMN IF NOT EXISTS  "foo" STRING default 'foo' PRIMARY KEY, ADD COLUMN "bar" STRING default 'bar' PRIMARY KEY;

ALTER TABLE test ADD COLUMN IF NOT EXISTS  "foo" STRING default 'foo' PRIMARY KEY, ADD COLUMN IF NOT EXISTS "bar" STRING default 'bar' PRIMARY KEY;

DESC TABLE test;

DROP TABLE test;
