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.disqus_id,
8
    c.email_hash
9
  FROM commentators AS c
10
  UNION ALL
11
  SELECT
12
    10000000 + u.id AS id,
13
    u.username AS name,
14
    u.mail,
15
    NULL AS website,
16
    NULL AS disqus_id,
17
    u.email_hash
18
  FROM users AS u
19