~/paste/15910
~/paste/15910
~/paste/15910

  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.9
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Genereertijd: 21 dec 2014 om 23:09
  6. -- Serverversie: 5.5.32-log
  7. -- PHP-versie: 5.4.35
  8.  
  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. SET time_zone = "+00:00";
  11.  
  12.  
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8 */;
  17.  
  18. --
  19. -- Databank: `picatoys_nl_joomla`
  20. --
  21.  
  22. -- --------------------------------------------------------
  23.  
  24. --
  25. -- Tabelstructuur voor tabel `jos_csvi_template_fields_combine`
  26. --
  27.  
  28. CREATE TABLE IF NOT EXISTS `jos_csvi_template_fields_combine` (
  29.   `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the cross reference',
  30.   `field_id` VARCHAR(255) NOT NULL COMMENT 'ID of the field',
  31.   `combine_id` VARCHAR(255) NOT NULL COMMENT 'ID of the combine rule',
  32.   PRIMARY KEY (`id`)
  33. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Holds the combine cross reference for a CSVI template field' AUTO_INCREMENT=9 ;
  34.  
  35. --
  36. -- Gegevens worden uitgevoerd voor tabel `jos_csvi_template_fields_combine`
  37. --
  38.  
  39. INSERT INTO `jos_csvi_template_fields_combine` (`id`, `field_id`, `combine_id`) VALUES
  40. (1, '14', '10'),
  41. (2, '14', '11'),
  42. (3, '14', '12'),
  43. (4, '14', '13'),
  44. (5, '37', '33'),
  45. (6, '37', '34'),
  46. (7, '37', '35'),
  47. (8, '37', '36');
  48.  
  49. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  50. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  51. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  52.  
Language: sql
Posted by jos_csvi_template_fields_combine at 21 Dec 2014, 10:12:19 UTC