CouchProjects/Demos/php/BugShrink/createSchema.php

   1 <?php
   2 if(!$couch) {
   3         die("Don't call me directly.");
   4 }
   5 $couch->db_create();
   6
   7
   8 $bugTable['open'] = <<<EOD
   9         SELECT State == "Open"
  10         COLUMN CreationDate
  11         COLUMN Subject
  12         COLUMN Author
  13         COLUMN State
  14         COLUMN Project
  15         COLUMN Category
  16 EOD;
  17
  18 //$couch->add_table('open', $bugTable);
  19
  20 $bugTable['closed'] = <<<EOD
  21         SELECT State == "Closed"
  22         COLUMN CreationDate
  23         COLUMN Subject
  24         COLUMN Author
  25         COLUMN State
  26         COLUMN Project
  27         COLUMN Category
  28 EOD;
  29
  30 //$couch->add_table('closed', $bugTable);
  31
  32 $bugTable['all'] = <<<EOD
  33         SELECT *
  34         COLUMN CreationDate
  35         COLUMN Subject
  36         COLUMN Author
  37         COLUMN State
  38         COLUMN Project
  39         COLUMN Category
  40 EOD;
  41
  42 $bugTable['allfull'] = <<<EOD
  43         SELECT *
  44         COLUMN CreationDate
  45         COLUMN Subject
  46         COLUMN Author
  47         COLUMN State
  48         COLUMN Body
  49         COLUMN Project
  50         COLUMN Category
  51 EOD;
  52
  53 $bugTable['addprojects'] = <<<EOD
  54         SELECT Type == "Project"
  55         COLUMN BugId
  56         COLUMN Counter
  57         COLUMN Name
  58 EOD;
  59
  60 $bugTable['addcategories'] = <<<EOD
  61         SELECT Type == "Category"
  62         COLUMN BugId
  63         COLUMN Counter
  64         COLUMN Name
  65 EOD;
  66
  67 $bugTable['projects'] = <<<EOD
  68         SELECT Type == "Project"
  69         COLUMN Counter
  70         COLUMN Name
  71 EOD;
  72
  73 $bugTable['categories'] = <<<EOD
  74         SELECT Type == "Category"
  75         COLUMN Counter
  76         COLUMN Name
  77 EOD;
  78
  79 $couch->table_add($bugTable);
  80