# MySQL dump 4.0
#
# Host: localhost    Database: commport
#--------------------------------------------------------

#
# Table structure for table 'Category'
#
CREATE TABLE Category (
  ID int(11) DEFAULT '0' NOT NULL auto_increment,
  name varchar(50) DEFAULT '' NOT NULL,
  in_column int(11) DEFAULT '0' NOT NULL,
  sort_hint int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (ID)
);

#
# Dumping data for table 'Category'
#

INSERT INTO Category VALUES (1,'Science',1,2);
INSERT INTO Category VALUES (2,'Health',1,1);
INSERT INTO Category VALUES (3,'Technology',1,3);
INSERT INTO Category VALUES (4,'Local',2,1);
INSERT INTO Category VALUES (5,'Regional',2,2);
INSERT INTO Category VALUES (6,'National',2,3);
INSERT INTO Category VALUES (7,'International',2,4);
INSERT INTO Category VALUES (8,'Computers',1,7);
INSERT INTO Category VALUES (9,'Special Interest',3,2);
INSERT INTO Category VALUES (10,'Finance',2,5);
INSERT INTO Category VALUES (11,'Kids Stuff',3,3);
INSERT INTO Category VALUES (12,'Web Stuff',3,4);
INSERT INTO Category VALUES (13,'Telecommunities',3,5);
INSERT INTO Category VALUES (14,'Entertainment',1,6);
INSERT INTO Category VALUES (15,'Education',1,4);
INSERT INTO Category VALUES (16,'Politics',1,5);
INSERT INTO Category VALUES (17,'Weather',3,1);
INSERT INTO Category VALUES (18,'Sports',2,6);
INSERT INTO Category VALUES (19,'Space',2,7);
INSERT INTO Category VALUES (20,'Usenet News',2,8);
INSERT INTO Category VALUES (21,'Jobs',2,9);
INSERT INTO Category VALUES (22,'Professional Associations',3,6);
INSERT INTO Category VALUES (23,'Webcams',3,7);

#
# Table structure for table 'Channel'
#
CREATE TABLE Channel (
  ID int(11) DEFAULT '0' NOT NULL auto_increment,
  ID_User int(11) DEFAULT '0' NOT NULL,
  Name varchar(50) DEFAULT '' NOT NULL,
  URL varchar(120) DEFAULT '' NOT NULL,
  Public tinyint(4) DEFAULT '0' NOT NULL,
  Descript varchar(200) DEFAULT '' NOT NULL,
  FetchURL varchar(160) DEFAULT '' NOT NULL,
  F_Time int(10) unsigned DEFAULT '0' NOT NULL,
  F_Last datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  Type tinyint(4) DEFAULT '0' NOT NULL,
  State tinyint(2),
  CkSum varchar(10),
  A_Last datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  Cat1 int(11) DEFAULT '0' NOT NULL,
  Cat2 int(11) DEFAULT '0' NOT NULL,
  Cat3 int(11) DEFAULT '0' NOT NULL,
  Section int(11) DEFAULT '0' NOT NULL,
  Img_URL varchar(250),
  Img_Text varchar(50),
  Img_Src varchar(250),
  Img_Mode tinyint(4) DEFAULT '0' NOT NULL,
  Img_W int(11) DEFAULT '0' NOT NULL,
  Img_H int(11) DEFAULT '0' NOT NULL,
  Sorting tinyint(4) DEFAULT '0',
  Img_Cache tinyint(4) DEFAULT '0' NOT NULL,
  F_Resp int(3) DEFAULT '0' NOT NULL,
  Img_Local varchar(250) DEFAULT '' NOT NULL,
  Img_Cached tinyint(4) DEFAULT '0' NOT NULL,
  ExpPW varchar(16) DEFAULT '' NOT NULL,
  PlugIn varchar(50) DEFAULT '' NOT NULL,
  PRIMARY KEY (ID),
  KEY ID_User (ID_User),
  KEY Public (Public),
  KEY Cat1 (Cat1)
);

#
# Dumping data for table 'Channel'
#

INSERT INTO Channel VALUES (1,1,'Root','',0,'This is the undeletable panel in the upper left hand corner for public users.','',0,'0000-00-00 00:00:00',1,4,NULL,'0000-00-00 00:00:00',0,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,'',0,'','');
INSERT INTO Channel VALUES (2,1,'Root','',0,'This is the undeletable panel in the upper left hand corner for registered users.','',0,'0000-00-00 00:00:00',1,4,NULL,'0000-00-00 00:00:00',0,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,'',0,'','');

#
# Table structure for table 'Item'
#
CREATE TABLE Item (
  ID int(11) DEFAULT '0' NOT NULL auto_increment,
  ID_Channel int(11) DEFAULT '0' NOT NULL,
  Title varchar(50) DEFAULT '' NOT NULL,
  URL varchar(120) DEFAULT '' NOT NULL,
  Last_Alt timestamp(14),
  PRIMARY KEY (ID),
  KEY ID_Channel (ID_Channel)
);

#
# Table structure for table 'Panel'
#
CREATE TABLE Panel (
  ID int(11) DEFAULT '0' NOT NULL auto_increment,
  ID_User int(11) DEFAULT '0' NOT NULL,
  ID_Channel int(11) DEFAULT '0' NOT NULL,
  SortPri tinyint(3) unsigned DEFAULT '0' NOT NULL,
  DisplayState tinyint(3) unsigned DEFAULT '0' NOT NULL,
  LMR tinyint(3) unsigned DEFAULT '0' NOT NULL,
  Title varchar(50) DEFAULT '' NOT NULL,
  URL varchar(120) DEFAULT '' NOT NULL,
  ILimit tinyint(2),
  PRIMARY KEY (ID),
  KEY ID_User (ID_User),
  KEY ID_Channel (ID_Channel)
);

#
# Table structure for table 'User'
#
CREATE TABLE User (
  ID int(11) DEFAULT '0' NOT NULL auto_increment,
  un varchar(16) DEFAULT '' NOT NULL,
  pw varchar(13) DEFAULT '' NOT NULL,
  email varchar(50) DEFAULT '' NOT NULL,
  fname varchar(30) DEFAULT '' NOT NULL,
  lname varchar(50) DEFAULT '' NOT NULL,
  address varchar(50) DEFAULT '' NOT NULL,
  community varchar(30) DEFAULT '' NOT NULL,
  prov char(2) DEFAULT '' NOT NULL,
  postal varchar(10) DEFAULT '' NOT NULL,
  country varchar(20) DEFAULT '' NOT NULL,
  Priv tinyint(4) DEFAULT '0' NOT NULL,
  Joined datetime,
  PRIMARY KEY (ID),
  UNIQUE un (un)
);

#
# Dumping data for table 'User'
#
# Warning: Update the passwords to be different on your system.

# UN:public PW:PublicPassword  -- This user's view is the default.
INSERT INTO User VALUES (1,'public','02juKpN7qU3Qs','chalsall@csp.net','Public','View','','','','','',0,'1999-06-06 21:37:23');

# UN:root PW:RootPassword  -- Need a SuperUser (priv 100) for user admin.
INSERT INTO User VALUES (2,'root','676t1VF01qb4.','chalsall@csp.net','Super','User','','','','','',100,'1999-06-06 21:37:23');

# UN:fetcher PW:FetcherPassword  -- Handy place to set up fetched channels.
INSERT INTO User VALUES (3,'fetcher','00ucE7cWZAUh2','chalsall@csp.net','Channel','Fetcher','','','','','',25,'1999-06-06 21:37:23');