· 9 years ago · Oct 11, 2016, 03:12 AM
1-- Drop the table if it exists;
2DROP TABLE IF EXISTS usertable;
3
4-- Create the user table with 5 fields.
5CREATE TABLE usertable(YCSB_KEY VARCHAR (255) NOT NULL,
6 FIELD0 VARCHAR(100), FIELD1 VARCHAR(100),
7 FIELD2 VARCHAR(100), FIELD3 VARCHAR(100),
8 FIELD4 VARCHAR(100), FIELD5 VARCHAR(100),
9 FIELD6 VARCHAR(100), FIELD7 VARCHAR(100),
10 FIELD8 VARCHAR(100), FIELD9 VARCHAR(100),
11 PRIMARY KEY(YCSB_KEY)
12 );