1  -- Wallet definition for Deployooor contractt
 2  -- Native Contract ID: EJs7oEjKkvCeEVCmpRsd6fEoTGCFJ7WKUBfmAjwaegN
 3  
 4  CREATE TABLE IF NOT EXISTS EJs7oEjKkvCeEVCmpRsd6fEoTGCFJ7WKUBfmAjwaegN_deploy_auth (
 5      -- Authority Contract ID
 6      contract_id BLOB PRIMARY KEY NOT NULL,
 7      -- Authority keypair secret key
 8      secret_key BLOB NOT NULL,
 9      -- Contract lock flag
10      is_locked INTEGER NOT NULL,
11      -- Block height of the transaction this contract was locked on chain
12      lock_height INTEGER
13  );
14  
15  CREATE TABLE IF NOT EXISTS EJs7oEjKkvCeEVCmpRsd6fEoTGCFJ7WKUBfmAjwaegN_deploy_history (
16      -- Transaction hash where this deployment action was executed
17      tx_hash TEXT PRIMARY KEY NOT NULL,
18      -- Authority identifier this deployment action is for
19      contract BLOB NOT NULL,
20      -- Type of this deployment action
21      type TEXT NOT NULL,
22      -- Block height of the transaction this deployment action was executed
23      block_height INTEGER NOT NULL,
24      -- Deployed WASM bincode of a deploy type action
25      wasm_bincode BLOB,
26      -- Serialized deploy instruction of a deploy type action
27      deploy_ix BLOB,
28  
29      FOREIGN KEY(contract) REFERENCES EJs7oEjKkvCeEVCmpRsd6fEoTGCFJ7WKUBfmAjwaegN_deploy_auth(contract_id) ON DELETE CASCADE ON UPDATE CASCADE
30  );