By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,530 Members | 880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,530 IT Pros & Developers. It's quick & easy.

Apriori algorithm in c

P: 1
Hi.I need a simple implementation of the Apriori algorithm in C.The ones available in the net are too complex.Thanks.

Bye,
Agean
Sep 22 '06 #1
Share this Question
Share on Google+
3 Replies


risby
P: 30
Hi.I need a simple implementation of the Apriori algorithm in C.The ones available in the net are too complex.Thanks.

Bye,
Agean
Don't we all!
Sep 22 '06 #2

10K+
P: 13,264
Perhaps you should put effort in trying to understand the available ones. An easier algorithm may be a bit long in coming.
Sep 22 '06 #3

P: 5
the scripts
<?
include ("app.php");

$sql_kosongkan = "truncate 1_hs";// untuk mengosongkan tabel kandidat 1
$kosong = mysql_query ($sql_kosongkan);
$sql_kosongkan2 = "truncate table 2_hs";// untuk mengosongkan tabel kandidat 2
$kosong2 = mysql_query ($sql_kosongkan2);
$sql_kosongkan3 = "truncate table 3_hs";// untuk mengosongkan tabel kandidat 3
$kosong3 = mysql_query ($sql_kosongkan3);
$sql_kosongkan4 = "truncate table 4_hs";// untuk mengosongkan tabel kandidat 4
$kosong4 = mysql_query ($sql_kosongkan4);
$sql_kosongkan5 = "truncate table 5_hs";// untuk mengosongkan tabel kandidat 5
$kosong5 = mysql_query ($sql_kosongkan5);
$sql_kosongkan6 = "truncate table 6_hs";// untuk mengosongkan tabel kandidat 6
$kosong6 = mysql_query ($sql_kosongkan6);
$sql_kosongkan7 = "truncate table 7_hs";// untuk mengosongkan tabel kandidat 7
$kosong7 = mysql_query ($sql_kosongkan7);
$sql_kosongkan8 = "truncate table 8_hs";// untuk mengosongkan tabel kandidat 8
$kosong8 = mysql_query ($sql_kosongkan8);
$sql_kosongkan9 = "truncate table 9_hs";// untuk mengosongkan tabel kandidat 9
$kosong9 = mysql_query ($sql_kosongkan9);
$sql_kosongkan10 = "truncate table 10_hs";// untuk mengosongkan tabel kandidat 10
$kosong10 = mysql_query ($sql_kosongkan10);


if($kosong&&$kosong2&&$kosong3&&$kosong4&&$kosong5 &&$kosong6&&$kosong7&&$kosong8&&$kosong9&&$kosong1 0)
echo "data awal sudah dikosongkan<br>";
else
echo "data awal masih tersimpan<br>";

$sql= 'SELECT MAX(id_session) as id_session FROM session';
$hasil = mysql_query ($sql);
$row = mysql_fetch_array($hasil);
$id = $row['id_session']; // banyak session yang terbentuk
echo "banyak session adalah: $id<br><br>";

$masukkan_nilai= 20; // nilai support dalam % ex: 10%, 20%
$supp = ($masukkan_nilai/100); // nilai support
$jumlah = $supp * $id; // banyak id hyperlink untuk minimum support


if($id>0) //$id>1 => banyak session yang dijadikan faktor pembagi
{// proses iterasi 1
$sql1="INSERT INTO 1_hs (id_link1, num, supp)
SELECT id_hyperlink as id_hyp, count(*) as jumlah, (count(*) / $id) as support
FROM `session` group by id_hyperlink having jumlah >= $jumlah";
$hasil1 = mysql_query ($sql1);
}
$sql_1hs = "SELECT * FROM 1_hs";
$hasil_1hs = mysql_query ($sql_1hs);
$bk1 = mysql_num_rows($hasil_1hs); // banyak_kandidat 1
echo "kandidat 1-hs menghasilkan $bk1 kandidat<br>";

