Creating the users table

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.