bbFxZ0Ue

1CREATE TABLE LOCKED_items
2(
3LOCKED text,
4item text,
5lock_date timestamp,
6PRIMARY KEY ((LOCKED),item)
7); 
8     
9insert into locked_item  (LOCKED,item,lock_date) values('Y','item1',toTimestamp(now())) IF NOT EXISTS; 
10     
11BEGIN BATCH
12insert into locked_skus (LOCKED,sku,lock_date) values('Y','item5',toTimestamp(now())) IF NOT EXISTS;
13insert into locked_skus (LOCKED,sku,lock_date) values('Y','item6',toTimestamp(now())) IF NOT EXISTS;
14insert into locked_skus (LOCKED,sku,lock_date) values('Y','tem7',toTimestamp(now())) IF NOT EXISTS;
15insert into locked_skus (LOCKED,sku,lock_date) values('Y','tem61',toTimestamp(now())) IF NOT EXISTS;
16APPLY BATCH;