Difference between revisions of "User:Alex Doll"
m (→Setting up a new project) |
(→Setting up a new project) |
||
| 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 18: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.
