Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- ########################################
- -- #### dbo.Componenten Neue Felder ####
- -- ########################################
- ALTER TABLE Component
- ADD
- -- Noch nicht vorhandene Felder bzgl. der Ball Definition Optionsgruppe
- B_CO_BOOL bit NOT NULL DEFAULT 0,
- -- B_YO_R+ gibt es schon -> Component.CO+
- -- B_YO_R- gibt es schon -> Component.CO-
- B_CO_ATTR nvarchar(50) DEFAULT NULL,
- B_XO_BOOL bit NOT NULL DEFAULT 0,
- "B_XO_R+" INT DEFAULT NULL,
- "B_XO_R-" INT DEFAULT NULL,
- B_XO_ATTR nvarchar(50) DEFAULT NULL,
- B_YO_BOOL bit NOT NULL DEFAULT 0,
- "B_YO_R+" INT DEFAULT NULL,
- "B_YO_R-" INT DEFAULT NULL,
- B_YO_ATTR nvarchar(50) DEFAULT NULL,
- B_RO_BOOL bit NOT NULL DEFAULT 0,
- "B_RO_R+" INT DEFAULT NULL,
- "B_RO_R-" INT DEFAULT NULL,
- B_RO_ATTR nvarchar(50) DEFAULT NULL,
- B_PI_BOOL bit NOT NULL DEFAULT 0,
- -- B_PI_R+ gibt es schon -> Component.PI+
- -- B_PI_R- gibt es schon -> Component.PI-
- B_WI_BOOL bit NOT NULL DEFAULT 0,
- -- B_WI_R+ gibt es schon -> Component.WI+
- -- B_WI_R- gibt es schon -> Component.WI-
- B_WI_ATTR nvarchar(50) DEFAULT NULL,
- B_QU_BOOL bit NOT NULL DEFAULT 0,
- "B_QU_R+" INT DEFAULT NULL,
- "B_QU_R-" INT DEFAULT NULL,
- B_CT_BOOL bit NOT NULL DEFAULT 0,
- "B_CT_R+" INT DEFAULT NULL,
- "B_CT_R-" INT DEFAULT NULL,
- B_BH_BOOL bit NOT NULL DEFAULT 0,
- "B_BH_R+" INT DEFAULT NULL,
- "B_BH_R-" INT DEFAULT NULL,
- -- Neues Feld fuer die Inspection Flow Optionsgruppe
- Ins_Body_Measurement bit NOT NULL DEFAULT 0,
- -- Neues Feld fuer die Ball3D Optionsgruppe
- Ball3_Ext_Warp bit NOT NULL DEFAULT 0
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement