Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'gsas'@'localhost' (using password: YES) in D:\inetpub\vhosts\berlinproductions.net\subdomains\gsas\httpdocs\beta\inc\gsas.db.class.php on line 29

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\inetpub\vhosts\berlinproductions.net\subdomains\gsas\httpdocs\beta\inc\gsas.db.class.php on line 474

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\inetpub\vhosts\berlinproductions.net\subdomains\gsas\httpdocs\beta\inc\gsas.db.class.php on line 90
Query Error. Access denied for user 'gsas'@'localhost' (using password: YES)
Query:
DROP TABLE IF EXISTS `categories`;
DROP TABLE IF EXISTS `domains`;
DROP TABLE IF EXISTS `gsas_departments`;
DROP TABLE IF EXISTS `gsas_facultyrecs`;
DROP TABLE IF EXISTS `gsas_programsrec`;
DROP TABLE IF EXISTS `gsas_programtypes`;
DROP TABLE IF EXISTS `gsas_researchtypes`;
DROP TABLE IF EXISTS `gsas_studentsrecs`;
DROP TABLE IF EXISTS `keywords`;
DROP TABLE IF EXISTS `link_keyword0`;
DROP TABLE IF EXISTS `link_keyword1`;
DROP TABLE IF EXISTS `link_keyword2`;
DROP TABLE IF EXISTS `link_keyword3`;
DROP TABLE IF EXISTS `link_keyword4`;
DROP TABLE IF EXISTS `link_keyword5`;
DROP TABLE IF EXISTS `link_keyword6`;
DROP TABLE IF EXISTS `link_keyword7`;
DROP TABLE IF EXISTS `link_keyword8`;
DROP TABLE IF EXISTS `link_keyword9`;
DROP TABLE IF EXISTS `link_keyworda`;
DROP TABLE IF EXISTS `link_keywordb`;
DROP TABLE IF EXISTS `link_keywordc`;
DROP TABLE IF EXISTS `link_keywordd`;
DROP TABLE IF EXISTS `link_keyworde`;
DROP TABLE IF EXISTS `link_keywordf`;
DROP TABLE IF EXISTS `links`;
DROP TABLE IF EXISTS `pending`;
DROP TABLE IF EXISTS `query_log`;
DROP TABLE IF EXISTS `site_category`;
DROP TABLE IF EXISTS `sites`;
DROP TABLE IF EXISTS `temp`;;
;

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\inetpub\vhosts\berlinproductions.net\subdomains\gsas\httpdocs\beta\inc\gsas.db.class.php on line 90
Query Error. Access denied for user 'gsas'@'localhost' (using password: YES)
Query:

CREATE TABLE `categories` (
`category_id` int(11) NOT NULL auto_increment,
`category` text,
`parent_num` int(11) default NULL,
PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `domains` (
`domain_id` int(11) NOT NULL auto_increment,
`domain` varchar(255) default NULL,
PRIMARY KEY (`domain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `gsas_degrees` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_departments` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_facultyrecs` (
`id` int(10) unsigned NOT NULL auto_increment,
`fname` varchar(100) default NULL,
`lname` varchar(100) NOT NULL,
`title` varchar(100) NOT NULL,
`dept` varchar(255) NOT NULL,
`resinter` varchar(255) NOT NULL,
`progtype` varchar(100) NOT NULL,
`hdegree` int(10) unsigned NOT NULL,
`phone` varchar(50) NOT NULL,
`email` varchar(150) NOT NULL,
`website` varchar(150) NOT NULL,
`picture` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_fields` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_programsrec` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`progtype` int(10) unsigned NOT NULL,
`desc` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_programtypes` (
`id` int(10) unsigned NOT NULL auto_increment,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_researchtypes` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`desc` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `gsas_studentsrecs` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`fname` varchar(100) default NULL,
`lname` varchar(100) NOT NULL,
`phone` varchar(60) NOT NULL,
`email` varchar(150) NOT NULL,
`mentor` varchar(100) NOT NULL,
`yearadmiss` date NOT NULL,
`progtype` int(10) unsigned NOT NULL,
`field` int(10) NOT NULL,
`cename` varchar(50) NOT NULL,
`cestate` varchar(2) NOT NULL,
`hcdegree` varchar(50) NOT NULL,
`yearearned` varchar(50) NOT NULL,
`disstitle` varchar(50) NOT NULL,
`photo` varchar(100) NOT NULL,
`privacy` int(1) NOT NULL default '0',
`is_student` int(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `keywords` (
`keyword_id` int(11) NOT NULL auto_increment,
`keyword` varchar(30) NOT NULL,
PRIMARY KEY (`keyword_id`),
UNIQUE KEY `kw` (`keyword`),
KEY `keyword` (`keyword`(10))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword0` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword1` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword2` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword3` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword4` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword5` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword6` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword7` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword8` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyword9` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyworda` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keywordb` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keywordc` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keywordd` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keyworde` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_keywordf` (
`link_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`weight` int(3) default NULL,
`domain` int(4) default NULL,
KEY `linkid` (`link_id`),
KEY `keyid` (`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `links` (
`link_id` int(11) NOT NULL auto_increment,
`site_id` int(11) default NULL,
`url` varchar(255) NOT NULL,
`title` varchar(200) default NULL,
`description` varchar(255) default NULL,
`fulltxt` mediumtext,
`indexdate` date default NULL,
`size` float default NULL,
`md5sum` varchar(32) default NULL,
`visible` int(11) default '0',
`level` int(11) default NULL,
PRIMARY KEY (`link_id`),
KEY `url` (`url`),
KEY `md5key` (`md5sum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pending` (
`site_id` int(11) default NULL,
`temp_id` varchar(32) default NULL,
`level` int(11) default NULL,
`count` int(11) default NULL,
`num` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `query_log` (
`query` varchar(255) default NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`elapsed` float default NULL,
`results` int(11) default NULL,
KEY `query_key` (`query`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `site_category` (
`site_id` int(11) default NULL,
`category_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `sites` (
`site_id` int(11) NOT NULL auto_increment,
`url` varchar(255) default NULL,
`title` varchar(255) default NULL,
`short_desc` text,
`indexdate` date default NULL,
`spider_depth` int(11) default '2',
`required` text,
`disallowed` text,
`can_leave_domain` tinyint(1) default NULL,
PRIMARY KEY (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `temp` (
`link` varchar(255) default NULL,
`level` int(11) default NULL,
`id` varchar(32) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
;
;