Difference between revisions of "User:Alex Doll"
(→Setting up a new project) |
m (→Alex's to-do lists) |
||
| Line 1: | Line 1: | ||
==Alex's to-do lists== |
==Alex's to-do lists== |
||
| − | Stuff that Alex needs to |
+ | Stuff that Alex needs to not forget. |
===Setting up a new project=== |
===Setting up a new project=== |
||
| Line 18: | Line 18: | ||
CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1; |
CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1; |
||
CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1; |
CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1; |
||
| − | CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.` |
+ | CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1; |
CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1; |
CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1; |
||
CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1; |
CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1; |
||
Revision as of 02:11, 18 November 2012
Alex's to-do lists
Stuff that Alex needs to not forget.
Setting up a new project
- Create a new database & dbuser.
- Create a new folder in circuitmodels/.
- Copy the base PHP files into the new folder.
- Tweak the configuration file to point to the new database.
- fill in the database structure, including default data.
<syntaxhighlight lang="mysql"> CREATE TABLE `labs` SELECT * FROM `sagmilli_agd`.`labs`; CREATE TABLE `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`; CREATE TABLE `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`=1; CREATE TABLE `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1; CREATE TABLE `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1; CREATE TABLE `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1; CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1; CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1; CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1; CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1; CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1; CREATE TABLE `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1; CREATE TABLE `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1; CREATE TABLE `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1; CREATE TABLE `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1; </syntaxhighlight>
