var pg = require('pg');

pg.connect(process.env.DATABASE_URL, function(err, client) {
	if (err) {
		return;
	}

	client.query("CREATE TABLE IF NOT EXISTS subscriptions(email varchar(64), repourl varchar(64))");
	client.query("CREATE TABLE IF NOT EXISTS packages(name varchar(64), version varchar(16), updated DATE)");
	client.query("INSERT INTO subscriptions(email, repourl) values('seriema@gmail.com', 'https://github.com/seriema/npmalerts.git')");
});


// client.query("INSERT INTO emps(firstname, lastname) values($1, $2)", ['Ronald', 'McDonald']);
// client.query("INSERT INTO emps(firstname, lastname) values($1, $2)", ['Mayor', 'McCheese']);

CREATE TABLE IF NOT EXISTS subscriptions(email varchar(64), repourl varchar(64))
CREATE TABLE IF NOT EXISTS packages(name varchar(64), version varchar(16), updated DATE)

INSERT INTO subscriptions(email, repourl) values('seriema@gmail.com', 'https://github.com/seriema/npmalerts.git')

@@ -451,485 +451,4 @@
 %7D);%0A
-%0A%0A// client.query(%22INSERT INTO emps(firstname, lastname) values($1, $2)%22, %5B'Ronald', 'McDonald'%5D);%0A// client.query(%22INSERT INTO emps(firstname, lastname) values($1, $2)%22, %5B'Mayor', 'McCheese'%5D);%0A%0ACREATE TABLE IF NOT EXISTS subscriptions(email varchar(64), repourl varchar(64))%0ACREATE TABLE IF NOT EXISTS packages(name varchar(64), version varchar(16), updated DATE)%0A%0AINSERT INTO subscriptions(email, repourl) values('seriema@gmail.com', 'https://github.com/seriema/npmalerts.git')%0A

Update create_db.js although it's not really used