TableContrastTableContrast

------------------------------------------- -- UPDATE gpsdb_test -- 2011-6-27 11:53:41 ------------------------------------------- USE gpsdb_test GO ------------------------------------------- -- UPDATE Table GPS_TERMINAL_ALARM_INFO ------------------------------------------- ALTER TABLE GPS_TERMINAL_ALARM_INFO ADD TerminalNo varchar (40) NULL GO ------------------------------------------- -- UPDATE Table MST_CAR_GROUP ------------------------------------------- ALTER TABLE MST_CAR_GROUP ADD ComCode nvarchar (50) NULL ALTER TABLE MST_CAR_GROUP ADD ComAdministrationCode nvarchar (50) NULL ALTER TABLE MST_CAR_GROUP ADD ComName nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD ArtificialPerson nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD EconomySort int NULL ALTER TABLE MST_CAR_GROUP ADD BusinessLicence nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD BusinessCertificate nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD ScopeOfBusiness nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD ComAddress nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD ComContactTEL nvarchar (50) NULL ALTER TABLE MST_CAR_GROUP ADD ComCapacity nchar (10) NULL ALTER TABLE MST_CAR_GROUP ADD ComAssessDate datetime NULL ALTER TABLE MST_CAR_GROUP ADD ComAssessOrg nvarchar (max) NULL ALTER TABLE MST_CAR_GROUP ADD ComAssessGrade numeric NULL ALTER TABLE MST_CAR_GROUP ADD ComRegisteredCapital numeric NULL ALTER TABLE MST_CAR_GROUP ADD CarNumber numeric NULL GO ------------------------------------------- -- UPDATE Table MST_ALARM ------------------------------------------- ALTER TABLE MST_ALARM ADD Culture nvarchar (30) NULL GO ------------------------------------------- -- UPDATE Table BSC_DRIVER_INFO ------------------------------------------- ALTER TABLE BSC_DRIVER_INFO ADD DriverGender varchar (10) NULL ALTER TABLE BSC_DRIVER_INFO ADD Birthday datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD IDCard nvarchar (50) NULL ALTER TABLE BSC_DRIVER_INFO ADD DrivingLicense nvarchar (50) NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHNo nvarchar (50) NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHOrg nvarchar (max) NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHBegin datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHEnd datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHAvailability varchar (40) NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHRHPJ datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD WWOHRHPJInfo varchar (40) NULL ALTER TABLE BSC_DRIVER_INFO ADD ServiceCom nvarchar (max) NULL ALTER TABLE BSC_DRIVER_INFO ADD AcademicCareer varchar (40) NULL ALTER TABLE BSC_DRIVER_INFO ADD ManSort varchar (40) NULL ALTER TABLE BSC_DRIVER_INFO ADD ManAssessDate datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD ManAssessOrg nvarchar (max) NULL ALTER TABLE BSC_DRIVER_INFO ADD ManAssessGrade numeric NULL ALTER TABLE BSC_DRIVER_INFO ADD CreditRecord numeric NULL ALTER TABLE BSC_DRIVER_INFO ADD DriverNumber int NULL ALTER TABLE BSC_DRIVER_INFO ADD ComCode nvarchar (18) NULL ALTER TABLE BSC_DRIVER_INFO ADD ComName nvarchar (50) NULL ALTER TABLE BSC_DRIVER_INFO ADD AppointmentBegin datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD AppointmentEnd datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD CarAndDriver varchar (40) NULL ALTER TABLE BSC_DRIVER_INFO ADD GetonTime datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD GetonTimeLimit datetime NULL ALTER TABLE BSC_DRIVER_INFO ADD operationAction varchar (40) NULL ALTER TABLE BSC_DRIVER_INFO ADD PhotoPath nvarchar (500) NULL ALTER TABLE BSC_DRIVER_INFO ADD PhotoSize float NULL ALTER TABLE BSC_DRIVER_INFO ADD FingerprintPath nvarchar (500) NULL ALTER TABLE BSC_DRIVER_INFO ADD FingerprintSize float NULL GO ALTER TABLE BSC_DRIVER_INFO DROP COLUMN CarInfoId GO ------------------------------------------- -- UPDATE Table ADM_USER_GROUP ------------------------------------------- ALTER TABLE ADM_USER_GROUP ADD FenceCount varchar (20) NULL ALTER TABLE ADM_USER_GROUP ADD IsActived bit NULL ALTER TABLE ADM_USER_GROUP ADD StartServiceTime datetime NULL ALTER TABLE ADM_USER_GROUP ADD EndServiceTime datetime NULL ALTER TABLE ADM_USER_GROUP ADD CreateBy varchar (20) NULL ALTER TABLE ADM_USER_GROUP ADD ZoomLevel int NULL ALTER TABLE ADM_USER_GROUP ADD Coordinates varchar (200) NULL ALTER TABLE ADM_USER_GROUP ADD IsMonitorForGroup bit NULL GO ------------------------------------------- -- UPDATE Table BSC_TERMINAL_INFO ------------------------------------------- ALTER TABLE BSC_TERMINAL_INFO ADD IsOil bit NULL GO ------------------------------------------- -- UPDATE Table GPS_POINT_REAL_DATA ------------------------------------------- ALTER TABLE GPS_POINT_REAL_DATA ADD AGRTType varchar (30) NULL ALTER TABLE GPS_POINT_REAL_DATA ADD Flag varchar (50) NULL ALTER TABLE GPS_POINT_REAL_DATA ADD ParkingTimeLength varchar (20) NULL ALTER TABLE GPS_POINT_REAL_DATA ADD IconStyle varchar (20) NULL ALTER TABLE GPS_POINT_REAL_DATA ADD AlarmFlag varchar (8) NULL GO ------------------------------------------- -- UPDATE Table BSC_CAR_INFO ------------------------------------------- ALTER TABLE BSC_CAR_INFO ADD AGRTType varchar (30) NULL ALTER TABLE BSC_CAR_INFO ADD StartServiceTime datetime NULL ALTER TABLE BSC_CAR_INFO ADD EndServiceTime datetime NULL ALTER TABLE BSC_CAR_INFO ADD CarColor nvarchar (50) NULL ALTER TABLE BSC_CAR_INFO ADD VehicleLicenseNo nvarchar (50) NULL ALTER TABLE BSC_CAR_INFO ADD EngineNo nvarchar (50) NULL ALTER TABLE BSC_CAR_INFO ADD CarframeNo nvarchar (50) NULL ALTER TABLE BSC_CAR_INFO ADD LabradorNo nvarchar (50) NULL ALTER TABLE BSC_CAR_INFO ADD FuelSort varchar (40) NULL ALTER TABLE BSC_CAR_INFO ADD BuyCarDate datetime NULL ALTER TABLE BSC_CAR_INFO ADD TransportNo nvarchar (50) NULL ALTER TABLE BSC_CAR_INFO ADD TransportOrg nvarchar (max) NULL ALTER TABLE BSC_CAR_INFO ADD TransportNoBegin datetime NULL ALTER TABLE BSC_CAR_INFO ADD TransportNoEnd datetime NULL ALTER TABLE BSC_CAR_INFO ADD ServiceStatus varchar (40) NULL ALTER TABLE BSC_CAR_INFO ADD AnnualVerificationInfo nvarchar (max) NULL ALTER TABLE BSC_CAR_INFO ADD CarBegin datetime NULL ALTER TABLE BSC_CAR_INFO ADD CarEnd datetime NULL GO ------------------------------------------- -- UPDATE Table ADM_FUNCTION ------------------------------------------- ALTER TABLE ADM_FUNCTION ADD FunctionHant varchar (60) NULL GO ------------------------------------------- -- UPDATE Table GPS_POINT_REAL_DATA_MONITOR ------------------------------------------- ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD IsFenceStatus bit NULL DEFAULT ('0') ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD AGRTType varchar (30) NULL ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD IsUpdateAddress varchar (1) NULL DEFAULT ('1') ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD Flag varchar (50) NULL ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD IconStyle varchar (20) NULL ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD AlarmFlag varchar (8) NULL ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD IsActived varchar (30) NULL ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD StartServiceTime datetime NULL ALTER TABLE GPS_POINT_REAL_DATA_MONITOR ADD EndServiceTime datetime NULL GO ------------------------------------------- -- UPDATE Table ADM_APP_SETTING ------------------------------------------- ALTER TABLE ADM_APP_SETTING ADD TimeZone nvarchar (6) NULL DEFAULT ('8') GO