mirror of
https://github.com/FlipsideCrypto/crosschain-models.git
synced 2026-02-06 13:07:03 +00:00
17 lines
566 B
MySQL
17 lines
566 B
MySQL
|
{% macro create_user_abi_table() -%}
|
||
|
|
{% set create_query %}
|
||
|
|
create schema if not exists bronze_public;
|
||
|
|
CREATE TABLE if NOT EXISTS bronze_public.user_abis(
|
||
|
|
contract_address VARCHAR,
|
||
|
|
blockchain VARCHAR,
|
||
|
|
abi VARCHAR,
|
||
|
|
discord_username VARCHAR,
|
||
|
|
_INSERTED_TIMESTAMP TIMESTAMP,
|
||
|
|
DUPLICATE_ABI BOOLEAN
|
||
|
|
);
|
||
|
|
grant select on all tables in schema bronze_public to role datascience;
|
||
|
|
grant insert on all tables in schema bronze_public to role datascience;
|
||
|
|
|
||
|
|
{% endset %}
|
||
|
|
{% do run_query(create_query) %}
|
||
|
|
{% endmacro -%}
|