百胜ERP3 SQL生成脚本

/*****************************************************/ begin transaction /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.code_def Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[code_def]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[code_def] GO create default code_def as 'A' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_base_date Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_base_date]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_base_date] GO create default default_base_date as '1 Jan 1900' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_bill_id Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_bill_id]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_bill_id] GO create default default_bill_id as 'STND' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_end_date Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_end_date]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_end_date] GO create default default_end_date as '1 Jan 2100' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_planning_pct Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_planning_pct]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_planning_pct] GO create default default_planning_pct as 100 GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_stnd Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_stnd]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_stnd] GO create default default_stnd as 'STND' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_all Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_all]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_all] GO create default default_to_all as 'ALL' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_backschedule Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_backschedule]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_backschedule] GO create default default_to_backschedule as 'BSCHD' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_cr Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_cr]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_cr] GO create default default_to_cr as 'CR' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_dr Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_dr]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_dr] GO create default default_to_dr as 'DR' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_english Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_english]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_english] GO create default default_to_english as 'ENG' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_fail Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_fail]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_fail] GO create default default_to_fail as 'F' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_hundred Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_hundred]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_hundred] GO create default default_to_hundred as 100 GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_ib Script Date: 2005-3-31 13:19:51 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_ib]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_ib] GO create default default_to_ib as 'IB' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_no Script Date: 2005-3-31 13:19:52 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_no]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_no] GO create default default_to_no as 'N' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_one Script Date: 2005-3-31 13:19:52 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_one]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_one] GO create default default_to_one as 1 GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_one_char Script Date: 2005-3-31 13:19:52 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_one_char]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_one_char] GO create default default_to_one_char as '1' GO GO /*****************************************************/ /*****************************************************/ /****** Object: Default dbo.default_to_pass Script Date: 2005-3-31 13:19:52 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[default_to_pass]') and OBJECTPROPERTY(id, N'IsDefault') = 1) drop default [dbo].[default_to_pass] GO create default default_to_pass as 'P' GO GO /*****************************************************/ /**********************************