CDN Cassandra Schema

Sirikata

Users

Users {
   'jterrace': {
      'name': 'Jeff Terrace',
      'email': 'jterrace@gmail.com',
      'openid_name': 'Jeff Terrace',
      'openid_email': 'jterrace@gmail.com'
      'openid_identity': 'https://www.google.com/accounts/o8/id?id=AItOawlcO0O-myv8W1nBduUdjJslJDjl',
      'uploaded:/jterrace/duck.dae:0': ,
      'uploaded:/jterrace/whatever.dae:4': ,
      'uploading:a0ede732-025e-4021-b250-10275892af9b': 'c90b170b22c84c3a91fa7dbf13929f00',
      ...
   }
}

Names

Names {
   '/jterrace/duck.dae': {
      'type':'collada'
      'latest':0,
      0: {
         'upload_timestamp': 1297708487,
         'user':'jterrace',
         'original': { hash: 'ddde4f8bed9a8bc97d8cbd4137c63efd5e625fabbbe695bc26756a3f5f430aa4', size: 4988 },
         'fullres': { hash: '5c4e5f861fba6bb158b2ad95d90b502aeb8b13d4a00c15cca2e6927c9ae31b57', size: 3700 },
         'lowres': { hash: '8a134b6391c998a200696f2f87e1e270fe6c50d0f02d2d9a67e6ef1c4d4b787c', size: 1200 },
         'progressive_steam': { hash: '56561dab611a2637c1d7d1cdd29e951e9574956864d49488129611188a59f602, size: 2000 },
         'subfiles': {
            '/jterrace/duck.dae/tex1.jpg/0': {
               'name': '/jterrace/duck.dae/tex1.jpg',
               'version': 0
            }
         }
      },
      ...
   },
   ...
}

Files

Files {
   'ddde4f8bed9a8bc97d8cbd4137c63efd5e625fabbbe695bc26756a3f5f430aa4': {
      'data': <BLOB>
   },
   ...
}

ProgressiveStreams

ProgressiveStreams {
   '56561dab611a2637c1d7d1cdd29e951e9574956864d49488129611188a59f602': {
      ...
   },
   ...
}

Temporary File Uploads

TempFiles

TempFiles {
   '885c671b1dcc4aa6a4ae24973d379a29': {
      'username': 'jterrace',
      'size': 141312,
      'chunk_list': '0,65536,131072',
      '0': <BLOB of size 64KB>,
      '65536': <BLOB of size 64KB>,
      '131072': <BLOB of size 10KB>
   },
   ...
}

OpenID Storage

OpenIdAssocs

OpenIdAssocs {
   'b95134d39b0e43bfe1b17bdeaace942120c6ff0e4960c73b5ef7d5547cb61b7e_7b6b48fbe0c5fd4a59813d76034bae139f8c8828b672373f4a4b8e8a2e81dd77': {
      'serverurl': 'https://www.google.com/accounts/o8/ud',
      'handle': 'AOQobUe22QNZJcMto1XkcAspZpQgAZP_N9VKKzQ-45G9vMyJLzpuerpI',
      'secret': 8faae495a43922e6876f352620999513291876f5,
      'issued': 1297809129,
      'lifetime': 46800,
      'assoc_type': 'HMAC-SHA1'
   },
   ...
}

OpenIdNonces

OpenIdNonces {
   'serverurl_timestamp_salt': {
      'serverurl': 'http://...',
      'timestamp': 13235,
      'salt': 'dddd'
   },
   ...
}

Session Storage

Sessions

Sessions {
   '99e30ee7b1508fa73c5f1a8a57ada5bb': {
      'serialized': 'gAJ9cQEuOGU4ZGU3ZGQ3ZTExNDMzMDFhMTBlYWUwZWIzMjg3YmU=',
   }
}