Created
October 5, 2016 16:33
-
-
Save natalia-chikina/7b78e469dabe4d6936b9f92e16bee29e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE IF NOT EXISTS streamingInventoryEvents( | |
| locationType text, | |
| locationId int, | |
| cacheTime timestamp, | |
| itemNumber text, | |
| tag text, | |
| time timestamp, | |
| scanType int, | |
| pieceTag text, | |
| repId int, | |
| ip text, | |
| PRIMARY KEY((locationType, locationId), cacheTime, itemNumber, tag)) WITH CLUSTERING ORDER BY (cacheTime DESC) AND default_time_to_live = 259200 AND gc_grace_seconds = 86400; | |
| CREATE TABLE IF NOT EXISTS streamingInventories ( | |
| locationType text, | |
| locationId int, | |
| cacheTime timestamp, | |
| PRIMARY KEY((locationType, locationId), cacheTime)) WITH CLUSTERING ORDER BY (cacheTime DESC) AND default_time_to_live = 259200 AND gc_grace_seconds = 86400; | |
| CREATE TABLE IF NOT EXISTS streamingInventoryProducts ( | |
| locationType text, | |
| locationId int, | |
| cacheTime timestamp, | |
| itemNumber text, | |
| productCount int, | |
| PRIMARY KEY((locationType, locationId), cacheTime, itemNumber)) WITH CLUSTERING ORDER BY (cacheTime DESC) AND default_time_to_live = 259200 AND gc_grace_seconds = 86400; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment