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.gender,
8
    c.fake_email,
9
    0 AS avatar_variant,
10
    c.email_check
11
  FROM commentators AS c
12
  UNION ALL
13
  SELECT
14
    10000000 + u.id AS id,
15
    u.username AS name,
16
    u.mail,
17
    NULL AS website,
18
    u.gender,
19
    0 AS fake_email,
20
    u.avatar_variant,
21
    NULL AS email_check
22
  FROM users AS u
23