DB migration: add indexes for latest and published

Add 'published' column to db tables

First step of integrating publishing workflows into struct

Migration cleanup

Finally removes a temp table left over by migration 16

Fix some incorrectly migrated lookup data

Migrate database to unified schema

Start unifying schema types

Schemas per se are type agnostic, isLookup property is removed. Data is stored and accessed differently based on how it is entered and retrieved.

The crucial change is i

Start unifying schema types

Schemas per se are type agnostic, isLookup property is removed. Data is stored and accessed differently based on how it is entered and retrieved.

The crucial change is introduction of the composite key of pid and rid. Previous page data utilizes rid = 0 to differentiate itself. Other types, notably lookup, have autoincrementing rid.

Database migration is not implemented yet.

show more ...

This commit adds '%lastsummary%' special column for page schemas. The column contains the summary of last page revision.

feat: Show translatable schema names on pages

SPR-841 #45

feat: store user and rev of all pages

Rename `meta/Title.php` `meta/Page.php` since it now handles the user
and timestamp for the last change as well.

This is done in preparation to adding a %laste

feat: store user and rev of all pages

Rename `meta/Title.php` `meta/Page.php` since it now handles the user
and timestamp for the last change as well.

This is done in preparation to adding a %lasteditor% selector showing
the last editor of a page and changing the %lastupdated% to show the
time when the page was last changed instead of showing the time when the
struct data of the page was last updated.

SPR-622

show more ...

add a latest column to the multi_* tables

This makes it easier to access the most current data, similar to what we
have in single tables already

added missing database file

added editors to schema. not checked anywhere, yet

Save user on schema change and more imexport tools

added islookup to schemas table

add a titles table

automatically change the type for existing Image fields

update assigments when patterns are changed

new table for page assignments/patterns #28

use one multivalue table per schema

adds a multivals table

for columns that store multiple values (multi = true), we store a NULL
in the data_* table and put all the values in the multivals table. The
row column acts as a simple count

adds a multivals table

for columns that store multiple values (multi = true), we store a NULL
in the data_* table and put all the values in the multivals table. The
row column acts as a simple counter so values can be stored and
retrieved in the correct order.

show more ...

added table to hold schema assignments

Schemas should be assignable to namespaces or pages. That's why the
column to hold that info is called assign and not pid.

a very first basic version of the schema editor works

a first go at the overall structure. far from complete