block_positions

0 rows


Description

Stores the position of a sticky block_instance on a another page than the one where it was added.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
blockinstanceid BIGINT 19 null
block_instances.id blocposi_blo2_fkR

The block_instance this position relates to.

contextid BIGINT 19 null
context.id blocposi_con2_fkR

With pagetype and subpage, defines the page we are setting the position for.

pagetype VARCHAR 64

With contextid and subpage, defines the page we are setting the position for.

subpage VARCHAR 16

With contextid and pagetype, defines the page we are setting the position for.

visible SMALLINT 5 null

Whether this block instance is visible on this page.

region VARCHAR 16

Which block region on this page this block should appear in.

weight BIGINT 19 null

Used to order the blocks within a block region.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
blocposi_blo_ix Performance Asc blockinstanceid
blocposi_bloconpagsub_uix Must be unique Asc/Asc/Asc/Asc blockinstanceid + contextid + pagetype + subpage
blocposi_con_ix Performance Asc contextid

Relationships