From Sharp Mockingbird, 6 Years ago, written in Plain Text.
Embed
  1. use bay;
  2. --
  3. -- Column family 'books' definition
  4. -- Key: book_id
  5. -- added file_size column
  6. update column family books
  7.   with comparator = UTF8Type
  8.   and key_validation_class = UTF8Type
  9.   and default_validation_class = UTF8Type
  10.   and column_metadata = [
  11.      {column_name: title, validation_class: UTF8Type},
  12.      {column_name: description, validation_class: UTF8Type},
  13.      {column_name: author, validation_class: UTF8Type},
  14.      {column_name: productid, validation_class: UTF8Type, index_name: 'productid_idx', index_type: 0},
  15.      {column_name: filename, validation_class: UTF8Type},
  16.      {column_name: thumbnail, validation_class: UTF8Type},
  17.      {column_name: thumbnailurl, validation_class: UTF8Type},
  18.      {column_name: thumbnailversion, validation_class: IntegerType},
  19.      {column_name: uri, validation_class: UTF8Type},
  20.      {column_name: uuid, validation_class: UTF8Type},
  21.      {column_name: tocuri, validation_class: UTF8Type},
  22.      {column_name: deployments, validation_class: UTF8Type},
  23.      {column_name: version, validation_class: IntegerType},
  24.      {column_name: epsversion, validation_class: IntegerType},
  25.      -- Source example: Habitat, etc.
  26.      {column_name: source, validation_class: UTF8Type},
  27.      -- Stringified list of labels [JSON]; May be we can use to query books
  28.      {column_name: labels, validation_class:UTF8Type},
  29.      {column_name: status, validation_class:UTF8Type},
  30.      {column_name: createdby, validation_class: UTF8Type},
  31.      {column_name: createdon, validation_class: DateType},
  32.      {column_name: updatedby, validation_class:UTF8Type},
  33.      {column_name: updatedon, validation_class: DateType},
  34.      {column_name: resourceurl, validation_class: UTF8Type},
  35.      {column_name: images, validation_class: UTF8Type},
  36.      {column_name: availabilitytype, validation_class: UTF8Type},
  37.      {column_name: prodversion, validation_class: IntegerType},
  38.      {column_name: coverimage, validation_class: UTF8Type},
  39.      {column_name: guid_generated, validation_class: BooleanType},
  40.      {column_name: friendly_status, validation_class:UTF8Type},
  41.      {column_name: offline_access_type, validation_class: UTF8Type},
  42.      {column_name: is_bulk_ftpupload, validation_class: BooleanType},
  43.      {column_name: file_path, validation_class: UTF8Type},
  44.      {column_name: server_info, validation_class: UTF8Type},
  45.      {column_name: current_deployments, validation_class: UTF8Type},
  46.      {column_name: eps_thumbnail_uuid, validation_class: UTF8Type},
  47.      {column_name: isbn, validation_class: UTF8Type},
  48.      {column_name: type_of_book, validation_class: UTF8Type},
  49.      {column_name: file_size, validation_class: UTF8Type}
  50.      {column_name: public_book_id, validation_class: UTF8Type}
  51. ];