| @@ 2221-2228 (lines=8) @@ | ||
| 2218 | return null; |
|
| 2219 | } |
|
| 2220 | ||
| 2221 | if ($indexes->recordCount() > 0) { |
|
| 2222 | $sql .= "\n-- Indexes\n\n"; |
|
| 2223 | while (!$indexes->EOF) { |
|
| 2224 | $sql .= $indexes->fields['inddef'] . ";\n"; |
|
| 2225 | ||
| 2226 | $indexes->moveNext(); |
|
| 2227 | } |
|
| 2228 | } |
|
| 2229 | ||
| 2230 | // Triggers |
|
| 2231 | $triggers = $this->getTriggers($table); |
|
| @@ 2238-2247 (lines=10) @@ | ||
| 2235 | return null; |
|
| 2236 | } |
|
| 2237 | ||
| 2238 | if ($triggers->recordCount() > 0) { |
|
| 2239 | $sql .= "\n-- Triggers\n\n"; |
|
| 2240 | while (!$triggers->EOF) { |
|
| 2241 | $sql .= $triggers->fields['tgdef']; |
|
| 2242 | $sql .= ";\n"; |
|
| 2243 | ||
| 2244 | $triggers->moveNext(); |
|
| 2245 | } |
|
| 2246 | } |
|
| 2247 | ||
| 2248 | // Rules |
|
| 2249 | $rules = $this->getRules($table); |
|
| 2250 | if (!is_object($rules)) { |
|
| @@ 2256-2263 (lines=8) @@ | ||
| 2253 | return null; |
|
| 2254 | } |
|
| 2255 | ||
| 2256 | if ($rules->recordCount() > 0) { |
|
| 2257 | $sql .= "\n-- Rules\n\n"; |
|
| 2258 | while (!$rules->EOF) { |
|
| 2259 | $sql .= $rules->fields['definition'] . "\n"; |
|
| 2260 | ||
| 2261 | $rules->moveNext(); |
|
| 2262 | } |
|
| 2263 | } |
|
| 2264 | ||
| 2265 | return $sql; |
|
| 2266 | } |
|