---------- 2011-02-15T19:52:57 ----------------------------
-- Drop simple view V_EO_KONTENPLAN
DROP VIEW nuclos.V_EO_KONTENPLAN
-- => Success

---------- 2011-02-15T19:52:57 ----------------------------
-- Drop foreign key constraint T_EO_KONTENPLAN.XR_T_EO_KONTENPLAN_SZZERD
ALTER TABLE nuclos.T_EO_KONTENPLAN DROP CONSTRAINT XR_T_EO_KONTENPLAN_SZZERD
-- => Success

---------- 2011-02-15T19:52:57 ----------------------------
-- Drop column T_EO_KONTENPLAN.INTID_STRAUFWERTEART
ALTER TABLE nuclos.T_EO_KONTENPLAN DROP COLUMN INTID_STRAUFWERTEART CASCADE
-- => Success

---------- 2011-02-15T19:52:57 ----------------------------
-- Create column T_EO_KONTENPLAN.INTID_STRAUSWERTEART
ALTER TABLE nuclos.T_EO_KONTENPLAN ADD INTID_STRAUSWERTEART NUMERIC(20,0) NOT NULL
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column "intid_strauswerteart" contains null values

---------- 2011-02-15T19:52:57 ----------------------------
-- Create foreign key constraint T_EO_KONTENPLAN.XR_T_EO_KONTENPLAN_DQ7NK4
ALTER TABLE nuclos.T_EO_KONTENPLAN ADD CONSTRAINT XR_T_EO_KONTENPLAN_DQ7NK4 FOREIGN KEY (INTID_STRAUSWERTEART) REFERENCES nuclos.T_EO_AUSWERTEART (INTID)
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column "intid_strauswerteart" referenced in foreign key constraint does not exist

---------- 2011-02-15T19:52:57 ----------------------------
-- Create simple view V_EO_KONTENPLAN
CREATE VIEW nuclos.V_EO_KONTENPLAN(
INTID,
INTKONTONUMMER,
INTID_STRKONTENART,
INTID_STRAUSWERTEART,
DBLFREISTELLUNG,
STRKONTO,
INTID_STRSTEUERSCHLUESSEL,
DATCHANGED,
STRCHANGED,
DATCREATED,
STRCREATED,
STRNUCLOSSYSTEMID,
INTID_NUCLOSPROCESS,
STRNUCLOSORIGIN,
BLNNUCLOSDELETED,
INTID_NUCLOSSTATE,
INTVERSION,
STRVALUE_STRKONTENART,
STRVALUE_STRAUSWERTEART,
STRVALUE_STRSTEUERSCHLUESSEL,
STRVALUE_NUCLOSPROCESS,
STRVALUE_NUCLOSSTATE,
INTVALUE_NUCLOSSTATE
) AS SELECT
t.INTID,
t.INTKONTONUMMER,
t.INTID_STRKONTENART,
t.INTID_STRAUSWERTEART,
t.DBLFREISTELLUNG,
t.STRKONTO,
t.INTID_STRSTEUERSCHLUESSEL,
t.DATCHANGED,
t.STRCHANGED,
t.DATCREATED,
t.STRCREATED,
t.STRNUCLOSSYSTEMID,
t.INTID_NUCLOSPROCESS,
t.STRNUCLOSORIGIN,
t.BLNNUCLOSDELETED,
t.INTID_NUCLOSSTATE,
t.INTVERSION,
CAST(fk1.STRVALUE AS VARCHAR(255)),
CAST(fk2.STRVALUE AS VARCHAR(255)),
CAST(fk3.STRschluessel AS VARCHAR(255)),
CAST(fk4.STRPROCESS AS VARCHAR(255)),
CAST(fk5.STRSTATE AS VARCHAR(255)),
CAST(fk6.INTNUMERAL AS NUMERIC(3,0))
FROM
T_EO_KONTENPLAN t
LEFT OUTER JOIN T_EO_KONTENART fk1 ON (t.INTID_STRKONTENART=fk1.INTID)
LEFT OUTER JOIN T_EO_AUSWERTEART fk2 ON (t.INTID_STRAUSWERTEART=fk2.INTID)
LEFT OUTER JOIN T_EO_STEUERSCHLUESSEL fk3 ON (t.INTID_STRSTEUERSCHLUESSEL=fk3.INTID)
LEFT OUTER JOIN T_MD_PROCESS fk4 ON (t.INTID_NUCLOSPROCESS=fk4.INTID)
LEFT OUTER JOIN T_MD_STATE fk5 ON (t.INTID_NUCLOSSTATE=fk5.INTID)
LEFT OUTER JOIN T_MD_STATE fk6 ON (t.INTID_NUCLOSSTATE=fk6.INTID)
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column t.intid_strauswerteart does not exist
  Position: 1133

---------- 2011-02-15T19:52:57 ----------------------------
-- Drop simple view V_EO_KONTENPLAN
DROP VIEW nuclos.V_EO_KONTENPLAN
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: view "v_eo_kontenplan" does not exist

