NP_gallery/trunk/gallery/documentation/dev.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r
   2 <html xml:lang="en" xmlns="http://www.w3.org/1999/xhtml">\r
   3 <head>\r
   4         <!-- $Id: sqltables.html,v 1.9 2005/03/05 13:19:30 dekarma Exp $ -->\r
   5         <title>Nucleus - SQL Table Structure</title>\r
   6         <link rel="stylesheet" type="text/css" href="manual.css" />\r
   7         <style type="text/css">\r
   8                 /* auto increment table columns*/\r
   9                 .autoinc {\r
  10                 }\r
  11 \r
  12                 /* primary-keys */\r
  13                 .primary {\r
  14                         text-decoration: underline;\r
  15                         font-weight: bold;\r
  16                 }\r
  17 \r
  18                 /* NOT NULL */\r
  19                 .notnull {\r
  20                 }\r
  21 \r
  22                 /* unique key */\r
  23                 .unique {\r
  24                 }\r
  25 \r
  26                 /* foreign keys */\r
  27                 .foreign {\r
  28                         font-style: italic;\r
  29                 }\r
  30 \r
  31                 /* auto increment table columns*/\r
  32                 .autoinc {\r
  33                 }\r
  34 \r
  35                 /* fulltext index */\r
  36                 .fulltext {\r
  37                 }\r
  38 \r
  39                 /* columns/tables to remove in later versions */\r
  40                 .toremove {\r
  41                         color: red;\r
  42                 }\r
  43 \r
  44         </style>\r
  45 </head>\r
  46 <body>\r
  47 \r
  48 <a name="top" id="top"></a>\r
  49 <div class="heading">\r
  50 Developer Documentation\r
  51 </div>\r
  52 <h1></h1>\r
  53 \r
  54 <h1>Introduction</h1>\r
  55 <p>This page is to document the database structure of NP_Gallery and the nucleus plugin API extensions.</p>\r
  56 \r
  57 <h1>Table of Contents</h1>\r
  58 <ul>\r
  59 <li><a href="#datastructure">Database Structure\r
  60         <ul>\r
  61                 <li><a href="#table_album">album</a></li>\r
  62                 <li><a href="#table_album_team">album_team</a></li>\r
  63                 <li><a href="#table_picture">picture</a></li>\r
  64                 <li><a href="#table_template">template</a></li>\r
  65                 <li><a href="#table_template_desc">template_desc</a></li>\r
  66                 <li><a href="#table_config">config</a></li>\r
  67                 <li><a href="#table_member">member</a></li>\r
  68                 <li><a href="#table_comment">comment</a></li>\r
  69                 <li><a href="#table_promo">promo</a></li>\r
  70                 <li><a href="#table_views">views</a></li>\r
  71                 <li><a href="#table_views_log">views_log</a></li>\r
  72         </ul>\r
  73 </li>\r
  74 <li><a href="#pluginhooks">Plugin Events</li>\r
  75 </ul>\r
  76 \r
  77 <h1><a name="datastructure"></a>Database structure</h1>\r
  78 \r
  79 <h1><a name="table_album"></a>album</h1>\r
  80 <table><thead><tr>\r
  81         <th>Column Name</th>\r
  82         <th>Type</th>\r
  83         <th>Default</th>\r
  84         <th>Description</th>\r
  85 </tr></thead><tbody><tr>\r
  86         <th class="notnull autoinc primary">albumid</th>\r
  87         <th></th>\r
  88         <th></th>\r
  89         <th></th>\r
  90 </tr><tr>\r
  91         <th>title</th>\r
  92         <th></th>\r
  93         <th></th>\r
  94         <th></th>\r
  95 </tr><tr>\r
  96         <th>description</th>\r
  97         <th></th>\r
  98         <th></th>\r
  99         <th></th>\r
 100 </tr><tr>\r
 101         <th>ownerid</th>\r
 102         <th></th>\r
 103         <th></th>\r
 104         <th></th>\r
 105 </tr><tr>\r
 106         <th>modified</th>\r
 107         <th></th>\r
 108         <th></th>\r
 109         <th></th>\r
 110 </tr><tr>\r
 111         <th>numberofimages</th>\r
 112         <th></th>\r
 113         <th></th>\r
 114         <th></th>\r
 115 </tr><tr>\r
 116         <th>thumbnail</th>\r
 117         <th></th>\r
 118         <th></th>\r
 119         <th></th>\r
 120 </tr><tr>\r
 121         <th>commentsallowed</th>\r
 122         <th></th>\r
 123         <th></th>\r
 124         <th></th>\r
 125 </tr></tbody>\r
 126 </table>\r
 127 \r
 128 \r
 129 <h2><a name="table_album_team"></a>album_team</h2>\r
 130 <h2><a name="table_picture"></a>picture</h2>\r
 131 <h2><a name="table_template"></a>template</h2>\r
 132 <h2><a name="table_template_desc"></a>template_desc</h2>\r
 133 <h2><a name="table_config"></a>config</h2>\r
 134 <h2><a name="table_member"></a>member</h2>\r
 135 <h2><a name="table_comment"></a>comment</h2>\r
 136 <h2><a name="table_promo"></a>promo</h2>\r
 137 <h2><a name="table_views"></a>views</h2>\r
 138 <h2><a name="table_views_log"></a>views_log</h2>\r
 139 \r
 140 <h1><a name="pluginhooks"></a>Gallery Events</h1>\r
 141 NPgCollectionDisplay\r
 142 \r
 143 </body>\r
 144 </html>\r