gistfile1.sql

# Sequel Pro dump
# Version 1630
# http://code.google.com/p/sequel-pro
#
# Host: ruatvak.osbg.co.uk (MySQL 5.1.41-3~bpo50+1)
# Database: cebgreen_cebpnz_gurfgber
# Generation Time: 2010-01-14 14:44:57 +0000
# ************************************************************

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table contacts
# ------------------------------------------------------------

CREATE TABLE `contacts` (
  `id` int(10) unsigned NOT NULL,
  `copy` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table datasheets
# ------------------------------------------------------------

CREATE TABLE `datasheets` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` enum('general','bs','pgro','sac','manufacturer','hgca','niab','safety') NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `file` text NOT NULL,
  `fulltext` text,
  `subtitle` text,
  `subcat` int(10) DEFAULT NULL,
  `manufacturers_id` int(10) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`,`name`),
  FULLTEXT KEY `name` (`name`,`file`,`subtitle`,`fulltext`)
) ENGINE=MyISAM AUTO_INCREMENT=1036 DEFAULT CHARSET=latin1;



# Dump of table datasheets_safety_manufacturers
# ------------------------------------------------------------

CREATE TABLE `datasheets_safety_manufacturers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  UNIQUE KEY `autoid` (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;



# Dump of table davesdiary
# ------------------------------------------------------------

CREATE TABLE `davesdiary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry` text NOT NULL,
  `picture1` text,
  `picture2` text,
  `picture3` text,
  `picture4` text,
  `attachment1` text,
  `attachment2` text,
  `attachment3` text,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;



# Dump of table hottopics_posts
# ------------------------------------------------------------

CREATE TABLE `hottopics_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `post` text NOT NULL,
  `thread` int(10) unsigned NOT NULL,
  `user` smallint(5) unsigned NOT NULL,
  `comment` text,
  `deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `thread` (`thread`),
  FULLTEXT KEY `post` (`post`)
) ENGINE=MyISAM AUTO_INCREMENT=157 DEFAULT CHARSET=utf8;



# Dump of table hottopics_threads
# ------------------------------------------------------------

CREATE TABLE `hottopics_threads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` tinytext NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `posts` int(10) unsigned NOT NULL DEFAULT '0',
  `lastuser` smallint(5) unsigned NOT NULL,
  `icon` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
  `comment` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;



# Dump of table inthenews_cuttings
# ------------------------------------------------------------

CREATE TABLE `inthenews_cuttings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `headline` text NOT NULL,
  `description` text NOT NULL,
  `file` text NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `headline` (`headline`,`description`,`file`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;



# Dump of table inthenews_releases
# ------------------------------------------------------------

CREATE TABLE `inthenews_releases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `news` text NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title_2` (`title`,`news`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;



# Dump of table nicksnotes
# ------------------------------------------------------------

CREATE TABLE `nicksnotes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry` text NOT NULL,
  `picture1` text,
  `picture2` text,
  `picture3` text,
  `picture4` text,
  `attachment1` text,
  `attachment2` text,
  `attachment3` text,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;



# Dump of table noticeboard
# ------------------------------------------------------------

CREATE TABLE `noticeboard` (
  `id` int(10) unsigned NOT NULL,
  `copy` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `copy` (`copy`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table pendingusers
# ------------------------------------------------------------

CREATE TABLE `pendingusers` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `email` text NOT NULL,
  `activationkey` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `activationkey` (`activationkey`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;



# Dump of table podcasts
# ------------------------------------------------------------

CREATE TABLE `podcasts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `podcast` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;



# Dump of table presentations
# ------------------------------------------------------------

CREATE TABLE `presentations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `cat` tinyint(3) unsigned NOT NULL,
  `thumbnail` text NOT NULL,
  `presentation` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;



# Dump of table privatesign_companynews
# ------------------------------------------------------------

CREATE TABLE `privatesign_companynews` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `news` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;



# Dump of table users
# ------------------------------------------------------------

CREATE TABLE `users` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `passhash` char(40) NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `email` text NOT NULL,
  `phone` tinytext,
  `sms` tinyint(1) NOT NULL DEFAULT '0',
  `digests` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;






/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;