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