• Home
• com.github.tchoulihan
• bitmerchant
• 1.4.0
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

houlihan.bitmerchant.1.4.0.source-code.bitmerchant-wallet-views.sql Maven / Gradle / Ivy

CREATE VIEW buttons_view AS 
SELECT
buttons.id as id, type, style, text, name, description, 
callback_url, total_native, iso as native_currency_iso,
variable_price, price_select, price_1, price_2, price_3,
price_4, price_5, buttons.created_at
FROM buttons
left join button_types
on button_types.id = buttons.type_id
left join button_styles
on button_styles.id = buttons.style_id
left join currencies
on currencies.id = buttons.native_currency_id
;

CREATE VIEW orders_view AS 
SELECT
orders.id as id, status, type, style, orders.total_satoshis, receive_address,
buttons.name as button_name, buttons.id as button_id, orders.total_native,
iso as native_currency_iso, description as button_description,
transaction_hash, network, 
payment_url, payment_request_url, merchant_data, memo, expire_time, orders.created_at
from orders
left join order_statuses
on order_statuses.id = orders.status_id

left join buttons
on buttons.id = orders.button_id

left join button_types
on button_types.id = buttons.type_id

left join button_styles
on button_styles.id = buttons.style_id

left join currencies
on currencies.id = buttons.native_currency_id
;

CREATE VIEW merchant_info_view AS
SELECT 
merchant_info.id, name, currency_id, iso as native_currency_iso
from merchant_info

left join currencies
on currencies.id = merchant_info.currency_id
;