Falcon supports all of the standard column data types supported by MySQL.

To create a table that is using the Falcon engine use the ENGINE = Falcon option within the CREATE TABLE statement:

CREATE TABLE names (id INT, fname VARCHAR (20), lname VARCHAR (20)) ENGINE=Falcon

Indexes can be created using all of the standard methods; for example you can explicitly specify an index on a column:

CREATE TABLE ids (id int, index (id)) ENGINE=Falcon

Generate one as part of a primary key:

CREATE TABLE ids (id int),PRIMARY KEY (id) ENGINE=Falcon

Or you can create multi-key and multiple indexes:

CREATE TABLE t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,
name CHAR(30),primary key (id,id2),index index_id3 (id3)) ENGINE=Falcon