zend-blog-3-backend

1
CREATE VIEW `v_commentators` AS
2
  SELECT
3
    c.id,
4
    c.name,
5
    c.mail,
6
    c.website,
7
    c.force_image
8
  FROM commentators AS c
9
  UNION ALL
10
  SELECT
11
    10000000 + u.id AS id,
12
    u.username AS name,
13
    u.mail,
14
    NULL AS website,
15
    1 AS force_image
16
  FROM users AS u
17