diff options
| author | ivan <ivan> | 2002-04-11 22:05:31 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-04-11 22:05:31 +0000 |
| commit | a7c1b602f88c177db34477ed4cdc1f72603f8995 (patch) | |
| tree | 116d090127ee48b041eeb9ff21a0d62c0c768250 /README.1.4.0pre12 | |
| parent | 52a07a405e197fda1654fc61eefa538450f269e8 (diff) | |
(almost) everything for bug#375 - create export_svc table - part_svc to
part_export is now properly many-to-many, not one-to-many
still need to finish service editing (choosing exports) in
httemplate/edit/part_svc.cgi and httemplate/edti/process/part_svc.cgi
and do somethinga about that manual $svcdb = 'svc_acct' in
httemplate/edit/part_export.cgi (do part_export records need a svcdb?
probably not... should be able to just pass an svcdb on creation of new
exports, move the big %exports hash into part_export.pm and allow
httemplate/edit/part_svc.cgi to query it for exports that can apply to a given
svcdb....
Diffstat (limited to 'README.1.4.0pre12')
| -rw-r--r-- | README.1.4.0pre12 | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/README.1.4.0pre12 b/README.1.4.0pre12 index ea1f95229..e8fdd3070 100644 --- a/README.1.4.0pre12 +++ b/README.1.4.0pre12 @@ -32,6 +32,17 @@ CREATE TABLE msgcat ( ); CREATE INDEX msgcat1 ON msgcat ( msgcode, locale ); +CREATE TABLE export_svc ( + exportsvcnum int primary key, + exportnum int not null, + svcpart int not null +); +CREATE UNIQUE INDEX export_svc1 ON export_svc ( exportnum, svcpart ); +CREATE INDEX export_svc2 ON export_svc ( exportnum ); +CREATE INDEX export_svc3 ON export_svc ( svcpart ); + +ALTER TABLE part_export RENAME svcpart TO deprecated; + Run bin/dbdef-create Run bin/create-history-tables |