Help for Aimeos

Code: Select all

php app/console aimeos:setup

Code: Select all

resource:
    db:
        ...
        opt-persistent: 1

Code: Select all

mysql> show tables;                       
+-------------------------------+
| Tables_in_symfony             |
+-------------------------------+
| fos_user                      |
| fos_user_address              |
| fos_user_list                 |
| fos_user_list_type            |
| madmin_cache                  |
| madmin_cache_tag              |
| madmin_job                    |
| madmin_log                    |
| mshop_attribute               |
| mshop_attribute_list          |
| mshop_attribute_list_type     |
| mshop_attribute_type          |
| mshop_catalog                 |
| mshop_catalog_index_attribute |
| mshop_catalog_index_catalog   |
| mshop_catalog_index_price     |
| mshop_catalog_index_text      |
| mshop_catalog_list            |
| mshop_catalog_list_type       |
| mshop_coupon                  |
| mshop_coupon_code             |
| mshop_customer                |
| mshop_customer_address        |
| mshop_customer_group          |
| mshop_customer_list           |
| mshop_customer_list_type      |
| mshop_locale                  |
| mshop_locale_currency         |
| mshop_locale_language         |
| mshop_locale_site             |
| mshop_media                   |
| mshop_media_list              |
| mshop_media_list_type         |
| mshop_media_type              |
| mshop_order                   |
| mshop_order_base              |
| mshop_order_base_address      |
| mshop_order_base_coupon       |
| mshop_order_base_product      |
| mshop_order_base_product_attr |
| mshop_order_base_service      |
| mshop_order_base_service_attr |
| mshop_order_status            |
| mshop_plugin                  |
| mshop_plugin_type             |
| mshop_price                   |
| mshop_price_list              |
| mshop_price_list_type         |
| mshop_price_type              |
| mshop_product                 |
| mshop_product_list            |
| mshop_product_list_type       |
| mshop_product_property        |
| mshop_product_property_type   |
| mshop_product_stock           |
| mshop_product_stock_warehouse |
| mshop_product_tag             |
| mshop_product_tag_type        |
| mshop_product_type            |
| mshop_service                 |
| mshop_service_list            |
| mshop_service_list_type       |
| mshop_service_type            |
| mshop_supplier                |
| mshop_supplier_address        |
| mshop_supplier_list           |
| mshop_supplier_list_type      |
| mshop_text                    |
| mshop_text_list               |
| mshop_text_list_type          |
| mshop_text_type               |
+-------------------------------+
71 rows in set (0.02 sec)

Code: Select all

set session sql_mode='ansi';

CREATE TABLE "mshop_media_list" (
	-- Unique list id
	"id" INTEGER NOT NULL AUTO_INCREMENT,
	-- media id (parent id)
	"parentid" INTEGER NOT NULL,
	-- site id, references mshop_locale_site.id
	"siteid" INTEGER NOT NULL,
	-- typeid
	"typeid" INTEGER NOT NULL,
	-- domain (e.g.: text, attribute)
	"domain" VARCHAR(32) NOT NULL,
	-- Reference of the object in given domain
	"refid" VARCHAR(32) NOT NULL,
	-- Valid from
	"start" DATETIME DEFAULT NULL,
	-- Valid until
	"end" DATETIME DEFAULT NULL,
	-- Configuration
	"config" TEXT NOT NULL,
	-- Precedence of the promotion
	"pos" INTEGER NOT NULL,
	-- status code (0=hidden, 1=display, >1 for anything special)
	"status" SMALLINT NOT NULL DEFAULT 0,
	-- Date of last modification of this database entry
	"mtime" DATETIME NOT NULL,
	-- Date of creation of this database entry
	"ctime" DATETIME NOT NULL,
	-- Editor who modified this entry at last
	"editor" VARCHAR(255) NOT NULL,
CONSTRAINT "pk_msmedli_id"
	PRIMARY KEY ("id"),
CONSTRAINT "unq_msmedli_sid_dm_rid_tid_pid"
	UNIQUE ("siteid", "domain", "refid", "typeid", "parentid"),
CONSTRAINT "fk_msmedli_pid"
	FOREIGN KEY ("parentid")
	REFERENCES "mshop_media" ("id")
	ON UPDATE CASCADE
	ON DELETE CASCADE,
CONSTRAINT "fk_msmedli_typeid"
	FOREIGN KEY ( "typeid" )
	REFERENCES "mshop_media_list_type" ("id")
	ON DELETE CASCADE
	ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

SET SESSION SQL_MODE='ANSI';
CREATE TABLE "mshop_media_list_type" (
	-- Unique id
	"id" INTEGER NOT NULL AUTO_INCREMENT,
	-- site id, references mshop_locale_site.id
	"siteid" INTEGER NOT NULL,
	-- domain
	"domain" VARCHAR(32) NOT NULL,
	-- code
	"code"  VARCHAR(32) NOT NULL COLLATE utf8_bin,
	-- Name of the list type
	"label" VARCHAR(255) NOT NULL,
	-- Status (0=disabled, 1=enabled, >1 for special)
	"status" SMALLINT NOT NULL,
	-- Date of last modification of this database entry
	"mtime" DATETIME NOT NULL,
	-- Date of creation of this database entry
	"ctime" DATETIME NOT NULL,
	-- Editor who modified this entry at last
	"editor" VARCHAR(255) NOT NULL,
CONSTRAINT "pk_msmedlity_id"
	PRIMARY KEY ("id"),
CONSTRAINT "unq_msmedlity_sid_dom_code"
	UNIQUE ("siteid", "domain", "code")
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE "mshop_media_list" (
	-- Unique list id
	"id" INTEGER NOT NULL AUTO_INCREMENT,
	-- media id (parent id)
	"parentid" INTEGER NOT NULL,
	-- site id, references mshop_locale_site.id
	"siteid" INTEGER NOT NULL,
	-- typeid
	"typeid" INTEGER NOT NULL,
	-- domain (e.g.: text, attribute)
	"domain" VARCHAR(32) NOT NULL,
	-- Reference of the object in given domain
	"refid" VARCHAR(32) NOT NULL,
	-- Valid from
	"start" DATETIME DEFAULT NULL,
	-- Valid until
	"end" DATETIME DEFAULT NULL,
	-- Configuration
	"config" TEXT NOT NULL,
	-- Precedence of the promotion
	"pos" INTEGER NOT NULL,
	-- status code (0=hidden, 1=display, >1 for anything special)
	"status" SMALLINT NOT NULL DEFAULT 0,
	-- Date of last modification of this database entry
	"mtime" DATETIME NOT NULL,
	-- Date of creation of this database entry
	"ctime" DATETIME NOT NULL,
	-- Editor who modified this entry at last
	"editor" VARCHAR(255) NOT NULL,
CONSTRAINT "pk_msmedli_id"
	PRIMARY KEY ("id"),
CONSTRAINT "unq_msmedli_sid_dm_rid_tid_pid"
	UNIQUE ("siteid", "domain", "refid", "typeid", "parentid"),
CONSTRAINT "fk_msmedli_pid"
	FOREIGN KEY ("parentid")
	REFERENCES "mshop_media" ("id")
	ON UPDATE CASCADE
	ON DELETE CASCADE,
CONSTRAINT "fk_msmedli_typeid"
	FOREIGN KEY ( "typeid" )
	REFERENCES "mshop_media_list_type" ("id")
	ON DELETE CASCADE
	ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Select all

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
	AND TABLE_SCHEMA = '<dbname>'
	AND TABLE_NAME = 'mshop_price_list'