{"slug":"meridian-digital-cjenik-i-sidrena-cijena","name":"Meridian Digital Cjenik i Sidrena Cijena","description":"Helps Croatian WooCommerce shops publish the daily price list (cjenik) as CSV/XML and show the anchor price (sidrena cijena) and lowest 30-day price.","author":"Leonard Martinis (Meridian Digital)","active_installs":0,"version":"0.1.0","wp_org_url":"https://wordpress.org/plugins/meridian-digital-cjenik-i-sidrena-cijena/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cjenik_price_history","full_table_name":"wp_cjenik_price_history","description":"Stores cjenik price history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"variation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"price","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"regular_price","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"is_sale","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sale_name","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"valid_from","type":"datetime","nullable":false,"primary_key":false},{"name":"valid_to","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cjenik_price_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_id bigint(20) unsigned NOT NULL, variation_id bigint(20) unsigned NOT NULL DEFAULT 0, item_id bigint(20) unsigned NOT NULL, price decimal(19,4) NOT NULL, regular_price decimal(19,4) NOT NULL, is_sale tinyint(1) NOT NULL DEFAULT 0, sale_name varchar(191) NOT NULL DEFAULT '', source varchar(20) NOT NULL DEFAULT 'observed', valid_from datetime NOT NULL, valid_to datetime DEFAULT NULL, PRIMARY KEY (id), KEY item_from (item_id,valid_from), KEY item_to (item_id,valid_to) ) $charset;\" );"},{"table_name":"cjenik_publications","full_table_name":"wp_cjenik_publications","description":"Stores cjenik publications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"outlet_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"storage_number","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"published_at","type":"datetime","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"file_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"format","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"row_count","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"sha256","type":"char(64)","nullable":false,"primary_key":false},{"name":"warnings","type":"longtext","nullable":true,"primary_key":false},{"name":"error","type":"text","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cjenik_publications ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, outlet_id varchar(64) NOT NULL, storage_number bigint(20) unsigned DEFAULT NULL, published_at datetime NOT NULL, status varchar(20) NOT NULL, file_name varchar(255) NOT NULL DEFAULT '', format varchar(10) NOT NULL DEFAULT '', row_count int(10) unsigned NOT NULL DEFAULT 0, sha256 char(64) NOT NULL DEFAULT '', warnings longtext, error text, deleted_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY outlet_storage (outlet_id,storage_number), KEY outlet_published (outlet_id,published_at) ) $charset;\" );"}],"table_count":2}