Skip to content

Instantly share code, notes, and snippets.

View dcopeland's full-sized avatar

Dan Copeland dcopeland

View GitHub Profile
Verifying that +dpc47 is my Bitcoin username. You can send me #bitcoin here: https://onename.io/dpc47
@dcopeland
dcopeland / keybase.md
Created March 12, 2014 17:42
Keybase proof

Keybase proof

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:

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