-- Create our table if it's not there.
CREATE TEMPORARY TABLE IF NOT EXISTS `all_queries` (
  `QUERY_NAME` VARCHAR(30) NOT NULL PRIMARY KEY,
  `QUERY_TEXT` TEXT NOT NULL
);
 
-- Make sure it's empty... This won't take IF EXISTS in MySQL 4.0!
TRUNCATE TABLE `all_queries`;
 
-- Grab all the default queries.
INSERT INTO `all_queries`
SELECT QUERY_NAME, QUERY_TEXT
FROM sc_master.queries WHERE QUERY_NAME LIKE 'USER%';
 
-- Now get our overrides.
REPLACE INTO `all_queries`
SELECT QUERY_NAME, QUERY_TEXT
FROM gc_midheart.queries WHERE QUERY_NAME LIKE 'USER%';
 
-- Display results.
SELECT * FROM `all_queries`;