Difference between revisions of "User:Alex Doll"

From SAGMILLING.COM
Jump to: navigation, search
(→‎Setting up a new project)
(→‎Setting up a new project)
Line 10: Line 10:
 
<div style='background-color: #F9F9F9; border: dashed thin blue; padding:0.5em;'>
  
<div style='background-color: #F9F9F9; border: dashed thin blue; padding:0.5em;'>
 
<syntaxhighlight lang="mysql">
  
<syntaxhighlight lang="mysql">
−
CREATE TABLE `labs` SELECT * FROM `sagmilli_agd`.`labs`;
  
−
ALTER TABLE `labs` ADD PRIMARY KEY ( `id` ) ;
  
   
  +
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
−
CREATE TABLE `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;
  
  +
CREATE TABLE `labs` LIKE `sagmilli_agd`.`labs`;
−
ALTER TABLE `mills_classes` ADD PRIMARY KEY ( `id` ) ;
  
  +
INSERT INTO `labs` SELECT * FROM `sagmilli_agd`.`labs`;
   
−
CREATE TABLE `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`=1;
 +
CREATE TABLE `mills_classes` LIKE `sagmilli_agd`.`mills_classes`;
  +
INSERT INTO `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;
−
INSERT INTO `project` (`id`, `name`, `folder`) VALUES (0, '_Listing of default mills', 'bond') ;
  
−
ALTER TABLE `project` ADD PRIMARY KEY ( `id` ) ;
  
   
−
CREATE TABLE `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;
 +
CREATE TABLE `project` LIKE `sagmilli_agd`.`project`;
  +
INSERT INTO `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`<=1;
−
ALTER TABLE `ai` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `ai` ADD INDEX `ProjNum` ( `ProjNum` , `Sample` ) ;
  
   
−
CREATE TABLE `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;
 +
CREATE TABLE `ai` LIKE `sagmilli_agd`.`ai`;
  +
INSERT INTO `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;
−
ALTER TABLE `dwt` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `dwt` ADD INDEX `ProjNum` ( `ProjNum` , `Sample` ) ;
  
   
−
CREATE TABLE `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;
 +
CREATE TABLE `dwt` LIKE `sagmilli_agd`.`dwt`;
  +
INSERT INTO `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;
−
ALTER TABLE `geotech` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `geotech` ADD INDEX `ProjNum` ( `ProjNum` ) ;
  
   
−
CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;
 +
CREATE TABLE `geotech` LIKE `sagmilli_agd`.`geotech`;
  +
INSERT INTO `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;
−
ALTER TABLE `litho` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `litho` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;
 +
CREATE TABLE `litho` LIKE `sagmilli_agd`.`litho`;
  +
INSERT INTO `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;
−
ALTER TABLE `pli` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `pli` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;
 +
CREATE TABLE `pli` LIKE `sagmilli_agd`.`pli`;
  +
INSERT INTO `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;
−
ALTER TABLE `project__circuits` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `project__circuits` ADD INDEX `ProjNum` ( `ProjNum` ) ;
  
   
−
CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;
 +
CREATE TABLE `project__circuits` LIKE `sagmilli_agd`.`project__circuits`;
  +
INSERT INTO `project_circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;
−
ALTER TABLE `spi` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `spi` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;
 +
CREATE TABLE `spi` LIKE `sagmilli_agd`.`spi`;
  +
INSERT INTO `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;
−
ALTER TABLE `ucs` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `ucs` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;
 +
CREATE TABLE `ucs` LIKE `sagmilli_agd`.`ucs`;
  +
INSERT INTO `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;
−
ALTER TABLE `wibm` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `wibm` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;
 +
CREATE TABLE `wibm` LIKE `sagmilli_agd`.`wibm`;
  +
INSERT INTO `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;
−
ALTER TABLE `wirm` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `wirm` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;
 +
CREATE TABLE `wirm` LIKE `sagmilli_agd`.`wirm`;
  +
INSERT INTO `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;
−
ALTER TABLE `wic` ADD PRIMARY KEY ( `id` ) ;
  
−
ALTER TABLE `wic` ADD INDEX `ProjNum` ( `ProjNum`,`Sample` ) ;
  
   
−
CREATE TABLE `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;
 +
CREATE TABLE `wic` LIKE `sagmilli_agd`.`wic`;
  +
INSERT INTO `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;
−
ALTER TABLE `mills` ADD PRIMARY KEY ( `id` ) ;
  
  +
−
ALTER TABLE `mills` ADD INDEX `ProjNum` ( `ProjNum` ) ;
  
  +
CREATE TABLE `mills` LIKE `sagmilli_agd`.`mills`;
  +
INSERT INTO `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;
   
 
</syntaxhighlight>
  
</syntaxhighlight>

Revision as of 01:39, 21 November 2012

Alex's to-do lists

Stuff that Alex needs to not forget.

Setting up a new project

  1. Create a new database & dbuser.
  2. Create a new folder in circuitmodels/.
  3. Copy the base PHP files into the new folder.
  4. Tweak the configuration file to point to the new database.
  5. fill in the database structure, including default data.

<syntaxhighlight lang="mysql">

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; CREATE TABLE `labs` LIKE `sagmilli_agd`.`labs`; INSERT INTO `labs` SELECT * FROM `sagmilli_agd`.`labs`;

CREATE TABLE `mills_classes` LIKE `sagmilli_agd`.`mills_classes`; INSERT INTO `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;

CREATE TABLE `project` LIKE `sagmilli_agd`.`project`; INSERT INTO `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`<=1;

CREATE TABLE `ai` LIKE `sagmilli_agd`.`ai`; INSERT INTO `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;

CREATE TABLE `dwt` LIKE `sagmilli_agd`.`dwt`; INSERT INTO `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;

CREATE TABLE `geotech` LIKE `sagmilli_agd`.`geotech`; INSERT INTO `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;

CREATE TABLE `litho` LIKE `sagmilli_agd`.`litho`; INSERT INTO `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;

CREATE TABLE `pli` LIKE `sagmilli_agd`.`pli`; INSERT INTO `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;

CREATE TABLE `project__circuits` LIKE `sagmilli_agd`.`project__circuits`; INSERT INTO `project_circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;

CREATE TABLE `spi` LIKE `sagmilli_agd`.`spi`; INSERT INTO `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;

CREATE TABLE `ucs` LIKE `sagmilli_agd`.`ucs`; INSERT INTO `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;

CREATE TABLE `wibm` LIKE `sagmilli_agd`.`wibm`; INSERT INTO `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;

CREATE TABLE `wirm` LIKE `sagmilli_agd`.`wirm`; INSERT INTO `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;

CREATE TABLE `wic` LIKE `sagmilli_agd`.`wic`; INSERT INTO `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;

CREATE TABLE `mills` LIKE `sagmilli_agd`.`mills`; INSERT INTO `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;

</syntaxhighlight>

Retrieved from "https://wiki.sagmilling.com/index.php?title=User:Alex_Doll&oldid=173"