-- MySQL dump 9.09
--
-- Host: localhost    Database: catalog
---------------------------------------------------------
-- Server version	4.0.15-max-nt

--
-- Table structure for table `catalogue`
--

CREATE TABLE catalogue (
  id int(10) unsigned NOT NULL auto_increment,
  title varchar(50) default NULL,
  pid int(10) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `catalogue`
--

INSERT INTO catalogue VALUES (1,'Category 1',0);
INSERT INTO catalogue VALUES (2,'Category 2',0);
INSERT INTO catalogue VALUES (3,'Category 3',0);
INSERT INTO catalogue VALUES (4,'Category 4',0);
INSERT INTO catalogue VALUES (5,'Sub-Category 1.1',1);
INSERT INTO catalogue VALUES (6,'Sub-Category 1.2',1);
INSERT INTO catalogue VALUES (7,'Sub-Category 1.3',1);
INSERT INTO catalogue VALUES (8,'Sub-Category 2.1',2);
INSERT INTO catalogue VALUES (9,'Sub-Category 2.2',2);
INSERT INTO catalogue VALUES (10,'Sub-Category 1.1.1',5);
INSERT INTO catalogue VALUES (11,'Sub-Category 1.1.2',5);
INSERT INTO catalogue VALUES (12,'Sub-Category 1.1.2.1 - updated',11);
INSERT INTO catalogue VALUES (13,'Sub-Category 3.1',3);
INSERT INTO catalogue VALUES (14,'Sub-Category 4.1',4);
INSERT INTO catalogue VALUES (15,'Sub-Category 4.2',4);
INSERT INTO catalogue VALUES (16,'Sub-Category 4.2.1',15);
INSERT INTO catalogue VALUES (17,'Sub-Category 2.2.1',9);
INSERT INTO catalogue VALUES (18,'Sub-Category 2.2.1.1',17);
INSERT INTO catalogue VALUES (19,'Sub-Category',9);
INSERT INTO catalogue VALUES (20,'Sub-Category 2.2.1.1.1',17);
INSERT INTO catalogue VALUES (21,'TheEnd',20);
INSERT INTO catalogue VALUES (22,'Aha 2',21);
INSERT INTO catalogue VALUES (23,'Poly',14);
INSERT INTO catalogue VALUES (24,'Demo 12,53',13);
INSERT INTO catalogue VALUES (25,'Test',21);
INSERT INTO catalogue VALUES (26,'Category 5',0);
INSERT INTO catalogue VALUES (27,'Category 6',0);
INSERT INTO catalogue VALUES (28,'Category 7',0);
INSERT INTO catalogue VALUES (29,'Category 8',0);
INSERT INTO catalogue VALUES (30,'Category 9',0);
INSERT INTO catalogue VALUES (31,'Category 10',0);
INSERT INTO catalogue VALUES (32,'Catalog',29);

--
-- Table structure for table `isp`
--

CREATE TABLE isp (
  id int(11) NOT NULL auto_increment,
  cat_id int(11) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  descr text NOT NULL,
  KEY id (id)
) TYPE=MyISAM;

--
-- Dumping data for table `isp`
--

INSERT INTO isp VALUES (1,8,'Mirotel','lline, dial-up, hosting, domain name, network hardware	');
INSERT INTO isp VALUES (2,24,'Selena','dial-up, lline');
INSERT INTO isp VALUES (3,24,'IPnet','lline\n');
INSERT INTO isp VALUES (4,12,'267879338','icq');

--
-- Table structure for table `reviews`
--

CREATE TABLE reviews (
  id int(11) NOT NULL auto_increment,
  isp_id int(11) NOT NULL default '0',
  descr text NOT NULL,
  mark smallint(11) NOT NULL default '0',
  KEY id (id)
) TYPE=MyISAM;

--
-- Dumping data for table `reviews`
--

INSERT INTO reviews VALUES (1,3,'Test',5);
INSERT INTO reviews VALUES (2,1,'29.07.2003 - Dedicated server хостинг в Украине \r\nС 28 июля ведущий хостинг-провайдер Украины MiroHost.net начал предоставлять услугу dedicated server хостинга – аренды и лизинга выделенных физических хостинговых серверов. \r\n',3);