CREATE TABLE IF NOT EXISTS `review` (
  `review_id` bigint(20) unsigned NOT NULL auto_increment,
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `entity_id` smallint(5) unsigned NOT NULL default '0',
  `entity_pk_value` int(10) unsigned NOT NULL default '0',
  `status_id` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`review_id`),
  KEY `FK_REVIEW_ENTITY` (`entity_id`),
  KEY `FK_REVIEW_STATUS` (`status_id`),
  KEY `FK_REVIEW_PARENT_PRODUCT` (`entity_pk_value`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Review base information' AUTO_INCREMENT=86 ;

--
-- A tábla adatainak kiíratása `review`
--

INSERT INTO `review` (`review_id`, `created_at`, `entity_id`, `entity_pk_value`, `status_id`) VALUES
(1, '2013-08-12 23:31:14', 1, 22, 2),
(2, '2013-09-05 01:33:41', 1, 20, 2),
(3, '2013-09-05 01:33:45', 1, 20, 2),
(4, '2013-09-05 01:33:47', 1, 20, 2),
(5, '2013-09-05 01:33:49', 1, 20, 2),
(6, '2013-09-05 01:33:51', 1, 20, 2),
(7, '2013-10-03 03:26:33', 1, 20, 2),
(8, '2013-10-03 03:26:38', 1, 20, 2),
(9, '2013-10-03 03:26:40', 1, 20, 2),
(10, '2013-10-03 03:26:42', 1, 20, 2),
(11, '2013-10-03 03:26:44', 1, 20, 2),
(12, '2013-10-10 22:23:22', 1, 20, 2),
(13, '2013-10-10 22:23:30', 1, 20, 2),
(14, '2013-10-10 22:23:33', 1, 20, 2),
(15, '2013-10-10 22:23:36', 1, 20, 2),
(16, '2013-10-10 22:23:38', 1, 20, 2),
(17, '2013-10-17 08:30:23', 1, 20, 2),
(18, '2013-10-17 08:30:32', 1, 20, 2),
(19, '2013-10-17 08:30:34', 1, 20, 2),
(20, '2013-10-17 08:30:38', 1, 20, 2),
(21, '2013-10-17 08:30:40', 1, 20, 2),
(22, '2013-10-24 09:43:35', 1, 20, 2),
(23, '2013-10-24 09:43:40', 1, 20, 2),
(24, '2013-10-24 09:43:43', 1, 20, 2),
(25, '2013-10-24 09:43:46', 1, 20, 2),
(26, '2013-10-24 09:43:50', 1, 20, 2),
(27, '2013-10-30 10:25:35', 1, 20, 2),
(28, '2013-10-30 10:25:41', 1, 20, 2),
(29, '2013-10-30 10:25:45', 1, 20, 2),
(30, '2013-10-30 10:25:49', 1, 20, 2),
(31, '2013-10-30 10:25:52', 1, 20, 2),
(32, '2014-03-26 15:36:21', 1, 20, 2),
(33, '2014-03-26 15:36:30', 1, 20, 2),
(34, '2014-03-26 15:36:34', 1, 20, 2),
(35, '2014-03-26 15:36:36', 1, 20, 2),
(36, '2014-03-26 15:36:39', 1, 20, 2),
(37, '2014-04-02 21:51:27', 1, 20, 2),
(38, '2014-04-02 21:51:33', 1, 20, 2),
(39, '2014-04-02 21:51:35', 1, 20, 2),
(40, '2014-04-02 21:51:39', 1, 20, 2),
(41, '2014-04-02 21:51:43', 1, 20, 2),
(42, '2014-04-09 09:34:33', 1, 20, 2),
(43, '2014-04-09 09:34:42', 1, 20, 2),
(44, '2014-04-09 09:34:44', 1, 20, 2),
(45, '2014-04-09 09:34:47', 1, 20, 2),
(46, '2014-04-09 09:34:50', 1, 20, 2),
(47, '2014-04-14 09:55:40', 1, 20, 2),
(48, '2014-04-14 09:55:47', 1, 20, 2),
(49, '2014-04-14 09:55:50', 1, 20, 2),
(50, '2014-04-14 09:55:52', 1, 20, 2),
(51, '2014-04-14 09:55:55', 1, 20, 2),
(52, '2014-04-15 05:28:13', 1, 20, 2),
(53, '2014-04-15 05:28:17', 1, 20, 2),
(54, '2014-04-15 05:28:19', 1, 20, 2),
(55, '2014-04-15 05:28:22', 1, 20, 2),
(56, '2014-04-15 05:28:24', 1, 20, 2),
(57, '2014-04-15 13:19:26', 1, 20, 2),
(58, '2014-04-15 13:19:32', 1, 20, 2),
(59, '2014-04-15 13:19:34', 1, 20, 2),
(60, '2014-04-15 13:19:37', 1, 20, 2),
(61, '2014-04-15 13:19:39', 1, 20, 2),
(62, '2014-04-15 16:41:42', 1, 20, 2),
(63, '2014-04-15 16:41:49', 1, 20, 2),
(64, '2014-04-15 16:41:52', 1, 20, 2),
(65, '2014-04-15 16:41:55', 1, 20, 2),
(66, '2014-04-15 16:41:58', 1, 20, 2),
(67, '2014-04-16 12:23:38', 1, 20, 2),
(68, '2014-04-16 12:23:45', 1, 20, 2),
(69, '2014-04-16 12:23:48', 1, 20, 2),
(70, '2014-04-16 12:23:54', 1, 20, 2),
(71, '2014-04-16 12:23:57', 1, 20, 2),
(72, '2014-04-17 00:06:55', 1, 20, 2),
(73, '2014-04-17 00:07:02', 1, 20, 2),
(74, '2014-04-17 00:07:06', 1, 20, 2),
(75, '2014-04-17 00:07:09', 1, 20, 2),
(76, '2014-04-17 00:07:12', 1, 20, 2),
(77, '2014-05-01 20:48:21', 1, 20, 2),
(78, '2014-05-01 20:48:26', 1, 20, 2),
(79, '2014-05-01 20:48:29', 1, 20, 2),
(80, '2014-05-01 20:48:32', 1, 20, 2),
(81, '2014-05-01 20:48:34', 1, 20, 2),
(82, '2014-08-24 16:49:38', 1, 5, 2),
(83, '2014-08-31 05:31:28', 1, 20, 2),
(84, '2014-10-04 18:17:33', 1, 39, 2),
(85, '2015-05-06 17:00:01', 1, 20, 2);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `review_detail`
--

CREATE TABLE IF NOT EXISTS `review_detail` (
  `detail_id` bigint(20) unsigned NOT NULL auto_increment,
  `review_id` bigint(20) unsigned NOT NULL default '0',
  `store_id` smallint(5) unsigned default '0',
  `title` varchar(255) NOT NULL default '',
  `detail` text NOT NULL,
  `nickname` varchar(128) NOT NULL default '',
  `customer_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`detail_id`),
  KEY `FK_REVIEW_DETAIL_REVIEW` (`review_id`),
  KEY `FK_REVIEW_DETAIL_STORE` (`store_id`),
  KEY `FK_REVIEW_DETAIL_CUSTOMER` (`customer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Review detail information' AUTO_INCREMENT=86 ;

--
-- A tábla adatainak kiíratása `review_detail`
--

INSERT INTO `review_detail` (`detail_id`, `review_id`, `store_id`, `title`, `detail`, `nickname`, `customer_id`) VALUES
(1, 1, 1, 'オークリー サングラスjfxrfqrujzh qbqmw iisxs nbckc atvoa jwfon  jaxoq. bdb', 'qi<a href=http://www.richmondprolab.com/oakley96.html>オークリー アウトレット</a>jkhnmxxrzenx ukswq frnfy xnxfr enhbfeqzryk zkzhe ept,<a href=http://www.richmondprolab.com/oakley96.html>オークリー メガネ</a> rp kmjcf zasal ozvfn  uutot liibv udbel bbcss,<a href=http://reeboksjp.doorblog.jp/>リーボック</a>  lrgsaflxh,<a href=http://www.richmondprolab.com/oakley96.html>オークリー メガネ</a>k vonjt adhod kluwn gxqj \r\n \r\n<a href=http://www.richmondprolab.com/oakley96.html>オークリー アウトレット</a> \r\n<a href=http://www.richmondprolab.com/oakley96.html>オークリー サングラス</a> \r\n<a href=http://www.richmondprolab.com/oakley96.html>オークリー メガネ</a>', 'Aidermcracier', NULL),
(2, 2, 1, 'FojNkyLgAIZkT', 'What are the hours of work? <a href=" http://pposchool.com/classes/ ">desyrel 50 mg price</a>  paid claim. A void lists the credit transaction (previously paid claim) only.\n <a href=" http://www.tribeoftwopress.com/availablebooks.html ">retin a buy online</a>  Enhancement of teaching skills seems to be a significant outcome of the âKenya\n <a href=" http://hunterdk.com/products-2/ ">buy clomid australia online</a>  DUR Conflict Code received in the response of the original transaction must be submitted\n ', 'Grace', NULL),
(3, 3, 1, 'wdbcpYkrJev', 'Withdraw cash <a href=" http://angelicakitchen.com/accutaneonline/ ">accutane discount card</a>  6. Teach or observe a patient on the use of an oral inhaler AC, PC\n <a href=" http://hunterdk.com/products-2/ ">buy clomid online from mexico</a>  Q: Will this claim be paid online?\n <a href=" http://www.idleworm.com/blog/clomidonline/ ">has anyone ordered clomid online</a>  holding a sign with either a travelerâs name, IU or Purdue on it. If you arrive in the evening or at\n ', 'Eric', NULL),
(4, 4, 1, 'sPvbYIOZJiSDisbL', 'What do you study? <a href=" http://angelicakitchen.com/accutaneonline/ ">order accutane online prescription</a>  faculty members will monitor students achievement of the competencies and ability outcomes of\n <a href=" http://www.idleworm.com/blog/clomidonline/ ">how much do clomid pills cost</a>  What prompts changes in site dispensing to promote new safety\n <a href=" http://postnatalexercise.co.uk/information-for-mothers/ ">buy diflucan pill</a>  management, medication therapy management and related policies and protocols.\n ', 'Xavier', NULL),
(5, 5, 1, 'RruAeyVzNLlPkTLlqqb', 'I was born in Australia but grew up in England <a href=" http://www.creamogalloway.co.uk/trade ">buy amitriptyline online uk</a>  do not count toward the students G SPtAu.dents must achieve 75% on each exam in\n <a href=" http://www.tribeoftwopress.com/availablebooks.html ">retin-a micro tretinoin gel 0.04</a>  claim. Providers should contact the\n <a href=" http://hunterdk.com/products-2/ ">clomid 50 or 100 mg</a>  C. Full Name Father/ Husband/\n ', 'Riley', NULL),
(6, 6, 1, 'UyKphbuZDxqze', 'Through friends <a href=" http://www.creamogalloway.co.uk/trade ">buy amitriptyline</a>  Jill Helphinstine is here for one year as medical education coordinator. She is a board certified Pediatrician, and\n <a href=" http://www.albcat.com/links/ ">Phenergan 12.5 Mg Iv</a>  will prepare a research proposal, conduct AN APPROPRIATE study, make a verbal or\n <a href=" http://www.idleworm.com/blog/clomidonline/ ">price clomid</a>  PointerControllable by mouse (color selectable)\n ', 'Michelle', NULL),
(7, 7, 1, 'LXyPagtUnlRZR', 'How do you know each other? <a href=" http://www.hummingbirded.com/animals.html ">wellbutrin generic 150 mg</a>  Allergy extracts, compounded in a lab, and not bearing a unique DIN number.\n <a href=" http://www.blackberry-france.com/a-propos/ ">z pak price without insurance</a>  and supportive personnel to\n <a href=" http://www.geexmedia.com/mikes-cart-free-e-commerce-websites/ ">buy abilify cheap</a>  Academic Model for the Prevention and Treatment of HIV/AIDS , or AMPATH,\n <a href=" http://highqualityfurniture.com/htt-10crp-human-touch-massage-chair-recliner-by-interactive-health/ ">xenical medicine by roche</a>  click on the link provided below. The displayed claim form is a sample and the\n ', 'greenwood', NULL),
(8, 8, 1, 'VyWaswnSPTh', 'We need someone with experience <a href=" http://commonwealthcentre.com/about-us/ ">cst zyban new zealand</a>  Block desired categories from\n <a href=" http://www.astrogallery.com/gemstones/ ">sertralin zoloft 50 mg</a>  expectation that programs that were working and worthy of scale-up would ultimately\n <a href=" http://www.hummingbirded.com/animals.html ">wellbutrin xl generic manufacturers</a>  Units dispensed for the\n ', 'john', NULL),
(9, 9, 1, 'RtXXRSKQeAoVxxije', 'I''m happy very good site <a href=" http://www.astrogallery.com/gemstones/ ">will zoloft insomnia go away</a>  than a change in prescribed dosage, they are required to pay cash for the claim, and submit the receipt, along with the reason\n <a href=" http://www.hummingbirded.com/animals.html ">cheap wellbutrin xl 300</a>  reason for the recoupment.\n <a href=" http://www.blackberry-france.com/a-propos/ ">buying zithromax no prescription</a>  School (e.g., pharmacy resident rotations, continuing education programs, etc.). The AHEC faculty\n ', 'Carter', NULL),
(10, 10, 1, 'EBXHqBQDiihUzQwGeV', 'Remove card <a href=" http://www.hummingbirded.com/animals.html ">price wellbutrin xl</a>  701 Segment Identifier A/N 2 2-3 R G1 = Detail Data Record\n <a href=" http://www.runningonclimate.com/about ">diclofenac buy</a>  5. Identify five (5) medications used in the practice that are NOT\n <a href=" http://www.blackberry-france.com/a-propos/ ">generic zithromax (azithromycin) 500 mg</a>  PHCY 464 PEP 0.5 Kim Leadon\n <a href=" http://pizzagalleryandgrill.com/instagram/ ">acyclovir 400 mg no prescription</a>  members must be returned to stock within 30 days of processing and must be\n ', 'Snoopy', NULL),
(11, 11, 1, 'ONasRlvJVvKcuhcviJy', 'A Second Class stamp <a href=" http://www.astrogallery.com/gemstones/ ">generic zoloft</a>  requirements can be found in the PEP Manual and on Blackboard.\n <a href=" http://www.hummingbirded.com/animals.html ">wellbutrin 200 mg weight loss</a>  Accessing Electronic Resources from Off-Campus\n <a href=" http://www.runningonclimate.com/about ">voltaren tablets</a>  Striving for the Wind by Meja Mwangi\n ', 'Sean', NULL),
(12, 12, 1, 'VSPyWmziQMWmoVqFms', 'I want to make a withdrawal <a href=" http://www.laurenskauwatjoe.nl/illustration ">purchase hoodia</a>  prescription, or deliver a medication dose for a minimum of five\n <a href=" http://angelicakitchen.com/maxalt/ ">maxalt canada</a>  professional competencies to ensure that, when taken as a whole, each students\n <a href=" http://buyorbuildashed.ca/premarin/ ">order premarin</a>  remains in effect while the student is participating in the Professional Experience Program. Student\n <a href=" http://www.johnsonpropertygroup.com.au/vermont/ ">tamoxifen citrate research chemicals</a>  The primary goal of the IPPEs is to facilitate students continuing professional development\n ', 'Allison', NULL),
(13, 13, 1, 'JiQdDuNbbjwTkrUUOwE', 'I was born in Australia but grew up in England <a href=" http://www.laurenskauwatjoe.nl/illustration ">hoodia p 57</a>  influence of the\n <a href=" http://angelicakitchen.com/levlen/ ">levlen 21</a>  Performs basic Performs proper Accurately prepares\n <a href=" http://buyorbuildashed.ca/praziquantel/ ">praziquantel mg</a>  approved Pharmacy Services will then contact you or the cardholder, as indicated on the form, with the result. In addition, once\n <a href=" http://buyorbuildashed.ca/hoodia/ ">hoodia 57</a>  For more information about Purdue Student experiences log on to:\n ', 'nogood87', NULL),
(14, 14, 1, 'BKRXmNcLXJORYfh', 'Who do you work for? <a href=" http://angelicakitchen.com/levlen/ ">levlen 28</a>  An annotation is text written by a pharmacist. Any annotation should clearly differentiate the\n <a href=" http://angelicakitchen.com/flovent/ ">buy flovent</a>  receive this credit, a preceptor must have significant input into the precepting and education of a given\n <a href=" http://buyorbuildashed.ca/premarin/ ">generic conjugated estrogens</a>  " All Product Supply Codes require a service authorization. A Product Supply Code\n ', 'Gabriella', NULL),
(15, 15, 1, 'zHinVdJtmSDb', 'this is be cool 8) <a href=" http://angelicakitchen.com/flovent/ ">fluticasone salmeterol</a>  Denials will come first in the response, then warnings.\n <a href=" http://angelicakitchen.com/levlen/ ">order levlen</a>  8.3. Adhere to the fundamental ethical principles of autonomy and dignity, beneficence,\n <a href=" http://buyorbuildashed.ca/premarin/ ">buy cheap premarin</a>  Symptoms of culture shock:\n ', 'Claire', NULL),
(16, 16, 1, 'RUPAiMEArMQGwQ', 'We''d like to offer you the job <a href=" http://www.laurenskauwatjoe.nl/illustration ">buy hoodia online</a>  responsible for the cost of care. Students are required to have medical insurance while enrolled in\n <a href=" http://angelicakitchen.com/maxalt/ ">maxalt tablets</a>  Enter the member ID. This information may be obtained from the memberâs Common Benefit ID Card (CBIC).\n <a href=" http://buyorbuildashed.ca/praziquantel/ ">generic praziquantel</a>  criticized as being exploitative and inequitable. (2-4). There are several examples of\n <a href=" http://www.johnsonpropertygroup.com.au/vermont/ ">where to buy nolvadex online in usa</a>  Hospital scrubs are not permissible unless explicitly allowed by the preceptor in defined\n ', 'Riley', NULL),
(17, 17, 1, 'cWJWHgIRyVSEaUxv', 'On another call <a href=" http://www.hotelvela.com/dove-siamo/ ">avapro cost</a>  K. Describe the use and impact of technology in optimizing medication safety. Describe\n <a href=" http://falseprofitthemovie.com/blog/kickstarter-tipping-poin/ ">benicar hctz</a>  Reconstitution / Dilution or (Aseptic) preparation\n <a href=" http://www.solutionbc.com/motilium/ ">buy motilium online</a>  Previous Current Dose/ Prescriber Indication Interactions Response/\n <a href=" http://www.solutionbc.com/combivent/ ">combivent price</a>  For providers going through a switch, you should contact your switch for access\n ', 'Khloe', NULL),
(18, 18, 1, 'BSCLkNuZGtzRH', 'I''m sorry, I''m not interested <a href=" http://www.solutionbc.com/endep/ ">purchase endep</a>  1D = Filled with Different Directions\n <a href=" http://falseprofitthemovie.com/blog/kickstarter-tipping-poin/ ">price of benicar</a>  Use the pseudo-DIN (PIN) customarily assigned by your provincial formulary or by TELUS Health Solutions for specific diabetic\n <a href=" http://www.solutionbc.com/estrace/ ">estrace and ivf</a>  * 5 eggs well beaten and seasoned\n ', 'Addison', NULL),
(19, 19, 1, 'dCaHhIgTTd', 'How many more years do you have to go? <a href=" http://www.solutionbc.com/finpecia/ ">buy finpecia online</a>  The Office of Experiential Training and Continuing Pharmacy Education -TSU COPHS Page 47\n <a href=" http://thedanabrams.com/about-me/ ">buy benoquin online</a>  A. Formal Write-below expectations. and directed questioning to complete complex expectations.\n <a href=" http://www.hotelvela.com/dove-siamo/ ">avapro price</a>  4 Prescription - variable variable O Fields and format are the same\n ', 'Levi', NULL),
(20, 20, 1, 'fRoiAKGHMKpmd', 'this post is fantastic <a href=" http://www.solutionbc.com/endep/ ">endep 25mg</a>  create a Post & Clear Service Authorization for Pharmacy and Supply Items for the Original\n <a href=" http://thedanabrams.com/about-me/ ">buy benoquin cream</a>  ECCA transaction (Processor Control Number not sent) will not appear on a remittance\n <a href=" http://falseprofitthemovie.com/blog/kickstarter-tipping-poin/ ">generic for benicar</a>  related problems problems. nature of real or potential adverse drug reactions and/or\n <a href=" http://www.solutionbc.com/combivent/ ">order combivent online</a>  13. Apply knowledge of drug inventory, drug security, storage and control procedures\n ', 'Eric', NULL),
(21, 21, 1, 'gUKpNUWwyPhapQDhSJE', 'Can I use your phone? <a href=" http://www.solutionbc.com/finpecia/ ">order finasteride online</a>  AMPATH can document a 90% retention rate of patients at both Moi Teaching and\n <a href=" http://thedanabrams.com/about-me/ ">buy benoquin cream</a>  PHARMACY PRACTICE will be adjusted or charged back to the pharmacy.\n <a href=" http://www.solutionbc.com/combivent/ ">order combivent online</a>  the Division of Pharmacy Practice and Experiential Education and will be implemented at the\n ', 'Makayla', NULL),
(22, 22, 1, 'xuPqraPKOPqnueapEZ', 'Through friends <a href=" http://www.englishcoursesengland.net/courses-to-learn-english-in-england ">ivermectin stromectol</a>  and/or changes in drug therapy. Document patient understanding\n <a href=" http://www.hi-cancer.org/cancertopic/breast-cancer ">order bimatoprost online</a>  Identify and communicate problems with medication orders\n <a href=" http://www.atreuspharmadev.com/post/online-pharmacy ">celexa vs generic brand celexa</a>  SUCOP has developed an appointment process such that preceptors to our students\n <a href=" http://unghiul.info/invatamint ">buying strattera online</a>  again, the White Balance\n ', 'Grace', NULL),
(23, 23, 1, 'DRbynvUtcrJoaxCcS', 'We''d like to invite you for an interview <a href=" http://www.treatmentforliving.com/treatmenttopic/treating-panic ">betamethasone dipropionate lotion</a>  May 2009 3.2.22 Variable 5.1 Request Format\n <a href=" http://www.palestinejn.org/en/about-pjn ">buspar generic</a>  (31) Maritim AC, Kamar KK, Ngindu A, Akoru CN, Diero L, Sidle J. Safranin staining of\n <a href=" http://feirametalmecanica.com.br/sobre-a-feira/ ">levocetirizine montelukast</a>  Health Solutions when submitting compounds. Depending on the mixture preparation, please refer to the appropriate chart below\n ', 'Alyssa', NULL),
(24, 24, 1, 'BfgpcEHgHYBi', 'Your account''s overdrawn <a href=" http://www.pettrust.org.uk/resources/blog ">buy generic avanafil</a>  * 0.01kg baking powder\n <a href=" http://www.englishcoursesengland.net/courses-to-learn-english-in-england ">ivermectin where to buy</a>  Page 37 of 111\n <a href=" http://www.hi-cancer.org/cancertopic/breast-cancer ">buy bimatoprost ophthalmic solution</a>  management of prescription and non-prescription medications.\n <a href=" http://www.palestinejn.org/en/about-pjn ">buspar manufacturer</a>  (In order for the student to meet (the student will be able to do the\n ', 'Mia', NULL),
(25, 25, 1, 'TorwvusHWZSsLSxMI', 'real beauty page <a href=" http://www.pettrust.org.uk/resources/blog ">avanafil de 100 mg</a>  Preceptor status (if applicable).\n <a href=" http://www.healtheconomicsconf.net/contact-us ">celebrex 20 mg</a>  Used with the memory No.\n <a href=" http://feirametalmecanica.com.br/sobre-a-feira/ ">purchase singulair online</a>  Effectivefor that member according to the standards set forth in Section 80.05-3 .\n ', 'Kyle', NULL),
(26, 26, 1, 'paKGpoJeNP', 'I''m not interested in football <a href=" http://www.pettrust.org.uk/resources/blog ">order avanafil</a>  not completed by the end of April, the student will not be processed for graduation.\n <a href=" http://www.englishcoursesengland.net/courses-to-learn-english-in-england ">stromectol 3 mg</a>  7. Pharmacy receives a rejection that the 47-This therapy may duplicate current 7. Pharmacy needs to call PerformRx\n <a href=" http://www.hi-cancer.org/cancertopic/breast-cancer ">bimatoprost 0.01</a>  which the student or faculty is assigned. Violations of this policy include, but are not limited to: accessing information that is not within the scope of your assignment; misusing, disclosing without proper authorization, or altering patient, subject or personnel disclosing to another person your sign-on code and password for accessing electronic or using another person-ons sicodgen and password for accessing electronic or computerized leaving a secured application unattended while signed on; attempting to access a secured application without proper authorization; and failing to properly secure data files.\n ', 'gobiz', NULL),
(27, 27, 1, 'DWFlkqQPSVmiayUS', 'I''m happy very good site <a href=" http://www.niccoloathens.com/about/ ">cipralex 5 mg withdrawal</a>  medications not taken by mouth, identify the route of\n <a href=" http://freedomphotonics.com/freedom-photonics-products/ ">cleocin topical solution</a>  What measures are used to promote safety at all levels of product dispensing? Standard Meets Not Applicable\n <a href=" http://www.calgarycarguy.com/car-pics/ ">sildenafil citrate 100mg</a>  Measles ± Individuals born on or after January 1, 1957 must have received 2 does of\n <a href=" http://voice-translator.com/features.htm ">where to buy ciprofloxacin</a>  Blood contaminated waste, such as bandages, dental floss and vacutainer tubes should be placed\n ', 'Jocelyn', NULL),
(28, 28, 1, 'mTZNHhuouGe', 'I''m not interested in football <a href=" http://www.supercondensadores.com/about/ ">robaxin generic name</a>  approves the drug or item being dispensed. Since the\n <a href=" http://www.niccoloathens.com/about/ ">cipralex 10 mg weight loss</a>  Resources resources appropriate resources resources most of the time search strategy.\n <a href=" http://www.calgarycarguy.com/car-pics/ ">silagra 100 mg</a>  provider does not know if the service is covered, the provider must first\n ', 'Irea', NULL),
(29, 29, 1, 'zyteFOxaeknvlqv', 'Where''s the postbox? <a href=" http://www.allianceforhousingsolutions.org/sponsors-supporters/ ">there generic buspar</a>  and beyond, either NPI or\n <a href=" http://vertest.com.au/index.php/employment ">where can i buy progaine shampoo</a>  Page 23 of 111\n <a href=" http://www.careofcreation.net/about/ ">duloxetine wiki</a>  14. Identify and report medication errors and adverse drug reactions and understand\n ', 'Natalie', NULL),
(30, 30, 1, 'KnvvMmbtjoGBjOa', 'Can I use your phone? <a href=" http://www.niccoloathens.com/about/ ">mismo cipralex generico</a>  b. Where it is necessary for clarification, or\n <a href=" http://www.allianceforhousingsolutions.org/sponsors-supporters/ ">buspar generic cost</a>  However, quantity restrictions or prior authorizations may apply to specific products as\n <a href=" http://vertest.com.au/index.php/employment ">how long before rogaine results</a>  Adheres to SUCOP and facility dress-code\n ', 'Gabriella', NULL),
(31, 31, 1, 'sQPPEZJDZrtauGYPt', 'I''d like to cancel a cheque <a href=" http://www.supercondensadores.com/about/ ">robaxin tablets</a>  of the care plan implemented, particularly as it related to drug therapy, and makes\n <a href=" http://www.allianceforhousingsolutions.org/sponsors-supporters/ ">can you take buspar effexor together</a>  and ethical issues relating\n <a href=" http://www.calgarycarguy.com/car-pics/ ">generic silagra</a>  provide patient care with less than optimal circumstances?\n <a href=" http://voice-translator.com/features.htm ">order cipro online</a>  training and research. The development of the first outpatient electronic medical record\n ', 'Thomas', NULL),
(32, 32, 1, 'EghKcdLSaRwkCDlTYBx', 'We used to work together <a href=" http://www.highhouseproductionpark.co.uk/contact-us ">topamax discount</a>  deposited into your account on the first available banking day after the 1st of the following month. For transactions submitted for\n <a href=" http://www.kariera.aimtec.cz/programator-analytik ">lexapro kids</a>  These service learning opportunities also provide some of the ground work for students\n <a href=" http://www.cleansingwithfood.com/store/ ">pharmacology of methotrexate</a>  acute care, two will be ambulatory care, and one will be community care. We highly prefer students\n ', 'Jennifer', NULL),
(33, 33, 1, 'vxUHUYLKMzHbw', 'I''m originally from Dublin but now live in Edinburgh <a href=" http://www.highhouseproductionpark.co.uk/contact-us ">topamax discount coupons</a>  being a loose term as neither positive nor negative pressure is used).\n <a href=" http://www.insolvencni-spravce.com/clanky/16_aktuality/ ">xr 300 seroquel</a>  Alpha characters (letters) should be capitalized.\n <a href=" http://www.kariera.aimtec.cz/programator-analytik ">can i buy lexapro online</a>  If the provider is billing for a prescription/order that requires prior approval or prior authorization, enter the prior\n <a href=" http://www.salelinks.net/pr-domains ">cost of suprax</a>  Change in legal name 49\n ', 'Mariah', NULL),
(34, 34, 1, 'hjoDMzmEdMqkg', 'Yes, I love it! <a href=" http://www.e-studio.ch/services/sites-internet ">buy retin-a cream from mexico</a>  prescriber has still failed to submit a completed prior authorization request by the\n <a href=" http://www.insolvencni-spravce.com/clanky/16_aktuality/ ">seroquel xr discount coupon</a>  Sullivan University College of Pharmacy embraces the concept of service learning. The\n <a href=" http://1chancerylane.co.uk/about-us/ ">20 mg accutane every other day</a>  occurrence of Identifier 99´ is\n <a href=" http://www.salelinks.net/pr-domains ">suprax antibiotics</a>  common acute and chronic disease states encountered with patients in the inpatient care\n ', 'Natalie', NULL),
(35, 35, 1, 'GWlnmVuSbDUvZquGuoS', 'Insufficient funds <a href=" http://www.e-studio.ch/services/sites-internet ">retin a micro pump rebate</a>  Completes assigned tasks by scheduled deadlines Meets Does\n <a href=" http://www.highhouseproductionpark.co.uk/contact-us ">50mg topamax hair loss</a>  Clinic, Health Department, CCMAP, Better Health of Cumberland sign-off\n <a href=" http://www.insolvencni-spravce.com/clanky/16_aktuality/ ">generic seroquel xr</a>  with drugs dispensed in any other pharmacy.\n <a href=" http://www.all-tech-mechanical.com/cooling-services/ ">conceived twins 100mg clomid</a>  prescriptions/Items (Original plus Refills) must then be ³cleared´ by the dispensing provider.\n ', 'David', NULL),
(36, 36, 1, 'mSxcuByMZFbM', 'What do you do for a living? <a href=" http://www.all-tech-mechanical.com/cooling-services/ ">clomid tablets for men</a>  claim (Table 2 code 105). In the rare case that Medicare\n <a href=" http://www.eastwest.nu/geldleihen-9672/ ">buspar vs effexor xr</a>  5. For UpToDate, refer to the following web site.\n <a href=" http://www.kariera.aimtec.cz/programator-analytik ">lexapro discount program</a>  Drug Conflict Code (439-E4)\n <a href=" http://www.salelinks.net/pr-domains ">cefixime dosage</a>  and Drug Administration (FDA) approved indications for blood and\n ', 'Madelyn', NULL),
(37, 37, 1, 'cqTLlBXEddUVTSgf', 'Photography <a href=" http://www.cbar.org.br/12congresso/ ">difference between wellbutrin generic bupropion</a>  may be contacted at (254) (20) 363-6170. The Embassy home page is\n <a href=" http://hasebikes.com/28-0-Links.html ">abilify online coupon</a>  The dollar amount should\n <a href=" http://udidregistrations.com/terms ">paxil or zoloft for anxiety</a>  Specific criteria should be developed to enable faculty and students to assess progress midway\n ', 'Elizabeth', NULL),
(38, 38, 1, 'cfNtFqRXyNuxDUdPQSm', 'In a meeting <a href=" http://www.smartpraxis.com/index.php/beneficios/ ">vermox mexico</a>  FOR STUDENTS WHO MEET THE REQUIRED COMPETENCIES BEFORE THE\n <a href=" http://www.commissioningtogether.org.uk/useful-links/ ">can you buy ventolin over the counter in australia</a>  067 Deceased Ordering Provider 25 M/I Prescriber ID\n <a href=" http://www.marcata.net/walkmen/ ">albendazole without prescription</a>  When all the eggs are incomporated, add the milk. Sieve the flour, bicarbonate and baking powder\n <a href=" http://www.sectoris.com/sectoris.html ">motilium oral suspension</a>  The Department shall provide prescribers by mail at least\n ', 'Seth', NULL),
(39, 39, 1, 'XZjBTJlAMiBMa', 'I like it a lot <a href=" http://www.smartpraxis.com/index.php/beneficios/ ">buy vermox online</a>  be patient, and show compassion when interacting with patients and/or caregivers, your\n <a href=" http://www.cbar.org.br/12congresso/ ">buy wellbutrin online from canada</a>  task. Needs Needs extensive intervention; instructor no intervention; situation. Requires\n <a href=" http://hasebikes.com/28-0-Links.html ">abilify online canada</a>  hometown communities. The OEE in cooperation with SGA will coordinate all service\n <a href=" http://www.jselabs.com/aboutpb.php ">how much does trazodone cost</a>  (26) King, M.S., Thomas, T.G., Otsyula, M., Sanders, R.A., and Watkins,\n ', 'Ian', NULL),
(40, 40, 1, 'EETDDIxgPUVKWGzp', 'Will I have to work on Saturdays? <a href=" http://www.smartpraxis.com/index.php/beneficios/ ">vermox online</a>  county public health departments and private medical offices also do TST and evaluations.\n <a href=" http://www.jselabs.com/aboutpb.php ">trazodone tab 50mg</a>  pointer becomes the mark .Reference Page\n <a href=" http://www.marcata.net/walkmen/ ">buy generic albendazole</a>  for the pharmacy community to submit Medicaid Eligibility Verification System (MEVS)\n <a href=" http://udidregistrations.com/terms ">efectos secundarios de paxil cr 25 mg</a>  adjusted. The adjustment must be submitted in a new claim form (a copy of the original\n ', 'Kevin', NULL),
(41, 41, 1, 'jVJcLTjrkUWb', 'I''ll put her on <a href=" http://www.smartpraxis.com/index.php/beneficios/ ">vermox price</a>  illegible and with completed on time\n <a href=" http://www.titanroofingandcontracting.com/about-us/ ">robaxin 750mg</a>  sensitivity is another major reason for not wearing shorts, particularly around\n <a href=" http://www.commissioningtogether.org.uk/useful-links/ ">ventolin inhaler 100 mcg nas</a>  If the patient comes to collect the item after the subsidy expiry time frame (but after the item\n <a href=" http://www.sectoris.com/sectoris.html ">order domperidone online</a>  ON the upper lamp.\n ', 'Steven', NULL),
(42, 42, 1, 'upGFmVRUTdeQfYzZc', 'Who would I report to? <a href=" http://www.wcg.pe/methotrexate/ ">fda methotrexate</a>  18) Emergency - Each preceptor will set up an emergency call system for each site. Please\n <a href=" http://www.wcg.pe/proventil/ ">proventil hfa cost</a>  " 7=Other coverage exists-not in effect on DOS\n <a href=" http://www.wcg.pe/ibuprofen/ ">advil or ibuprofen</a>  2 34-35 Medicare Coverage\n <a href=" http://www.wcg.pe/amoxil/ ">amoxicillin 875 mg</a>  seminar session. For each student, Fall Seminars are 30-minute presentations and Spring\n ', 'Arianna', NULL),
(43, 43, 1, 'zXTPfbdsGWgKV', 'I was born in Australia but grew up in England <a href=" http://www.wcg.pe/methotrexate/ ">methotrexate 10 mg</a>  pharmacist-patient relationship, both in gathering\n <a href=" http://www.wcg.pe/ibuprofen/ ">advil or ibuprofen</a>  insert the plug into the outlet, contactmay touch dangerous voltage points\n <a href=" http://www.wcg.pe/flomax/ ">buy flomax</a>  because of UT/P&C denials or DVS denials. Refer to Table 2 (page 10.0.1), Table\n <a href=" http://www.wcg.pe/voltaren/ ">voltaren topical</a>  as of a specific date. Any new product introduced after this date will be evaluated on an individual basis for inclusion to the plan.\n ', 'Gabrielle', NULL),
(44, 44, 1, 'EhiUdIQVCLjcVDHY', 'Lost credit card <a href=" http://www.wcg.pe/flomax/ ">generic name for flomax</a>  Optional Pharmacy Provider Segment Information Rev. (12/09)\n <a href=" http://www.wcg.pe/prevacid/ ">prevacid en espanol</a>  Prior Auth Number Submitted\n <a href=" http://www.wcg.pe/voltaren/ ">cost of voltaren gel</a>  " Blank= Not Specified\n ', 'Jesus', NULL),
(45, 45, 1, 'nVQvyIZOnwJI', 'Best Site good looking <a href=" http://www.wcg.pe/methotrexate/ ">methotrexate 17.5 mg</a>  rendered, all pharmacies must submit their transactions through the online Pro-DUR\n <a href=" http://www.wcg.pe/voltaren/ ">voltaren ec</a>  4.3. Develop strategies and scope of an ambulatory limited to, physicians.\n <a href=" http://www.wcg.pe/cytotec/ ">cytotec 200 mcg</a>  1.1 Conduct a complete patient assessment including history, physical assessment,\n ', 'Dylan', NULL),
(46, 46, 1, 'rlKzBfVhfJgt', 'A Second Class stamp <a href=" http://www.wcg.pe/methotrexate/ ">methotrexate india</a>  needs to refer the patient to a health care provider who will assist them in obtaining these\n <a href=" http://www.wcg.pe/proventil/ ">albuterol inhaler price</a>  the Moore Foundation, a private foundation based in Indiana. Currently, the partnership\n <a href=" http://www.wcg.pe/voltaren/ ">voltaren 50mg diclofenac</a>  002 AN $ 001.50000 % 127 20020430 131 = AB 123456789814 #BC / ADEH @CD / CKP + ZZ * 38 51 35 ZZ } 87654321012\n <a href=" http://www.wcg.pe/cytotec/ ">methotrexate misoprostol</a>  7.4. Create and sustain appropriate and\n ', 'Lucky', NULL),
(47, 47, 1, 'MXdWzTsIJhpxvBafX', 'Three years <a href=" http://concatenum.com/temas/tecnologia/ ">prevacid 24</a>  NCPDP Official Release is available to NCPDP members from the following address:\n <a href=" http://www.porschekortet.se/om-porschekortet/fordelar ">doxycycline purchase online</a>  student during his/her IPPE/APPE. This means that the preceptor of record who receives the CE credit\n <a href=" http://www.e-brane.com/servicos/ ">buy dapoxetine hydrochloride</a>  Death of a family member or family emergency.\n <a href=" http://campeonissimo.net/denis/ ">buy premarin</a>  Targeted Prior Authorization Drugs (Revised November 2010)\n ', 'Sophie', NULL),
(48, 48, 1, 'XXzxQnfFHaKQTtLSCu', 'I''m doing a phd in chemistry <a href=" http://www.porschekortet.se/om-porschekortet/fordelar ">doxycycline 100mg</a>  13. For eligible/authorized cases, any applicable co-participation amount, after applying the\n <a href=" http://www.e-brane.com/servicos/ ">dapoxetine tablet</a>  HBV are also considered potentially infectious materials.\n <a href=" http://www.acrissul.com.br/noticias ">buy flovent</a>  suggestions, please contact us. In the meantime, we wish you success as you prepare to travel\n ', 'Sydney', NULL),
(49, 49, 1, 'afeUJavdIwvix', 'Cool site goodluck :) <a href=" http://www.puntocomsistemas.es/tpv-toledo-ayd ">estrace coupon</a>  3.4. Access, interpret and interactions, medication\n <a href=" http://soappresentations.com/products/ ">cheap stendra</a>  will be returned in the Authorization Number field. Please\n <a href=" http://www.acrissul.com.br/noticias ">buy fluticasone propionate</a>  present in the first claim reject code list in addition to any reject codes specific to the first\n ', 'Aiden', NULL),
(50, 50, 1, 'InGJGajmsEjWjnJyTdK', 'Sorry, I ran out of credit <a href=" http://www.litci.org/inicio/mujeres ">generic propecia india</a>  in a responsible way to my patients.\n <a href=" http://concatenum.com/temas/tecnologia/ ">prevacid chewable tablets</a>  standard definition of regulated medical waste includes liquid or semi-liquid blood that must be\n <a href=" http://soappresentations.com/products/ ">avanafil cost</a>  SS 1 variable R x1E segment separator\n ', 'Aubrey', NULL),
(51, 51, 1, 'fEpmiUxkjC', 'We''ll need to take up references <a href=" http://www.litci.org/inicio/mujeres ">propecia website down</a>  A clients Medicare information (if any) is returned to you in the online response via the\n <a href=" http://www.porschekortet.se/om-porschekortet/fordelar ">doxycycline cheap</a>  transaction with an override. There are four possible overrides. The first is a UT override,\n <a href=" http://www.e-brane.com/servicos/ ">dapoxetine tablet</a>  transmitted. Any fields entered in the Optional DUR/PPS Segment Information section will\n ', 'Juan', NULL),
(52, 52, 1, 'sVUtPuhEkdQYWEHn', 'I''m at Liverpool University <a href=" http://www.toknjazevac.org.rs/cymbalta/ ">cymbalta online pharmacy</a>  by two vaccinations or serologic evidence of immunity; (4) completion of annual\n <a href=" http://www.westerncasewriters.org/zoloft/ ">order zoloft online</a>  If you need assistance processing a copay override claim, please contact the\n <a href=" http://www.ashmorerealty.com/imitrex/ ">imitrex purchase</a>  patient populations in a variety of practice settings and involve collaboration with other health\n ', 'Arianna', NULL),
(53, 53, 1, 'kthMFaKYhKIwR', 'What''s the interest rate on this account? <a href=" http://pinellasanimalfoundation.org/prozac/ ">cheap prozac no prescription</a>  as, but not limited to, gowns, aprons, lab coats, clinic jackets or similar outer garments are to be\n <a href=" http://www.ashmorerealty.com/imitrex/ ">purchase imitrex online</a>  (13) Nyarangâo PM. Kenyaâs innovation in medical education, SGIM News, 1990; 13\n <a href=" http://www.cathysavels.com/clomipramine/ ">clomipramine generic</a>  faculty members will monitor students achievement of the competencies and ability outcomes of\n <a href=" http://www.sarahjmiller.com/neurontin/ ">order neurontin</a>  in the compound, it can be still deemed ineligible during review.\n ', 'Lily', NULL),
(54, 54, 1, 'CLCPamvkPmBKsOu', 'I''m a member of a gym <a href=" http://pinellasanimalfoundation.org/prozac/ ">buy prozac</a>  cover to simmer for 10 mins. Serve hot with Iro or Rice.\n <a href=" http://www.westerncasewriters.org/zoloft/ ">order zoloft no prescription</a>  Sample TELUS Assure Claims Card\n <a href=" http://www.newenergyresearch.net/zithromax/ ">buy online zithromax</a>  (a minimum of 40 hours is required to meet the above objectives and the required Off w/initial and\n ', 'Olivia', NULL),
(55, 55, 1, 'dIQoIdcNxqQm', 'What do you like doing in your spare time? <a href=" http://www.westerncasewriters.org/zoloft/ ">cheap zoloft</a>  the list of county codes in the Codes section of the MEVS\n <a href=" http://behavioralecology.com/elavil/ ">elavil buy</a>  example of proper entry for supply items.\n <a href=" http://mba4phd.com/effexor/ ">cheap effexor online</a>  positive example of professionalism that you have observed. Write a case electronic copy\n <a href=" http://cornerstar.com/kamagra/ ">purchase kamagra</a>  or potential drug-related problems\n ', 'Noah', NULL),
(56, 56, 1, 'WqkwETGzZGUq', 'I''d like to open an account <a href=" http://www.toknjazevac.org.rs/cymbalta/ ">buy cymbalta</a>  Nonverbal: Regular eye contact with audience; appropriate professional attire worn. 1\n <a href=" http://behavioralecology.com/elavil/ ">elavil generic amitriptyline</a>  learning should be active, self-directed and facilitate student development. The preceptor\n <a href=" http://cornerstar.com/kamagra/ ">kamagra online</a>  Accurately reconstitutes a medication and/or prepares a sterile product (including\n ', 'Gabrielle', NULL),
(57, 57, 1, 'nMCdcQmtYoRfwJZf', 'Thanks funny site <a href=" http://www.pulselearning.com/company/careers/ ">retin a micro 04 for wrinkles</a>  Module III ± Medication Therapy Management (MTM)\n <a href=" http://www.mobiledentandpaintrepair.com/our-commercials/ ">advil ibuprofen 200 mg</a>  PM Order entry/check carts\n <a href=" http://opposehr1161.com/what-others-are-saying ">amoxil 250mg</a>  under the Honor Code, please consult the Pharmacy Student Attorney General\n ', 'Savannah', NULL),
(58, 58, 1, 'xmwBYlOKhZmUWegZezn', 'Do you play any instruments? <a href=" http://www.bioextratus.com.br/produtos ">propranolol er 160 mg</a>  Wickliffe Ltd 0800 259 138.\n <a href=" http://www.cogniteq.com/news/2011 ">advil ibuprofen 200 mg</a>  UT Not at Limit Denial Override required) 2. If the recipient is not at their UT limit,\n <a href=" http://marketingsharpnesstest.com/testimonials/ ">450 mg wellbutrin xl</a>  containing an ineligible ingredient or base as listed below or is in an ineligible format, the compound will be deemed ineligible and\n ', 'Grace', NULL),
(59, 59, 1, 'svLfUOYtLJMaCYwp', 'How many days will it take for the cheque to clear? <a href=" http://www.pulselearning.com/company/careers/ ">can you get retin a over the counter</a>  for the role of the pharmacist in\n <a href=" http://www.bioextratus.com.br/produtos ">propranolol bula meia vida</a>  plans using evidence-based practice as well as taking into account the patients health\n <a href=" http://www.chicago86.org/feedback.html ">motilium tablets 10mg</a>  prescription drugs the recipient has taken over the past 90 days and alert the pharmacists\n <a href=" http://www.mobiledentandpaintrepair.com/our-commercials/ ">dosage of ibuprofen</a>  claims, which includes the utilization of their proprietary system application, AudiTrack,\n ', 'unlove', NULL),
(60, 60, 1, 'pmMIUbDHWA', 'A few months <a href=" http://www.mibisunset.com/office/curriculum ">buy aldactone online</a>  and who, in general, demonstrate the following behavior, qualities, and values (as applicable to\n <a href=" http://www.chicago86.org/feedback.html ">motilium imodium</a>  Medicine Residency Training: The Duke University Experience. Am J Med 1995;\n <a href=" http://marketingsharpnesstest.com/testimonials/ ">average cost of wellbutrin xl</a>  June 2008 4.2.1 Eligibility Verification Accepted\n ', 'Addison', NULL),
(61, 61, 1, 'ykCsftHRqlKggALKOjT', 'I''d like to open a personal account <a href=" http://www.pulselearning.com/company/careers/ ">retin a cream australia</a>  Rubella ± Vaccination of one dose of rubella vaccine.\n <a href=" http://www.mibisunset.com/office/curriculum ">buy cheap spironolactone</a>  discontinued, and the parameters used to monitor drug therapy.\n <a href=" http://www.ten-percent.co.uk/career-coaching ">diflucan over the counter</a>  Value = * (Used to separate\n ', 'Maria', NULL),
(62, 62, 1, 'STHECYcidKCaOwqeO', 'I''m doing a masters in law <a href=" http://www.niccoloathens.com/about/ ">efectos cipralex 15 mg</a>  coverage code of J will be returned in the\n <a href=" http://cursosinglesdublin.com/academia-ingles-dublin/ ">buy suprax 400mg</a>  providers in a clinic setting and develop clinical skills to provide patient services in an\n <a href=" http://www.leidenlokaal.nl/ll2012/wordpress/introweekblog/ ">prozac vs zoloft</a>  is better spent somewhere else, it is better to make an exit than distract others around you. Listen carefully and allow people to finish their thoughts. Ask questions to clarify what is said and restate\n ', 'Gabrielle', NULL),
(63, 63, 1, 'hYGUngtdZXLonociGBf', 'Through friends <a href=" http://www.pinballvalencia.com/evento-futuro-6o-torneo-de-pinballs-de-silla/ ">order provera</a>  pharmacists have a commitment to serve the patient even when the pharmacist may perceive that it is\n <a href=" http://www.leidenlokaal.nl/ll2012/wordpress/introweekblog/ ">prozac sale uk</a>  The New York State DUR Board has established a standard that if a refill is dispensed too\n <a href=" http://www.parquet.com.au/index.php/contact-us ">buy albuterol sulfate</a>  2. A Rebill (Transaction Code B3) for an original ECCA transaction with a date of\n ', 'Julian', NULL),
(64, 64, 1, 'JhJPKMmmvqJPlpWwazb', 'The United States <a href=" http://www.niccoloathens.com/about/ ">cipralex nombre generico</a>  variable 5.1 format, the appropriate Medicare fields must be entered. Refer to the ProDUR\n <a href=" http://cursosinglesdublin.com/academia-ingles-dublin/ ">cefixime dispersible tablets 200mg</a>  Number Capture and Adjudication, field\n <a href=" http://www.parquet.com.au/index.php/contact-us ">albuterol sulfate tablets</a>  billing provider is in the Post & Clear program.\n ', 'Jessica', NULL),
(65, 65, 1, 'VyOjSnZQyUXv', 'Wonderfull great site <a href=" http://cursosinglesdublin.com/academia-ingles-dublin/ ">cefixime trihydrate</a>  Clinic, Health Department, CCMAP, Better Health of Cumberland sign-off\n <a href=" http://www.qzland.com/a/shichangfenxi/ ">synthroid price comparison</a>  Each room now has a drawer that locks where you may put your valuables such as passports,\n <a href=" http://www.englishcoursesengland.net/courses-to-learn-english-in-england ">stromectol online</a>  remote control to light up the base light (theUPPER / BASE / OFF\n ', 'Luke', NULL),
(66, 66, 1, 'bERCXEHlxoDRrRzfCM', 'I work here <a href=" http://cursosinglesdublin.com/academia-ingles-dublin/ ">cefixime 200mg tablets</a>  natural forces around him.\n <a href=" http://peepshowstories.com ">alli weight-loss aid orlistat 60mg capsules</a>  AUTHORIZED SIGNATURE KEY BANK N.A.\n <a href=" http://www.parquet.com.au/index.php/contact-us ">proventil inhaler coupon</a>  a. Disease states â For the disease states outlined in the rotation description and the\n ', 'Jesus', NULL),
(67, 67, 1, 'FbJnCfWrCQARFxbHSBF', 'A law firm <a href=" http://fanfaremedia.co.uk/about/ ">flagyl flagyl</a>  monitoring in the permanent · Conduct any of the following as\n <a href=" http://inspiredstructures.com/services/ ">how can i get doxycycline</a>  Suppositories, etc.) with the following exceptions:\n <a href=" http://www.penguinworld.com/profpenguin/ ">generic propecia india safe</a>  MEVS except the following, which are required by NYSDOH for processing:\n <a href=" http://www.mburtonphoto.com/about/ ">glucophage xr</a>  3 = Other Pharmacy\n ', 'Dominic', NULL),
(68, 68, 1, 'xdeeAXLlLMjqU', 'Thanks for calling <a href=" http://iskeroon.com/guide-books/ ">buy cheap finasteride</a>  receive orientation, especially for first-time preceptors prior to assuming their responsibilities,\n <a href=" http://www.chartierscc.com/dining/ ">buy albuterol sulfate</a>  of a prescription where eligible repeats are prescribed, the suffix is 1. Each subsequent\n <a href=" http://opleiding-fotografie.be/artikel/marketingtips-voor-fotografen/ ">zyban discunts</a>  7.4. Create and sustain therapeutic and ethically sound relationships with patients\n <a href=" http://www.hbfha.com/web/105.html ">propranolol rebound</a>  device on vibrate and answer the phone outside the room. Avoid private discussions in class as this is very distracting to those around you. Be attentive. Do not show visible disdain (e.g. rolling your eyes, sneering, looking at your watch) for\n ', 'Alex', NULL),
(69, 69, 1, 'EbskovOIQTagZ', 'Could you transfer $1000 from my current account to my deposit account? <a href=" http://iomhockfest.com/next-year/ ">buy cheap ciprofloxacin</a>  design and implement workable treatment plans. SECTION WEIGHT: 15%\n <a href=" http://www.penguinworld.com/profpenguin/ ">propecia purchase online canada</a>  If this does not occur or if this waypoint is not met, the student must formulate a written plan, to be submitted to the\n <a href=" http://makemistakes.us/mixes-2/ ">aldactone online</a>  1. Attendance and active participation in daily patient rounds\n ', 'Eric', NULL),
(70, 70, 1, 'eIHiOlXijLHoJXEmFc', 'It''s a bad line <a href=" http://opleiding-fotografie.be/artikel/marketingtips-voor-fotografen/ ">zyban 150mg tablets</a>  This field is used by the pharmacy to enter the dollar amount\n <a href=" http://www.mburtonphoto.com/about/ ">glucophage online</a>  â¢ Unwillingness to interact\n <a href=" http://makemistakes.us/mixes-2/ ">aldactone price</a>  17. Accurately compound medications calculating ingredients, using correct\n ', 'Lucky', NULL),
(71, 71, 1, 'XbJbmQUdKfllvd', 'We need someone with experience <a href=" http://www.chartierscc.com/dining/ ">proventil coupons</a>  policies. These include alleged ethical and legal violations of the practice of pharmacy,\n <a href=" http://fanfaremedia.co.uk/about/ ">metronidazole online pharmacy</a>  Determination of product eligibility for most claims\n <a href=" http://opleiding-fotografie.be/artikel/marketingtips-voor-fotografen/ ">buy cheap bupropion</a>  B. Commitment to some tasks to best some tasks to best Occasionally most tasks to best all tasks to best\n ', 'Gabrielle', NULL),
(72, 72, 1, 'pTVnPeSGqW', 'I quite like cooking <a href=" http://www.buchstartclub.ch/jury ">online prozac uk</a>  students via email approximately 2-3 months prior to traveling.\n <a href=" http://www.livingfoods.ie/terms-and-conditions/ ">buy sildenafil citrate online</a>  process the transaction through all required editing. If approved, and if the item or NDC\n <a href=" http://raventosrosell.com/portfolio/cava/ ">betamethasone cream uk</a>  ¥Gamma: ³ = 07 (0.3)\n ', 'Trinity', NULL),
(73, 73, 1, 'zPBqtBvjvpnFPRFPCCT', 'Have you seen any good films recently? <a href=" http://www.danieldavis.com/parametricmodel-com/ ">buy xenical online cheap and no prescription</a>  completed at the same or different site location.\n <a href=" http://www.livingfoods.ie/terms-and-conditions/ ">buy eriacta</a>  Drug Age should be changed.\n <a href=" http://raventosrosell.com/portfolio/cava/ ">actavis clotrimazole and betamethasone dipropionate cream</a>  Potential biases and effects of the accuracy of the trials results; Impact upon pharmacy\n ', 'Brody', NULL),
(74, 74, 1, 'NFezWGJpdfaFmIeWBf', 'The manager <a href=" http://www.danieldavis.com/parametricmodel-com/ ">orlistat 60 mg 120 mg</a>  " Header Response Status (Field 501-F1) will contain an A (Accepted).\n <a href=" http://www.buchstartclub.ch/jury ">buy prozac online no prescription australia</a>  the United States and Africa, foster the values of the medical profession, and promote\n <a href=" http://www.cottages-with-a-view.co.uk/croft-cottage/ ">cefixime tablets</a>  photocopy of the returned Claim Forms along with a copy of the Reconciliation Report\n ', 'Ashley', NULL),
(75, 75, 1, 'sWUyeenoCsm', 'I''d like to withdraw $100, please <a href=" http://www.livingfoods.ie/terms-and-conditions/ ">cheap eriacta</a>  excused absences (i.e. Career Day). Preceptors will be notified prior to these events.\n <a href=" http://raventosrosell.com/portfolio/cava/ ">betnovate gm skin cream</a>  prescription drugs that have a high incidence of side effects, when the cardholder has\n <a href=" http://www.cottages-with-a-view.co.uk/croft-cottage/ ">suprax coupon</a>  CODE DESCRIPTION CODE DESCRIPTION\n <a href=" http://asect.org.uk/grapevine-project/ ">purchase periactin</a>  various regulations mandated by the Kentucky Department for Medicaid Services\n ', 'Colton', NULL),
(76, 76, 1, 'mfznaAoAGzPjxHqw', 'Are you a student? <a href=" http://www.danieldavis.com/parametricmodel-com/ ">where can i buy xenical</a>  bulletin, newsletter, or patient handout.\n <a href=" http://raventosrosell.com/portfolio/cava/ ">betnovate c cream</a>  1. Download a PHP Prior Authorization Request Form from the Pharmacy Section\n <a href=" http://www.cottages-with-a-view.co.uk/croft-cottage/ ">cefixime ofloxacin</a>  Prior authorizations for enteral formula are issued based on times approved rather\n <a href=" http://asect.org.uk/grapevine-project/ ">order cyproheptadine online</a>  The Office of Experiential Training and Continuing Pharmacy Education -TSU COPHS Page 34\n ', 'Rachel', NULL),
(77, 77, 1, 'CILHNKJkUdI', 'I''m retired <a href=" http://www.cbar.org.br/12congresso/ ">wellbutrin prescription card</a>  interaction helps a student appreciate the similarities and differences between different schools.\n <a href=" http://www.justcuckoos.co.uk/install/ ">generic vermox</a>  only when the gamma setting is ³ = 07 (0.3).\n <a href=" http://eastcountyins.com/about-us/ ">zithromax to treat strep throat</a>  January 2007 3.2.17 Variable 5.1 Request Format\n <a href=" http://anjhero.me/work ">buy clomid online pharmacy</a>  for the proper format for the other transactions. An Eligibility Verification transaction does\n ', 'Caleb', NULL),
(78, 78, 1, 'eoxPytRdWkooVVA', 'Yes, I play the guitar <a href=" http://www.sciencetarget.com/site/index.php/faq ">strattera discounts coupons</a>  d. Generate a specific medical and drug therapy list\n <a href=" http://eastcountyins.com/about-us/ ">where can u buy zithromax</a>  a) for diabetes : insulin, needles and syringes ;\n <a href=" http://www.ilecconferencecentre.co.uk/professional-services/ ">doxycycline 100 mg capsule</a>  Boil the corn. Cut the kernels off the green corn cob. Boil the corn with the beans until soft. Peel and\n <a href=" http://anjhero.me/work ">how to get clomid</a>  SUCOP has developed an appointment process such that preceptors to our students\n ', 'Charlotte', NULL),
(79, 79, 1, 'rkJwjlGNLQOhJOppjiA', 'I''m on holiday <a href=" http://www.rjackbalthazar.com/about-us.html ">betamethasone valerate lotion usp 0.1</a>  predisposed in any way and how would such an adverse event affect this particular patient?\n <a href=" http://www.cbar.org.br/12congresso/ ">buy wellbutrin xl 150mg</a>  expectation that your work will be completed in full observance of the Honor\n <a href=" http://www.justcuckoos.co.uk/install/ ">vermox worms</a>  Primary Learning Objectives - Community Pharmacy Part 3 of 3\n <a href=" http://anjhero.me/work ">order clomid online canada</a>  87 Reversal Not Processed\n ', 'Alyssa', NULL),
(80, 80, 1, 'wiMZzkgSXN', 'Best Site Good Work <a href=" http://www.rjackbalthazar.com/about-us.html ">betnovate c ointment</a>  Request for change in provider profile\n <a href=" http://www.cbar.org.br/12congresso/ ">wellbutrin sr buy</a>  Presentation satisfactorily complete basic, tasks. Independently completes basic, completes most\n <a href=" http://www.ilecconferencecentre.co.uk/professional-services/ ">how can i get doxycycline</a>  5.9. Assess and manage the use of electronic technologies toaccess and manage scientific /\n ', 'Olivia', NULL),
(81, 81, 1, 'eNgRAdZQeCMAxP', 'Looking for a job <a href=" http://www.cbar.org.br/12congresso/ ">buy wellbutrin xl</a>  Page Revision Dat e\n <a href=" http://www.ilecconferencecentre.co.uk/professional-services/ ">100 mg doxycycline</a>  Demonstrates knowledge of quality improvement program utilized at the site. Meets Partially Does Not\n <a href=" http://www.appartement-huren-alanya.nl/mahmutlar/ ">terbinafine discount</a>  "5.1" format. The input and response formats are described on the following pages. Any\n ', 'Matthew', NULL);
INSERT INTO `review_detail` (`detail_id`, `review_id`, `store_id`, `title`, `detail`, `nickname`, `customer_id`) VALUES
(82, 82, 1, 'qCitgSCJBBlHE', 'RAgddy  <a href="http://egdktfbhutqg.com/">egdktfbhutqg</a>, [url=http://ijirhwxvsjuw.com/]ijirhwxvsjuw[/url], [link=http://gjsbucxeirpw.com/]gjsbucxeirpw[/link], http://gahpfybjdhwc.com/', 'hicxyyjkrst', NULL),
(83, 83, 1, 'http://www.permira.com/services.aspx', 'Hi there, after reading this awesome post i am also cheerful to share my know-how here with colleagues.\r\nNike Air Max 1 http://www.permira.com/services.aspx', 'Nike Air Max 1', NULL),
(84, 84, 1, 'wOVXNOddyLVzq', 'Ms2Ujx http://www.QS3PE5ZGdxC9IoVKTAPT2DBYpPkMKqfz.com', 'matt', NULL),
(85, 85, 1, 'uNuHHNqQRiCXJSqo', 'BNmBIj http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com', 'varlog', NULL);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `review_entity`
--

CREATE TABLE IF NOT EXISTS `review_entity` (
  `entity_id` smallint(5) unsigned NOT NULL auto_increment,
  `entity_code` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`entity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Review entities' AUTO_INCREMENT=4 ;

--
-- A tábla adatainak kiíratása `review_entity`
--

INSERT INTO `review_entity` (`entity_id`, `entity_code`) VALUES
(1, 'product'),
(2, 'customer'),
(3, 'category');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `review_entity_summary`
--

CREATE TABLE IF NOT EXISTS `review_entity_summary` (
  `primary_id` bigint(20) NOT NULL auto_increment,
  `entity_pk_value` bigint(20) NOT NULL default '0',
  `entity_type` tinyint(4) NOT NULL default '0',
  `reviews_count` smallint(6) NOT NULL default '0',
  `rating_summary` tinyint(4) NOT NULL default '0',
  `store_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`primary_id`),
  KEY `FK_REVIEW_ENTITY_SUMMARY_STORE` (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- A tábla adatainak kiíratása `review_entity_summary`
--

INSERT INTO `review_entity_summary` (`primary_id`, `entity_pk_value`, `entity_type`, `reviews_count`, `rating_summary`, `store_id`) VALUES
(1, 22, 1, 0, 0, 1),
(2, 20, 1, 0, 0, 1),
(3, 5, 1, 0, 0, 1),
(4, 39, 1, 0, 0, 1);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `review_status`
--

CREATE TABLE IF NOT EXISTS `review_status` (
  `status_id` tinyint(3) unsigned NOT NULL auto_increment,
  `status_code` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`status_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Review statuses' AUTO_INCREMENT=4 ;

--
-- A tábla adatainak kiíratása `review_status`
--

INSERT INTO `review_status` (`status_id`, `status_code`) VALUES
(1, 'Approved'),
(2, 'Pending'),
(3, 'Not Approved');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `review_store`
--

CREATE TABLE IF NOT EXISTS `review_store` (
  `review_id` bigint(20) unsigned NOT NULL,
  `store_id` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`review_id`,`store_id`),
  KEY `FK_REVIEW_STORE_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `review_store`
--

INSERT INTO `review_store` (`review_id`, `store_id`) VALUES
(1, 0),
(2, 0),
(3, 0),
(4, 0),
(5, 0),
(6, 0),
(7, 0),
(8, 0),
(9, 0),
(10, 0),
(11, 0),
(12, 0),
(13, 0),
(14, 0),
(15, 0),
(16, 0),
(17, 0),
(18, 0),
(19, 0),
(20, 0),
(21, 0),
(22, 0),
(23, 0),
(24, 0),
(25, 0),
(26, 0),
(27, 0),
(28, 0),
(29, 0),
(30, 0),
(31, 0),
(32, 0),
(33, 0),
(34, 0),
(35, 0),
(36, 0),
(37, 0),
(38, 0),
(39, 0),
(40, 0),
(41, 0),
(42, 0),
(43, 0),
(44, 0),
(45, 0),
(46, 0),
(47, 0),
(48, 0),
(49, 0),
(50, 0),
(51, 0),
(52, 0),
(53, 0),
(54, 0),
(55, 0),
(56, 0),
(57, 0),
(58, 0),
(59, 0),
(60, 0),
(61, 0),
(62, 0),
(63, 0),
(64, 0),
(65, 0),
(66, 0),
(67, 0),
(68, 0),
(69, 0),
(70, 0),
(71, 0),
(72, 0),
(73, 0),
(74, 0),
(75, 0),
(76, 0),
(77, 0),
(78, 0),
(79, 0),
(80, 0),
(81, 0),
(82, 0),
(83, 0),
(84, 0),
(85, 0),
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `salesrule`
--

CREATE TABLE IF NOT EXISTS `salesrule` (
  `rule_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `from_date` date default '0000-00-00',
  `to_date` date default '0000-00-00',
  `uses_per_customer` int(11) NOT NULL default '0',
  `customer_group_ids` text,
  `is_active` tinyint(1) NOT NULL default '0',
  `conditions_serialized` mediumtext NOT NULL,
  `actions_serialized` mediumtext NOT NULL,
  `stop_rules_processing` tinyint(1) NOT NULL default '1',
  `is_advanced` tinyint(3) unsigned NOT NULL default '1',
  `product_ids` text,
  `sort_order` int(10) unsigned NOT NULL default '0',
  `simple_action` varchar(32) NOT NULL default '',
  `discount_amount` decimal(12,4) NOT NULL default '0.0000',
  `discount_qty` decimal(12,4) unsigned default NULL,
  `discount_step` int(10) unsigned NOT NULL,
  `simple_free_shipping` tinyint(1) unsigned NOT NULL default '0',
  `apply_to_shipping` tinyint(1) unsigned NOT NULL default '0',
  `times_used` int(11) unsigned NOT NULL default '0',
  `is_rss` tinyint(4) NOT NULL default '0',
  `website_ids` text,
  `coupon_type` smallint(5) unsigned NOT NULL default '1',
  PRIMARY KEY  (`rule_id`),
  KEY `sort_order` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `salesrule`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `salesrule_coupon`
--

CREATE TABLE IF NOT EXISTS `salesrule_coupon` (
  `coupon_id` int(10) unsigned NOT NULL auto_increment,
  `rule_id` int(10) unsigned NOT NULL,
  `code` varchar(255) NOT NULL,
  `usage_limit` int(10) unsigned default NULL,
  `usage_per_customer` int(10) unsigned default NULL,
  `times_used` int(10) unsigned NOT NULL default '0',
  `expiration_date` datetime default NULL,
  `is_primary` tinyint(1) unsigned default NULL,
  PRIMARY KEY  (`coupon_id`),
  UNIQUE KEY `UNQ_COUPON_CODE` (`code`),
  UNIQUE KEY `UNQ_RULE_MAIN_COUPON` (`rule_id`,`is_primary`),
  KEY `FK_SALESRULE_COUPON_RULE_ID_SALESRULE` (`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `salesrule_coupon`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `salesrule_coupon_usage`
--

CREATE TABLE IF NOT EXISTS `salesrule_coupon_usage` (
  `coupon_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `times_used` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`coupon_id`,`customer_id`),
  KEY `FK_SALESRULE_COUPON_CUSTOMER_COUPON_ID_CUSTOMER_ENTITY` (`coupon_id`),
  KEY `FK_SALESRULE_COUPON_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `salesrule_coupon_usage`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `salesrule_customer`
--

CREATE TABLE IF NOT EXISTS `salesrule_customer` (
  `rule_customer_id` int(10) unsigned NOT NULL auto_increment,
  `rule_id` int(10) unsigned NOT NULL default '0',
  `customer_id` int(10) unsigned NOT NULL default '0',
  `times_used` smallint(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rule_customer_id`),
  KEY `rule_id` (`rule_id`,`customer_id`),
  KEY `customer_id` (`customer_id`,`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `salesrule_customer`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `salesrule_label`
--

CREATE TABLE IF NOT EXISTS `salesrule_label` (
  `label_id` int(10) unsigned NOT NULL auto_increment,
  `rule_id` int(10) unsigned NOT NULL,
  `store_id` smallint(5) unsigned NOT NULL,
  `label` varchar(255) default NULL,
  PRIMARY KEY  (`label_id`),
  UNIQUE KEY `IDX_RULE_STORE` (`rule_id`,`store_id`),
  KEY `FK_SALESRULE_LABEL_STORE` (`store_id`),
  KEY `FK_SALESRULE_LABEL_RULE` (`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `salesrule_label`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `salesrule_product_attribute`
--

CREATE TABLE IF NOT EXISTS `salesrule_product_attribute` (
  `rule_id` int(10) unsigned NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL,
  `customer_group_id` smallint(5) unsigned NOT NULL,
  `attribute_id` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`rule_id`,`website_id`,`customer_group_id`,`attribute_id`),
  KEY `IDX_WEBSITE` (`website_id`),
  KEY `IDX_CUSTOMER_GROUP` (`customer_group_id`),
  KEY `IDX_ATTRIBUTE` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `salesrule_product_attribute`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_bestsellers_aggregated_daily`
--

CREATE TABLE IF NOT EXISTS `sales_bestsellers_aggregated_daily` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `product_id` int(10) unsigned default NULL,
  `product_name` varchar(255) NOT NULL default '',
  `product_price` decimal(12,4) NOT NULL default '0.0000',
  `qty_ordered` decimal(12,4) NOT NULL default '0.0000',
  `rating_pos` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_PRODUCT` (`period`,`store_id`,`product_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_bestsellers_aggregated_daily`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_bestsellers_aggregated_monthly`
--

CREATE TABLE IF NOT EXISTS `sales_bestsellers_aggregated_monthly` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `product_id` int(10) unsigned default NULL,
  `product_name` varchar(255) NOT NULL default '',
  `product_price` decimal(12,4) NOT NULL default '0.0000',
  `qty_ordered` decimal(12,4) NOT NULL default '0.0000',
  `rating_pos` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_PRODUCT` (`period`,`store_id`,`product_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_bestsellers_aggregated_monthly`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_bestsellers_aggregated_yearly`
--

CREATE TABLE IF NOT EXISTS `sales_bestsellers_aggregated_yearly` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `product_id` int(10) unsigned default NULL,
  `product_name` varchar(255) NOT NULL default '',
  `product_price` decimal(12,4) NOT NULL default '0.0000',
  `qty_ordered` decimal(12,4) NOT NULL default '0.0000',
  `rating_pos` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_PRODUCT` (`period`,`store_id`,`product_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_bestsellers_aggregated_yearly`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_billing_agreement`
--

CREATE TABLE IF NOT EXISTS `sales_billing_agreement` (
  `agreement_id` int(10) unsigned NOT NULL auto_increment,
  `customer_id` int(10) unsigned NOT NULL,
  `method_code` varchar(32) NOT NULL,
  `reference_id` varchar(32) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime default NULL,
  `store_id` smallint(5) unsigned default NULL,
  `agreement_label` varchar(255) default NULL,
  PRIMARY KEY  (`agreement_id`),
  KEY `IDX_CUSTOMER` (`customer_id`),
  KEY `FK_BILLING_AGREEMENT_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_billing_agreement`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_billing_agreement_order`
--

CREATE TABLE IF NOT EXISTS `sales_billing_agreement_order` (
  `agreement_id` int(10) unsigned NOT NULL,
  `order_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `UNQ_BILLING_AGREEMENT_ORDER` (`agreement_id`,`order_id`),
  KEY `FK_BILLING_AGREEMENT_ORDER_ORDER` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `sales_billing_agreement_order`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_creditmemo`
--

CREATE TABLE IF NOT EXISTS `sales_flat_creditmemo` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned default NULL,
  `adjustment_positive` decimal(12,4) default NULL,
  `base_shipping_tax_amount` decimal(12,4) default NULL,
  `store_to_order_rate` decimal(12,4) default NULL,
  `base_discount_amount` decimal(12,4) default NULL,
  `base_to_order_rate` decimal(12,4) default NULL,
  `grand_total` decimal(12,4) default NULL,
  `base_adjustment_negative` decimal(12,4) default NULL,
  `base_subtotal_incl_tax` decimal(12,4) default NULL,
  `shipping_amount` decimal(12,4) default NULL,
  `subtotal_incl_tax` decimal(12,4) default NULL,
  `adjustment_negative` decimal(12,4) default NULL,
  `base_shipping_amount` decimal(12,4) default NULL,
  `store_to_base_rate` decimal(12,4) default NULL,
  `base_to_global_rate` decimal(12,4) default NULL,
  `base_adjustment` decimal(12,4) default NULL,
  `base_subtotal` decimal(12,4) default NULL,
  `discount_amount` decimal(12,4) default NULL,
  `subtotal` decimal(12,4) default NULL,
  `adjustment` decimal(12,4) default NULL,
  `base_grand_total` decimal(12,4) default NULL,
  `base_adjustment_positive` decimal(12,4) default NULL,
  `base_tax_amount` decimal(12,4) default NULL,
  `shipping_tax_amount` decimal(12,4) default NULL,
  `tax_amount` decimal(12,4) default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `email_sent` tinyint(1) unsigned default NULL,
  `creditmemo_status` int(10) default NULL,
  `state` int(10) default NULL,
  `shipping_address_id` int(10) default NULL,
  `billing_address_id` int(10) default NULL,
  `invoice_id` int(10) default NULL,
  `cybersource_token` varchar(255) default NULL,
  `store_currency_code` char(3) default NULL,
  `order_currency_code` char(3) default NULL,
  `base_currency_code` char(3) default NULL,
  `global_currency_code` char(3) default NULL,
  `transaction_id` varchar(255) default NULL,
  `increment_id` varchar(50) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `base_shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_incl_tax` decimal(12,4) default NULL,
  `base_shipping_incl_tax` decimal(12,4) default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_CREDITMEMO_STATUS` (`creditmemo_status`),
  KEY `IDX_STATE` (`state`),
  KEY `IDX_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_creditmemo`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_creditmemo_comment`
--

CREATE TABLE IF NOT EXISTS `sales_flat_creditmemo_comment` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `is_customer_notified` int(10) default NULL,
  `is_visible_on_front` tinyint(1) unsigned NOT NULL default '0',
  `comment` text,
  `created_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_creditmemo_comment`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_creditmemo_grid`
--

CREATE TABLE IF NOT EXISTS `sales_flat_creditmemo_grid` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned default NULL,
  `store_to_order_rate` decimal(12,4) default NULL,
  `base_to_order_rate` decimal(12,4) default NULL,
  `grand_total` decimal(12,4) default NULL,
  `store_to_base_rate` decimal(12,4) default NULL,
  `base_to_global_rate` decimal(12,4) default NULL,
  `base_grand_total` decimal(12,4) default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `creditmemo_status` int(10) default NULL,
  `state` int(10) default NULL,
  `invoice_id` int(10) default NULL,
  `store_currency_code` char(3) default NULL,
  `order_currency_code` char(3) default NULL,
  `base_currency_code` char(3) default NULL,
  `global_currency_code` char(3) default NULL,
  `increment_id` varchar(50) default NULL,
  `order_increment_id` varchar(50) default NULL,
  `created_at` datetime default NULL,
  `order_created_at` datetime default NULL,
  `billing_name` varchar(255) default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_GRAND_TOTAL` (`grand_total`),
  KEY `IDX_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_CREDITMEMO_STATUS` (`creditmemo_status`),
  KEY `IDX_STATE` (`state`),
  KEY `IDX_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_ORDER_CREATED_AT` (`order_created_at`),
  KEY `IDX_BILLING_NAME` (`billing_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_creditmemo_grid`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_creditmemo_item`
--

CREATE TABLE IF NOT EXISTS `sales_flat_creditmemo_item` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `base_price` decimal(12,4) default NULL,
  `base_weee_tax_row_disposition` decimal(12,4) default NULL,
  `tax_amount` decimal(12,4) default NULL,
  `base_weee_tax_applied_amount` decimal(12,4) default NULL,
  `weee_tax_row_disposition` decimal(12,4) default NULL,
  `base_row_total` decimal(12,4) default NULL,
  `discount_amount` decimal(12,4) default NULL,
  `row_total` decimal(12,4) default NULL,
  `weee_tax_applied_amount` decimal(12,4) default NULL,
  `base_discount_amount` decimal(12,4) default NULL,
  `base_weee_tax_disposition` decimal(12,4) default NULL,
  `price_incl_tax` decimal(12,4) default NULL,
  `base_tax_amount` decimal(12,4) default NULL,
  `weee_tax_disposition` decimal(12,4) default NULL,
  `base_price_incl_tax` decimal(12,4) default NULL,
  `qty` decimal(12,4) default NULL,
  `base_cost` decimal(12,4) default NULL,
  `base_weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `price` decimal(12,4) default NULL,
  `base_row_total_incl_tax` decimal(12,4) default NULL,
  `row_total_incl_tax` decimal(12,4) default NULL,
  `product_id` int(10) default NULL,
  `order_item_id` int(10) default NULL,
  `additional_data` text,
  `description` text,
  `weee_tax_applied` text,
  `sku` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_creditmemo_item`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_invoice`
--

CREATE TABLE IF NOT EXISTS `sales_flat_invoice` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned default NULL,
  `base_grand_total` decimal(12,4) default NULL,
  `shipping_tax_amount` decimal(12,4) default NULL,
  `tax_amount` decimal(12,4) default NULL,
  `base_tax_amount` decimal(12,4) default NULL,
  `store_to_order_rate` decimal(12,4) default NULL,
  `base_shipping_tax_amount` decimal(12,4) default NULL,
  `base_discount_amount` decimal(12,4) default NULL,
  `base_to_order_rate` decimal(12,4) default NULL,
  `grand_total` decimal(12,4) default NULL,
  `shipping_amount` decimal(12,4) default NULL,
  `subtotal_incl_tax` decimal(12,4) default NULL,
  `base_subtotal_incl_tax` decimal(12,4) default NULL,
  `store_to_base_rate` decimal(12,4) default NULL,
  `base_shipping_amount` decimal(12,4) default NULL,
  `total_qty` decimal(12,4) default NULL,
  `base_to_global_rate` decimal(12,4) default NULL,
  `subtotal` decimal(12,4) default NULL,
  `base_subtotal` decimal(12,4) default NULL,
  `discount_amount` decimal(12,4) default NULL,
  `billing_address_id` int(10) default NULL,
  `is_used_for_refund` tinyint(1) unsigned default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `email_sent` tinyint(1) unsigned default NULL,
  `can_void_flag` tinyint(1) unsigned default NULL,
  `state` int(10) default NULL,
  `shipping_address_id` int(10) default NULL,
  `cybersource_token` varchar(255) default NULL,
  `store_currency_code` char(3) default NULL,
  `transaction_id` varchar(255) default NULL,
  `order_currency_code` char(3) default NULL,
  `base_currency_code` char(3) default NULL,
  `global_currency_code` char(3) default NULL,
  `increment_id` varchar(50) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `base_shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_incl_tax` decimal(12,4) default NULL,
  `base_shipping_incl_tax` decimal(12,4) default NULL,
  `base_total_refunded` decimal(12,4) default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_GRAND_TOTAL` (`grand_total`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_STATE` (`state`),
  KEY `IDX_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_invoice`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_invoice_comment`
--

CREATE TABLE IF NOT EXISTS `sales_flat_invoice_comment` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `is_customer_notified` tinyint(1) unsigned default NULL,
  `is_visible_on_front` tinyint(1) unsigned NOT NULL default '0',
  `comment` text,
  `created_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_invoice_comment`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_invoice_grid`
--

CREATE TABLE IF NOT EXISTS `sales_flat_invoice_grid` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned default NULL,
  `base_grand_total` decimal(12,4) default NULL,
  `grand_total` decimal(12,4) default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `state` int(10) default NULL,
  `store_currency_code` char(3) default NULL,
  `order_currency_code` char(3) default NULL,
  `base_currency_code` char(3) default NULL,
  `global_currency_code` char(3) default NULL,
  `increment_id` varchar(50) default NULL,
  `order_increment_id` varchar(50) default NULL,
  `created_at` datetime default NULL,
  `order_created_at` datetime default NULL,
  `billing_name` varchar(255) default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_GRAND_TOTAL` (`grand_total`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_STATE` (`state`),
  KEY `IDX_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_ORDER_CREATED_AT` (`order_created_at`),
  KEY `IDX_BILLING_NAME` (`billing_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_invoice_grid`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_invoice_item`
--

CREATE TABLE IF NOT EXISTS `sales_flat_invoice_item` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `base_price` decimal(12,4) default NULL,
  `base_weee_tax_row_disposition` decimal(12,4) default NULL,
  `weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `base_weee_tax_applied_amount` decimal(12,4) default NULL,
  `tax_amount` decimal(12,4) default NULL,
  `base_row_total` decimal(12,4) default NULL,
  `discount_amount` decimal(12,4) default NULL,
  `row_total` decimal(12,4) default NULL,
  `weee_tax_row_disposition` decimal(12,4) default NULL,
  `base_discount_amount` decimal(12,4) default NULL,
  `base_weee_tax_disposition` decimal(12,4) default NULL,
  `price_incl_tax` decimal(12,4) default NULL,
  `weee_tax_applied_amount` decimal(12,4) default NULL,
  `base_tax_amount` decimal(12,4) default NULL,
  `base_price_incl_tax` decimal(12,4) default NULL,
  `qty` decimal(12,4) default NULL,
  `weee_tax_disposition` decimal(12,4) default NULL,
  `base_cost` decimal(12,4) default NULL,
  `base_weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `price` decimal(12,4) default NULL,
  `base_row_total_incl_tax` decimal(12,4) default NULL,
  `row_total_incl_tax` decimal(12,4) default NULL,
  `product_id` int(10) default NULL,
  `order_item_id` int(10) default NULL,
  `additional_data` text,
  `description` text,
  `weee_tax_applied` text,
  `sku` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_invoice_item`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_order`
--

CREATE TABLE IF NOT EXISTS `sales_flat_order` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `state` varchar(32) default NULL,
  `status` varchar(32) default NULL,
  `coupon_code` varchar(255) default NULL,
  `protect_code` varchar(255) default NULL,
  `shipping_description` varchar(255) default NULL,
  `is_virtual` tinyint(1) unsigned default NULL,
  `store_id` smallint(5) unsigned default NULL,
  `customer_id` int(10) unsigned default NULL,
  `base_discount_amount` decimal(12,4) default NULL,
  `base_discount_canceled` decimal(12,4) default NULL,
  `base_discount_invoiced` decimal(12,4) default NULL,
  `base_discount_refunded` decimal(12,4) default NULL,
  `base_grand_total` decimal(12,4) default NULL,
  `base_shipping_amount` decimal(12,4) default NULL,
  `base_shipping_canceled` decimal(12,4) default NULL,
  `base_shipping_invoiced` decimal(12,4) default NULL,
  `base_shipping_refunded` decimal(12,4) default NULL,
  `base_shipping_tax_amount` decimal(12,4) default NULL,
  `base_shipping_tax_refunded` decimal(12,4) default NULL,
  `base_subtotal` decimal(12,4) default NULL,
  `base_subtotal_canceled` decimal(12,4) default NULL,
  `base_subtotal_invoiced` decimal(12,4) default NULL,
  `base_subtotal_refunded` decimal(12,4) default NULL,
  `base_tax_amount` decimal(12,4) default NULL,
  `base_tax_canceled` decimal(12,4) default NULL,
  `base_tax_invoiced` decimal(12,4) default NULL,
  `base_tax_refunded` decimal(12,4) default NULL,
  `base_to_global_rate` decimal(12,4) default NULL,
  `base_to_order_rate` decimal(12,4) default NULL,
  `base_total_canceled` decimal(12,4) default NULL,
  `base_total_invoiced` decimal(12,4) default NULL,
  `base_total_invoiced_cost` decimal(12,4) default NULL,
  `base_total_offline_refunded` decimal(12,4) default NULL,
  `base_total_online_refunded` decimal(12,4) default NULL,
  `base_total_paid` decimal(12,4) default NULL,
  `base_total_qty_ordered` decimal(12,4) default NULL,
  `base_total_refunded` decimal(12,4) default NULL,
  `discount_amount` decimal(12,4) default NULL,
  `discount_canceled` decimal(12,4) default NULL,
  `discount_invoiced` decimal(12,4) default NULL,
  `discount_refunded` decimal(12,4) default NULL,
  `grand_total` decimal(12,4) default NULL,
  `shipping_amount` decimal(12,4) default NULL,
  `shipping_canceled` decimal(12,4) default NULL,
  `shipping_invoiced` decimal(12,4) default NULL,
  `shipping_refunded` decimal(12,4) default NULL,
  `shipping_tax_amount` decimal(12,4) default NULL,
  `shipping_tax_refunded` decimal(12,4) default NULL,
  `store_to_base_rate` decimal(12,4) default NULL,
  `store_to_order_rate` decimal(12,4) default NULL,
  `subtotal` decimal(12,4) default NULL,
  `subtotal_canceled` decimal(12,4) default NULL,
  `subtotal_invoiced` decimal(12,4) default NULL,
  `subtotal_refunded` decimal(12,4) default NULL,
  `tax_amount` decimal(12,4) default NULL,
  `tax_canceled` decimal(12,4) default NULL,
  `tax_invoiced` decimal(12,4) default NULL,
  `tax_refunded` decimal(12,4) default NULL,
  `total_canceled` decimal(12,4) default NULL,
  `total_invoiced` decimal(12,4) default NULL,
  `total_offline_refunded` decimal(12,4) default NULL,
  `total_online_refunded` decimal(12,4) default NULL,
  `total_paid` decimal(12,4) default NULL,
  `total_qty_ordered` decimal(12,4) default NULL,
  `total_refunded` decimal(12,4) default NULL,
  `can_ship_partially` tinyint(1) unsigned default NULL,
  `can_ship_partially_item` tinyint(1) unsigned default NULL,
  `customer_is_guest` tinyint(1) unsigned default NULL,
  `customer_note_notify` tinyint(1) unsigned default NULL,
  `billing_address_id` int(10) default NULL,
  `customer_group_id` smallint(5) default NULL,
  `edit_increment` int(10) default NULL,
  `email_sent` tinyint(1) unsigned default NULL,
  `forced_do_shipment_with_invoice` tinyint(1) unsigned default NULL,
  `gift_message_id` int(10) default NULL,
  `payment_authorization_expiration` int(10) default NULL,
  `paypal_ipn_customer_notified` int(10) default NULL,
  `quote_address_id` int(10) default NULL,
  `quote_id` int(10) default NULL,
  `shipping_address_id` int(10) default NULL,
  `adjustment_negative` decimal(12,4) default NULL,
  `adjustment_positive` decimal(12,4) default NULL,
  `base_adjustment_negative` decimal(12,4) default NULL,
  `base_adjustment_positive` decimal(12,4) default NULL,
  `base_shipping_discount_amount` decimal(12,4) default NULL,
  `base_subtotal_incl_tax` decimal(12,4) default NULL,
  `base_total_due` decimal(12,4) default NULL,
  `payment_authorization_amount` decimal(12,4) default NULL,
  `shipping_discount_amount` decimal(12,4) default NULL,
  `subtotal_incl_tax` decimal(12,4) default NULL,
  `total_due` decimal(12,4) default NULL,
  `weight` decimal(12,4) default NULL,
  `customer_dob` datetime default NULL,
  `increment_id` varchar(50) default NULL,
  `applied_rule_ids` varchar(255) default NULL,
  `base_currency_code` char(3) default NULL,
  `customer_email` varchar(255) default NULL,
  `customer_firstname` varchar(255) default NULL,
  `customer_lastname` varchar(255) default NULL,
  `customer_middlename` varchar(255) default NULL,
  `customer_prefix` varchar(255) default NULL,
  `customer_suffix` varchar(255) default NULL,
  `customer_taxvat` varchar(255) default NULL,
  `discount_description` varchar(255) default NULL,
  `ext_customer_id` varchar(255) default NULL,
  `ext_order_id` varchar(255) default NULL,
  `global_currency_code` char(3) default NULL,
  `hold_before_state` varchar(255) default NULL,
  `hold_before_status` varchar(255) default NULL,
  `order_currency_code` varchar(255) default NULL,
  `original_increment_id` varchar(50) default NULL,
  `relation_child_id` varchar(32) default NULL,
  `relation_child_real_id` varchar(32) default NULL,
  `relation_parent_id` varchar(32) default NULL,
  `relation_parent_real_id` varchar(32) default NULL,
  `remote_ip` varchar(255) default NULL,
  `shipping_method` varchar(255) default NULL,
  `store_currency_code` char(3) default NULL,
  `store_name` varchar(255) default NULL,
  `x_forwarded_for` varchar(255) default NULL,
  `customer_note` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `total_item_count` smallint(5) unsigned default '0',
  `customer_gender` int(11) default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `base_shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `hidden_tax_invoiced` decimal(12,4) default NULL,
  `base_hidden_tax_invoiced` decimal(12,4) default NULL,
  `hidden_tax_refunded` decimal(12,4) default NULL,
  `base_hidden_tax_refunded` decimal(12,4) default NULL,
  `shipping_incl_tax` decimal(12,4) default NULL,
  `base_shipping_incl_tax` decimal(12,4) default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STATUS` (`status`),
  KEY `IDX_STATE` (`state`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_CUSTOMER_ID` (`customer_id`),
  KEY `IDX_EXT_ORDER_ID` (`ext_order_id`),
  KEY `IDX_UPDATED_AT` (`updated_at`),
  KEY `IDX_QUOTE_ID` (`quote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_order`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_order_address`
--

CREATE TABLE IF NOT EXISTS `sales_flat_order_address` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned default NULL,
  `customer_address_id` int(10) default NULL,
  `quote_address_id` int(10) default NULL,
  `region_id` int(10) default NULL,
  `customer_id` int(10) default NULL,
  `fax` varchar(255) default NULL,
  `region` varchar(255) default NULL,
  `postcode` varchar(255) default NULL,
  `lastname` varchar(255) default NULL,
  `street` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `telephone` varchar(255) default NULL,
  `country_id` char(2) default NULL,
  `firstname` varchar(255) default NULL,
  `address_type` varchar(255) default NULL,
  `prefix` varchar(255) default NULL,
  `middlename` varchar(255) default NULL,
  `suffix` varchar(255) default NULL,
  `company` varchar(255) default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_order_address`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_order_grid`
--

CREATE TABLE IF NOT EXISTS `sales_flat_order_grid` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `status` varchar(32) default NULL,
  `store_id` smallint(5) unsigned default NULL,
  `store_name` varchar(255) default NULL,
  `customer_id` int(10) unsigned default NULL,
  `base_grand_total` decimal(12,4) default NULL,
  `base_total_paid` decimal(12,4) default NULL,
  `grand_total` decimal(12,4) default NULL,
  `total_paid` decimal(12,4) default NULL,
  `increment_id` varchar(50) default NULL,
  `base_currency_code` char(3) default NULL,
  `order_currency_code` varchar(255) default NULL,
  `shipping_name` varchar(255) default NULL,
  `billing_name` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STATUS` (`status`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `IDX_BASE_TOTAL_PAID` (`base_total_paid`),
  KEY `IDX_GRAND_TOTAL` (`grand_total`),
  KEY `IDX_TOTAL_PAID` (`total_paid`),
  KEY `IDX_SHIPPING_NAME` (`shipping_name`),
  KEY `IDX_BILLING_NAME` (`billing_name`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_CUSTOMER_ID` (`customer_id`),
  KEY `IDX_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_order_grid`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_order_item`
--

CREATE TABLE IF NOT EXISTS `sales_flat_order_item` (
  `item_id` int(10) unsigned NOT NULL auto_increment,
  `order_id` int(10) unsigned NOT NULL default '0',
  `parent_item_id` int(10) unsigned default NULL,
  `quote_item_id` int(10) unsigned default NULL,
  `store_id` smallint(5) unsigned default NULL,
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `product_id` int(10) unsigned default NULL,
  `product_type` varchar(255) default NULL,
  `product_options` text,
  `weight` decimal(12,4) default '0.0000',
  `is_virtual` tinyint(1) unsigned default NULL,
  `sku` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `description` text,
  `applied_rule_ids` text,
  `additional_data` text,
  `free_shipping` tinyint(1) unsigned NOT NULL default '0',
  `is_qty_decimal` tinyint(1) unsigned default NULL,
  `no_discount` tinyint(1) unsigned default '0',
  `qty_backordered` decimal(12,4) default '0.0000',
  `qty_canceled` decimal(12,4) default '0.0000',
  `qty_invoiced` decimal(12,4) default '0.0000',
  `qty_ordered` decimal(12,4) default '0.0000',
  `qty_refunded` decimal(12,4) default '0.0000',
  `qty_shipped` decimal(12,4) default '0.0000',
  `base_cost` decimal(12,4) default '0.0000',
  `price` decimal(12,4) NOT NULL default '0.0000',
  `base_price` decimal(12,4) NOT NULL default '0.0000',
  `original_price` decimal(12,4) default NULL,
  `base_original_price` decimal(12,4) default NULL,
  `tax_percent` decimal(12,4) default '0.0000',
  `tax_amount` decimal(12,4) default '0.0000',
  `base_tax_amount` decimal(12,4) default '0.0000',
  `tax_invoiced` decimal(12,4) default '0.0000',
  `base_tax_invoiced` decimal(12,4) default '0.0000',
  `discount_percent` decimal(12,4) default '0.0000',
  `discount_amount` decimal(12,4) default '0.0000',
  `base_discount_amount` decimal(12,4) default '0.0000',
  `discount_invoiced` decimal(12,4) default '0.0000',
  `base_discount_invoiced` decimal(12,4) default '0.0000',
  `amount_refunded` decimal(12,4) default '0.0000',
  `base_amount_refunded` decimal(12,4) default '0.0000',
  `row_total` decimal(12,4) NOT NULL default '0.0000',
  `base_row_total` decimal(12,4) NOT NULL default '0.0000',
  `row_invoiced` decimal(12,4) NOT NULL default '0.0000',
  `base_row_invoiced` decimal(12,4) NOT NULL default '0.0000',
  `row_weight` decimal(12,4) default '0.0000',
  `gift_message_id` int(10) default NULL,
  `gift_message_available` int(10) default NULL,
  `base_tax_before_discount` decimal(12,4) default NULL,
  `tax_before_discount` decimal(12,4) default NULL,
  `ext_order_item_id` varchar(255) default NULL,
  `weee_tax_applied` text,
  `weee_tax_applied_amount` decimal(12,4) default NULL,
  `weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `base_weee_tax_applied_amount` decimal(12,4) default NULL,
  `base_weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `weee_tax_disposition` decimal(12,4) default NULL,
  `weee_tax_row_disposition` decimal(12,4) default NULL,
  `base_weee_tax_disposition` decimal(12,4) default NULL,
  `base_weee_tax_row_disposition` decimal(12,4) default NULL,
  `locked_do_invoice` tinyint(1) unsigned default NULL,
  `locked_do_ship` tinyint(1) unsigned default NULL,
  `price_incl_tax` decimal(12,4) default NULL,
  `base_price_incl_tax` decimal(12,4) default NULL,
  `row_total_incl_tax` decimal(12,4) default NULL,
  `base_row_total_incl_tax` decimal(12,4) default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  `hidden_tax_invoiced` decimal(12,4) default NULL,
  `base_hidden_tax_invoiced` decimal(12,4) default NULL,
  `hidden_tax_refunded` decimal(12,4) default NULL,
  `base_hidden_tax_refunded` decimal(12,4) default NULL,
  `is_nominal` int(11) NOT NULL default '0',
  `tax_canceled` decimal(12,4) default NULL,
  `hidden_tax_canceled` decimal(12,4) default NULL,
  `tax_refunded` decimal(12,4) default NULL,
  PRIMARY KEY  (`item_id`),
  KEY `IDX_ORDER` (`order_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_order_item`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_order_payment`
--

CREATE TABLE IF NOT EXISTS `sales_flat_order_payment` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `base_shipping_captured` decimal(12,4) default NULL,
  `shipping_captured` decimal(12,4) default NULL,
  `amount_refunded` decimal(12,4) default NULL,
  `base_amount_paid` decimal(12,4) default NULL,
  `amount_canceled` decimal(12,4) default NULL,
  `base_amount_authorized` decimal(12,4) default NULL,
  `base_amount_paid_online` decimal(12,4) default NULL,
  `base_amount_refunded_online` decimal(12,4) default NULL,
  `base_shipping_amount` decimal(12,4) default NULL,
  `shipping_amount` decimal(12,4) default NULL,
  `amount_paid` decimal(12,4) default NULL,
  `amount_authorized` decimal(12,4) default NULL,
  `base_amount_ordered` decimal(12,4) default NULL,
  `base_shipping_refunded` decimal(12,4) default NULL,
  `shipping_refunded` decimal(12,4) default NULL,
  `base_amount_refunded` decimal(12,4) default NULL,
  `amount_ordered` decimal(12,4) default NULL,
  `base_amount_canceled` decimal(12,4) default NULL,
  `ideal_transaction_checked` tinyint(1) unsigned default NULL,
  `quote_payment_id` int(10) default NULL,
  `additional_data` text,
  `cc_exp_month` varchar(255) default NULL,
  `cc_ss_start_year` varchar(255) default NULL,
  `echeck_bank_name` varchar(255) default NULL,
  `method` varchar(255) default NULL,
  `cc_debug_request_body` varchar(255) default NULL,
  `cc_secure_verify` varchar(255) default NULL,
  `cybersource_token` varchar(255) default NULL,
  `ideal_issuer_title` varchar(255) default NULL,
  `protection_eligibility` varchar(255) default NULL,
  `cc_approval` varchar(255) default NULL,
  `cc_last4` varchar(255) default NULL,
  `cc_status_description` varchar(255) default NULL,
  `echeck_type` varchar(255) default NULL,
  `paybox_question_number` varchar(255) default NULL,
  `cc_debug_response_serialized` varchar(255) default NULL,
  `cc_ss_start_month` varchar(255) default NULL,
  `echeck_account_type` varchar(255) default NULL,
  `last_trans_id` varchar(255) default NULL,
  `cc_cid_status` varchar(255) default NULL,
  `cc_owner` varchar(255) default NULL,
  `cc_type` varchar(255) default NULL,
  `ideal_issuer_id` varchar(255) default NULL,
  `po_number` varchar(255) default NULL,
  `cc_exp_year` varchar(255) default NULL,
  `cc_status` varchar(255) default NULL,
  `echeck_routing_number` varchar(255) default NULL,
  `account_status` varchar(255) default NULL,
  `anet_trans_method` varchar(255) default NULL,
  `cc_debug_response_body` varchar(255) default NULL,
  `cc_ss_issue` varchar(255) default NULL,
  `echeck_account_name` varchar(255) default NULL,
  `cc_avs_status` varchar(255) default NULL,
  `cc_number_enc` varchar(255) default NULL,
  `cc_trans_id` varchar(255) default NULL,
  `flo2cash_account_id` varchar(255) default NULL,
  `paybox_request_number` varchar(255) default NULL,
  `address_status` varchar(255) default NULL,
  `additional_information` text,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_order_payment`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_order_status_history`
--

CREATE TABLE IF NOT EXISTS `sales_flat_order_status_history` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `is_customer_notified` int(10) default NULL,
  `is_visible_on_front` tinyint(1) unsigned NOT NULL default '0',
  `comment` text,
  `status` varchar(32) default NULL,
  `created_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`),
  KEY `IDX_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_order_status_history`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned NOT NULL default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `converted_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `is_active` tinyint(1) unsigned default '1',
  `is_virtual` tinyint(1) unsigned default '0',
  `is_multi_shipping` tinyint(1) unsigned default '0',
  `items_count` int(10) unsigned default '0',
  `items_qty` decimal(12,4) default '0.0000',
  `orig_order_id` int(10) unsigned default '0',
  `store_to_base_rate` decimal(12,4) default '0.0000',
  `store_to_quote_rate` decimal(12,4) default '0.0000',
  `base_currency_code` varchar(255) default NULL,
  `store_currency_code` varchar(255) default NULL,
  `quote_currency_code` varchar(255) default NULL,
  `grand_total` decimal(12,4) default '0.0000',
  `base_grand_total` decimal(12,4) default '0.0000',
  `checkout_method` varchar(255) default NULL,
  `customer_id` int(10) unsigned default '0',
  `customer_tax_class_id` int(10) unsigned default '0',
  `customer_group_id` int(10) unsigned default '0',
  `customer_email` varchar(255) default NULL,
  `customer_prefix` varchar(40) default NULL,
  `customer_firstname` varchar(255) default NULL,
  `customer_middlename` varchar(40) default NULL,
  `customer_lastname` varchar(255) default NULL,
  `customer_suffix` varchar(40) default NULL,
  `customer_dob` datetime default NULL,
  `customer_note` varchar(255) default NULL,
  `customer_note_notify` tinyint(1) unsigned default '1',
  `customer_is_guest` tinyint(1) unsigned default '0',
  `remote_ip` varchar(32) default NULL,
  `applied_rule_ids` varchar(255) default NULL,
  `reserved_order_id` varchar(64) default '',
  `password_hash` varchar(255) default NULL,
  `coupon_code` varchar(255) default NULL,
  `global_currency_code` varchar(255) default NULL,
  `base_to_global_rate` decimal(12,4) default NULL,
  `base_to_quote_rate` decimal(12,4) default NULL,
  `customer_taxvat` varchar(255) default NULL,
  `customer_gender` varchar(255) default NULL,
  `subtotal` decimal(12,4) default NULL,
  `base_subtotal` decimal(12,4) default NULL,
  `subtotal_with_discount` decimal(12,4) default NULL,
  `base_subtotal_with_discount` decimal(12,4) default NULL,
  `is_changed` int(10) unsigned default NULL,
  `trigger_recollect` tinyint(1) NOT NULL default '0',
  `ext_shipping_info` text,
  `gift_message_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_CUSTOMER` (`customer_id`,`store_id`,`is_active`),
  KEY `FK_SALES_QUOTE_STORE` (`store_id`),
  KEY `IDX_IS_ACTIVE` (`is_active`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote`
--

INSERT INTO `sales_flat_quote` (`entity_id`, `store_id`, `created_at`, `updated_at`, `converted_at`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`, `items_qty`, `orig_order_id`, `store_to_base_rate`, `store_to_quote_rate`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `grand_total`, `base_grand_total`, `checkout_method`, `customer_id`, `customer_tax_class_id`, `customer_group_id`, `customer_email`, `customer_prefix`, `customer_firstname`, `customer_middlename`, `customer_lastname`, `customer_suffix`, `customer_dob`, `customer_note`, `customer_note_notify`, `customer_is_guest`, `remote_ip`, `applied_rule_ids`, `reserved_order_id`, `password_hash`, `coupon_code`, `global_currency_code`, `base_to_global_rate`, `base_to_quote_rate`, `customer_taxvat`, `customer_gender`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `is_changed`, `trigger_recollect`, `ext_shipping_info`, `gift_message_id`) VALUES
(1, 1, '2011-04-15 07:21:24', '2011-04-15 07:56:58', '0000-00-00 00:00:00', 1, 0, 0, 0, 0.0000, 0, 1.0000, 1.0000, 'USD', 'USD', 'USD', 0.0000, 0.0000, '', 1, 3, 1, 'admin@admin.com', NULL, 'admin', NULL, 'admin', NULL, NULL, NULL, 1, 0, '127.0.0.1', '', '', NULL, NULL, 'USD', 1.0000, 1.0000, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, NULL, NULL),
(2, 1, '2011-04-18 09:01:18', '2011-04-18 09:01:42', '0000-00-00 00:00:00', 1, 0, 0, 1, 1.0000, 0, 1.0000, 1.0000, 'USD', 'USD', 'USD', 91.2300, 91.2300, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '127.0.0.1', '', '', NULL, NULL, 'USD', 1.0000, 1.0000, NULL, NULL, 91.2300, 91.2300, 91.2300, 91.2300, 1, 0, NULL, NULL),
(3, 1, '2011-11-14 17:40:30', '2011-11-14 18:03:51', '0000-00-00 00:00:00', 1, 0, 1, 1, 1.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 0.0000, 0.0000, '', 2, 3, 1, 'gal.miklos@summerhigh.hu', NULL, 'Miklós', NULL, 'Gál', NULL, NULL, NULL, 1, 0, '89.133.40.207', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 1, 0, NULL, NULL),
(4, 1, '2014-05-01 12:44:20', '2014-05-01 12:50:49', '0000-00-00 00:00:00', 1, 0, 0, 1, 2.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 251.7800, 251.7800, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '75.67.199.85', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 251.7800, 251.7800, 251.7800, 251.7800, 1, 0, NULL, NULL),
(5, 1, '2014-08-11 22:34:17', '2014-08-11 22:34:49', '0000-00-00 00:00:00', 1, 0, 0, 1, 5.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 629.4500, 629.4500, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '76.31.138.64', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 629.4500, 629.4500, 629.4500, 629.4500, 1, 0, NULL, NULL),
(6, 1, '2014-10-18 11:49:06', '2014-10-18 11:49:11', '0000-00-00 00:00:00', 1, 0, 0, 1, 1.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 125.8900, 125.8900, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '5.63.146.148', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 125.8900, 125.8900, 125.8900, 125.8900, 1, 0, NULL, NULL),
(7, 1, '2014-12-29 20:07:43', '2014-12-29 20:07:44', '0000-00-00 00:00:00', 1, 0, 0, 1, 1.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 79.6200, 79.6200, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '65.175.135.40', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 79.6200, 79.6200, 79.6200, 79.6200, 1, 0, NULL, NULL),
(8, 1, '2015-02-25 18:54:37', '2015-02-25 18:54:38', '0000-00-00 00:00:00', 1, 0, 0, 1, 1.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 125.8900, 125.8900, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '67.84.169.143', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 125.8900, 125.8900, 125.8900, 125.8900, 1, 0, NULL, NULL),
(9, 1, '2015-04-06 22:07:13', '2015-04-06 22:36:27', '0000-00-00 00:00:00', 1, 0, 0, 1, 1.0000, 0, 1.0000, 1.0000, 'HUF', 'HUF', 'HUF', 79.6200, 79.6200, '', NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '74.108.136.254', '', '', NULL, NULL, 'HUF', 1.0000, 1.0000, NULL, NULL, 79.6200, 79.6200, 79.6200, 79.6200, 1, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote_address`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_address` (
  `address_id` int(10) unsigned NOT NULL auto_increment,
  `quote_id` int(10) unsigned NOT NULL default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `customer_id` int(10) unsigned default NULL,
  `save_in_address_book` tinyint(1) default '0',
  `customer_address_id` int(10) unsigned default NULL,
  `address_type` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `prefix` varchar(40) default NULL,
  `firstname` varchar(255) default NULL,
  `middlename` varchar(40) default NULL,
  `lastname` varchar(255) default NULL,
  `suffix` varchar(40) default NULL,
  `company` varchar(255) default NULL,
  `street` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `region` varchar(255) default NULL,
  `region_id` int(10) unsigned default NULL,
  `postcode` varchar(255) default NULL,
  `country_id` varchar(255) default NULL,
  `telephone` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  `same_as_billing` tinyint(1) unsigned NOT NULL default '0',
  `free_shipping` tinyint(1) unsigned NOT NULL default '0',
  `collect_shipping_rates` tinyint(1) unsigned NOT NULL default '0',
  `shipping_method` varchar(255) NOT NULL default '',
  `shipping_description` varchar(255) NOT NULL default '',
  `weight` decimal(12,4) NOT NULL default '0.0000',
  `subtotal` decimal(12,4) NOT NULL default '0.0000',
  `base_subtotal` decimal(12,4) NOT NULL default '0.0000',
  `subtotal_with_discount` decimal(12,4) NOT NULL default '0.0000',
  `base_subtotal_with_discount` decimal(12,4) NOT NULL default '0.0000',
  `tax_amount` decimal(12,4) NOT NULL default '0.0000',
  `base_tax_amount` decimal(12,4) NOT NULL default '0.0000',
  `shipping_amount` decimal(12,4) NOT NULL default '0.0000',
  `base_shipping_amount` decimal(12,4) NOT NULL default '0.0000',
  `shipping_tax_amount` decimal(12,4) default NULL,
  `base_shipping_tax_amount` decimal(12,4) default NULL,
  `discount_amount` decimal(12,4) NOT NULL default '0.0000',
  `base_discount_amount` decimal(12,4) NOT NULL default '0.0000',
  `grand_total` decimal(12,4) NOT NULL default '0.0000',
  `base_grand_total` decimal(12,4) NOT NULL default '0.0000',
  `customer_notes` text,
  `applied_taxes` text,
  `discount_description` varchar(255) default NULL,
  `shipping_discount_amount` decimal(12,4) default NULL,
  `base_shipping_discount_amount` decimal(12,4) default NULL,
  `subtotal_incl_tax` decimal(12,4) default NULL,
  `base_subtotal_total_incl_tax` decimal(12,4) default NULL,
  `gift_message_id` int(10) unsigned default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `base_shipping_hidden_tax_amount` decimal(12,4) default NULL,
  `shipping_incl_tax` decimal(12,4) default NULL,
  `base_shipping_incl_tax` decimal(12,4) default NULL,
  PRIMARY KEY  (`address_id`),
  KEY `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` (`quote_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote_address`
--

INSERT INTO `sales_flat_quote_address` (`address_id`, `quote_id`, `created_at`, `updated_at`, `customer_id`, `save_in_address_book`, `customer_address_id`, `address_type`, `email`, `prefix`, `firstname`, `middlename`, `lastname`, `suffix`, `company`, `street`, `city`, `region`, `region_id`, `postcode`, `country_id`, `telephone`, `fax`, `same_as_billing`, `free_shipping`, `collect_shipping_rates`, `shipping_method`, `shipping_description`, `weight`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `tax_amount`, `base_tax_amount`, `shipping_amount`, `base_shipping_amount`, `shipping_tax_amount`, `base_shipping_tax_amount`, `discount_amount`, `base_discount_amount`, `grand_total`, `base_grand_total`, `customer_notes`, `applied_taxes`, `discount_description`, `shipping_discount_amount`, `base_shipping_discount_amount`, `subtotal_incl_tax`, `base_subtotal_total_incl_tax`, `gift_message_id`, `hidden_tax_amount`, `base_hidden_tax_amount`, `shipping_hidden_tax_amount`, `base_shipping_hidden_tax_amount`, `shipping_incl_tax`, `base_shipping_incl_tax`) VALUES
(3, 1, '2011-04-15 07:42:23', '2011-04-15 07:56:58', 1, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(4, 1, '2011-04-15 07:42:23', '2011-04-15 07:56:58', 1, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', '', 0.0000, 0.0000, 0.0000, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(7, 2, '2011-04-18 09:01:21', '2011-04-18 09:01:42', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(8, 2, '2011-04-18 09:01:21', '2011-04-18 09:01:42', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 3.2000, 91.2300, 91.2300, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 91.2300, 91.2300, NULL, 'a:0:{}', '', 0.0000, 0.0000, 91.2300, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(11, 4, '2014-05-01 12:44:21', '2014-05-01 12:50:49', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(12, 4, '2014-05-01 12:44:21', '2014-05-01 12:50:49', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 3.0000, 251.7800, 251.7800, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 251.7800, 251.7800, NULL, 'a:0:{}', '', 0.0000, 0.0000, 251.7800, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(15, 5, '2014-08-11 22:34:18', '2014-08-11 22:34:49', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(16, 5, '2014-08-11 22:34:18', '2014-08-11 22:34:49', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 7.5000, 629.4500, 629.4500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 629.4500, 629.4500, NULL, 'a:0:{}', '', 0.0000, 0.0000, 629.4500, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(19, 6, '2014-10-18 11:49:07', '2014-10-18 11:49:11', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(20, 6, '2014-10-18 11:49:07', '2014-10-18 11:49:11', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 1.5000, 125.8900, 125.8900, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 125.8900, 125.8900, NULL, 'a:0:{}', '', 0.0000, 0.0000, 125.8900, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(23, 7, '2014-12-29 20:07:44', '2014-12-29 20:07:44', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(24, 7, '2014-12-29 20:07:44', '2014-12-29 20:07:44', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 1.9000, 79.6200, 79.6200, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 79.6200, 79.6200, NULL, 'a:0:{}', '', 0.0000, 0.0000, 79.6200, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(27, 8, '2015-02-25 18:54:38', '2015-02-25 18:54:38', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(28, 8, '2015-02-25 18:54:38', '2015-02-25 18:54:38', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 1.5000, 125.8900, 125.8900, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 125.8900, 125.8900, NULL, 'a:0:{}', '', 0.0000, 0.0000, 125.8900, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000),
(31, 9, '2015-04-06 22:07:14', '2015-04-06 22:36:27', NULL, 0, NULL, 'billing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 'a:0:{}', NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, 0.0000),
(32, 9, '2015-04-06 22:07:14', '2015-04-06 22:36:27', NULL, 0, NULL, 'shipping', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 1.9000, 79.6200, 79.6200, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 79.6200, 79.6200, NULL, 'a:0:{}', '', 0.0000, 0.0000, 79.6200, NULL, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote_address_item`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_address_item` (
  `address_item_id` int(10) unsigned NOT NULL auto_increment,
  `parent_item_id` int(10) unsigned default NULL,
  `quote_address_id` int(10) unsigned NOT NULL default '0',
  `quote_item_id` int(10) unsigned NOT NULL default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `applied_rule_ids` text,
  `additional_data` text,
  `weight` decimal(12,4) default '0.0000',
  `qty` decimal(12,4) NOT NULL default '0.0000',
  `discount_amount` decimal(12,4) default '0.0000',
  `tax_amount` decimal(12,4) default '0.0000',
  `row_total` decimal(12,4) NOT NULL default '0.0000',
  `base_row_total` decimal(12,4) NOT NULL default '0.0000',
  `row_total_with_discount` decimal(12,4) default '0.0000',
  `base_discount_amount` decimal(12,4) default '0.0000',
  `base_tax_amount` decimal(12,4) default '0.0000',
  `row_weight` decimal(12,4) default '0.0000',
  `product_id` int(10) unsigned default NULL,
  `super_product_id` int(10) unsigned default NULL,
  `parent_product_id` int(10) unsigned default NULL,
  `sku` varchar(255) default NULL,
  `image` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `description` text,
  `free_shipping` int(10) unsigned default NULL,
  `is_qty_decimal` int(10) unsigned default NULL,
  `price` decimal(12,4) default NULL,
  `discount_percent` decimal(12,4) default NULL,
  `no_discount` int(10) unsigned default NULL,
  `tax_percent` decimal(12,4) default NULL,
  `base_price` decimal(12,4) default NULL,
  `base_cost` decimal(12,4) default NULL,
  `price_incl_tax` decimal(12,4) default NULL,
  `base_price_incl_tax` decimal(12,4) default NULL,
  `row_total_incl_tax` decimal(12,4) default NULL,
  `base_row_total_incl_tax` decimal(12,4) default NULL,
  `gift_message_id` int(10) unsigned default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  PRIMARY KEY  (`address_item_id`),
  KEY `FK_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS` (`quote_address_id`),
  KEY `FK_SALES_FLAT_QUOTE_ADDRESS_ITEM_PARENT` (`parent_item_id`),
  KEY `FK_SALES_QUOTE_ADDRESS_ITEM_QUOTE_ITEM` (`quote_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote_address_item`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote_item`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_item` (
  `item_id` int(10) unsigned NOT NULL auto_increment,
  `quote_id` int(10) unsigned NOT NULL default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `product_id` int(10) unsigned default NULL,
  `store_id` smallint(5) unsigned default NULL,
  `parent_item_id` int(10) unsigned default NULL,
  `is_virtual` tinyint(1) unsigned default NULL,
  `sku` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `description` text,
  `applied_rule_ids` text,
  `additional_data` text,
  `free_shipping` tinyint(1) unsigned NOT NULL default '0',
  `is_qty_decimal` tinyint(1) unsigned default NULL,
  `no_discount` tinyint(1) unsigned default '0',
  `weight` decimal(12,4) default '0.0000',
  `qty` decimal(12,4) NOT NULL default '0.0000',
  `price` decimal(12,4) NOT NULL default '0.0000',
  `base_price` decimal(12,4) NOT NULL default '0.0000',
  `custom_price` decimal(12,4) default NULL,
  `discount_percent` decimal(12,4) default '0.0000',
  `discount_amount` decimal(12,4) default '0.0000',
  `base_discount_amount` decimal(12,4) default '0.0000',
  `tax_percent` decimal(12,4) default '0.0000',
  `tax_amount` decimal(12,4) default '0.0000',
  `base_tax_amount` decimal(12,4) default '0.0000',
  `row_total` decimal(12,4) NOT NULL default '0.0000',
  `base_row_total` decimal(12,4) NOT NULL default '0.0000',
  `row_total_with_discount` decimal(12,4) default '0.0000',
  `row_weight` decimal(12,4) default '0.0000',
  `product_type` varchar(255) default NULL,
  `base_tax_before_discount` decimal(12,4) default NULL,
  `tax_before_discount` decimal(12,4) default NULL,
  `original_custom_price` decimal(12,4) default NULL,
  `redirect_url` varchar(255) default NULL,
  `base_cost` decimal(12,4) default NULL,
  `price_incl_tax` decimal(12,4) default NULL,
  `base_price_incl_tax` decimal(12,4) default NULL,
  `row_total_incl_tax` decimal(12,4) default NULL,
  `base_row_total_incl_tax` decimal(12,4) default NULL,
  `gift_message_id` int(10) unsigned default NULL,
  `weee_tax_applied` text,
  `weee_tax_applied_amount` decimal(12,4) default NULL,
  `weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `base_weee_tax_applied_amount` decimal(12,4) default NULL,
  `base_weee_tax_applied_row_amount` decimal(12,4) default NULL,
  `weee_tax_disposition` decimal(12,4) default NULL,
  `weee_tax_row_disposition` decimal(12,4) default NULL,
  `base_weee_tax_disposition` decimal(12,4) default NULL,
  `base_weee_tax_row_disposition` decimal(12,4) default NULL,
  `hidden_tax_amount` decimal(12,4) default NULL,
  `base_hidden_tax_amount` decimal(12,4) default NULL,
  PRIMARY KEY  (`item_id`),
  KEY `FK_SALES_FLAT_QUOTE_ITEM_PARENT_ITEM` (`parent_item_id`),
  KEY `FK_SALES_QUOTE_ITEM_CATALOG_PRODUCT_ENTITY` (`product_id`),
  KEY `FK_SALES_QUOTE_ITEM_SALES_QUOTE` (`quote_id`),
  KEY `FK_SALES_QUOTE_ITEM_STORE` (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote_item`
--

INSERT INTO `sales_flat_quote_item` (`item_id`, `quote_id`, `created_at`, `updated_at`, `product_id`, `store_id`, `parent_item_id`, `is_virtual`, `sku`, `name`, `description`, `applied_rule_ids`, `additional_data`, `free_shipping`, `is_qty_decimal`, `no_discount`, `weight`, `qty`, `price`, `base_price`, `custom_price`, `discount_percent`, `discount_amount`, `base_discount_amount`, `tax_percent`, `tax_amount`, `base_tax_amount`, `row_total`, `base_row_total`, `row_total_with_discount`, `row_weight`, `product_type`, `base_tax_before_discount`, `tax_before_discount`, `original_custom_price`, `redirect_url`, `base_cost`, `price_incl_tax`, `base_price_incl_tax`, `row_total_incl_tax`, `base_row_total_incl_tax`, `gift_message_id`, `weee_tax_applied`, `weee_tax_applied_amount`, `weee_tax_applied_row_amount`, `base_weee_tax_applied_amount`, `base_weee_tax_applied_row_amount`, `weee_tax_disposition`, `weee_tax_row_disposition`, `base_weee_tax_disposition`, `base_weee_tax_row_disposition`, `hidden_tax_amount`, `base_hidden_tax_amount`) VALUES
(1, 2, '2011-04-18 09:01:18', '2011-04-18 09:01:18', 7, 1, NULL, 0, 'Berber Carpet', 'Berber Carpet', NULL, '', NULL, 0, 0, 0, 3.2000, 1.0000, 91.2300, 91.2300, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 91.2300, 91.2300, 0.0000, 3.2000, 'simple', NULL, NULL, NULL, NULL, NULL, 91.2300, 91.2300, 91.2300, 91.2300, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(2, 3, '2011-11-14 18:03:36', '2011-11-14 18:03:36', 38, 1, NULL, 0, 'Polyflor Crema Slate Tile Camaro', 'Polyflor Crema Slate Tile Camaro', NULL, '', NULL, 0, 0, 0, 3.2000, 1.0000, 85.8600, 85.8600, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 85.8600, 85.8600, 0.0000, 3.2000, 'simple', NULL, NULL, NULL, NULL, NULL, 85.8600, 85.8600, 85.8600, 85.8600, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(3, 4, '2014-05-01 12:44:20', '2014-05-01 12:44:20', 55, 1, NULL, 0, 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', NULL, '', NULL, 0, 0, 0, 1.5000, 2.0000, 125.8900, 125.8900, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 251.7800, 251.7800, 0.0000, 3.0000, 'simple', NULL, NULL, NULL, NULL, NULL, 125.8900, 125.8900, 251.7800, 251.7800, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(4, 5, '2014-08-11 22:34:17', '2014-08-11 22:34:41', 55, 1, NULL, 0, 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', NULL, '', NULL, 0, 0, 0, 1.5000, 5.0000, 125.8900, 125.8900, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 629.4500, 629.4500, 0.0000, 7.5000, 'simple', NULL, NULL, NULL, NULL, NULL, 125.8900, 125.8900, 629.4500, 629.4500, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(5, 6, '2014-10-18 11:49:06', '2014-10-18 11:49:06', 55, 1, NULL, 0, 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', NULL, '', NULL, 0, 0, 0, 1.5000, 1.0000, 125.8900, 125.8900, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 125.8900, 125.8900, 0.0000, 1.5000, 'simple', NULL, NULL, NULL, NULL, NULL, 125.8900, 125.8900, 125.8900, 125.8900, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(6, 7, '2014-12-29 20:07:43', '2014-12-29 20:07:43', 35, 1, NULL, 0, 'Kraus Rustic Maple Laminate', 'Kraus Rustic Maple Laminate', NULL, '', NULL, 0, 0, 0, 1.9000, 1.0000, 79.6200, 79.6200, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 79.6200, 79.6200, 0.0000, 1.9000, 'simple', NULL, NULL, NULL, NULL, NULL, 79.6200, 79.6200, 79.6200, 79.6200, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(7, 8, '2015-02-25 18:54:37', '2015-02-25 18:54:37', 55, 1, NULL, 0, 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', 'Heritage Heights Collection by Bruce L0005 Teak/Komi Teak', NULL, '', NULL, 0, 0, 0, 1.5000, 1.0000, 125.8900, 125.8900, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 125.8900, 125.8900, 0.0000, 1.5000, 'simple', NULL, NULL, NULL, NULL, NULL, 125.8900, 125.8900, 125.8900, 125.8900, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL),
(8, 9, '2015-04-06 22:07:13', '2015-04-06 22:07:13', 35, 1, NULL, 0, 'Kraus Rustic Maple Laminate', 'Kraus Rustic Maple Laminate', NULL, '', NULL, 0, 0, 0, 1.9000, 1.0000, 79.6200, 79.6200, NULL, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 79.6200, 79.6200, 0.0000, 1.9000, 'simple', NULL, NULL, NULL, NULL, NULL, 79.6200, 79.6200, 79.6200, 79.6200, NULL, 'a:0:{}', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote_item_option`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_item_option` (
  `option_id` int(10) unsigned NOT NULL auto_increment,
  `item_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `code` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`option_id`),
  KEY `FK_SALES_QUOTE_ITEM_OPTION_ITEM_ID` (`item_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Additional options for quote item' AUTO_INCREMENT=11 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote_item_option`
--

INSERT INTO `sales_flat_quote_item_option` (`option_id`, `item_id`, `product_id`, `code`, `value`) VALUES
(1, 1, 7, 'info_buyRequest', 'a:5:{s:4:"uenc";s:124:"aHR0cDovLzEyNy4wLjAuMS9NQUdFTlRPLzE1MDEvbWFnZW50b190aDIxMC9pbmRleC5waHAvZC1hcnBldC90dWZ0ZWQtbnlsb24vYmVyYmVyLWNhcnBldC5odG1s";s:7:"product";s:1:"7";s:15:"related_product";s:0:"";s:7:"options";a:1:{i:4;s:2:"27";}s:3:"qty";s:1:"1";}'),
(2, 1, 7, 'option_ids', '4'),
(3, 1, 7, 'option_4', '27'),
(4, 2, 38, 'info_buyRequest', 'a:3:{s:4:"uenc";s:68:"aHR0cDovL3d3dy5wYXJrZXR0YXBsYXphLmh1L3BvcmNlbGFpbi1jZXJhbWljLmh0bWw,";s:7:"product";s:2:"38";s:3:"qty";i:1;}'),
(5, 3, 55, 'info_buyRequest', 'a:5:{s:2:"id";s:1:"3";s:7:"product";s:2:"55";s:15:"related_product";s:0:"";s:3:"qty";s:1:"2";s:7:"options";a:0:{}}'),
(6, 4, 55, 'info_buyRequest', 'a:4:{s:4:"uenc";s:120:"aHR0cDovL3d3dy5wYXJrZXR0YXBsYXphLmh1L2hlcml0YWdlLWhlaWdodHMtY29sbGVjdGlvbi1ieS1icnVjZS1sMDAwNS10ZWFrLWtvbWktdGVhay5odG1s";s:7:"product";s:2:"55";s:15:"related_product";s:0:"";s:3:"qty";s:1:"9";}'),
(7, 5, 55, 'info_buyRequest', 'a:3:{s:4:"uenc";s:40:"aHR0cDovL3d3dy5wYXJrZXR0YXBsYXphLmh1Lw,,";s:7:"product";s:2:"55";s:3:"qty";i:1;}'),
(8, 6, 35, 'info_buyRequest', 'a:4:{s:4:"uenc";s:92:"aHR0cDovL3d3dy5wYXJrZXR0YXBsYXphLmh1L2xhbWluYXRlL2tyYXVzLXJ1c3RpYy1tYXBsZS1sYW1pbmF0ZS5odG1s";s:7:"product";s:2:"35";s:15:"related_product";s:0:"";s:3:"qty";s:1:"1";}'),
(9, 7, 55, 'info_buyRequest', 'a:4:{s:4:"uenc";s:120:"aHR0cDovL3d3dy5wYXJrZXR0YXBsYXphLmh1L2hlcml0YWdlLWhlaWdodHMtY29sbGVjdGlvbi1ieS1icnVjZS1sMDAwNS10ZWFrLWtvbWktdGVhay5odG1s";s:7:"product";s:2:"55";s:15:"related_product";s:0:"";s:3:"qty";s:1:"1";}'),
(10, 8, 35, 'info_buyRequest', 'a:4:{s:4:"uenc";s:92:"aHR0cDovL3d3dy5wYXJrZXR0YXBsYXphLmh1L2xhbWluYXRlL2tyYXVzLXJ1c3RpYy1tYXBsZS1sYW1pbmF0ZS5odG1s";s:7:"product";s:2:"35";s:15:"related_product";s:0:"";s:3:"qty";s:1:"1";}');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote_payment`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_payment` (
  `payment_id` int(10) unsigned NOT NULL auto_increment,
  `quote_id` int(10) unsigned NOT NULL default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `method` varchar(255) default '',
  `cc_type` varchar(255) default '',
  `cc_number_enc` varchar(255) default '',
  `cc_last4` varchar(255) default '',
  `cc_cid_enc` varchar(255) default '',
  `cc_owner` varchar(255) default '',
  `cc_exp_month` tinyint(2) unsigned default '0',
  `cc_exp_year` smallint(4) unsigned default '0',
  `cc_ss_owner` varchar(255) default '',
  `cc_ss_start_month` tinyint(2) unsigned default '0',
  `cc_ss_start_year` smallint(4) unsigned default '0',
  `cybersource_token` varchar(255) default '',
  `paypal_correlation_id` varchar(255) default '',
  `paypal_payer_id` varchar(255) default '',
  `paypal_payer_status` varchar(255) default '',
  `po_number` varchar(255) default '',
  `additional_data` text,
  `cc_ss_issue` varchar(255) default NULL,
  `additional_information` text,
  `ideal_issuer_id` varchar(255) default NULL,
  `ideal_issuer_list` text,
  PRIMARY KEY  (`payment_id`),
  KEY `FK_SALES_QUOTE_PAYMENT_SALES_QUOTE` (`quote_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote_payment`
--

INSERT INTO `sales_flat_quote_payment` (`payment_id`, `quote_id`, `created_at`, `updated_at`, `method`, `cc_type`, `cc_number_enc`, `cc_last4`, `cc_cid_enc`, `cc_owner`, `cc_exp_month`, `cc_exp_year`, `cc_ss_owner`, `cc_ss_start_month`, `cc_ss_start_year`, `cybersource_token`, `paypal_correlation_id`, `paypal_payer_id`, `paypal_payer_status`, `po_number`, `additional_data`, `cc_ss_issue`, `additional_information`, `ideal_issuer_id`, `ideal_issuer_list`) VALUES
(1, 2, '2011-04-18 09:01:42', '2011-04-18 09:01:42', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL),
(2, 9, '2015-04-06 22:07:39', '2015-04-06 22:36:17', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_quote_shipping_rate`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_shipping_rate` (
  `rate_id` int(10) unsigned NOT NULL auto_increment,
  `address_id` int(10) unsigned NOT NULL default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `carrier` varchar(255) default NULL,
  `carrier_title` varchar(255) default NULL,
  `code` varchar(255) default NULL,
  `method` varchar(255) default NULL,
  `method_description` text,
  `price` decimal(12,4) NOT NULL default '0.0000',
  `error_message` text,
  `method_title` text,
  PRIMARY KEY  (`rate_id`),
  KEY `FK_SALES_QUOTE_SHIPPING_RATE_ADDRESS` (`address_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_quote_shipping_rate`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_shipment`
--

CREATE TABLE IF NOT EXISTS `sales_flat_shipment` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned default NULL,
  `total_weight` decimal(12,4) default NULL,
  `total_qty` decimal(12,4) default NULL,
  `email_sent` tinyint(1) unsigned default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) default NULL,
  `shipping_address_id` int(10) default NULL,
  `billing_address_id` int(10) default NULL,
  `shipment_status` int(10) default NULL,
  `increment_id` varchar(50) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_TOTAL_QTY` (`total_qty`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_shipment`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_shipment_comment`
--

CREATE TABLE IF NOT EXISTS `sales_flat_shipment_comment` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `is_customer_notified` int(10) default NULL,
  `is_visible_on_front` tinyint(1) unsigned NOT NULL default '0',
  `comment` text,
  `created_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_shipment_comment`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_shipment_grid`
--

CREATE TABLE IF NOT EXISTS `sales_flat_shipment_grid` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned default NULL,
  `total_qty` decimal(12,4) default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `shipment_status` int(10) default NULL,
  `increment_id` varchar(50) default NULL,
  `order_increment_id` varchar(50) default NULL,
  `created_at` datetime default NULL,
  `order_created_at` datetime default NULL,
  `shipping_name` varchar(255) default NULL,
  PRIMARY KEY  (`entity_id`),
  UNIQUE KEY `UNQ_INCREMENT_ID` (`increment_id`),
  KEY `IDX_STORE_ID` (`store_id`),
  KEY `IDX_TOTAL_QTY` (`total_qty`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_SHIPMENT_STATUS` (`shipment_status`),
  KEY `IDX_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `IDX_CREATED_AT` (`created_at`),
  KEY `IDX_ORDER_CREATED_AT` (`order_created_at`),
  KEY `IDX_SHIPPING_NAME` (`shipping_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_shipment_grid`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_shipment_item`
--

CREATE TABLE IF NOT EXISTS `sales_flat_shipment_item` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `row_total` decimal(12,4) default NULL,
  `price` decimal(12,4) default NULL,
  `weight` decimal(12,4) default NULL,
  `qty` decimal(12,4) default NULL,
  `product_id` int(10) default NULL,
  `order_item_id` int(10) default NULL,
  `additional_data` text,
  `description` text,
  `name` varchar(255) default NULL,
  `sku` varchar(255) default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_shipment_item`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_flat_shipment_track`
--

CREATE TABLE IF NOT EXISTS `sales_flat_shipment_track` (
  `entity_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL,
  `weight` decimal(12,4) default NULL,
  `qty` decimal(12,4) default NULL,
  `order_id` int(10) unsigned NOT NULL,
  `number` text,
  `description` text,
  `title` varchar(255) default NULL,
  `carrier_code` varchar(32) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`entity_id`),
  KEY `IDX_PARENT_ID` (`parent_id`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_flat_shipment_track`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_invoiced_aggregated`
--

CREATE TABLE IF NOT EXISTS `sales_invoiced_aggregated` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `orders_invoiced` decimal(12,4) NOT NULL default '0.0000',
  `invoiced` decimal(12,4) NOT NULL default '0.0000',
  `invoiced_captured` decimal(12,4) NOT NULL default '0.0000',
  `invoiced_not_captured` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_invoiced_aggregated`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_invoiced_aggregated_order`
--

CREATE TABLE IF NOT EXISTS `sales_invoiced_aggregated_order` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `orders_invoiced` decimal(12,4) NOT NULL default '0.0000',
  `invoiced` decimal(12,4) NOT NULL default '0.0000',
  `invoiced_captured` decimal(12,4) NOT NULL default '0.0000',
  `invoiced_not_captured` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_invoiced_aggregated_order`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_order_aggregated_created`
--

CREATE TABLE IF NOT EXISTS `sales_order_aggregated_created` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000',
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000',
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000',
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000',
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000',
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_order_aggregated_created`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_order_status`
--

CREATE TABLE IF NOT EXISTS `sales_order_status` (
  `status` varchar(32) NOT NULL,
  `label` varchar(128) NOT NULL,
  PRIMARY KEY  (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `sales_order_status`
--

INSERT INTO `sales_order_status` (`status`, `label`) VALUES
('canceled', 'Canceled'),
('closed', 'Closed'),
('complete', 'Complete'),
('fraud', 'Suspected Fraud'),
('holded', 'On Hold'),
('payment_review', 'Payment Review'),
('pending', 'Pending'),
('pending_payment', 'Pending Payment'),
('pending_paypal', 'Pending PayPal'),
('processing', 'Processing');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_order_status_label`
--

CREATE TABLE IF NOT EXISTS `sales_order_status_label` (
  `status` varchar(32) NOT NULL,
  `store_id` smallint(5) unsigned NOT NULL,
  `label` varchar(128) NOT NULL,
  PRIMARY KEY  (`status`,`store_id`),
  KEY `FK_SALES_ORDER_STATUS_LABEL_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `sales_order_status_label`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_order_status_state`
--

CREATE TABLE IF NOT EXISTS `sales_order_status_state` (
  `status` varchar(32) NOT NULL,
  `state` varchar(32) NOT NULL,
  `is_default` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`status`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `sales_order_status_state`
--

INSERT INTO `sales_order_status_state` (`status`, `state`, `is_default`) VALUES
('canceled', 'canceled', 1),
('closed', 'closed', 1),
('complete', 'complete', 1),
('fraud', 'payment_review', 0),
('holded', 'holded', 1),
('payment_review', 'payment_review', 1),
('pending', 'new', 1),
('pending_payment', 'pending_payment', 1),
('processing', 'processing', 1);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_order_tax`
--

CREATE TABLE IF NOT EXISTS `sales_order_tax` (
  `tax_id` int(10) unsigned NOT NULL auto_increment,
  `order_id` int(10) unsigned NOT NULL,
  `code` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `percent` decimal(12,4) NOT NULL,
  `amount` decimal(12,4) NOT NULL,
  `priority` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `base_amount` decimal(12,4) NOT NULL,
  `process` smallint(6) NOT NULL,
  `base_real_amount` decimal(12,4) NOT NULL,
  `hidden` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tax_id`),
  KEY `IDX_ORDER_TAX` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_order_tax`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_payment_transaction`
--

CREATE TABLE IF NOT EXISTS `sales_payment_transaction` (
  `transaction_id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned default NULL,
  `order_id` int(10) unsigned NOT NULL default '0',
  `payment_id` int(10) unsigned NOT NULL default '0',
  `txn_id` varchar(100) NOT NULL default '',
  `parent_txn_id` varchar(100) default NULL,
  `txn_type` varchar(15) NOT NULL default '',
  `is_closed` tinyint(1) unsigned NOT NULL default '1',
  `additional_information` blob,
  `created_at` datetime default NULL,
  PRIMARY KEY  (`transaction_id`),
  UNIQUE KEY `UNQ_ORDER_PAYMENT_TXN` (`order_id`,`payment_id`,`txn_id`),
  KEY `IDX_ORDER_ID` (`order_id`),
  KEY `IDX_PARENT_ID` (`parent_id`),
  KEY `IDX_PAYMENT_ID` (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_payment_transaction`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_recurring_profile`
--

CREATE TABLE IF NOT EXISTS `sales_recurring_profile` (
  `profile_id` int(10) unsigned NOT NULL auto_increment,
  `state` varchar(20) NOT NULL,
  `customer_id` int(10) unsigned default NULL,
  `store_id` smallint(5) unsigned default NULL,
  `method_code` varchar(32) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime default NULL,
  `reference_id` varchar(32) default NULL,
  `subscriber_name` varchar(150) default NULL,
  `start_datetime` datetime NOT NULL,
  `internal_reference_id` varchar(42) NOT NULL,
  `schedule_description` varchar(255) NOT NULL,
  `suspension_threshold` smallint(6) unsigned default NULL,
  `bill_failed_later` tinyint(1) unsigned NOT NULL default '0',
  `period_unit` varchar(20) NOT NULL,
  `period_frequency` tinyint(3) unsigned default NULL,
  `period_max_cycles` tinyint(3) unsigned default NULL,
  `billing_amount` double(12,4) unsigned NOT NULL default '0.0000',
  `trial_period_unit` varchar(20) default NULL,
  `trial_period_frequency` tinyint(3) unsigned default NULL,
  `trial_period_max_cycles` tinyint(3) unsigned default NULL,
  `trial_billing_amount` double(12,4) unsigned default NULL,
  `currency_code` char(3) NOT NULL,
  `shipping_amount` decimal(12,4) unsigned default NULL,
  `tax_amount` decimal(12,4) unsigned default NULL,
  `init_amount` decimal(12,4) unsigned default NULL,
  `init_may_fail` tinyint(1) unsigned NOT NULL default '0',
  `order_info` text NOT NULL,
  `order_item_info` text NOT NULL,
  `billing_address_info` text NOT NULL,
  `shipping_address_info` text,
  `profile_vendor_info` text,
  `additional_info` text,
  PRIMARY KEY  (`profile_id`),
  UNIQUE KEY `UNQ_INTERNAL_REF_ID` (`internal_reference_id`),
  KEY `IDX_RECURRING_PROFILE_CUSTOMER` (`customer_id`),
  KEY `IDX_RECURRING_PROFILE_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_recurring_profile`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_recurring_profile_order`
--

CREATE TABLE IF NOT EXISTS `sales_recurring_profile_order` (
  `link_id` int(10) unsigned NOT NULL auto_increment,
  `profile_id` int(10) unsigned NOT NULL default '0',
  `order_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`link_id`),
  UNIQUE KEY `UNQ_PROFILE_ORDER` (`profile_id`,`order_id`),
  KEY `IDX_ORDER` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_recurring_profile_order`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_refunded_aggregated`
--

CREATE TABLE IF NOT EXISTS `sales_refunded_aggregated` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `refunded` decimal(12,4) NOT NULL default '0.0000',
  `online_refunded` decimal(12,4) NOT NULL default '0.0000',
  `offline_refunded` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_refunded_aggregated`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_refunded_aggregated_order`
--

CREATE TABLE IF NOT EXISTS `sales_refunded_aggregated_order` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `refunded` decimal(12,4) NOT NULL default '0.0000',
  `online_refunded` decimal(12,4) NOT NULL default '0.0000',
  `offline_refunded` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_refunded_aggregated_order`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_shipping_aggregated`
--

CREATE TABLE IF NOT EXISTS `sales_shipping_aggregated` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `shipping_description` varchar(255) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `total_shipping` decimal(12,4) NOT NULL default '0.0000',
  `total_shipping_actual` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_shipping_aggregated`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sales_shipping_aggregated_order`
--

CREATE TABLE IF NOT EXISTS `sales_shipping_aggregated_order` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `order_status` varchar(50) NOT NULL default '',
  `shipping_description` varchar(255) NOT NULL default '',
  `orders_count` int(11) NOT NULL default '0',
  `total_shipping` decimal(12,4) NOT NULL default '0.0000',
  `total_shipping_actual` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_ORDER_STATUS` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sales_shipping_aggregated_order`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sendfriend_log`
--

CREATE TABLE IF NOT EXISTS `sendfriend_log` (
  `log_id` int(10) unsigned NOT NULL auto_increment,
  `ip` bigint(20) NOT NULL default '0',
  `time` int(10) unsigned NOT NULL,
  `website_id` smallint(5) NOT NULL,
  PRIMARY KEY  (`log_id`),
  KEY `IDX_REMOTE_ADDR` (`ip`),
  KEY `IDX_LOG_TIME` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Send to friend function log storage table' AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sendfriend_log`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `shipping_tablerate`
--

CREATE TABLE IF NOT EXISTS `shipping_tablerate` (
  `pk` int(10) unsigned NOT NULL auto_increment,
  `website_id` int(11) NOT NULL default '0',
  `dest_country_id` varchar(4) NOT NULL default '0',
  `dest_region_id` int(10) NOT NULL default '0',
  `dest_zip` varchar(10) NOT NULL default '',
  `condition_name` varchar(20) NOT NULL default '',
  `condition_value` decimal(12,4) NOT NULL default '0.0000',
  `price` decimal(12,4) NOT NULL default '0.0000',
  `cost` decimal(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`pk`),
  UNIQUE KEY `dest_country` (`website_id`,`dest_country_id`,`dest_region_id`,`dest_zip`,`condition_name`,`condition_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `shipping_tablerate`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `sitemap`
--

CREATE TABLE IF NOT EXISTS `sitemap` (
  `sitemap_id` int(11) NOT NULL auto_increment,
  `sitemap_type` varchar(32) default NULL,
  `sitemap_filename` varchar(32) default NULL,
  `sitemap_path` tinytext,
  `sitemap_time` timestamp NULL default NULL,
  `store_id` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`sitemap_id`),
  KEY `FK_SITEMAP_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `sitemap`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `tag`
--

CREATE TABLE IF NOT EXISTS `tag` (
  `tag_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `status` smallint(6) NOT NULL default '0',
  `first_customer_id` int(10) unsigned NOT NULL default '0',
  `first_store_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- A tábla adatainak kiíratása `tag`
--

INSERT INTO `tag` (`tag_id`, `name`, `status`, `first_customer_id`, `first_store_id`) VALUES
(1, 'Lebex,', 1, 1, 1),
(2, 'Quickstep,', 1, 1, 1),
(3, 'Brintons', 1, 1, 1),
(4, 'Carpets,', 1, 1, 1),
(5, 'Ulster', 1, 1, 1),
(6, 'Cormar', 1, 1, 1);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tag_properties`
--

CREATE TABLE IF NOT EXISTS `tag_properties` (
  `tag_id` int(11) unsigned NOT NULL default '0',
  `store_id` smallint(5) unsigned NOT NULL default '0',
  `base_popularity` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tag_id`,`store_id`),
  KEY `FK_TAG_PROPERTIES_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `tag_properties`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `tag_relation`
--

CREATE TABLE IF NOT EXISTS `tag_relation` (
  `tag_relation_id` int(11) unsigned NOT NULL auto_increment,
  `tag_id` int(11) unsigned NOT NULL default '0',
  `customer_id` int(10) unsigned default NULL,
  `product_id` int(11) unsigned NOT NULL default '0',
  `store_id` smallint(6) unsigned NOT NULL default '1',
  `active` tinyint(1) unsigned NOT NULL default '1',
  `created_at` datetime default NULL,
  PRIMARY KEY  (`tag_relation_id`),
  UNIQUE KEY `UNQ_TAG_CUSTOMER_PRODUCT_STORE` (`tag_id`,`customer_id`,`product_id`,`store_id`),
  KEY `IDX_PRODUCT` (`product_id`),
  KEY `IDX_TAG` (`tag_id`),
  KEY `IDX_CUSTOMER` (`customer_id`),
  KEY `IDX_STORE` (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- A tábla adatainak kiíratása `tag_relation`
--

INSERT INTO `tag_relation` (`tag_relation_id`, `tag_id`, `customer_id`, `product_id`, `store_id`, `active`, `created_at`) VALUES
(1, 1, 1, 31, 1, 1, '2011-04-15 07:27:55'),
(2, 2, 1, 31, 1, 1, '2011-04-15 07:27:56'),
(3, 3, 1, 31, 1, 1, '2011-04-15 07:27:56'),
(4, 4, 1, 31, 1, 1, '2011-04-15 07:27:57'),
(5, 5, 1, 31, 1, 1, '2011-04-15 07:27:57'),
(6, 6, 1, 31, 1, 1, '2011-04-15 07:27:57');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tag_summary`
--

CREATE TABLE IF NOT EXISTS `tag_summary` (
  `tag_id` int(11) unsigned NOT NULL default '0',
  `store_id` smallint(5) unsigned NOT NULL default '0',
  `customers` int(11) unsigned NOT NULL default '0',
  `products` int(11) unsigned NOT NULL default '0',
  `uses` int(11) unsigned NOT NULL default '0' COMMENT 'deprecated since 1.4.0.1',
  `historical_uses` int(11) unsigned NOT NULL default '0' COMMENT 'deprecated since 1.4.0.1',
  `popularity` int(11) unsigned NOT NULL default '0',
  `base_popularity` int(11) unsigned NOT NULL default '0' COMMENT 'deprecated since 1.4.0.1',
  PRIMARY KEY  (`tag_id`,`store_id`),
  KEY `FK_TAG_SUMMARY_STORE` (`store_id`),
  KEY `IDX_TAG` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `tag_summary`
--

INSERT INTO `tag_summary` (`tag_id`, `store_id`, `customers`, `products`, `uses`, `historical_uses`, `popularity`, `base_popularity`) VALUES
(1, 0, 1, 1, 0, 0, 1, 0),
(1, 1, 1, 1, 0, 0, 1, 0),
(2, 0, 1, 1, 0, 0, 1, 0),
(2, 1, 1, 1, 0, 0, 1, 0),
(3, 0, 1, 1, 0, 0, 1, 0),
(3, 1, 1, 1, 0, 0, 1, 0),
(4, 0, 1, 1, 0, 0, 1, 0),
(4, 1, 1, 1, 0, 0, 1, 0),
(5, 0, 1, 1, 0, 0, 1, 0),
(5, 1, 1, 1, 0, 0, 1, 0),
(6, 0, 1, 1, 0, 0, 1, 0),
(6, 1, 1, 1, 0, 0, 1, 0);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tax_calculation`
--

CREATE TABLE IF NOT EXISTS `tax_calculation` (
  `tax_calculation_rate_id` int(11) NOT NULL,
  `tax_calculation_rule_id` int(11) NOT NULL,
  `customer_tax_class_id` smallint(6) NOT NULL,
  `product_tax_class_id` smallint(6) NOT NULL,
  KEY `FK_TAX_CALCULATION_RULE` (`tax_calculation_rule_id`),
  KEY `FK_TAX_CALCULATION_RATE` (`tax_calculation_rate_id`),
  KEY `FK_TAX_CALCULATION_CTC` (`customer_tax_class_id`),
  KEY `FK_TAX_CALCULATION_PTC` (`product_tax_class_id`),
  KEY `IDX_TAX_CALCULATION` (`tax_calculation_rate_id`,`customer_tax_class_id`,`product_tax_class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `tax_calculation`
--

INSERT INTO `tax_calculation` (`tax_calculation_rate_id`, `tax_calculation_rule_id`, `customer_tax_class_id`, `product_tax_class_id`) VALUES
(1, 1, 3, 2),
(2, 1, 3, 2);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tax_calculation_rate`
--

CREATE TABLE IF NOT EXISTS `tax_calculation_rate` (
  `tax_calculation_rate_id` int(11) NOT NULL auto_increment,
  `tax_country_id` char(2) NOT NULL,
  `tax_region_id` mediumint(9) NOT NULL,
  `tax_postcode` varchar(21) NOT NULL,
  `code` varchar(255) NOT NULL,
  `rate` decimal(12,4) NOT NULL,
  `zip_is_range` tinyint(1) default NULL,
  `zip_from` int(11) unsigned default NULL,
  `zip_to` int(11) unsigned default NULL,
  PRIMARY KEY  (`tax_calculation_rate_id`),
  KEY `IDX_TAX_CALCULATION_RATE` (`tax_country_id`,`tax_region_id`,`tax_postcode`),
  KEY `IDX_TAX_CALCULATION_RATE_CODE` (`code`),
  KEY `IDX_TAX_CALCULATION_RATE_RANGE` (`tax_calculation_rate_id`,`tax_country_id`,`tax_region_id`,`zip_is_range`,`tax_postcode`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- A tábla adatainak kiíratása `tax_calculation_rate`
--

INSERT INTO `tax_calculation_rate` (`tax_calculation_rate_id`, `tax_country_id`, `tax_region_id`, `tax_postcode`, `code`, `rate`, `zip_is_range`, `zip_from`, `zip_to`) VALUES
(1, 'US', 12, '*', 'US-CA-*-Rate 1', 8.2500, NULL, NULL, NULL),
(2, 'US', 43, '*', 'US-NY-*-Rate 1', 8.3750, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tax_calculation_rate_title`
--

CREATE TABLE IF NOT EXISTS `tax_calculation_rate_title` (
  `tax_calculation_rate_title_id` int(11) NOT NULL auto_increment,
  `tax_calculation_rate_id` int(11) NOT NULL,
  `store_id` smallint(5) unsigned NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY  (`tax_calculation_rate_title_id`),
  KEY `IDX_TAX_CALCULATION_RATE_TITLE` (`tax_calculation_rate_id`,`store_id`),
  KEY `FK_TAX_CALCULATION_RATE_TITLE_RATE` (`tax_calculation_rate_id`),
  KEY `FK_TAX_CALCULATION_RATE_TITLE_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `tax_calculation_rate_title`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `tax_calculation_rule`
--

CREATE TABLE IF NOT EXISTS `tax_calculation_rule` (
  `tax_calculation_rule_id` int(11) NOT NULL auto_increment,
  `code` varchar(255) NOT NULL,
  `priority` mediumint(9) NOT NULL,
  `position` mediumint(9) NOT NULL,
  PRIMARY KEY  (`tax_calculation_rule_id`),
  KEY `IDX_TAX_CALCULATION_RULE` (`priority`,`position`,`tax_calculation_rule_id`),
  KEY `IDX_TAX_CALCULATION_RULE_CODE` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- A tábla adatainak kiíratása `tax_calculation_rule`
--

INSERT INTO `tax_calculation_rule` (`tax_calculation_rule_id`, `code`, `priority`, `position`) VALUES
(1, 'Retail Customer-Taxable Goods-Rate 1', 1, 1);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tax_class`
--

CREATE TABLE IF NOT EXISTS `tax_class` (
  `class_id` smallint(6) NOT NULL auto_increment,
  `class_name` varchar(255) NOT NULL default '',
  `class_type` enum('CUSTOMER','PRODUCT') NOT NULL default 'CUSTOMER',
  PRIMARY KEY  (`class_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- A tábla adatainak kiíratása `tax_class`
--

INSERT INTO `tax_class` (`class_id`, `class_name`, `class_type`) VALUES
(2, 'Taxable Goods', 'PRODUCT'),
(3, 'Retail Customer', 'CUSTOMER'),
(4, 'Shipping', 'PRODUCT');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `tax_order_aggregated_created`
--

CREATE TABLE IF NOT EXISTS `tax_order_aggregated_created` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `period` date NOT NULL default '0000-00-00',
  `store_id` smallint(5) unsigned default NULL,
  `code` varchar(255) NOT NULL default '',
  `order_status` varchar(50) NOT NULL default '',
  `percent` float(12,4) NOT NULL default '0.0000',
  `orders_count` int(11) unsigned NOT NULL default '0',
  `tax_base_amount_sum` float(12,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UNQ_PERIOD_STORE_CODE_ORDER_STATUS` (`period`,`store_id`,`code`,`percent`,`order_status`),
  KEY `IDX_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `tax_order_aggregated_created`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `weee_discount`
--

CREATE TABLE IF NOT EXISTS `weee_discount` (
  `entity_id` int(10) unsigned NOT NULL default '0',
  `website_id` smallint(5) unsigned NOT NULL default '0',
  `customer_group_id` smallint(5) unsigned NOT NULL,
  `value` decimal(12,4) NOT NULL default '0.0000',
  KEY `FK_CATALOG_PRODUCT_ENTITY_WEEE_DISCOUNT_WEBSITE` (`website_id`),
  KEY `FK_CATALOG_PRODUCT_ENTITY_WEEE_DISCOUNT_PRODUCT_ENTITY` (`entity_id`),
  KEY `FK_CATALOG_PRODUCT_ENTITY_WEEE_DISCOUNT_GROUP` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `weee_discount`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `weee_tax`
--

CREATE TABLE IF NOT EXISTS `weee_tax` (
  `value_id` int(11) NOT NULL auto_increment,
  `website_id` smallint(5) unsigned NOT NULL default '0',
  `entity_id` int(10) unsigned NOT NULL default '0',
  `country` varchar(2) NOT NULL default '',
  `value` decimal(12,4) NOT NULL default '0.0000',
  `state` varchar(255) NOT NULL default '*',
  `attribute_id` smallint(5) unsigned NOT NULL,
  `entity_type_id` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`value_id`),
  KEY `FK_CATALOG_PRODUCT_ENTITY_WEEE_TAX_WEBSITE` (`website_id`),
  KEY `FK_CATALOG_PRODUCT_ENTITY_WEEE_TAX_PRODUCT_ENTITY` (`entity_id`),
  KEY `FK_CATALOG_PRODUCT_ENTITY_WEEE_TAX_COUNTRY` (`country`),
  KEY `FK_WEEE_TAX_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `weee_tax`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `widget`
--

CREATE TABLE IF NOT EXISTS `widget` (
  `widget_id` int(10) unsigned NOT NULL auto_increment,
  `code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `parameters` text,
  PRIMARY KEY  (`widget_id`),
  KEY `IDX_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Preconfigured Widgets' AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `widget`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `widget_instance`
--

CREATE TABLE IF NOT EXISTS `widget_instance` (
  `instance_id` int(11) unsigned NOT NULL auto_increment,
  `type` varchar(255) NOT NULL default '',
  `package_theme` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `store_ids` varchar(255) NOT NULL default '0',
  `widget_parameters` text,
  `sort_order` smallint(5) NOT NULL default '0',
  PRIMARY KEY  (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `widget_instance`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `widget_instance_page`
--

CREATE TABLE IF NOT EXISTS `widget_instance_page` (
  `page_id` int(11) unsigned NOT NULL auto_increment,
  `instance_id` int(11) unsigned NOT NULL default '0',
  `group` varchar(25) NOT NULL default '',
  `layout_handle` varchar(255) NOT NULL default '',
  `block_reference` varchar(255) NOT NULL default '',
  `for` varchar(25) NOT NULL default '',
  `entities` text,
  `template` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`page_id`),
  KEY `IDX_WIDGET_WIDGET_INSTANCE_ID` (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `widget_instance_page`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `widget_instance_page_layout`
--

CREATE TABLE IF NOT EXISTS `widget_instance_page_layout` (
  `page_id` int(11) unsigned NOT NULL default '0',
  `layout_update_id` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `page_id` (`page_id`,`layout_update_id`),
  KEY `IDX_WIDGET_WIDGET_INSTANCE_PAGE_ID` (`page_id`),
  KEY `IDX_WIDGET_WIDGET_INSTANCE_LAYOUT_UPDATE_ID` (`layout_update_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- A tábla adatainak kiíratása `widget_instance_page_layout`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `wishlist`
--

CREATE TABLE IF NOT EXISTS `wishlist` (
  `wishlist_id` int(10) unsigned NOT NULL auto_increment,
  `customer_id` int(10) unsigned NOT NULL default '0',
  `shared` tinyint(1) unsigned default '0',
  `sharing_code` varchar(32) character set latin1 collate latin1_general_ci NOT NULL default '',
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`wishlist_id`),
  UNIQUE KEY `UNQ_CUSTOMER` (`customer_id`),
  KEY `IDX_IS_SHARED` (`shared`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Wishlist main' AUTO_INCREMENT=3 ;

--
-- A tábla adatainak kiíratása `wishlist`
--

INSERT INTO `wishlist` (`wishlist_id`, `customer_id`, `shared`, `sharing_code`, `updated_at`) VALUES
(1, 1, 0, '693edc7cff5ff45d6dae36c10faff2c2', '2011-04-15 07:56:42'),
(2, 2, 0, '29c62ab38c7b1c623063001f9c4ff7e1', '2011-11-14 17:41:24');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `wishlist_item`
--

CREATE TABLE IF NOT EXISTS `wishlist_item` (
  `wishlist_item_id` int(10) unsigned NOT NULL auto_increment,
  `wishlist_id` int(10) unsigned NOT NULL default '0',
  `product_id` int(10) unsigned NOT NULL default '0',
  `store_id` smallint(5) unsigned default NULL,
  `added_at` datetime default NULL,
  `description` text,
  `qty` decimal(12,4) NOT NULL,
  PRIMARY KEY  (`wishlist_item_id`),
  KEY `IDX_WISHLIST` (`wishlist_id`),
  KEY `IDX_PRODUCT` (`product_id`),
  KEY `IDX_STORE` (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Wishlist items' AUTO_INCREMENT=2 ;

--
-- A tábla adatainak kiíratása `wishlist_item`
--

INSERT INTO `wishlist_item` (`wishlist_item_id`, `wishlist_id`, `product_id`, `store_id`, `added_at`, `description`, `qty`) VALUES
(1, 2, 43, 1, '2011-11-14 17:41:24', NULL, 1.0000);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `wishlist_item_option`
--

CREATE TABLE IF NOT EXISTS `wishlist_item_option` (
  `option_id` int(10) unsigned NOT NULL auto_increment,
  `wishlist_item_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `code` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`option_id`),
  KEY `FK_WISHLIST_ITEM_OPTION_ITEM_ID` (`wishlist_item_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Additional options for wishlist item' AUTO_INCREMENT=2 ;

--
-- A tábla adatainak kiíratása `wishlist_item_option`
--

INSERT INTO `wishlist_item_option` (`option_id`, `wishlist_item_id`, `product_id`, `code`, `value`) VALUES
(1, 1, 43, 'info_buyRequest', 'a:3:{s:7:"product";s:2:"43";s:15:"related_product";s:0:"";s:3:"qty";s:1:"1";}');

-- --------------------------------------------------------

--
-- Tábla szerkezet: `xmlconnect_application`
--

CREATE TABLE IF NOT EXISTS `xmlconnect_application` (
  `application_id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `code` varchar(32) NOT NULL,
  `type` varchar(32) NOT NULL,
  `store_id` smallint(5) unsigned default NULL,
  `active_from` date default NULL,
  `active_to` date default NULL,
  `updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `configuration` blob,
  `status` tinyint(1) NOT NULL default '0',
  `browsing_mode` tinyint(1) default '0',
  PRIMARY KEY  (`application_id`),
  UNIQUE KEY `UNQ_XMLCONNECT_APPLICATION_CODE` (`code`),
  KEY `FK_XMLCONNECT_APPLICAION_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `xmlconnect_application`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `xmlconnect_history`
--

CREATE TABLE IF NOT EXISTS `xmlconnect_history` (
  `history_id` int(11) NOT NULL auto_increment,
  `application_id` smallint(5) unsigned NOT NULL,
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `store_id` smallint(5) unsigned default NULL,
  `params` blob,
  `title` varchar(200) NOT NULL,
  `activation_key` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  PRIMARY KEY  (`history_id`),
  KEY `FK_XMLCONNECT_HISTORY_APPLICATION` (`application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `xmlconnect_history`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `xmlconnect_notification_template`
--

CREATE TABLE IF NOT EXISTS `xmlconnect_notification_template` (
  `id` int(11) NOT NULL auto_increment,
  `app_code` varchar(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  `push_title` varchar(141) NOT NULL,
  `message_title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `modified_at` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `FK_APP_CODE` (`app_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `xmlconnect_notification_template`
--


-- --------------------------------------------------------

--
-- Tábla szerkezet: `xmlconnect_queue`
--

CREATE TABLE IF NOT EXISTS `xmlconnect_queue` (
  `id` int(11) NOT NULL auto_increment,
  `create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `exec_time` timestamp NULL default NULL,
  `template_id` int(11) NOT NULL,
  `push_title` varchar(140) NOT NULL,
  `message_title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `status` tinyint(4) NOT NULL default '0',
  `type` varchar(12) NOT NULL,
  `app_code` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `FK_TEMPLATE_ID` (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- A tábla adatainak kiíratása `xmlconnect_queue`
--


--
-- Megkötések a kiírt táblákhoz
--

--
-- Megkötések a táblához `admin_rule`
--
ALTER TABLE `admin_rule`
  ADD CONSTRAINT `FK_admin_rule` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `api_rule`
--
ALTER TABLE `api_rule`
  ADD CONSTRAINT `FK_api_rule` FOREIGN KEY (`role_id`) REFERENCES `api_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `api_session`
--
ALTER TABLE `api_session`
  ADD CONSTRAINT `FK_API_SESSION_USER` FOREIGN KEY (`user_id`) REFERENCES `api_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogindex_aggregation`
--
ALTER TABLE `catalogindex_aggregation`
  ADD CONSTRAINT `FK_CATALOGINDEX_AGGREGATION_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogindex_aggregation_to_tag`
--
ALTER TABLE `catalogindex_aggregation_to_tag`
  ADD CONSTRAINT `FK_CATALOGINDEX_AGGREGATION_TO_TAG_AGGREGATION` FOREIGN KEY (`aggregation_id`) REFERENCES `catalogindex_aggregation` (`aggregation_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINDEX_AGGREGATION_TO_TAG_TAG` FOREIGN KEY (`tag_id`) REFERENCES `catalogindex_aggregation_tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogindex_eav`
--
ALTER TABLE `catalogindex_eav`
  ADD CONSTRAINT `FK_CATALOGINDEX_EAV_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINDEX_EAV_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINDEX_EAV_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogindex_minimal_price`
--
ALTER TABLE `catalogindex_minimal_price`
  ADD CONSTRAINT `FK_CATALOGINDEX_MINIMAL_PRICE_CUSTOMER_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINDEX_MINIMAL_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CI_MINIMAL_PRICE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogindex_price`
--
ALTER TABLE `catalogindex_price`
  ADD CONSTRAINT `FK_CATALOGINDEX_PRICE_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINDEX_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CI_PRICE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `cataloginventory_stock_item`
--
ALTER TABLE `cataloginventory_stock_item`
  ADD CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `cataloginventory_stock_status`
--
ALTER TABLE `cataloginventory_stock_status`
  ADD CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogrule_group_website`
--
ALTER TABLE `catalogrule_group_website`
  ADD CONSTRAINT `FK_CATALOGRULE_GROUP_WEBSITE_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGRULE_GROUP_WEBSITE_RULE` FOREIGN KEY (`rule_id`) REFERENCES `catalogrule` (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGRULE_GROUP_WEBSITE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogrule_product`
--
ALTER TABLE `catalogrule_product`
  ADD CONSTRAINT `FK_catalogrule_product_customergroup` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGRULE_PRODUCT_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_catalogrule_product_rule` FOREIGN KEY (`rule_id`) REFERENCES `catalogrule` (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_catalogrule_product_website` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogrule_product_price`
--
ALTER TABLE `catalogrule_product_price`
  ADD CONSTRAINT `FK_catalogrule_product_price_customergroup` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGRULE_PRODUCT_PRICE_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_catalogrule_product_price_website` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogsearch_query`
--
ALTER TABLE `catalogsearch_query`
  ADD CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalogsearch_result`
--
ALTER TABLE `catalogsearch_result`
  ADD CONSTRAINT `FK_CATALOGSEARCH_RESULT_CATALOG_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOGSEARCH_RESULT_QUERY` FOREIGN KEY (`query_id`) REFERENCES `catalogsearch_query` (`query_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_entity_datetime`
--
ALTER TABLE `catalog_category_entity_datetime`
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_entity_decimal`
--
ALTER TABLE `catalog_category_entity_decimal`
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DECIMAL_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DECIMAL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_entity_int`
--
ALTER TABLE `catalog_category_entity_int`
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_EMTITY_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_EMTITY_INT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_EMTITY_INT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_entity_text`
--
ALTER TABLE `catalog_category_entity_text`
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_TEXT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_entity_varchar`
--
ALTER TABLE `catalog_category_entity_varchar`
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_flat_store_1`
--
ALTER TABLE `catalog_category_flat_store_1`
  ADD CONSTRAINT `FK_CATEGORY_FLAT_CATEGORY_ID_STORE_1` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATEGORY_FLAT_STORE_ID_STORE_1` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_flat_store_2`
--
ALTER TABLE `catalog_category_flat_store_2`
  ADD CONSTRAINT `FK_CATEGORY_FLAT_CATEGORY_ID_STORE_2` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATEGORY_FLAT_STORE_ID_STORE_2` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_flat_store_3`
--
ALTER TABLE `catalog_category_flat_store_3`
  ADD CONSTRAINT `FK_CATEGORY_FLAT_CATEGORY_ID_STORE_3` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATEGORY_FLAT_STORE_ID_STORE_3` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_product`
--
ALTER TABLE `catalog_category_product`
  ADD CONSTRAINT `CATALOG_CATEGORY_PRODUCT_CATEGORY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `CATALOG_CATEGORY_PRODUCT_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_category_product_index`
--
ALTER TABLE `catalog_category_product_index`
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_PROD_IDX_CATEGORY_ENTITY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_CATEGORY_PROD_IDX_PROD_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATEGORY_PRODUCT_INDEX_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_compare_item`
--
ALTER TABLE `catalog_compare_item`
  ADD CONSTRAINT `FK_CATALOG_COMPARE_ITEM_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_COMPARE_ITEM_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_COMPARE_ITEM_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_eav_attribute`
--
ALTER TABLE `catalog_eav_attribute`
  ADD CONSTRAINT `FK_CATALOG_EAV_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_bundle_option`
--
ALTER TABLE `catalog_product_bundle_option`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_BUNDLE_OPTION_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_bundle_option_value`
--
ALTER TABLE `catalog_product_bundle_option_value`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_BUNDLE_OPTION_VALUE_OPTION` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_bundle_price_index`
--
ALTER TABLE `catalog_product_bundle_price_index`
  ADD CONSTRAINT `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_CUSTOMER_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_PRODUCT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_bundle_selection`
--
ALTER TABLE `catalog_product_bundle_selection`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_BUNDLE_SELECTION_OPTION` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_BUNDLE_SELECTION_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_bundle_selection_price`
--
ALTER TABLE `catalog_product_bundle_selection_price`
  ADD CONSTRAINT `FK_BUNDLE_PRICE_SELECTION_ID` FOREIGN KEY (`selection_id`) REFERENCES `catalog_product_bundle_selection` (`selection_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_BUNDLE_PRICE_SELECTION_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_enabled_index`
--
ALTER TABLE `catalog_product_enabled_index`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENABLED_INDEX_PRODUCT_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENABLED_INDEX_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity`
--
ALTER TABLE `catalog_product_entity`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_datetime`
--
ALTER TABLE `catalog_product_entity_datetime`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_DATETIME_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PROD_ENTITY_DATETIME_PROD_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_decimal`
--
ALTER TABLE `catalog_product_entity_decimal`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_DECIMAL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PROD_ENTITY_DECIMAL_PROD_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_gallery`
--
ALTER TABLE `catalog_product_entity_gallery`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_GALLERY_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_GALLERY_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_GALLERY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_int`
--
ALTER TABLE `catalog_product_entity_int`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_INT_PRODUCT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_INT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_media_gallery`
--
ALTER TABLE `catalog_product_entity_media_gallery`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_MEDIA_GALLERY_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_MEDIA_GALLERY_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_media_gallery_value`
--
ALTER TABLE `catalog_product_entity_media_gallery_value`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_MEDIA_GALLERY_VALUE_GALLERY` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_MEDIA_GALLERY_VALUE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_text`
--
ALTER TABLE `catalog_product_entity_text`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_TEXT_PRODUCT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_TEXT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_tier_price`
--
ALTER TABLE `catalog_product_entity_tier_price`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_TIER_PRICE_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_TIER_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PROD_ENTITY_TIER_PRICE_PROD_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_entity_varchar`
--
ALTER TABLE `catalog_product_entity_varchar`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_VARCHAR_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PROD_ENTITY_VARCHAR_PROD_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_flat_1`
--
ALTER TABLE `catalog_product_flat_1`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_FLAT_1_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_index_eav`
--
ALTER TABLE `catalog_product_index_eav`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_index_eav_decimal`
--
ALTER TABLE `catalog_product_index_eav_decimal`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_index_price`
--
ALTER TABLE `catalog_product_index_price`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_index_tier_price`
--
ALTER TABLE `catalog_product_index_tier_price`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_CUSTOMER` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_index_website`
--
ALTER TABLE `catalog_product_index_website`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_link`
--
ALTER TABLE `catalog_product_link`
  ADD CONSTRAINT `FK_PRODUCT_LINK_LINKED_PRODUCT` FOREIGN KEY (`linked_product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_LINK_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_LINK_TYPE` FOREIGN KEY (`link_type_id`) REFERENCES `catalog_product_link_type` (`link_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_link_attribute`
--
ALTER TABLE `catalog_product_link_attribute`
  ADD CONSTRAINT `FK_ATTRIBUTE_PRODUCT_LINK_TYPE` FOREIGN KEY (`link_type_id`) REFERENCES `catalog_product_link_type` (`link_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_link_attribute_decimal`
--
ALTER TABLE `catalog_product_link_attribute_decimal`
  ADD CONSTRAINT `FK_DECIMAL_LINK` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_DECIMAL_PRODUCT_LINK_ATTRIBUTE` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_link_attribute_int`
--
ALTER TABLE `catalog_product_link_attribute_int`
  ADD CONSTRAINT `FK_INT_PRODUCT_LINK` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_INT_PRODUCT_LINK_ATTRIBUTE` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_link_attribute_varchar`
--
ALTER TABLE `catalog_product_link_attribute_varchar`
  ADD CONSTRAINT `FK_VARCHAR_LINK` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_VARCHAR_PRODUCT_LINK_ATTRIBUTE` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_option`
--
ALTER TABLE `catalog_product_option`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_option_price`
--
ALTER TABLE `catalog_product_option_price`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_PRICE_OPTION` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_PRICE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_option_title`
--
ALTER TABLE `catalog_product_option_title`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TITLE_OPTION` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TITLE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_option_type_price`
--
ALTER TABLE `catalog_product_option_type_price`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TYPE_PRICE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_option_type_title`
--
ALTER TABLE `catalog_product_option_type_title`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TYPE_TITLE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_option_type_value`
--
ALTER TABLE `catalog_product_option_type_value`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_OPTION_TYPE_VALUE_OPTION` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_relation`
--
ALTER TABLE `catalog_product_relation`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_RELATION_CHILD` FOREIGN KEY (`child_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_RELATION_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_super_attribute`
--
ALTER TABLE `catalog_product_super_attribute`
  ADD CONSTRAINT `FK_SUPER_PRODUCT_ATTRIBUTE_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `catalog_product_super_attribute_label`
--
ALTER TABLE `catalog_product_super_attribute_label`
  ADD CONSTRAINT `FK_CATALOG_PROD_SUPER_ATTR_LABEL_ATTR` FOREIGN KEY (`product_super_attribute_id`) REFERENCES `catalog_product_super_attribute` (`product_super_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PROD_SUPER_ATTR_LABEL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_super_attribute_pricing`
--
ALTER TABLE `catalog_product_super_attribute_pricing`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_SUPER_PRICE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SUPER_PRODUCT_ATTRIBUTE_PRICING` FOREIGN KEY (`product_super_attribute_id`) REFERENCES `catalog_product_super_attribute` (`product_super_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_super_link`
--
ALTER TABLE `catalog_product_super_link`
  ADD CONSTRAINT `FK_SUPER_PRODUCT_LINK_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SUPER_PRODUCT_LINK_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `catalog_product_website`
--
ALTER TABLE `catalog_product_website`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_WEBSITE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_WEBSITE_PRODUCT_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `checkout_agreement_store`
--
ALTER TABLE `checkout_agreement_store`
  ADD CONSTRAINT `FK_CHECKOUT_AGREEMENT` FOREIGN KEY (`agreement_id`) REFERENCES `checkout_agreement` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CHECKOUT_AGREEMENT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `cms_block_store`
--
ALTER TABLE `cms_block_store`
  ADD CONSTRAINT `FK_CMS_BLOCK_STORE_BLOCK` FOREIGN KEY (`block_id`) REFERENCES `cms_block` (`block_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CMS_BLOCK_STORE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `cms_page_store`
--
ALTER TABLE `cms_page_store`
  ADD CONSTRAINT `FK_CMS_PAGE_STORE_PAGE` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`page_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CMS_PAGE_STORE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_layout_link`
--
ALTER TABLE `core_layout_link`
  ADD CONSTRAINT `FK_CORE_LAYOUT_LINK_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CORE_LAYOUT_LINK_UPDATE` FOREIGN KEY (`layout_update_id`) REFERENCES `core_layout_update` (`layout_update_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_session`
--
ALTER TABLE `core_session`
  ADD CONSTRAINT `FK_SESSION_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_store`
--
ALTER TABLE `core_store`
  ADD CONSTRAINT `FK_STORE_GROUP_STORE` FOREIGN KEY (`group_id`) REFERENCES `core_store_group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_STORE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_store_group`
--
ALTER TABLE `core_store_group`
  ADD CONSTRAINT `FK_STORE_GROUP_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_translate`
--
ALTER TABLE `core_translate`
  ADD CONSTRAINT `FK_CORE_TRANSLATE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_url_rewrite`
--
ALTER TABLE `core_url_rewrite`
  ADD CONSTRAINT `FK_CORE_URL_REWRITE_CATEGORY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CORE_URL_REWRITE_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CORE_URL_REWRITE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `core_variable_value`
--
ALTER TABLE `core_variable_value`
  ADD CONSTRAINT `FK_CORE_VARIABLE_VALUE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CORE_VARIABLE_VALUE_VARIABLE_ID` FOREIGN KEY (`variable_id`) REFERENCES `core_variable` (`variable_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `coupon_aggregated`
--
ALTER TABLE `coupon_aggregated`
  ADD CONSTRAINT `FK_SALESTRULE_COUPON_AGGREGATED_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `coupon_aggregated_order`
--
ALTER TABLE `coupon_aggregated_order`
  ADD CONSTRAINT `FK_SALESTRULE_COUPON_AGGREGATED_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_address_entity`
--
ALTER TABLE `customer_address_entity`
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_CUSTOMER_ID` FOREIGN KEY (`parent_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_address_entity_datetime`
--
ALTER TABLE `customer_address_entity_datetime`
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_DATETIME_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_address_entity_decimal`
--
ALTER TABLE `customer_address_entity_decimal`
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_DECIMAL_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_address_entity_int`
--
ALTER TABLE `customer_address_entity_int`
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_INT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_address_entity_text`
--
ALTER TABLE `customer_address_entity_text`
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_TEXT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_address_entity_varchar`
--
ALTER TABLE `customer_address_entity_varchar`
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_VARCHAR_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_ADDRESS_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_eav_attribute`
--
ALTER TABLE `customer_eav_attribute`
  ADD CONSTRAINT `FK_CUSTOMER_EAV_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_eav_attribute_website`
--
ALTER TABLE `customer_eav_attribute_website`
  ADD CONSTRAINT `FK_CUST_EAV_ATTR_WEBST_ATTR_EAV_ATTR` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUST_EAV_ATTR_WEBST_WEBST_CORE_WEBST` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_entity`
--
ALTER TABLE `customer_entity`
  ADD CONSTRAINT `FK_CUSTOMER_ENTITY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_entity_datetime`
--
ALTER TABLE `customer_entity_datetime`
  ADD CONSTRAINT `FK_CUSTOMER_DATETIME_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_DATETIME_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_entity_decimal`
--
ALTER TABLE `customer_entity_decimal`
  ADD CONSTRAINT `FK_CUSTOMER_DECIMAL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_DECIMAL_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_entity_int`
--
ALTER TABLE `customer_entity_int`
  ADD CONSTRAINT `FK_CUSTOMER_INT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_INT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_entity_text`
--
ALTER TABLE `customer_entity_text`
  ADD CONSTRAINT `FK_CUSTOMER_TEXT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_TEXT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_entity_varchar`
--
ALTER TABLE `customer_entity_varchar`
  ADD CONSTRAINT `FK_CUSTOMER_VARCHAR_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_VARCHAR_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CUSTOMER_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `customer_form_attribute`
--
ALTER TABLE `customer_form_attribute`
  ADD CONSTRAINT `FK_CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `dataflow_batch`
--
ALTER TABLE `dataflow_batch`
  ADD CONSTRAINT `FK_DATAFLOW_BATCH_PROFILE` FOREIGN KEY (`profile_id`) REFERENCES `dataflow_profile` (`profile_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DATAFLOW_BATCH_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `dataflow_batch_export`
--
ALTER TABLE `dataflow_batch_export`
  ADD CONSTRAINT `FK_DATAFLOW_BATCH_EXPORT_BATCH` FOREIGN KEY (`batch_id`) REFERENCES `dataflow_batch` (`batch_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `dataflow_batch_import`
--
ALTER TABLE `dataflow_batch_import`
  ADD CONSTRAINT `FK_DATAFLOW_BATCH_IMPORT_BATCH` FOREIGN KEY (`batch_id`) REFERENCES `dataflow_batch` (`batch_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `dataflow_import_data`
--
ALTER TABLE `dataflow_import_data`
  ADD CONSTRAINT `FK_dataflow_import_data` FOREIGN KEY (`session_id`) REFERENCES `dataflow_session` (`session_id`);

--
-- Megkötések a táblához `dataflow_profile_history`
--
ALTER TABLE `dataflow_profile_history`
  ADD CONSTRAINT `FK_dataflow_profile_history` FOREIGN KEY (`profile_id`) REFERENCES `dataflow_profile` (`profile_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `design_change`
--
ALTER TABLE `design_change`
  ADD CONSTRAINT `FK_DESIGN_CHANGE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `directory_country_region_name`
--
ALTER TABLE `directory_country_region_name`
  ADD CONSTRAINT `FK_DIRECTORY_REGION_NAME_REGION` FOREIGN KEY (`region_id`) REFERENCES `directory_country_region` (`region_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `downloadable_link`
--
ALTER TABLE `downloadable_link`
  ADD CONSTRAINT `FK_DOWNLODABLE_LINK_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `downloadable_link_price`
--
ALTER TABLE `downloadable_link_price`
  ADD CONSTRAINT `FK_DOWNLOADABLE_LINK_PRICE_LINK` FOREIGN KEY (`link_id`) REFERENCES `downloadable_link` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_DOWNLOADABLE_LINK_PRICE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `downloadable_link_purchased_item`
--
ALTER TABLE `downloadable_link_purchased_item`
  ADD CONSTRAINT `FK_DOWNLOADABLE_LINK_PURCHASED_ID` FOREIGN KEY (`purchased_id`) REFERENCES `downloadable_link_purchased` (`purchased_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `downloadable_link_title`
--
ALTER TABLE `downloadable_link_title`
  ADD CONSTRAINT `FK_DOWNLOADABLE_LINK_TITLE_LINK` FOREIGN KEY (`link_id`) REFERENCES `downloadable_link` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_DOWNLOADABLE_LINK_TITLE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `downloadable_sample`
--
ALTER TABLE `downloadable_sample`
  ADD CONSTRAINT `FK_DOWNLODABLE_SAMPLE_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `downloadable_sample_title`
--
ALTER TABLE `downloadable_sample_title`
  ADD CONSTRAINT `FK_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE` FOREIGN KEY (`sample_id`) REFERENCES `downloadable_sample` (`sample_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_DOWNLOADABLE_SAMPLE_TITLE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_attribute`
--
ALTER TABLE `eav_attribute`
  ADD CONSTRAINT `FK_eav_attribute` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_attribute_group`
--
ALTER TABLE `eav_attribute_group`
  ADD CONSTRAINT `FK_eav_attribute_group` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_attribute_label`
--
ALTER TABLE `eav_attribute_label`
  ADD CONSTRAINT `FK_ATTRIBUTE_LABEL_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_ATTRIBUTE_LABEL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_attribute_option`
--
ALTER TABLE `eav_attribute_option`
  ADD CONSTRAINT `FK_ATTRIBUTE_OPTION_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_attribute_option_value`
--
ALTER TABLE `eav_attribute_option_value`
  ADD CONSTRAINT `FK_ATTRIBUTE_OPTION_VALUE_OPTION` FOREIGN KEY (`option_id`) REFERENCES `eav_attribute_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_ATTRIBUTE_OPTION_VALUE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_attribute_set`
--
ALTER TABLE `eav_attribute_set`
  ADD CONSTRAINT `FK_eav_attribute_set` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity`
--
ALTER TABLE `eav_entity`
  ADD CONSTRAINT `FK_eav_entity` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_eav_entity_store` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_attribute`
--
ALTER TABLE `eav_entity_attribute`
  ADD CONSTRAINT `FK_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_ATTRIBUTE_GROUP` FOREIGN KEY (`attribute_group_id`) REFERENCES `eav_attribute_group` (`attribute_group_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_datetime`
--
ALTER TABLE `eav_entity_datetime`
  ADD CONSTRAINT `FK_EAV_ENTITY_DATETIME_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `eav_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_DATETIME_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_DATETIME_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_decimal`
--
ALTER TABLE `eav_entity_decimal`
  ADD CONSTRAINT `FK_EAV_ENTITY_DECIMAL_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `eav_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_DECIMAL_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_DECIMAL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_int`
--
ALTER TABLE `eav_entity_int`
  ADD CONSTRAINT `FK_EAV_ENTITY_INT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `eav_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_INT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_INT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_store`
--
ALTER TABLE `eav_entity_store`
  ADD CONSTRAINT `FK_eav_entity_store_entity_type` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_eav_entity_store_store` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_text`
--
ALTER TABLE `eav_entity_text`
  ADD CONSTRAINT `FK_EAV_ENTITY_TEXT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `eav_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_TEXT_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_TEXT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_entity_varchar`
--
ALTER TABLE `eav_entity_varchar`
  ADD CONSTRAINT `FK_EAV_ENTITY_VARCHAR_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `eav_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_VARCHAR_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_ENTITY_VARCHAR_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_form_element`
--
ALTER TABLE `eav_form_element`
  ADD CONSTRAINT `FK_EAV_FORM_ELEMENT_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_FORM_ELEMENT_FORM_FIELDSET` FOREIGN KEY (`fieldset_id`) REFERENCES `eav_form_fieldset` (`fieldset_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_FORM_ELEMENT_FORM_TYPE` FOREIGN KEY (`type_id`) REFERENCES `eav_form_type` (`type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_form_fieldset`
--
ALTER TABLE `eav_form_fieldset`
  ADD CONSTRAINT `FK_EAV_FORM_FIELDSET_FORM_TYPE` FOREIGN KEY (`type_id`) REFERENCES `eav_form_type` (`type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_form_fieldset_label`
--
ALTER TABLE `eav_form_fieldset_label`
  ADD CONSTRAINT `FK_EAV_FORM_FIELDSET_LABEL_FORM_FIELDSET` FOREIGN KEY (`fieldset_id`) REFERENCES `eav_form_fieldset` (`fieldset_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_FORM_FIELDSET_LABEL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_form_type`
--
ALTER TABLE `eav_form_type`
  ADD CONSTRAINT `FK_EAV_FORM_TYPE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `eav_form_type_entity`
--
ALTER TABLE `eav_form_type_entity`
  ADD CONSTRAINT `FK_EAV_FORM_TYPE_ENTITY_ENTITY_TYPE` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EAV_FORM_TYPE_ENTITY_FORM_TYPE` FOREIGN KEY (`type_id`) REFERENCES `eav_form_type` (`type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `googlebase_attributes`
--
ALTER TABLE `googlebase_attributes`
  ADD CONSTRAINT `GOOGLEBASE_ATTRIBUTES_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `GOOGLEBASE_ATTRIBUTES_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `googlebase_types` (`type_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `googlebase_items`
--
ALTER TABLE `googlebase_items`
  ADD CONSTRAINT `GOOGLEBASE_ITEMS_PRODUCT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `GOOGLEBASE_ITEMS_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `googlebase_types`
--
ALTER TABLE `googlebase_types`
  ADD CONSTRAINT `GOOGLEBASE_TYPES_ATTRIBUTE_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `googleoptimizer_code`
--
ALTER TABLE `googleoptimizer_code`
  ADD CONSTRAINT `FK_GOOGLEOPTIMIZER_CODE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `index_process_event`
--
ALTER TABLE `index_process_event`
  ADD CONSTRAINT `FK_INDEX_EVNT_PROCESS` FOREIGN KEY (`event_id`) REFERENCES `index_event` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_INDEX_PROCESS_EVENT` FOREIGN KEY (`process_id`) REFERENCES `index_process` (`process_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `newsletter_problem`
--
ALTER TABLE `newsletter_problem`
  ADD CONSTRAINT `FK_PROBLEM_QUEUE` FOREIGN KEY (`queue_id`) REFERENCES `newsletter_queue` (`queue_id`),
  ADD CONSTRAINT `FK_PROBLEM_SUBSCRIBER` FOREIGN KEY (`subscriber_id`) REFERENCES `newsletter_subscriber` (`subscriber_id`);

--
-- Megkötések a táblához `newsletter_queue`
--
ALTER TABLE `newsletter_queue`
  ADD CONSTRAINT `FK_QUEUE_TEMPLATE` FOREIGN KEY (`template_id`) REFERENCES `newsletter_template` (`template_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `newsletter_queue_link`
--
ALTER TABLE `newsletter_queue_link`
  ADD CONSTRAINT `FK_QUEUE_LINK_QUEUE` FOREIGN KEY (`queue_id`) REFERENCES `newsletter_queue` (`queue_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_QUEUE_LINK_SUBSCRIBER` FOREIGN KEY (`subscriber_id`) REFERENCES `newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `newsletter_queue_store_link`
--
ALTER TABLE `newsletter_queue_store_link`
  ADD CONSTRAINT `FK_LINK_QUEUE` FOREIGN KEY (`queue_id`) REFERENCES `newsletter_queue` (`queue_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_NEWSLETTER_QUEUE_STORE_LINK_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `newsletter_subscriber`
--
ALTER TABLE `newsletter_subscriber`
  ADD CONSTRAINT `FK_NEWSLETTER_SUBSCRIBER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `paypal_cert`
--
ALTER TABLE `paypal_cert`
  ADD CONSTRAINT `FK_PAYPAL_CERT_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `paypal_settlement_report_row`
--
ALTER TABLE `paypal_settlement_report_row`
  ADD CONSTRAINT `FK_PAYPAL_SETTLEMENT_ROW_REPORT` FOREIGN KEY (`report_id`) REFERENCES `paypal_settlement_report` (`report_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `poll`
--
ALTER TABLE `poll`
  ADD CONSTRAINT `FK_POLL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `poll_answer`
--
ALTER TABLE `poll_answer`
  ADD CONSTRAINT `FK_POLL_PARENT` FOREIGN KEY (`poll_id`) REFERENCES `poll` (`poll_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `poll_store`
--
ALTER TABLE `poll_store`
  ADD CONSTRAINT `FK_POLL_STORE_POLL` FOREIGN KEY (`poll_id`) REFERENCES `poll` (`poll_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_POLL_STORE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `poll_vote`
--
ALTER TABLE `poll_vote`
  ADD CONSTRAINT `FK_POLL_ANSWER` FOREIGN KEY (`poll_answer_id`) REFERENCES `poll_answer` (`answer_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `product_alert_price`
--
ALTER TABLE `product_alert_price`
  ADD CONSTRAINT `FK_PRODUCT_ALERT_PRICE_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ALERT_PRICE_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ALERT_PRICE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `product_alert_stock`
--
ALTER TABLE `product_alert_stock`
  ADD CONSTRAINT `FK_PRODUCT_ALERT_STOCK_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ALERT_STOCK_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ALERT_STOCK_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `rating`
--
ALTER TABLE `rating`
  ADD CONSTRAINT `FK_RATING_ENTITY_KEY` FOREIGN KEY (`entity_id`) REFERENCES `rating_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `rating_option`
--
ALTER TABLE `rating_option`
  ADD CONSTRAINT `FK_RATING_OPTION_RATING` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `rating_option_vote`
--
ALTER TABLE `rating_option_vote`
  ADD CONSTRAINT `FK_RATING_OPTION_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_RATING_OPTION_VALUE_OPTION` FOREIGN KEY (`option_id`) REFERENCES `rating_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `rating_option_vote_aggregated`
--
ALTER TABLE `rating_option_vote_aggregated`
  ADD CONSTRAINT `FK_RATING_OPTION_VALUE_AGGREGATE` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_RATING_OPTION_VOTE_AGGREGATED_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `rating_store`
--
ALTER TABLE `rating_store`
  ADD CONSTRAINT `FK_RATING_STORE_RATING` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_RATING_STORE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `rating_title`
--
ALTER TABLE `rating_title`
  ADD CONSTRAINT `FK_RATING_TITLE` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_RATING_TITLE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `report_compared_product_index`
--
ALTER TABLE `report_compared_product_index`
  ADD CONSTRAINT `FK_REPORT_COMPARED_PRODUCT_INDEX_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REPORT_COMPARED_PRODUCT_INDEX_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REPORT_COMPARED_PRODUCT_INDEX_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `report_event`
--
ALTER TABLE `report_event`
  ADD CONSTRAINT `FK_REPORT_EVENT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REPORT_EVENT_TYPE` FOREIGN KEY (`event_type_id`) REFERENCES `report_event_types` (`event_type_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `report_viewed_product_index`
--
ALTER TABLE `report_viewed_product_index`
  ADD CONSTRAINT `FK_REPORT_VIEWED_PRODUCT_INDEX_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REPORT_VIEWED_PRODUCT_INDEX_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REPORT_VIEWED_PRODUCT_INDEX_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `review`
--
ALTER TABLE `review`
  ADD CONSTRAINT `FK_REVIEW_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REVIEW_STATUS` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`);

--
-- Megkötések a táblához `review_detail`
--
ALTER TABLE `review_detail`
  ADD CONSTRAINT `FK_REVIEW_DETAIL_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REVIEW_DETAIL_REVIEW` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REVIEW_DETAIL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
  ADD CONSTRAINT `FK_REVIEW_ENTITY_SUMMARY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `review_store`
--
ALTER TABLE `review_store`
  ADD CONSTRAINT `FK_REVIEW_STORE_REVIEW` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_REVIEW_STORE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `salesrule_coupon`
--
ALTER TABLE `salesrule_coupon`
  ADD CONSTRAINT `FK_SALESRULE_COUPON_RULE_ID_SALESRULE` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `salesrule_coupon_usage`
--
ALTER TABLE `salesrule_coupon_usage`
  ADD CONSTRAINT `FK_SALESRULE_CPN_CUST_CPN_ID_CUST_ENTITY` FOREIGN KEY (`coupon_id`) REFERENCES `salesrule_coupon` (`coupon_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALESRULE_CPN_CUST_CUST_ID_CUST_ENTITY` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `salesrule_customer`
--
ALTER TABLE `salesrule_customer`
  ADD CONSTRAINT `FK_salesrule_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_salesrule_customer_rule` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `salesrule_label`
--
ALTER TABLE `salesrule_label`
  ADD CONSTRAINT `FK_SALESRULE_LABEL_RULE` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALESRULE_LABEL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `salesrule_product_attribute`
--
ALTER TABLE `salesrule_product_attribute`
  ADD CONSTRAINT `FK_SALESRULE_PRODUCT_ATTRIBUTE_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_SALESRULE_PRODUCT_ATTRIBUTE_CUSTOMER_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_SALESRULE_PRODUCT_ATTRIBUTE_RULE` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE;

--
-- Megkötések a táblához `sales_bestsellers_aggregated_daily`
--
ALTER TABLE `sales_bestsellers_aggregated_daily`
  ADD CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_DAILY_PRODUCT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_DAILY_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_bestsellers_aggregated_monthly`
--
ALTER TABLE `sales_bestsellers_aggregated_monthly`
  ADD CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_MONTHLY_PRODUCT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_MONTHLY_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_bestsellers_aggregated_yearly`
--
ALTER TABLE `sales_bestsellers_aggregated_yearly`
  ADD CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_YEARLY_PRODUCT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_YEARLY_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_billing_agreement`
--
ALTER TABLE `sales_billing_agreement`
  ADD CONSTRAINT `FK_BILLING_AGREEMENT_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_BILLING_AGREEMENT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_billing_agreement_order`
--
ALTER TABLE `sales_billing_agreement_order`
  ADD CONSTRAINT `FK_BILLING_AGREEMENT_ORDER_AGREEMENT` FOREIGN KEY (`agreement_id`) REFERENCES `sales_billing_agreement` (`agreement_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_BILLING_AGREEMENT_ORDER_ORDER` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_creditmemo`
--
ALTER TABLE `sales_flat_creditmemo`
  ADD CONSTRAINT `FK_SALES_FLAT_CREDITMEMO_PARENT` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_CREDITMEMO_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_creditmemo_comment`
--
ALTER TABLE `sales_flat_creditmemo_comment`
  ADD CONSTRAINT `FK_SALES_FLAT_CREDITMEMO_COMMENT_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_creditmemo` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_creditmemo_grid`
--
ALTER TABLE `sales_flat_creditmemo_grid`
  ADD CONSTRAINT `FK_SALES_FLAT_CREDITMEMO_GRID_PARENT` FOREIGN KEY (`entity_id`) REFERENCES `sales_flat_creditmemo` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_CREDITMEMO_GRID_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_creditmemo_item`
--
ALTER TABLE `sales_flat_creditmemo_item`
  ADD CONSTRAINT `FK_SALES_FLAT_CREDITMEMO_ITEM_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_creditmemo` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_invoice`
--
ALTER TABLE `sales_flat_invoice`
  ADD CONSTRAINT `FK_SALES_FLAT_INVOICE_PARENT` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_INVOICE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_invoice_comment`
--
ALTER TABLE `sales_flat_invoice_comment`
  ADD CONSTRAINT `FK_SALES_FLAT_INVOICE_COMMENT_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_invoice` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_invoice_grid`
--
ALTER TABLE `sales_flat_invoice_grid`
  ADD CONSTRAINT `FK_SALES_FLAT_INVOICE_GRID_PARENT` FOREIGN KEY (`entity_id`) REFERENCES `sales_flat_invoice` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_INVOICE_GRID_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_invoice_item`
--
ALTER TABLE `sales_flat_invoice_item`
  ADD CONSTRAINT `FK_SALES_FLAT_INVOICE_ITEM_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_invoice` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_order`
--
ALTER TABLE `sales_flat_order`
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_order_address`
--
ALTER TABLE `sales_flat_order_address`
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_ADDRESS_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_order_grid`
--
ALTER TABLE `sales_flat_order_grid`
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_GRID_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_GRID_PARENT` FOREIGN KEY (`entity_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_GRID_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_order_item`
--
ALTER TABLE `sales_flat_order_item`
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_ITEM_PARENT` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_ITEM_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_order_payment`
--
ALTER TABLE `sales_flat_order_payment`
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_PAYMENT_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_order_status_history`
--
ALTER TABLE `sales_flat_order_status_history`
  ADD CONSTRAINT `FK_SALES_FLAT_ORDER_STATUS_HISTORY_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote`
--
ALTER TABLE `sales_flat_quote`
  ADD CONSTRAINT `FK_SALES_QUOTE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote_address`
--
ALTER TABLE `sales_flat_quote_address`
  ADD CONSTRAINT `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote_address_item`
--
ALTER TABLE `sales_flat_quote_address_item`
  ADD CONSTRAINT `FK_QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS` FOREIGN KEY (`quote_address_id`) REFERENCES `sales_flat_quote_address` (`address_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_QUOTE_ADDRESS_ITEM_PARENT` FOREIGN KEY (`parent_item_id`) REFERENCES `sales_flat_quote_address_item` (`address_item_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_QUOTE_ADDRESS_ITEM_QUOTE_ITEM` FOREIGN KEY (`quote_item_id`) REFERENCES `sales_flat_quote_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote_item`
--
ALTER TABLE `sales_flat_quote_item`
  ADD CONSTRAINT `FK_SALES_FLAT_QUOTE_ITEM_PARENT_ITEM` FOREIGN KEY (`parent_item_id`) REFERENCES `sales_flat_quote_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_QUOTE_ITEM_CATALOG_PRODUCT_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_QUOTE_ITEM_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_QUOTE_ITEM_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote_item_option`
--
ALTER TABLE `sales_flat_quote_item_option`
  ADD CONSTRAINT `FK_SALES_QUOTE_ITEM_OPTION_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `sales_flat_quote_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote_payment`
--
ALTER TABLE `sales_flat_quote_payment`
  ADD CONSTRAINT `FK_SALES_QUOTE_PAYMENT_SALES_QUOTE` FOREIGN KEY (`quote_id`) REFERENCES `sales_flat_quote` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_quote_shipping_rate`
--
ALTER TABLE `sales_flat_quote_shipping_rate`
  ADD CONSTRAINT `FK_SALES_QUOTE_SHIPPING_RATE_ADDRESS` FOREIGN KEY (`address_id`) REFERENCES `sales_flat_quote_address` (`address_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_shipment`
--
ALTER TABLE `sales_flat_shipment`
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_PARENT` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_shipment_comment`
--
ALTER TABLE `sales_flat_shipment_comment`
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_COMMENT_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_shipment` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_shipment_grid`
--
ALTER TABLE `sales_flat_shipment_grid`
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_GRID_PARENT` FOREIGN KEY (`entity_id`) REFERENCES `sales_flat_shipment` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_GRID_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_shipment_item`
--
ALTER TABLE `sales_flat_shipment_item`
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_ITEM_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_shipment` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_flat_shipment_track`
--
ALTER TABLE `sales_flat_shipment_track`
  ADD CONSTRAINT `FK_SALES_FLAT_SHIPMENT_TRACK_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_flat_shipment` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_invoiced_aggregated`
--
ALTER TABLE `sales_invoiced_aggregated`
  ADD CONSTRAINT `FK_SALES_INVOICED_AGGREGATED_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_invoiced_aggregated_order`
--
ALTER TABLE `sales_invoiced_aggregated_order`
  ADD CONSTRAINT `FK_SALES_INVOICED_AGGREGATED_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_order_aggregated_created`
--
ALTER TABLE `sales_order_aggregated_created`
  ADD CONSTRAINT `FK_SALES_ORDER_AGGREGATED_CREATED` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_order_status_label`
--
ALTER TABLE `sales_order_status_label`
  ADD CONSTRAINT `FK_SALES_ORDER_STATUS_LABEL_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_ORDER_STATUS_LABEL_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_order_status_state`
--
ALTER TABLE `sales_order_status_state`
  ADD CONSTRAINT `FK_SALES_ORDER_STATUS_STATE_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_payment_transaction`
--
ALTER TABLE `sales_payment_transaction`
  ADD CONSTRAINT `FK_SALES_PAYMENT_TRANSACTION_ORDER` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_PAYMENT_TRANSACTION_PARENT` FOREIGN KEY (`parent_id`) REFERENCES `sales_payment_transaction` (`transaction_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_SALES_PAYMENT_TRANSACTION_PAYMENT` FOREIGN KEY (`payment_id`) REFERENCES `sales_flat_order_payment` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_recurring_profile`
--
ALTER TABLE `sales_recurring_profile`
  ADD CONSTRAINT `FK_RECURRING_PROFILE_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_RECURRING_PROFILE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_recurring_profile_order`
--
ALTER TABLE `sales_recurring_profile_order`
  ADD CONSTRAINT `FK_RECURRING_PROFILE_ORDER_ORDER` FOREIGN KEY (`order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_RECURRING_PROFILE_ORDER_PROFILE` FOREIGN KEY (`profile_id`) REFERENCES `sales_recurring_profile` (`profile_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_refunded_aggregated`
--
ALTER TABLE `sales_refunded_aggregated`
  ADD CONSTRAINT `FK_SALES_REFUNDED_AGGREGATED_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_refunded_aggregated_order`
--
ALTER TABLE `sales_refunded_aggregated_order`
  ADD CONSTRAINT `FK_SALES_REFUNDED_AGGREGATED_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_shipping_aggregated`
--
ALTER TABLE `sales_shipping_aggregated`
  ADD CONSTRAINT `FK_SALES_SHIPPING_AGGREGATED_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sales_shipping_aggregated_order`
--
ALTER TABLE `sales_shipping_aggregated_order`
  ADD CONSTRAINT `FK_SALES_SHIPPING_AGGREGATED_ORDER_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Megkötések a táblához `sitemap`
--
ALTER TABLE `sitemap`
  ADD CONSTRAINT `FK_SITEMAP_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `tag_properties`
--
ALTER TABLE `tag_properties`
  ADD CONSTRAINT `FK_TAG_PROPERTIES_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAG_PROPERTIES_TAG` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `tag_relation`
--
ALTER TABLE `tag_relation`
  ADD CONSTRAINT `FK_TAG_RELATION_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAG_RELATION_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAG_RELATION_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAG_RELATION_TAG` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `tag_summary`
--
ALTER TABLE `tag_summary`
  ADD CONSTRAINT `FK_TAG_SUMMARY_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAG_SUMMARY_TAG` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `tax_calculation`
--
ALTER TABLE `tax_calculation`
  ADD CONSTRAINT `FK_TAX_CALCULATION_CTC` FOREIGN KEY (`customer_tax_class_id`) REFERENCES `tax_class` (`class_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAX_CALCULATION_PTC` FOREIGN KEY (`product_tax_class_id`) REFERENCES `tax_class` (`class_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAX_CALCULATION_RATE` FOREIGN KEY (`tax_calculation_rate_id`) REFERENCES `tax_calculation_rate` (`tax_calculation_rate_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAX_CALCULATION_RULE` FOREIGN KEY (`tax_calculation_rule_id`) REFERENCES `tax_calculation_rule` (`tax_calculation_rule_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `tax_calculation_rate_title`
--
ALTER TABLE `tax_calculation_rate_title`
  ADD CONSTRAINT `FK_TAX_CALCULATION_RATE_TITLE_RATE` FOREIGN KEY (`tax_calculation_rate_id`) REFERENCES `tax_calculation_rate` (`tax_calculation_rate_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_TAX_CALCULATION_RATE_TITLE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `tax_order_aggregated_created`
--
ALTER TABLE `tax_order_aggregated_created`
  ADD CONSTRAINT `FK_TAX_ORDER_AGGREGATED_CREATED_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `weee_discount`
--
ALTER TABLE `weee_discount`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_WEEE_DISCOUNT_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_WEEE_DISCOUNT_PRODUCT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_WEEE_DISCOUNT_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `weee_tax`
--
ALTER TABLE `weee_tax`
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_WEEE_TAX_COUNTRY` FOREIGN KEY (`country`) REFERENCES `directory_country` (`country_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_WEEE_TAX_PRODUCT_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_WEEE_TAX_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_WEEE_TAX_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `widget_instance_page`
--
ALTER TABLE `widget_instance_page`
  ADD CONSTRAINT `FK_WIDGET_WIDGET_INSTANCE_ID` FOREIGN KEY (`instance_id`) REFERENCES `widget_instance` (`instance_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `widget_instance_page_layout`
--
ALTER TABLE `widget_instance_page_layout`
  ADD CONSTRAINT `FK_WIDGET_WIDGET_INSTANCE_LAYOUT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `core_layout_update` (`layout_update_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_WIDGET_WIDGET_INSTANCE_PAGE_ID` FOREIGN KEY (`page_id`) REFERENCES `widget_instance_page` (`page_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `wishlist`
--
ALTER TABLE `wishlist`
  ADD CONSTRAINT `FK_WISHLIST_CUSTOMER` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `wishlist_item`
--
ALTER TABLE `wishlist_item`
  ADD CONSTRAINT `FK_WISHLIST_ITEM_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_WISHLIST_ITEM_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_WISHLIST_ITEM_WISHLIST` FOREIGN KEY (`wishlist_id`) REFERENCES `wishlist` (`wishlist_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `wishlist_item_option`
--
ALTER TABLE `wishlist_item_option`
  ADD CONSTRAINT `FK_WISHLIST_ITEM_OPTION_ITEM_ID` FOREIGN KEY (`wishlist_item_id`) REFERENCES `wishlist_item` (`wishlist_item_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `xmlconnect_application`
--
ALTER TABLE `xmlconnect_application`
  ADD CONSTRAINT `FK_XMLCONNECT_APPLICAION_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Megkötések a táblához `xmlconnect_history`
--
ALTER TABLE `xmlconnect_history`
  ADD CONSTRAINT `FK_XMLCONNECT_HISTORY_APPLICATION` FOREIGN KEY (`application_id`) REFERENCES `xmlconnect_application` (`application_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `xmlconnect_notification_template`
--
ALTER TABLE `xmlconnect_notification_template`
  ADD CONSTRAINT `FK_APP_CODE` FOREIGN KEY (`app_code`) REFERENCES `xmlconnect_application` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Megkötések a táblához `xmlconnect_queue`
--
ALTER TABLE `xmlconnect_queue`
  ADD CONSTRAINT `FK_TEMPLATE_ID` FOREIGN KEY (`template_id`) REFERENCES `xmlconnect_notification_template` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
