Database Reference
In-Depth Information
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 above statement, we created a new table called users , which has three columns:
username and email , which are text columns, and encrypted_password , which
has the type blob . The username column acts as the primary key for the table.
Search WWH ::




Custom Search