/*M!999999\- enable the sandbox mode */ 

/*!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 utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data` (
  `file` mediumint(7) unsigned NOT NULL DEFAULT 0,
  `a` double unsigned DEFAULT NULL,
  `siga` float unsigned DEFAULT NULL,
  `b` double unsigned DEFAULT NULL,
  `sigb` float unsigned DEFAULT NULL,
  `c` double unsigned DEFAULT NULL,
  `sigc` float unsigned DEFAULT NULL,
  `alpha` float unsigned DEFAULT NULL,
  `sigalpha` float unsigned DEFAULT NULL,
  `beta` float unsigned DEFAULT NULL,
  `sigbeta` float unsigned DEFAULT NULL,
  `gamma` float unsigned DEFAULT NULL,
  `siggamma` float unsigned DEFAULT NULL,
  `vol` float unsigned DEFAULT NULL,
  `sigvol` float unsigned DEFAULT NULL,
  `celltemp` float unsigned DEFAULT NULL,
  `sigcelltemp` float unsigned DEFAULT NULL,
  `diffrtemp` float unsigned DEFAULT NULL,
  `sigdiffrtemp` float unsigned DEFAULT NULL,
  `cellpressure` float unsigned DEFAULT NULL,
  `sigcellpressure` float unsigned DEFAULT NULL,
  `diffrpressure` float unsigned DEFAULT NULL,
  `sigdiffrpressure` float unsigned DEFAULT NULL,
  `thermalhist` varchar(255) DEFAULT NULL,
  `pressurehist` varchar(255) DEFAULT NULL,
  `compoundsource` varchar(255) DEFAULT NULL,
  `nel` varchar(4) DEFAULT NULL,
  `sg` varchar(32) DEFAULT NULL,
  `sgHall` varchar(64) DEFAULT NULL,
  `sgNumber` smallint(3) unsigned DEFAULT NULL,
  `commonname` varchar(1024) DEFAULT NULL,
  `chemname` varchar(2048) DEFAULT NULL,
  `mineral` varchar(255) DEFAULT NULL,
  `formula` varchar(255) DEFAULT NULL,
  `calcformula` varchar(255) DEFAULT NULL,
  `cellformula` varchar(255) DEFAULT NULL,
  `Z` smallint(5) unsigned DEFAULT NULL,
  `Zprime` float unsigned DEFAULT NULL,
  `acce_code` char(6) DEFAULT NULL,
  `authors` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `journal` varchar(255) DEFAULT NULL,
  `year` smallint(4) unsigned DEFAULT NULL,
  `volume` smallint(5) unsigned DEFAULT NULL,
  `issue` varchar(10) DEFAULT NULL,
  `firstpage` varchar(20) DEFAULT NULL,
  `lastpage` varchar(20) DEFAULT NULL,
  `doi` varchar(127) DEFAULT NULL,
  `method` enum('single crystal','powder diffraction','theoretical') DEFAULT NULL,
  `radiation` varchar(32) DEFAULT NULL,
  `wavelength` float unsigned DEFAULT NULL,
  `radType` varchar(80) DEFAULT NULL,
  `radSymbol` varchar(20) DEFAULT NULL,
  `Rall` float unsigned DEFAULT NULL,
  `Robs` float unsigned DEFAULT NULL,
  `Rref` float unsigned DEFAULT NULL,
  `wRall` float unsigned DEFAULT NULL,
  `wRobs` float unsigned DEFAULT NULL,
  `wRref` float unsigned DEFAULT NULL,
  `RFsqd` float unsigned DEFAULT NULL,
  `RI` float unsigned DEFAULT NULL,
  `gofall` float DEFAULT NULL,
  `gofobs` float DEFAULT NULL,
  `gofgt` float DEFAULT NULL,
  `gofref` float DEFAULT NULL,
  `duplicateof` mediumint(7) unsigned DEFAULT NULL,
  `optimal` mediumint(7) unsigned DEFAULT NULL,
  `status` enum('warnings','errors','retracted') DEFAULT NULL,
  `flags` set('has coordinates','has disorder','has Fobs') DEFAULT NULL,
  `text` text NOT NULL,
  `svnrevision` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time /* mariadb-5.3 */ DEFAULT NULL,
  `onhold` date DEFAULT NULL,
  PRIMARY KEY (`file`),
  KEY `a` (`a`),
  KEY `b` (`b`),
  KEY `c` (`c`),
  KEY `alpha` (`alpha`),
  KEY `beta` (`beta`),
  KEY `gamma` (`gamma`),
  KEY `vol` (`vol`),
  KEY `sg` (`sg`),
  KEY `formula` (`formula`),
  KEY `nel` (`nel`),
  KEY `acce_code` (`acce_code`),
  KEY `doi` (`doi`),
  KEY `method` (`method`),
  KEY `svnrevision` (`svnrevision`),
  KEY `mineral` (`mineral`),
  KEY `date` (`date`),
  KEY `time` (`time`),
  KEY `chemname` (`chemname`(333)),
  KEY `commonname` (`commonname`(333)),
  KEY `journal` (`journal`),
  KEY `Z` (`Z`),
  KEY `Zprime` (`Zprime`),
  KEY `calcformula` (`calcformula`),
  KEY `sgHall` (`sgHall`),
  KEY `sgNumber` (`sgNumber`),
  FULLTEXT KEY `text` (`text`),
  FULLTEXT KEY `minchem` (`mineral`,`chemname`,`commonname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

