I hereby claim:
- I am dcopeland on github.
- I am dpc47 (https://keybase.io/dpc47) on keybase.
- I have a public key whose fingerprint is 8A21 3C38 4842 782E 457B 5471 3269 978A 4785 FD90
To claim this, I am signing this object:
Verifying that +dpc47 is my Bitcoin username. You can send me #bitcoin here: https://onename.io/dpc47 |
I hereby claim:
To claim this, I am signing this object:
SELECT * FROM foo_base; | |
+----+-----------+-------------+-------------+ | |
| id | tenant | foo | bar | | |
+----+-----------+-------------+-------------+ | |
| 1 | tenant1 | tenant1foo1 | tenant1bar1 | | |
| 2 | tenant2 | tenant2foo1 | tenant2bar1 | | |
+----+-----------+-------------+-------------+ | |
2 rows in set (0.00 sec) |
SELECT * FROM foo; | |
+----+-------------+-------------+ | |
| id | foo | bar | | |
+----+-------------+-------------+ | |
| 1 | tenant1foo1 | tenant1bar1 | | |
+----+-------------+-------------+ | |
1 row in set (0.00 sec) |
INSERT INTO foo (foo, bar) | |
VALUES ('tenant2foo1', 'tenant2bar1'); | |
SELECT * FROM foo; | |
+----+-------------+-------------+ | |
| id | foo | bar | | |
+----+-------------+-------------+ | |
| 2 | tenant2foo1 | tenant2bar1 | | |
+----+-------------+-------------+ | |
1 row in set (0.00 sec) |
INSERT INTO foo (foo, bar) | |
VALUES ('tenant1foo1', 'tenant1bar1'); |
CREATE TABLE foo_base ( | |
id INTEGER AUTO_INCREMENT PRIMARY KEY, | |
tenant VARCHAR(16), | |
foo VARCHAR(64), | |
bar VARCHAR(64) | |
); | |
CREATE VIEW foo AS | |
SELECT id, foo, bar | |
FROM foo_base |