Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Custom Computer Creator (CCC) Database entry help


zorrac

Recommended Posts

In the CCC READ (Directions).htm, there is a list of code that creates tables. How do I apply this code to my database?

 

Reference:

CREATE TABLE `ccc_cat` (
 `cat_id` int(11) NOT NULL auto_increment,
 `status` tinyint(2) NOT NULL default '1',
 `cat_req` tinyint(2) NOT NULL default '0',
 `sort_order` int(11) NOT NULL default '0',
 `sys_id` int(11) NOT NULL default '0',
 `fsb_id` int(11) NOT NULL default '0',
 KEY `cat_id` (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=5;

#
# Dumping data for table `ccc_cat`
#

INSERT INTO `ccc_cat` VALUES (4, 1, 0, 1, 5, 5);
INSERT INTO `ccc_cat` VALUES (4, 1, 0, 1, 5, 6);

# --------------------------------------------------------

#
# Table structure for table `ccc_cat_description`
#

CREATE TABLE `ccc_cat_description` (
 `cat_id` int(11) NOT NULL default '0',
 `cat_name` varchar(64) NOT NULL default '',
 `cat_description` text NOT NULL,
 `language_id` int(11) NOT NULL default '1'
) TYPE=MyISAM;

#
# Dumping data for table `ccc_cat_description`
#

INSERT INTO `ccc_cat_description` VALUES (4, 'Motherboards', 'Motherboard For The Computer', 1);
INSERT INTO `ccc_cat_description` VALUES (4, 'Motherboards', 'Motherboard For The Computer', 2);
INSERT INTO `ccc_cat_description` VALUES (4, 'Motherboards', 'Motherboard For The Computer', 3);

# --------------------------------------------------------

#
# Table structure for table `ccc_config`
#

CREATE TABLE `ccc_config` (
 `ccc_config_id` int(11) NOT NULL auto_increment,
 `config_name` varchar(254) NOT NULL default '',
 `config_value` varchar(254) NOT NULL default '',
 `config_desc` varchar(254) NOT NULL default '',
 PRIMARY KEY  (`ccc_config_id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=16;

#
# Dumping data for table `ccc_config`
#

INSERT INTO `ccc_config` VALUES (1, 'ccc_dpic', '', 'Default Image For Custom Computers');
INSERT INTO `ccc_config` VALUES (2, 'quantity', '2', 'Default Quantity For Custom Computers');
INSERT INTO `ccc_config` VALUES (3, 'status', '0', 'Default Status of Custom Computers');
INSERT INTO `ccc_config` VALUES (5, 'cur_symbol', '$', 'Currency Symbol For CCC');
INSERT INTO `ccc_config` VALUES (6, 'ccc_tax_class', '1', 'Tax Rate For CCC');
INSERT INTO `ccc_config` VALUES (8, 'show_build', 'n', 'Show Option To Build Computers (build.php)');
INSERT INTO `ccc_config` VALUES (9, 'show_warranty', 'y', 'Show Optional Warranty For CCC (build.php)');
INSERT INTO `ccc_config` VALUES (10, 'warranty_price', '60.00', 'Default Warranty Cost');
INSERT INTO `ccc_config` VALUES (11, 'build_price', '60.00', 'Default Build Price');
INSERT INTO `ccc_config` VALUES (13, 'pond', 'y', 'Pictures On By Default');
INSERT INTO `ccc_config` VALUES (14, 'CCC_WARRANTY_TAXABLE', 'true', 'Is The CCC Warranty Taxable?');
INSERT INTO `ccc_config` VALUES (15, 'CCC_BUILD_TAXABLE', 'true', 'Is CCC Build Price Taxable?');

# --------------------------------------------------------

#
# Table structure for table `ccc_fsb`
#

CREATE TABLE `ccc_fsb` (
 `fsb_id` int(11) NOT NULL auto_increment,
 `status` tinyint(2) NOT NULL default '1',
 `sort_order` mediumint(11) NOT NULL default '0',
 `sys_id` int(11) NOT NULL default '0',
 KEY `fsb_id` (`fsb_id`)
) TYPE=MyISAM AUTO_INCREMENT=7;

#
# Dumping data for table `ccc_fsb`
#

INSERT INTO `ccc_fsb` VALUES (6, 1, 2, 5);
INSERT INTO `ccc_fsb` VALUES (5, 1, 1, 5);

# --------------------------------------------------------

#
# Table structure for table `ccc_fsb_description`
#

CREATE TABLE `ccc_fsb_description` (
 `fsb_id` int(11) NOT NULL default '0',
 `fsb_name` varchar(64) NOT NULL default '',
 `fsb_description` text NOT NULL,
 `status` tinyint(2) NOT NULL default '1',
 `language_id` int(11) NOT NULL default '1'
) TYPE=MyISAM;

#
# Dumping data for table `ccc_fsb_description`
#

INSERT INTO `ccc_fsb_description` VALUES (6, 'Amd Xp 3600', '', 1, 3);
INSERT INTO `ccc_fsb_description` VALUES (5, 'Amd Xp 3500', 'Super Fast', 1, 3);
INSERT INTO `ccc_fsb_description` VALUES (6, 'Amd Xp 3600', '', 1, 1);
INSERT INTO `ccc_fsb_description` VALUES (6, 'Amd Xp 3600', '', 1, 2);
INSERT INTO `ccc_fsb_description` VALUES (5, 'Amd Xp 3500', 'Super Fast', 1, 1);
INSERT INTO `ccc_fsb_description` VALUES (5, 'Amd Xp 3500', 'Super Fast', 1, 2);

# --------------------------------------------------------

#
# Table structure for table `ccc_pending`
#

CREATE TABLE `ccc_pending` (
 `orders_id` varchar(9) NOT NULL default '',
 `orders_status` varchar(4) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `ccc_pending`
#


# --------------------------------------------------------

#
# Table structure for table `ccc_prod`
#

CREATE TABLE `ccc_prod` (
 `product_id` int(11) NOT NULL auto_increment,
 `osc_prod_id` int(11) NOT NULL default '0',
 `cat_id` int(11) NOT NULL default '0',
 `fsb_id` int(11) NOT NULL default '0',
 `sort_order` int(11) NOT NULL default '0',
 `default_prod` tinyint(2) NOT NULL default '0',
 KEY `product_id` (`product_id`)
) TYPE=MyISAM AUTO_INCREMENT=13;

#
# Dumping data for table `ccc_prod`
#

INSERT INTO `ccc_prod` VALUES (5, 6, 4, 5, 2, 0);
INSERT INTO `ccc_prod` VALUES (4, 4, 4, 5, 1, 0);
INSERT INTO `ccc_prod` VALUES (6, 9, 4, 5, 3, 0);
INSERT INTO `ccc_prod` VALUES (7, 10, 4, 5, 4, 0);
INSERT INTO `ccc_prod` VALUES (8, 11, 4, 5, 5, 0);
INSERT INTO `ccc_prod` VALUES (9, 12, 4, 5, 6, 0);
INSERT INTO `ccc_prod` VALUES (10, 13, 4, 5, 7, 0);
INSERT INTO `ccc_prod` VALUES (11, 17, 4, 5, 8, 1);
INSERT INTO `ccc_prod` VALUES (12, 18, 4, 5, 9, 0);

# --------------------------------------------------------

#
# Table structure for table `ccc_system_edit`
#

CREATE TABLE `ccc_system_edit` (
 `products_id` int(11) NOT NULL default '0',
 `products_included` text NOT NULL,
 `products_build` tinyint(2) NOT NULL default '0',
 `products_warranty` tinyint(2) NOT NULL default '0',
 `products_systype` varchar(64) NOT NULL default '',
 `products_fsb` varchar(64) NOT NULL default '',
 KEY `products_id` (`products_id`)
) TYPE=MyISAM;

#
# Dumping data for table `ccc_system_edit`
#


# --------------------------------------------------------

#
# Table structure for table `ccc_systems`
#

CREATE TABLE `ccc_systems` (
 `sys_id` int(11) NOT NULL auto_increment,
 `sort_order` int(11) NOT NULL default '0',
 `status` tinyint(2) NOT NULL default '1',
 KEY `sys_id` (`sys_id`)
) TYPE=MyISAM AUTO_INCREMENT=6;

#
# Dumping data for table `ccc_systems`
#

INSERT INTO `ccc_systems` VALUES (5, 1, 1);
INSERT INTO `ccc_systems` VALUES (2, 2, 1);

# --------------------------------------------------------

#
# Table structure for table `ccc_systems_description`
#

CREATE TABLE `ccc_systems_description` (
 `sys_id` int(11) NOT NULL default '0',
 `sys_name` varchar(64) NOT NULL default '',
 `sys_description` text NOT NULL,
 `language_id` int(11) NOT NULL default '1'
) TYPE=MyISAM;

#
# Dumping data for table `ccc_systems_description`
#

INSERT INTO `ccc_systems_description` VALUES (5, 'Amd Super System', 'Nice Amd System', 3);
INSERT INTO `ccc_systems_description` VALUES (5, 'Amd Super System', 'Nice Amd System', 1);
INSERT INTO `ccc_systems_description` VALUES (5, 'Amd Super System', 'Nice Amd System', 2);
INSERT INTO `ccc_systems_description` VALUES (2, 'Intel Super System', 'This Is The Second Description For CCC\'s New System Description Capability.', 1);
INSERT INTO `ccc_systems_description` VALUES (2, 'Intel Super System', 'This Is The Second Description For CCC\'s New System Description Capability', 2);
INSERT INTO `ccc_systems_description` VALUES (2, 'Intel Super System', 'This Is The Second Description For CCC\'s New System Description Capability', 3);

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...