View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001741 | CaseTalk Modeler | Generation (SQL, XML, etc) | public | 2018-06-20 17:53 | 2022-01-10 20:40 |
| Reporter | BCP Software | Assigned To | BCP Software | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Target Version | 9.1 | Fixed in Version | 9.1 | ||
| Summary | 0001741: Generate layered sql scripts | ||||
| Description | SQL Scripts create and drop database objects in architecture layers. According to BCP Software development experience and common DBA insights, a layered set of scripts is more easy to manage, certainly on live databases. | ||||
| Additional Information | /* * This script is part of a set to build a database or other artifact. * The X marks this script as part of the set: * [ ] generic - Create and/or set database generators * [ ] create - Create domains, tables, primary keys, unique constraints * [ ] load - Insert data * [ ] protect - Add check constraints, foreign key constraints (internal to module) and triggers * [ ] link - Add foreign key constraints referencing other modules * [ ] access - Create indices, views and procedures * [ ] grant - Template grant statements * * The inverse set is: * * [ ] revoke - Template revoke statements * [ ] noaccess - Drop indices, views and procedures * [ ] unlink - Drop foreign key constraints referencing other modules * [ ] unprotect - Drop check constrints, foreign key constraints (internal to module) and triggers * [ ] unload - Delete data * [ ] drop - Drop tables and domains * * [ ] catalog - Catalog insert statements describing the script objects */ | ||||
| Tags | No tags attached. | ||||
| CaseTalk Edition | unknown | ||||
 |
Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-06-20 17:53 | BCP Software | New Issue | |
| 2018-06-20 17:53 | BCP Software | Status | new => assigned |
| 2018-06-20 17:53 | BCP Software | Assigned To | => BCP Software |
| 2018-06-20 17:53 | BCP Software | Status | assigned => resolved |
| 2018-06-20 17:53 | BCP Software | Resolution | open => fixed |
| 2018-06-20 17:53 | BCP Software | Fixed in Version | => 9.1 |
| 2022-01-10 20:40 | BCP Software | Note Added: 0003503 | |
| 2022-01-10 20:40 | BCP Software | Status | resolved => closed |
