wp_gr_address
StaticStores gr address data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| name | varchar(100) | NO |
| street_address | varchar(100) | NO |
| postal_code | int(10) | NO |
| locality | varchar(50) | NO |
| region | varchar(50) | NO |
| country_name | varchar(20) | NO |
| varchar(50) | NO | |
| tel | varchar(15) | NO |
| logo | varchar(100) | NO |
| url | varchar(100) | NO |
| kind | int(1) | NO |
| annotation | varchar(10) | NO |
| lati | varchar(11) | NO |
| long | varchar(11) | NO |
| duns | varchar(20) | NO |
| gln | varchar(20) | NO |
| isicv4 | varchar(11) | NO |
| naics | varchar(11) | NO |
| language | varchar(3) | NO |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled GoodRelations for WP e-Commerce, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_gr_address`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from GoodRelations for WP e-Commerce