---------- 2011-02-15T19:52:57 ----------------------------
-- Drop foreign key constraint T_EO_KONTENPLAN.XR_T_EO_KONTENPLAN_DQ7NK4
ALTER TABLE nuclos.T_EO_KONTENPLAN DROP CONSTRAINT XR_T_EO_KONTENPLAN_DQ7NK4
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: constraint "xr_t_eo_kontenplan_dq7nk4" of relation "t_eo_kontenplan" does not exist

---------- 2011-02-15T19:52:57 ----------------------------
-- Drop column T_EO_KONTENPLAN.INTID_STRAUSWERTEART
ALTER TABLE nuclos.T_EO_KONTENPLAN DROP COLUMN INTID_STRAUSWERTEART CASCADE
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column "intid_strauswerteart" of relation "t_eo_kontenplan" does not exist

---------- 2011-02-15T19:52:57 ----------------------------
-- Create column T_EO_KONTENPLAN.INTID_STRAUFWERTEART
ALTER TABLE nuclos.T_EO_KONTENPLAN ADD INTID_STRAUFWERTEART NUMERIC(20,0) NOT NULL
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column "intid_straufwerteart" contains null values

---------- 2011-02-15T19:52:57 ----------------------------
-- Create foreign key constraint T_EO_KONTENPLAN.XR_T_EO_KONTENPLAN_SZZERD
ALTER TABLE nuclos.T_EO_KONTENPLAN ADD CONSTRAINT XR_T_EO_KONTENPLAN_SZZERD FOREIGN KEY (INTID_STRAUFWERTEART) REFERENCES nuclos.T_EO_AUSWERTEART (INTID)
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column "intid_straufwerteart" referenced in foreign key constraint does not exist

---------- 2011-02-15T19:52:57 ----------------------------
-- Create simple view V_EO_KONTENPLAN
CREATE VIEW nuclos.V_EO_KONTENPLAN(
INTID,
INTID_NUCLOSSTATE,
BLNNUCLOSDELETED,
INTID_STRKONTENART,
INTID_STRSTEUERSCHLUESSEL,
INTID_NUCLOSPROCESS,
INTKONTONUMMER,
STRCHANGED,
STRCREATED,
INTID_STRAUFWERTEART,
STRNUCLOSORIGIN,
DATCREATED,
STRKONTO,
STRNUCLOSSYSTEMID,
DATCHANGED,
DBLFREISTELLUNG,
INTVERSION,
STRVALUE_NUCLOSSTATE,
STRVALUE_STRKONTENART,
STRVALUE_STRSTEUERSCHLUESSEL,
STRVALUE_NUCLOSPROCESS,
INTVALUE_NUCLOSSTATE,
STRVALUE_STRAUFWERTEART
) AS SELECT
t.INTID,
t.INTID_NUCLOSSTATE,
t.BLNNUCLOSDELETED,
t.INTID_STRKONTENART,
t.INTID_STRSTEUERSCHLUESSEL,
t.INTID_NUCLOSPROCESS,
t.INTKONTONUMMER,
t.STRCHANGED,
t.STRCREATED,
t.INTID_STRAUFWERTEART,
t.STRNUCLOSORIGIN,
t.DATCREATED,
t.STRKONTO,
t.STRNUCLOSSYSTEMID,
t.DATCHANGED,
t.DBLFREISTELLUNG,
t.INTVERSION,
CAST(fk1.STRSTATE AS VARCHAR(255)),
CAST(fk2.STRVALUE AS VARCHAR(255)),
CAST(fk3.STRschluessel AS VARCHAR(255)),
CAST(fk4.STRPROCESS AS VARCHAR(255)),
CAST(fk5.INTNUMERAL AS NUMERIC(3,0)),
CAST(fk6.STRVALUE AS VARCHAR(255))
FROM
T_EO_KONTENPLAN t
LEFT OUTER JOIN T_MD_STATE fk1 ON (t.INTID_NUCLOSSTATE=fk1.INTID)
LEFT OUTER JOIN T_EO_KONTENART fk2 ON (t.INTID_STRKONTENART=fk2.INTID)
LEFT OUTER JOIN T_EO_STEUERSCHLUESSEL fk3 ON (t.INTID_STRSTEUERSCHLUESSEL=fk3.INTID)
LEFT OUTER JOIN T_MD_PROCESS fk4 ON (t.INTID_NUCLOSPROCESS=fk4.INTID)
LEFT OUTER JOIN T_MD_STATE fk5 ON (t.INTID_NUCLOSSTATE=fk5.INTID)
LEFT OUTER JOIN T_EO_AUSWERTEART fk6 ON (t.INTID_STRAUFWERTEART=fk6.INTID)
-- => Error: org.nuclos.server.dblayer.DbException: ERROR: column t.intid_straufwerteart does not exist
  Position: 1420