gistfile1.sql

-- How to get all queries that has not been used by the site id 1 ?

    DROP TABLE IF EXISTS `queries`;
    SET @saved_cs_client     = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `queries` (
      `id` int(11) NOT NULL auto_increment,
      `created_at` datetime default NULL,
      `updated_at` datetime default NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    SET character_set_client = @saved_cs_client;

    DROP TABLE IF EXISTS `sites`;
    SET @saved_cs_client     = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `sites` (
      `id` int(11) NOT NULL auto_increment,
      `created_at` datetime default NULL,
      `updated_at` datetime default NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    SET character_set_client = @saved_cs_client;

    DROP TABLE IF EXISTS `sites_queries`;
    SET @saved_cs_client     = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `sites_queries` (
      `id` int(11) NOT NULL auto_increment,
      `site_id` int(11) NOT NULL,
      `query_id` int(11) NOT NULL,
      `created_at` datetime default NULL,
      `updated_at` datetime default NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    SET character_set_client = @saved_cs_client;