User:Alex Doll: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
| Line 7: | Line 7: | ||
# Copy the base PHP files into the new folder. |
# Copy the base PHP files into the new folder. |
||
# Tweak the configuration file to point to the new database. |
# Tweak the configuration file to point to the new database. |
||
# fill in the database structure, including default data. |
# [[TODO:New Database|fill in the database structure, including default data.]] |
||
<div style='background-color: #F9F9F9; border: dashed thin blue; padding:0.5em;'> |
|||
<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> |
|||
</div> |
|||
Revision as of 17:48, 11 December 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.