Форум программистов [Powered by Invision Power Board]

Код


CREATE TABLE IF NOT EXISTS `details` (
  `detail_id` int(11) NOT NULL auto_increment,
  `detail_name` varchar(150) character set cp1251 NOT NULL,
  `specification_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY  (`detail_name`,`specification_id`,`product_id`),
  KEY `detail_id` (`detail_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_name` varchar(150) character set cp1251 NOT NULL,
  `product_desc` text character set cp1251 NOT NULL,
  `product_simg` varchar(35) character set cp1251 NOT NULL,
  `category_id` int(11) default NULL,
  PRIMARY KEY  (`product_id`),
  UNIQUE KEY `product_link` (`product_link`),
  UNIQUE KEY `product_name` (`product_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `specifications`
--

CREATE TABLE IF NOT EXISTS `specifications` (
  `specification_id` int(11) NOT NULL auto_increment,
  `specification_name` varchar(150) character set cp1251 NOT NULL,
  `parent_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`specification_name`,`parent_id`),
  KEY `specification_id` (`specification_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Цитата

innodb_additional_mem_pool_size    2097152
innodb_autoextend_increment    8
innodb_buffer_pool_awe_mem_mb    0
innodb_buffer_pool_size    49283072
innodb_checksums    ON
innodb_commit_concurrency    0
innodb_concurrency_tickets    500
innodb_data_file_path    ibdata1:10M:autoextend
innodb_data_home_dir
innodb_doublewrite    ON
innodb_fast_shutdown    1
innodb_file_io_threads    4
innodb_file_per_table    OFF
innodb_flush_log_at_trx_commit    1
innodb_flush_method
innodb_force_recovery    0
innodb_lock_wait_timeout    50
innodb_locks_unsafe_for_binlog    OFF
innodb_log_arch_dir
innodb_log_archive    OFF
innodb_log_buffer_size    130023424
innodb_log_file_size    178257920
innodb_log_files_in_group    2
innodb_log_group_home_dir    .\
innodb_max_dirty_pages_pct    90
innodb_max_purge_lag    0
innodb_mirrored_log_groups    1
innodb_open_files    300
innodb_rollback_on_timeout    OFF
innodb_support_xa    ON
innodb_sync_spin_loops    20
innodb_table_locks    ON
innodb_thread_concurrency    8
innodb_thread_sleep_delay    10000