sql.sql

sql.sql

CREATE TABLE wp_woocommerce_api_keys (
key_id int NOT NULL identity(1,1),
user_id int NOT NULL,
description nvarchar(max) NULL,
permissions nvarchar(10) NOT NULL,
consumer_key nvarchar(64) NOT NULL,
consumer_secret nvarchar(43) NOT NULL,
nonces nvarchar(max) NULL,
truncated_key nvarchar(7) NOT NULL,
last_access datetime2 NULL default null,
constraint wp_woocommerce_api_keys_PK PRIMARY KEY (key_id)
)
GO
CREATE INDEX wp_woocommerce_api_keys_IDX1 on wp_woocommerce_api_keys (consumer_key)
GO
CREATE INDEX wp_woocommerce_api_keys_IDX2 on wp_woocommerce_api_keys (consumer_secret)
GO