{"slug":"wpec-goodrelations","name":"GoodRelations for WP e-Commerce","description":"Adds GoodRelations metadata as RDFa to WP e-Commerce plugin","author":"Cjunghanns","active_installs":10,"version":"0.1.8","wp_org_url":"https://wordpress.org/plugins/wpec-goodrelations/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"gr_address","full_table_name":"wp_gr_address","description":"Stores gr address data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"street_address","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"postal_code","type":"int(10)","nullable":false,"primary_key":false},{"name":"locality","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"region","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"country_name","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"tel","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"logo","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"kind","type":"int(1)","nullable":false,"primary_key":false},{"name":"annotation","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"lati","type":"varchar(11)","nullable":false,"primary_key":false},{"name":"long","type":"varchar(11)","nullable":false,"primary_key":false},{"name":"duns","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"gln","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"isicv4","type":"varchar(11)","nullable":false,"primary_key":false},{"name":"naics","type":"varchar(11)","nullable":false,"primary_key":false},{"name":"language","type":"varchar(3)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gr_address ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, street_address varchar(100) NOT NULL, postal_code int(10) NOT NULL, locality varchar(50) NOT NULL, region varchar(50) NOT NULL, country_name varchar(20) NOT NULL, email varchar(50) NOT NULL, tel varchar(15) NOT NULL, logo varchar(100) NOT NULL, url varchar(100) NOT NULL, kind int(1) NOT NULL COMMENT '1 = BusinessEntitity 2=LocationOfSalesOrServiceProvisioning 3=Manufacterer', annotation varchar(10) NOT NULL, lati varchar(11) NOT NULL, `long` varchar(11) NOT NULL, duns varchar(20) NOT NULL, gln varchar(20) NOT NULL, isicv4 varchar(11) NOT NULL, naics varchar(11) NOT NULL, `language` varchar(3) NOT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"gr_openinghours","full_table_name":"wp_gr_openinghours","description":"Stores gr openinghours data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"pos_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"day","type":"varchar(7)","nullable":false,"primary_key":false},{"name":"am_pm","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"opens","type":"time","nullable":false,"primary_key":false},{"name":"closes","type":"time","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gr_openinghours ( id int(11) NOT NULL AUTO_INCREMENT, pos_id int(11) NOT NULL, `day` varchar(7) NOT NULL COMMENT 'Possible values: mon, tue, wed, thu, fri, sat, sun, pub, mon_fri', am_pm varchar(2) NOT NULL, opens time NOT NULL, closes time NOT NULL, PRIMARY KEY (id) ) ENGINE"}],"table_count":2}