blt · June 7, 2011 20:10
diff --git a/error.txt b/error.txt
 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE NOT EXISTS (         SELECT id FROM PlatonicBridgeUser         WHERE jid= ' at line 1
diff --git a/query.sql b/query.sql
 INSERT INTO PlatonicBridgeUser (jid)
 SELECT '[email protected]' 
 WHERE NOT EXISTS (
    SELECT id FROM PlatonicBridgeUser
    WHERE jid= '[email protected]' 
 )
diff --git a/schema.sql b/schema.sql
 CREATE TABLE PlatonicBridgeUser (
       id SERIAL NOT NULL PRIMARY KEY,
       jid text NOT NULL UNIQUE
 );
	INSERT INTO PlatonicBridgeUser (jid)
	SELECT '[email protected]'
	WHERE NOT EXISTS (
	SELECT id FROM PlatonicBridgeUser
	WHERE jid= '[email protected]'
	)
	CREATE TABLE PlatonicBridgeUser (
	id SERIAL NOT NULL PRIMARY KEY,
	jid text NOT NULL UNIQUE
	);