'svc_forward' => {
'columns' => [
- 'svcnum', 'int', '', '',
- 'srcsvc', 'int', '', '',
+ 'svcnum', 'int', '', '',
+ 'srcsvc', 'int', 'NULL', '',
'src', 'varchar', 'NULL', 255,
- 'dstsvc', 'int', '', '',
+ 'dstsvc', 'int', 'NULL', '',
'dst', 'varchar', 'NULL', 255,
],
'primary_key' => 'svcnum',
ALTER TABLE h_pkg_svc ADD primary_svc char(1) NULL;
ALTER TABLE svc_forward ADD src varchar(255) NULL;
ALTER TABLE h_svc_forward ADD src varchar(255) NULL;
+ALTER TABLE svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
+ALTER TABLE h_svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
+ALTER TABLE svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
+ALTER TABLE h_svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
+
+
dump database, edit:
- cust_main: increase otaker from 8 to 32