if ($bk1>1) //lakukan iterasi ke-2
{
$sql2 ="INSERT INTO 2_hs(id_link1, id_link2, num, supp)
SELECT s1.id_hyperlink as id1, s2.id_hyperlink as id2,count(*) as num,(count(*)/$id) AS support
FROM session s1, session s2
where s1.id_hyperlink in (select id_link1 from 1_hs)
and s2.id_hyperlink in (select id_link1 from 1_hs)
and s1.id_hyperlink <> s2.id_hyperlink
and s1.id_session = s2.id_session
group by id1, id2
having num>= $jumlah
";
$hasil2 = mysql_query ($sql2);
if ($hasil2==true)
echo "kandidat 2-hs disimpan...";
else
echo "kandidat 2-hs tidak tersimpan...";
$sql_2hs = "SELECT * FROM 2_hs";
$hasil_2hs = mysql_query ($sql_2hs);
$bk2 = mysql_num_rows($hasil_2hs); // banyak_kandidat 2
echo "2-HS menghasilkan $bk2 kombinasi<br>";
if ($bk2>1) //lakukan iterasi ke-3
{
$sql3 ="INSERT INTO 3_hs (id_link1, id_link2, id_link3, num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3
WHERE s1.id_hyperlink IN (select id_link1 from 2_hs)
AND s2.id_hyperlink IN (select id_link1 from 2_hs)
AND s3.id_hyperlink IN (select id_link2 from 2_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink
having num>= $jumlah
";
$hasil3 = mysql_query($sql3);
if ($hasil3==true)
echo "kandidat 3-hs disimpan...";
else
echo "kandidat 3-hs tidak tersimpan...";
$sql_3hs = "SELECT * FROM 3_hs";
$hasil_3hs = mysql_query ($sql_3hs);
$bk3 = mysql_num_rows($hasil_3hs); // banyak_kandidat 3HS
echo "3-HS menghasilkan $bk3 kombinasi<br>";
if ($bk3>1) //lakukan iterasi ke-4
{
$sql4 ="INSERT INTO 4_hs (id_link1, id_link2, id_link3, id_link4, num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4
WHERE s1.id_hyperlink IN (select id_link1 from 3_hs)
AND s2.id_hyperlink IN (select id_link1 from 3_hs)
AND s3.id_hyperlink IN (select id_link2 from 3_hs)
AND s4.id_hyperlink IN (select id_link3 from 3_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink
having num>=$jumlah
";
$hasil4 = mysql_query($sql4);
if ($hasil4==true)
echo "kandidat 4-hs disimpan...";
else
echo "kandidat 4-hs tidak tersimpan...";
$sql_4hs = "SELECT * FROM 4_hs";
$hasil_4hs = mysql_query ($sql_4hs);
$bk4 = mysql_num_rows($hasil_4hs); //banyak_kandidat 4
echo "4-HS menghasilkan $bk4 kombinasi<br>";
if ($bk4>1) //lakukan iterasi ke-5
{
$sql5 ="INSERT INTO 5_hs (id_link1, id_link2, id_link3, id_link4, id_link5, num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4, session s5
WHERE s1.id_hyperlink IN (select id_link1 from 4_hs)
AND s2.id_hyperlink IN (select id_link1 from 4_hs)
AND s3.id_hyperlink IN (select id_link2 from 4_hs)
AND s4.id_hyperlink IN (select id_link3 from 4_hs)
AND s5.id_hyperlink IN (select id_link4 from 4_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s4.id_session = s5.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
AND s4.id_hyperlink < s5.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink
having num>=$jumlah
";
$hasil5 = mysql_query($sql5);
if ($hasil5==true)
echo "kandidat 5-hs disimpan...";
else
echo "kandidat 5-hs tidak tersimpan...";
$sql_5hs = "SELECT * FROM 5_hs";
$hasil_5hs = mysql_query ($sql_5hs);
$bk5 = mysql_num_rows($hasil_5hs); //banyak_kandidat 5
echo "5-HS menghasilkan $bk5 kombinasi<br>";
if ($bk5>1) //lakukan iterasi ke-6
{
$sql6 ="INSERT INTO 6_hs (id_link1, id_link2, id_link3, id_link4, id_link5, id_link6, num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4, session s5, session s6
WHERE s1.id_hyperlink IN (select id_link1 from 5_hs)
AND s2.id_hyperlink IN (select id_link1 from 5_hs)
AND s3.id_hyperlink IN (select id_link2 from 5_hs)
AND s4.id_hyperlink IN (select id_link3 from 5_hs)
AND s5.id_hyperlink IN (select id_link4 from 5_hs)
AND s6.id_hyperlink IN (select id_link5 from 5_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s4.id_session = s5.id_session
AND s5.id_session = s6.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
AND s4.id_hyperlink < s5.id_hyperlink
AND s5.id_hyperlink < s6.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink
having num>=$jumlah
";
$hasil6 = mysql_query($sql6);
if ($hasil6==true)
echo "kandidat 6-hs disimpan...";
else
echo "kandidat 6-hs tidak tersimpan...";
$sql_6hs = "SELECT * FROM 6_hs";
$hasil_6hs = mysql_query ($sql_6hs);
$bk6 = mysql_num_rows($hasil_6hs); //banyak_kandidat 6
echo "6-HS menghasilkan $bk6 kombinasi<br>";
if ($bk6>1) //lakukan iterasi ke-7
{
$sql7 ="INSERT INTO 7_hs (id_link1, id_link2, id_link3, id_link4, id_link5, id_link6, id_link7, num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4, session s5, session s6, session s7
WHERE s1.id_hyperlink IN (select id_link1 from 6_hs)
AND s2.id_hyperlink IN (select id_link1 from 6_hs)
AND s3.id_hyperlink IN (select id_link2 from 6_hs)
AND s4.id_hyperlink IN (select id_link3 from 6_hs)
AND s5.id_hyperlink IN (select id_link4 from 6_hs)
AND s6.id_hyperlink IN (select id_link5 from 6_hs)
AND s7.id_hyperlink IN (select id_link6 from 6_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s4.id_session = s5.id_session
AND s5.id_session = s6.id_session
AND s6.id_session = s7.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
AND s4.id_hyperlink < s5.id_hyperlink
AND s5.id_hyperlink < s6.id_hyperlink
AND s6.id_hyperlink < s7.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink
having num>=$jumlah
";
$hasil7 = mysql_query($sql7);
if ($hasil7==true)
echo "kandidat 7-hs disimpan...";
else
echo "kandidat 7-hs tidak tersimpan...";
$sql_7hs = "SELECT * FROM 7_hs";
$hasil_7hs = mysql_query ($sql_7hs);
$bk7 = mysql_num_rows($hasil_7hs); //banyak_kandidat 7
echo "7-HS menghasilkan $bk7 kombinasi<br>";
if ($bk7>1) //lakukan iterasi ke-8
{
$sql8 ="INSERT INTO 8_hs (id_link1, id_link2, id_link3, id_link4, id_link5, id_link6, id_link7, id_link8,num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink, s8.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4, session s5, session s6, session s7 , session s8
WHERE s1.id_hyperlink IN (select id_link1 from 7_hs)
AND s2.id_hyperlink IN (select id_link1 from 7_hs)
AND s3.id_hyperlink IN (select id_link2 from 7_hs)
AND s4.id_hyperlink IN (select id_link3 from 7_hs)
AND s5.id_hyperlink IN (select id_link4 from 7_hs)
AND s6.id_hyperlink IN (select id_link5 from 7_hs)
AND s7.id_hyperlink IN (select id_link6 from 7_hs)
AND s8.id_hyperlink IN (select id_link6 from 7_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s4.id_session = s5.id_session
AND s5.id_session = s6.id_session
AND s6.id_session = s7.id_session
AND s7.id_session = s8.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
AND s4.id_hyperlink < s5.id_hyperlink
AND s5.id_hyperlink < s6.id_hyperlink
AND s6.id_hyperlink < s7.id_hyperlink
AND s7.id_hyperlink < s8.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink, s8.id_hyperlink
having num>=$jumlah
";
$hasil8 = mysql_query($sql8);
if ($hasil8==true)
echo "kandidat 8-hs disimpan...";
else
echo "kandidat 8-hs tidak tersimpan...";
$sql_8hs = "SELECT * FROM 8_hs";
$hasil_8hs = mysql_query ($sql_8hs);
$bk8 = mysql_num_rows($hasil_8hs); //banyak_kandidat 8
echo "8-HS menghasilkan $bk8 kombinasi<br>";
if ($bk8>1) //lakukan iterasi ke-9
{
$sql9 ="INSERT INTO 9_hs (id_link1, id_link2, id_link3, id_link4, id_link5, id_link6, id_link7, id_link8,id_link9,num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink, s8.id_hyperlink, s9.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4, session s5, session s6, session s7 , session s8, session s9
WHERE s1.id_hyperlink IN (select id_link1 from 8_hs)
AND s2.id_hyperlink IN (select id_link1 from 8_hs)
AND s3.id_hyperlink IN (select id_link2 from 8_hs)
AND s4.id_hyperlink IN (select id_link3 from 8_hs)
AND s5.id_hyperlink IN (select id_link4 from 8_hs)
AND s6.id_hyperlink IN (select id_link5 from 8_hs)
AND s7.id_hyperlink IN (select id_link6 from 8_hs)
AND s8.id_hyperlink IN (select id_link7 from 8_hs)
AND s9.id_hyperlink IN (select id_link7 from 8_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s4.id_session = s5.id_session
AND s5.id_session = s6.id_session
AND s6.id_session = s7.id_session
AND s7.id_session = s8.id_session
AND s8.id_session = s9.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
AND s4.id_hyperlink < s5.id_hyperlink
AND s5.id_hyperlink < s6.id_hyperlink
AND s6.id_hyperlink < s7.id_hyperlink
AND s7.id_hyperlink < s8.id_hyperlink
AND s8.id_hyperlink < s9.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink, s8.id_hyperlink, s9.id_hyperlink
having num>=$jumlah
";
$hasil9 = mysql_query($sql9);
if ($hasil9==true)
echo "kandidat 9-hs disimpan...";
else
echo "kandidat 9-hs tidak tersimpan...";
$sql_9hs = "SELECT * FROM 9_hs";
$hasil_9hs = mysql_query ($sql_9hs);
$bk9 = mysql_num_rows($hasil_9hs); //banyak_kandidat 9
echo "9-HS menghasilkan $bk9 kombinasi<br>";
if ($bk9>1) //lakukan iterasi ke-10
{
$sql10 ="INSERT INTO 10_hs (id_link1, id_link2, id_link3, id_link4, id_link5, id_link6, id_link7, id_link8, id_link9, id_link10, num, supp)
SELECT s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink, s8.id_hyperlink, s9.id_hyperlink, s10.id_hyperlink,
count(*) as num,
(count(*)/$id) AS support
FROM session s1, session s2, session s3, session s4, session s5, session s6, session s7 , session s8, session s9, session s10
WHERE s1.id_hyperlink IN (select id_link1 from 9_hs)
AND s2.id_hyperlink IN (select id_link1 from 9_hs)
AND s3.id_hyperlink IN (select id_link2 from 9_hs)
AND s4.id_hyperlink IN (select id_link3 from 9_hs)
AND s5.id_hyperlink IN (select id_link4 from 9_hs)
AND s6.id_hyperlink IN (select id_link5 from 9_hs)
AND s7.id_hyperlink IN (select id_link6 from 9_hs)
AND s8.id_hyperlink IN (select id_link7 from 9_hs)
AND s9.id_hyperlink IN (select id_link7 from 9_hs)
AND s10.id_hyperlink IN (select id_link7 from 9_hs)
AND s1.id_session = s2.id_session
AND s2.id_session = s3.id_session
AND s3.id_session = s4.id_session
AND s4.id_session = s5.id_session
AND s5.id_session = s6.id_session
AND s6.id_session = s7.id_session
AND s7.id_session = s8.id_session
AND s8.id_session = s9.id_session
AND s9.id_session = s10.id_session
AND s1.id_hyperlink < s2.id_hyperlink
AND s2.id_hyperlink < s3.id_hyperlink
AND s3.id_hyperlink < s4.id_hyperlink
AND s4.id_hyperlink < s5.id_hyperlink
AND s5.id_hyperlink < s6.id_hyperlink
AND s6.id_hyperlink < s7.id_hyperlink
AND s7.id_hyperlink < s8.id_hyperlink
AND s8.id_hyperlink < s9.id_hyperlink
AND s9.id_hyperlink < s10.id_hyperlink
GROUP BY s1.id_hyperlink, s2.id_hyperlink, s3.id_hyperlink, s4.id_hyperlink, s5.id_hyperlink, s6.id_hyperlink, s7.id_hyperlink, s8.id_hyperlink, s9.id_hyperlink, s10.id_hyperlink
having num>=$jumlah
";
$hasil10 = mysql_query($sql10);
if ($hasil10==true)
echo "kandidat 10-hs disimpan...";
else
echo "kandidat 10-hs tidak tersimpan...";
$sql_10hs = "SELECT * FROM 10_hs";
$hasil_10hs = mysql_query ($sql_10hs);
$bk10 = mysql_num_rows($hasil_10hs); //banyak_kandidat 10
echo "10-HS menghasilkan $bk10 kombinasi<br>";
}
}
}
}
}
}
}

}
}
else
echo"tidak ada kombinasi";
?>
<link href="style.css" rel="stylesheet" type="text/css">


//database
CREATE TABLE `10_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`id_link5` int(10) NOT NULL,
`id_link6` int(10) NOT NULL,
`id_link7` int(10) NOT NULL,
`id_link8` int(10) NOT NULL,
`id_link9` int(10) NOT NULL,
`id_link10` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `1_hs`
--

CREATE TABLE `1_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 ;

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

--
-- Table structure for table `2_hs`
--

CREATE TABLE `2_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=123 ;

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

--
-- Table structure for table `3_hs`
--

CREATE TABLE `3_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=143 ;

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

--
-- Table structure for table `4_hs`
--

CREATE TABLE `4_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=180 ;

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

--
-- Table structure for table `5_hs`
--

CREATE TABLE `5_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`id_link5` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=128 ;

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

--
-- Table structure for table `6_hs`
--

CREATE TABLE `6_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`id_link5` int(10) NOT NULL,
`id_link6` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=52 ;

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

--
-- Table structure for table `7_hs`
--

CREATE TABLE `7_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`id_link5` int(10) NOT NULL,
`id_link6` int(10) NOT NULL,
`id_link7` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ;

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

--
-- Table structure for table `8_hs`
--

CREATE TABLE `8_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`id_link5` int(10) NOT NULL,
`id_link6` int(10) NOT NULL,
`id_link7` int(10) NOT NULL,
`id_link8` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `9_hs`
--

CREATE TABLE `9_hs` (
`id` int(11) NOT NULL auto_increment,
`id_link1` int(11) NOT NULL,
`id_link2` int(10) NOT NULL,
`id_link3` int(10) NOT NULL,
`id_link4` int(10) NOT NULL,
`id_link5` int(10) NOT NULL,
`id_link6` int(10) NOT NULL,
`id_link7` int(10) NOT NULL,
`id_link8` int(10) NOT NULL,
`id_link9` int(10) NOT NULL,
`num` int(10) NOT NULL,
`supp` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
Aug 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.