| @@ 2261-2268 (lines=8) @@ | ||
| 2258 | return; |
|
| 2259 | } |
|
| 2260 | ||
| 2261 | if ($indexes->recordCount() > 0) { |
|
| 2262 | $sql .= "\n-- Indexes\n\n"; |
|
| 2263 | while (!$indexes->EOF) { |
|
| 2264 | $sql .= $indexes->fields['inddef'].";\n"; |
|
| 2265 | ||
| 2266 | $indexes->moveNext(); |
|
| 2267 | } |
|
| 2268 | } |
|
| 2269 | ||
| 2270 | // Triggers |
|
| 2271 | $triggers = $this->getTriggers($table); |
|
| @@ 2278-2287 (lines=10) @@ | ||
| 2275 | return; |
|
| 2276 | } |
|
| 2277 | ||
| 2278 | if ($triggers->recordCount() > 0) { |
|
| 2279 | $sql .= "\n-- Triggers\n\n"; |
|
| 2280 | while (!$triggers->EOF) { |
|
| 2281 | $sql .= $triggers->fields['tgdef']; |
|
| 2282 | $sql .= ";\n"; |
|
| 2283 | ||
| 2284 | $triggers->moveNext(); |
|
| 2285 | } |
|
| 2286 | } |
|
| 2287 | ||
| 2288 | // Rules |
|
| 2289 | $rules = $this->getRules($table); |
|
| 2290 | if (!is_object($rules)) { |
|
| @@ 2296-2303 (lines=8) @@ | ||
| 2293 | return; |
|
| 2294 | } |
|
| 2295 | ||
| 2296 | if ($rules->recordCount() > 0) { |
|
| 2297 | $sql .= "\n-- Rules\n\n"; |
|
| 2298 | while (!$rules->EOF) { |
|
| 2299 | $sql .= $rules->fields['definition']."\n"; |
|
| 2300 | ||
| 2301 | $rules->moveNext(); |
|
| 2302 | } |
|
| 2303 | } |
|
| 2304 | ||
| 2305 | return $sql; |
|
| 2306 | } |
|