use bay;
--
-- Column family 'books' definition
-- Key: book_id
-- added file_size column
update column family books
  with comparator = UTF8Type
  and key_validation_class = UTF8Type
  and default_validation_class = UTF8Type
  and column_metadata = [
     {column_name: title, validation_class: UTF8Type},
     {column_name: description, validation_class: UTF8Type},
     {column_name: author, validation_class: UTF8Type},
     {column_name: productid, validation_class: UTF8Type, index_name: 'productid_idx', index_type: 0},
     {column_name: filename, validation_class: UTF8Type},
     {column_name: thumbnail, validation_class: UTF8Type},
     {column_name: thumbnailurl, validation_class: UTF8Type},
     {column_name: thumbnailversion, validation_class: IntegerType},
     {column_name: uri, validation_class: UTF8Type},
     {column_name: uuid, validation_class: UTF8Type},
     {column_name: tocuri, validation_class: UTF8Type},
     {column_name: deployments, validation_class: UTF8Type},
     {column_name: version, validation_class: IntegerType},
     {column_name: epsversion, validation_class: IntegerType},
     -- Source example: Habitat, etc.
     {column_name: source, validation_class: UTF8Type},
     -- Stringified list of labels [JSON]; May be we can use to query books
     {column_name: labels, validation_class:UTF8Type},
     {column_name: status, validation_class:UTF8Type},
     {column_name: createdby, validation_class: UTF8Type},
     {column_name: createdon, validation_class: DateType},
     {column_name: updatedby, validation_class:UTF8Type},
     {column_name: updatedon, validation_class: DateType},
     {column_name: resourceurl, validation_class: UTF8Type},
     {column_name: images, validation_class: UTF8Type},
     {column_name: availabilitytype, validation_class: UTF8Type},
     {column_name: prodversion, validation_class: IntegerType},
     {column_name: coverimage, validation_class: UTF8Type},
     {column_name: guid_generated, validation_class: BooleanType},
     {column_name: friendly_status, validation_class:UTF8Type},
     {column_name: offline_access_type, validation_class: UTF8Type},
     {column_name: is_bulk_ftpupload, validation_class: BooleanType},
     {column_name: file_path, validation_class: UTF8Type},
     {column_name: server_info, validation_class: UTF8Type},
     {column_name: current_deployments, validation_class: UTF8Type},
     {column_name: eps_thumbnail_uuid, validation_class: UTF8Type},
     {column_name: isbn, validation_class: UTF8Type},
     {column_name: type_of_book, validation_class: UTF8Type},
     {column_name: file_size, validation_class: UTF8Type}
     {column_name: public_book_id, validation_class: UTF8Type}
];