Our first table will store basic user account information: username, email, and password. To create the table, fire up the CQL shell (don't forget to use the USE my_status; statement if you are starting a fresh session) and enter the following CQL statement:
CREATE TABLE "users" (
"username" text PRIMARY KEY,
"email" text,
"encrypted_password" blob
);In the preceding statement, we created a new table called users, which has three columns: username and email, which are the text columns, and encrypted_password, which has the type blob. The username column acts as the primary key for the table.
Another way to declare this table is as follows:
CREATE TABLE "my_status"."users" ( "username" text, "email" text, "encrypted_password" blob, primary key (username) );
Later, we will learn that the second way of declaring tables is often the only way.