First version of cupcart entities tables

gistfile1.sql

-- phpMyAdmin SQL Dump
-- version 3.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 10, 2012 at 09:39 PM
-- Server version: 5.0.84
-- PHP Version: 5.3.8-pl0-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `cupcart`
--

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

--
-- Table structure for table `cup_entities`
--

CREATE TABLE IF NOT EXISTS `cup_entities` (
  `revisionId` int(11) NOT NULL auto_increment,
  `guid` int(10) unsigned NOT NULL,
  `revisionStatus` tinyint(3) unsigned NOT NULL,
  `authorGuid` int(10) unsigned NOT NULL,
  `authoredDateTime` int(10) unsigned NOT NULL,
  `entityType` varchar(64) NOT NULL,
  PRIMARY KEY  (`revisionId`),
  KEY `entityType` (`entityType`),
  KEY `guid` (`guid`),
  KEY `revisionStatus` (`revisionStatus`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `cup_entities`
--

INSERT INTO `cup_entities` (`revisionId`, `guid`, `revisionStatus`, `authorGuid`, `authoredDateTime`, `entityType`) VALUES
(7, 1, 2, 1, 1340602866, 'Product'),
(8, 2, 2, 1, 1340603054, 'Product'),
(9, 3, 1, 1, 1340672385, 'Taxonomy'),
(10, 4, 1, 1, 1340672385, 'Taxonomy'),
(11, 5, 1, 1, 1340673843, 'TaxonomyTerm'),
(12, 6, 1, 0, 0, 'TaxonomyTerm'),
(19, 2, 1, 1, 1340603054, 'Product'),
(18, 1, 2, 1, 1340602866, 'Product'),
(21, 1, 2, 1, 1340602866, 'Product'),
(22, 1, 2, 1, 1340602866, 'Product'),
(23, 1, 2, 1, 1340602866, 'Product'),
(24, 1, 2, 1, 1340602866, 'Product'),
(25, 1, 2, 1, 1340602866, 'Product'),
(26, 1, 2, 1, 1340602866, 'Product'),
(27, 1, 2, 1, 1340602866, 'Product'),
(28, 1, 1, 1, 1340602866, 'Product'),
(29, 7, 1, 0, 0, 'Product'),
(30, 8, 1, 0, 0, 'TaxonomyTerm'),
(31, 9, 1, 0, 0, 'TaxonomyTerm'),
(32, 10, 1, 0, 0, 'TaxonomyTerm'),
(33, 11, 1, 0, 0, 'TaxonomyTerm'),
(34, 12, 1, 0, 0, 'TaxonomyTerm'),
(35, 13, 1, 0, 0, 'TaxonomyTerm'),
(36, 14, 1, 0, 0, 'TaxonomyTerm'),
(37, 15, 1, 0, 0, 'TaxonomyTerm'),
(38, 16, 1, 0, 0, 'TaxonomyTerm'),
(39, 17, 1, 0, 0, 'TaxonomyTerm'),
(40, 18, 1, 0, 0, 'TaxonomyTerm');

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

--
-- Table structure for table `cup_entities_meta`
--

CREATE TABLE IF NOT EXISTS `cup_entities_meta` (
  `metaId` int(10) unsigned NOT NULL auto_increment,
  `entityGuid` int(10) unsigned NOT NULL,
  `entityRevision` int(11) NOT NULL,
  `autoload` tinyint(4) NOT NULL,
  `metaKey` int(10) unsigned NOT NULL,
  `metaValue` text NOT NULL,
  PRIMARY KEY  (`metaId`),
  FULLTEXT KEY `metaValue` (`metaValue`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=163 ;

--
-- Dumping data for table `cup_entities_meta`
--

INSERT INTO `cup_entities_meta` (`metaId`, `entityGuid`, `entityRevision`, `autoload`, `metaKey`, `metaValue`) VALUES
(1, 1, 18, 0, 1, '1'),
(2, 2, 8, 0, 1, '1'),
(3, 1, 7, 1, 3, 'Full Computer A'),
(4, 2, 8, 1, 3, 'Full Computer B'),
(5, 3, 9, 1, 3, 'Category'),
(6, 4, 10, 1, 3, 'Tag'),
(127, 5, 11, 1, 3, 'Computer Hardware'),
(126, 5, 11, 1, 4, '3'),
(129, 6, 12, 1, 3, 'Memory'),
(11, 1, 7, 1, 5, '5'),
(12, 2, 8, 1, 5, '5'),
(13, 1, 7, 1, 5, '6'),
(14, 2, 8, 1, 5, '6'),
(15, 1, 18, 0, 2, '1'),
(16, 2, 8, 0, 2, '1'),
(20, 1, 18, 1, 5, '5'),
(19, 1, 18, 1, 3, 'Full Computer A'),
(21, 1, 18, 1, 5, '6'),
(22, 2, 19, 1, 3, 'Full Computer B'),
(23, 2, 19, 1, 5, '5'),
(24, 2, 19, 1, 5, '6'),
(35, 1, 21, 1, 3, 'Full Computer A'),
(34, 1, 21, 0, 1, '1'),
(33, 1, 21, 0, 2, '1'),
(36, 1, 21, 1, 5, '5'),
(37, 1, 21, 1, 5, '6'),
(47, 1, 22, 1, 5, '6'),
(46, 1, 22, 1, 5, '5'),
(45, 1, 22, 1, 3, 'Full Computer A'),
(44, 1, 22, 0, 2, '1'),
(43, 1, 22, 0, 1, '1'),
(56, 1, 23, 1, 5, '6'),
(55, 1, 23, 1, 3, 'I changed it again!'),
(54, 1, 23, 0, 1, '1'),
(53, 1, 23, 0, 2, '1'),
(57, 1, 23, 1, 5, '5'),
(66, 1, 24, 1, 5, '6'),
(65, 1, 24, 1, 3, 'I changed it again!'),
(64, 1, 24, 0, 2, '1'),
(63, 1, 24, 0, 1, '1'),
(67, 1, 24, 1, 5, '5'),
(68, 1, 25, 0, 2, '1'),
(69, 1, 25, 0, 1, '1'),
(70, 1, 25, 1, 3, 'I changed this'),
(71, 1, 25, 1, 5, '6'),
(72, 1, 25, 1, 5, '5'),
(73, 1, 26, 0, 2, '1'),
(74, 1, 26, 0, 1, '1'),
(75, 1, 26, 1, 3, 'I changed this'),
(76, 1, 26, 1, 5, '6'),
(77, 1, 26, 1, 5, '5'),
(78, 1, 27, 0, 2, '1'),
(79, 1, 27, 0, 1, '1'),
(80, 1, 27, 1, 3, 'I changed this'),
(81, 1, 27, 1, 5, '6'),
(82, 1, 27, 1, 5, '5'),
(83, 1, 28, 0, 2, '1'),
(84, 1, 28, 0, 1, '1'),
(85, 1, 28, 1, 3, 'I changed this'),
(86, 1, 28, 1, 5, '6'),
(87, 1, 28, 1, 5, '5'),
(88, 7, 29, 1, 3, 'Hello World'),
(122, 7, 29, 0, 17, 'two'),
(121, 7, 29, 0, 17, 'one'),
(128, 6, 12, 1, 4, '3'),
(130, 6, 12, 1, 18, '5'),
(131, 8, 30, 1, 4, '3'),
(132, 8, 30, 1, 3, 'Input Devices (Keyboards & Mice)'),
(133, 8, 30, 1, 18, '5'),
(134, 9, 31, 1, 4, '3'),
(135, 9, 31, 1, 3, 'Monitors and Displays'),
(136, 9, 31, 1, 18, '5'),
(137, 10, 32, 1, 4, '3'),
(138, 10, 32, 1, 3, 'Hard Disk Drives'),
(139, 10, 32, 1, 18, '5'),
(140, 11, 33, 1, 4, '3'),
(141, 11, 33, 1, 3, 'Motherboards'),
(142, 11, 33, 1, 18, '5'),
(143, 12, 34, 1, 4, '3'),
(144, 12, 34, 1, 3, 'Graphics Cards'),
(145, 12, 34, 1, 18, '5'),
(146, 13, 35, 1, 4, '3'),
(147, 13, 35, 1, 3, 'Sound Cards'),
(148, 13, 35, 1, 18, '5'),
(149, 14, 36, 1, 4, '3'),
(150, 14, 36, 1, 3, 'Processors (CPUs)'),
(151, 14, 36, 1, 18, '5'),
(152, 15, 37, 1, 4, '3'),
(153, 15, 37, 1, 3, 'Cooling'),
(154, 15, 37, 1, 18, '5'),
(155, 16, 38, 1, 4, '3'),
(156, 16, 38, 1, 3, 'Office Equipment'),
(157, 17, 39, 1, 4, '3'),
(158, 17, 39, 1, 3, 'Desks'),
(159, 17, 39, 1, 18, '16'),
(160, 18, 40, 1, 4, '3'),
(161, 18, 40, 1, 3, 'Chairs'),
(162, 18, 40, 1, 18, '16');

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

--
-- Table structure for table `cup_entities_metakeys`
--

CREATE TABLE IF NOT EXISTS `cup_entities_metakeys` (
  `metaKey` int(10) unsigned NOT NULL auto_increment,
  `metaKeyName` varchar(32) NOT NULL,
  PRIMARY KEY  (`metaKey`),
  KEY `metaKeyName` (`metaKeyName`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `cup_entities_metakeys`
--

INSERT INTO `cup_entities_metakeys` (`metaKey`, `metaKeyName`) VALUES
(1, 'isSpecial'),
(2, 'isPromoted'),
(3, 'name'),
(4, 'taxonomyGuid'),
(5, 'belongsToTaxonomies'),
(6, 'price'),
(7, 'description'),
(8, 'serialNumber'),
(9, 'inStock'),
(10, 'reservedStock'),
(18, 'parent'),
(17, 'testing');