--CP_SQL(DescriptionDE: "Beschreibung Deutsch", DescriptionEN: "Beschreibung Englisch", ExecuteForEachCompany: false, DBName: "TIG", Transaction: "On", RunOnce: "SomeKey")--
--CP_SQL(DescriptionDE: "CP_VARIABLE", DescriptionEN: "CP_VARIABLE")----*********************************************************************************************************************--if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.CP_VARIABLE') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.CP_VARIABLE ( VA_ID varchar (36) not null ) ON PRIMARY ENDGO exec dbo.CP_UPDATE_ADD_FIELD 'dbo', 'CP_VARIABLE', 'varchar', 'CO_ID', '36', , , 1 exec dbo.CP_UPDATE_ADD_FIELD 'dbo', 'CP_VARIABLE', 'int', 'VA_NUMBER', , , , 1 exec dbo.CP_UPDATE_ADD_FIELD 'dbo', 'CP_VARIABLE', 'varchar', 'VA_NAME', '50', , , 1 exec dbo.CP_UPDATE_ADD_FIELD 'dbo', 'CP_VARIABLE', 'varchar', 'VA_TYPE', '50', , , 1 exec dbo.CP_UPDATE_ADD_FIELD 'dbo', 'CP_VARIABLE', 'varchar', 'VA_VALUE', '1024', , , 1 exec dbo.CP_UPDATE_ADD_FIELD 'dbo', 'CP_VARIABLE', 'varchar', 'VA_DESCRIPTION', '2048', , , 1 exec CP_UPDATE_ADD_PRIMARYKEY 'CP_VARIABLE', 'PK_CP_VARIABLE', 'VA_ID', , ''GO