User:Alex Doll

Alex's to-do lists

Stuff that Alex needs to no 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.

PREPARE populate FROM 'CREATE TABLE `sagmilli_?`.`?` SELECT * FROM `sagmilli_agd`.`?` ?;'
SET @db = 'Example';
SET @where='';
SET @table= 'labs';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'mills_classes';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'project';
SET @where=' WHERE `id`=1';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'ai';
SET @where=' WHERE `ProjNum`=1';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'dwt';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'geotech';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'litho';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'pli';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'project__circuits';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'spi';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'ucs';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'wibm';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'wirm';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'wic';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'mills';
SET @where= 'WHERE `ProjNum`=0 OR `ProjNum`=1';
EXECUTE populate USING @db, @table, @table, @where;

DEALLOCATE PREPARE populate;