StangFAST01 - action to delete account for using storage copy
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from 01 - action to delete account for using storage @ https://flipsidecrypto.xyz/edit/queries/2aeedd90-3cec-4192-82e1-9147453a6569
-- forked from 01 - action to delete account for using storage @ https://flipsidecrypto.xyz/edit/queries/7c5d953f-dc2b-4732-81c2-74d7eb71ba74
-- forked from 01 - Chart action @ https://flipsidecrypto.xyz/edit/queries/8edf6f0f-2ff5-4eae-a2be-2fd223e111fa
-- forked from 01 - Chart @ https://flipsidecrypto.xyz/edit/queries/00a37573-f347-450e-80c1-d91b5e86d2e8
--- used LIKE and add the % to the end of each line
--- Program log: Instruction: InitializeAccount --> Program log: User requires [ xxx shades ] to store [ xxx byte ]
--- Program log: Instruction: IncreaseStorage --> ( Program log: Initial storage: ) - ( Program log: New storage: )
--- Program log: Instruction: DecreaseStorage --> ?
--- Program log: Instruction: IncreaseImmutableStorage --> ( Program log: Initial storage: ) - ( Program log: New storage: )
--- Program log: Instruction: MakeAccountImmutable --> ?
--- Program log: Instruction: RequestDeleteAccount --> request delete account
--- Program log: Instruction: DeleteAccount --> success delete account
--- Program log: Instruction: UnmarkDeleteAccount --> cancel delete account
with
new_users AS
(
SELECT
min( a.block_timestamp ) AS min_date
, a.signers[0] AS min_user
FROM
solana.core.fact_transactions a
WHERE
a.succeeded = 'true'
AND substring( a.log_messages[0] , charindex( ' ' , a.log_messages[0] ) +1 , 44 ) = '2e1wdyNhUvE76y6yUCvah2KaviavMJYKoRun8acMRBZZ'
AND a.signers[0] != 'E9gtcGSYWNAUGEg9MT8fHBEWeEZWRia7EafbxvBGChxd'
AND (
Run a query to Download Data