Voxelgon SQL schema

Schema.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: localhost (MySQL 5.6.16)
# Database: test
# Generation Time: 2014-03-18 01:41:34 +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 elements
# ------------------------------------------------------------

CREATE TABLE `elements` (
  `atomic_number` int(3) unsigned NOT NULL DEFAULT '0',
  `symbol` varchar(3) NOT NULL DEFAULT '???',
  `element_name` varchar(15) NOT NULL DEFAULT 'impossabilium',
  `stable` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `phase` char(1) NOT NULL DEFAULT 's',
  `catagory` char(1) NOT NULL DEFAULT 'x',
  `atomic_weight` float(6,3) unsigned DEFAULT NULL,
  `density` float(8,3) unsigned DEFAULT NULL,
  `melting_point` float(8,3) unsigned DEFAULT NULL,
  `boiling_point` float(8,3) unsigned DEFAULT NULL,
  PRIMARY KEY (`atomic_number`),
  UNIQUE KEY `symbol` (`symbol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table elements_catagory
# ------------------------------------------------------------

CREATE TABLE `elements_catagory` (
  `flag` char(11) NOT NULL DEFAULT '',
  `catagory` text,
  PRIMARY KEY (`flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table materials
# ------------------------------------------------------------

CREATE TABLE `materials` (
  `material_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(30) NOT NULL DEFAULT 'Voxelgon',
  `material_name` varchar(30) NOT NULL DEFAULT 'Unknown Substance',
  `material_description` text,
  `conductive` tinyint(1) NOT NULL DEFAULT '1',
  `magnetic` tinyint(1) NOT NULL DEFAULT '0',
  `organic` tinyint(1) NOT NULL DEFAULT '0',
  `strength` float(5,2) NOT NULL DEFAULT '2.00',
  `rad-shieding` float(5,3) NOT NULL DEFAULT '1.000',
  `radiation` float(5,1) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`material_id`,`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;



# Dump of table materials_makeup
# ------------------------------------------------------------

CREATE TABLE `materials_makeup` (
  `makeup_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `material_id` int(11) unsigned NOT NULL DEFAULT '0',
  `namespace` varchar(30) NOT NULL DEFAULT 'voxelgon',
  `atomic_number` int(11) NOT NULL DEFAULT '1',
  `element_percentage` float(4,1) unsigned NOT NULL DEFAULT '100.0',
  PRIMARY KEY (`makeup_id`,`material_id`,`namespace`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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 */;