# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generatie Tijd: 21 Oct 2004 om 09:14
# Server versie: 4.0.20
# PHP Versie: 4.3.8
# 
# Database : `san_data04`
# 

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

#
# Tabel structuur voor tabel `san_product_files_lnk`
#

CREATE TABLE `san_product_files_lnk` (
  `product_id` int(11) NOT NULL default '0',
  `file_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`product_id`,`file_id`)
) TYPE=MyISAM;

#
# Gegevens worden uitgevoerd voor tabel `san_product_files_lnk`
#

INSERT INTO `san_product_files_lnk` VALUES (11, 19);
INSERT INTO `san_product_files_lnk` VALUES (12, 33);
INSERT INTO `san_product_files_lnk` VALUES (13, 24);
INSERT INTO `san_product_files_lnk` VALUES (22, 41);

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

#
# Tabel structuur voor tabel `san_product_group`
#

CREATE TABLE `san_product_group` (
  `id` int(11) NOT NULL auto_increment,
  `c_name_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Gegevens worden uitgevoerd voor tabel `san_product_group`
#

INSERT INTO `san_product_group` VALUES (1, 1);
INSERT INTO `san_product_group` VALUES (2, 2);
INSERT INTO `san_product_group` VALUES (3, 3);
INSERT INTO `san_product_group` VALUES (4, 4);

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

#
# Tabel structuur voor tabel `san_product_images_lnk`
#

CREATE TABLE `san_product_images_lnk` (
  `product_id` int(11) NOT NULL default '0',
  `file_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`product_id`,`file_id`)
) TYPE=MyISAM;

#
# Gegevens worden uitgevoerd voor tabel `san_product_images_lnk`
#

INSERT INTO `san_product_images_lnk` VALUES (11, 16);
INSERT INTO `san_product_images_lnk` VALUES (22, 43);
INSERT INTO `san_product_images_lnk` VALUES (32, 44);
INSERT INTO `san_product_images_lnk` VALUES (34, 34);
INSERT INTO `san_product_images_lnk` VALUES (35, 35);
INSERT INTO `san_product_images_lnk` VALUES (36, 36);
INSERT INTO `san_product_images_lnk` VALUES (37, 37);
INSERT INTO `san_product_images_lnk` VALUES (38, 38);
INSERT INTO `san_product_images_lnk` VALUES (39, 39);
INSERT INTO `san_product_images_lnk` VALUES (40, 40);
INSERT INTO `san_product_images_lnk` VALUES (41, 45);

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

#
# Tabel structuur voor tabel `san_product_item`
#

CREATE TABLE `san_product_item` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL default '0',
  `c_name_id` int(11) NOT NULL default '0',
  `c_intro_id` int(11) NOT NULL default '0',
  `c_content_id` int(11) NOT NULL default '0',
  `order` int(11) NOT NULL default '0',
  `price` float(6,2) NOT NULL default '0.00',
  `code` varchar(255) NOT NULL default '',
  `date` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=42 ;

#
# Gegevens worden uitgevoerd voor tabel `san_product_item`
#

INSERT INTO `san_product_item` VALUES (11, 1, 78, 79, 80, 5, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (12, 6, 82, 83, 84, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (13, 6, 85, 86, 87, 2, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (16, 7, 96, 97, 98, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (23, 14, 123, 124, 125, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (17, 9, 102, 103, 104, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (18, 9, 105, 106, 107, 2, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (19, 10, 108, 109, 110, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (20, 11, 111, 112, 113, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (21, 12, 116, 117, 118, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (22, 13, 119, 120, 121, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (24, 15, 127, 128, 129, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (25, 16, 131, 132, 133, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (26, 18, 137, 138, 139, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (27, 17, 140, 141, 142, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (28, 19, 143, 144, 145, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (31, 20, 153, 154, 155, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (32, 7, 156, 157, 158, 2, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (33, 1, 159, 160, 161, 6, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (34, 22, 167, 168, 169, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (35, 18, 170, 171, 172, 2, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (36, 21, 173, 174, 175, 1, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (37, 17, 176, 177, 178, 5, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (38, 17, 179, 180, 181, 4, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (39, 17, 182, 183, 184, 3, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (40, 17, 185, 186, 187, 2, '0.00', '', -1);
INSERT INTO `san_product_item` VALUES (41, 27, 190, 191, 192, 1, '0.00', '', -1);

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

#
# Tabel structuur voor tabel `san_product_shop_lnk`
#

CREATE TABLE `san_product_shop_lnk` (
  `id` int(11) NOT NULL auto_increment,
  `session_id` varchar(255) NOT NULL default '',
  `product_id` int(11) NOT NULL default '0',
  `date` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Gegevens worden uitgevoerd voor tabel `san_product_shop_lnk`
#


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

#
# Tabel structuur voor tabel `san_product_subgroup`
#

CREATE TABLE `san_product_subgroup` (
  `id` int(11) NOT NULL auto_increment,
  `product_group_id` int(11) NOT NULL default '0',
  `c_subname_id` int(11) NOT NULL default '0',
  `order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;

#
# Gegevens worden uitgevoerd voor tabel `san_product_subgroup`
#

INSERT INTO `san_product_subgroup` VALUES (1, 1, 43, 1);
INSERT INTO `san_product_subgroup` VALUES (6, 1, 81, 3);
INSERT INTO `san_product_subgroup` VALUES (7, 1, 88, 4);
INSERT INTO `san_product_subgroup` VALUES (20, 4, 152, 6);
INSERT INTO `san_product_subgroup` VALUES (9, 4, 99, 1);
INSERT INTO `san_product_subgroup` VALUES (10, 4, 100, 2);
INSERT INTO `san_product_subgroup` VALUES (11, 4, 101, 3);
INSERT INTO `san_product_subgroup` VALUES (12, 3, 114, 2);
INSERT INTO `san_product_subgroup` VALUES (13, 3, 115, 3);
INSERT INTO `san_product_subgroup` VALUES (14, 4, 122, 4);
INSERT INTO `san_product_subgroup` VALUES (15, 4, 126, 5);
INSERT INTO `san_product_subgroup` VALUES (16, 4, 130, 7);
INSERT INTO `san_product_subgroup` VALUES (17, 2, 134, 1);
INSERT INTO `san_product_subgroup` VALUES (18, 2, 135, 2);
INSERT INTO `san_product_subgroup` VALUES (19, 2, 136, 8);
INSERT INTO `san_product_subgroup` VALUES (21, 2, 162, 3);
INSERT INTO `san_product_subgroup` VALUES (22, 2, 163, 4);
INSERT INTO `san_product_subgroup` VALUES (23, 2, 164, 5);
INSERT INTO `san_product_subgroup` VALUES (24, 2, 165, 6);
INSERT INTO `san_product_subgroup` VALUES (25, 2, 166, 7);
INSERT INTO `san_product_subgroup` VALUES (26, 3, 188, 4);
INSERT INTO `san_product_subgroup` VALUES (27, 3, 189, 5);
