代码搜索结果
找到约 10,000 项符合
V 的代码
v004_to_v005.sql
insert into QX_SYS_PROP (PROP_ID, PROP_VAL, DESCRIPTION) values ('DB_CORE_VERSION', '005', 'Core database version. Do not modify');
-- all new update scripts must include a line like this:
UPDATE QX_S
v018_to_v019.sql
create view dbo.qx_user_permissions as
select u.pkey as user_id, p.*
from qx_permission p
inner join qx_role_to_users r2u on p.role_id = r2u.role_id
inner join qx_users u on u.pkey = r
v041_to_v042.sql
create view dbo.QX_DD_OBJECT_TYPE as
select
ENUM_VALUE as PKEY,
ENUM_LABEL as NAME
from QX_FIELDINFO
where (TABLE_NAME = 'qx_inbox') and (COLUMN_NAME = 'object_type')
v050_to_v051.sql
update qx_users set email='' where loginname='admin' or loginname='system'
update QX_SYS_PROP set prop_val='default@sender.com' where PROP_ID='DEFAULT_SENDER'
go
UPDATE dbo.QX_SYS_PROP SET PROP_V
v061_to_v062.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[QX_CHART]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [QX_CHART]
GO
create table dbo.QX_CHART (
CHART_ID I
v038_to_v039.sql
alter table QX_FORM_SETTINGS
add autosearch bit not null default 0
go
UPDATE QX_SYS_PROP SET PROP_VAL = '039' WHERE (PROP_ID = 'DB_CORE_VERSION');
go
v034_to_v035.sql
insert into dbo.QX_LOCALIZATION_TYPE values (2, 'HTML contents');
insert into dbo.QX_LOCALIZED_OBJECT_TYPE values (10, 'Html element')
if exists (select * from dbo.sysobjects where id = object_i
v015_to_v016.sql
ALTER TABLE QX_USER_PROP
ALTER COLUMN PROP_VAL VARCHAR(512)
GO
UPDATE QX_SYS_PROP SET PROP_VAL = '016' WHERE (PROP_ID = 'DB_CORE_VERSION');
v037_to_v038.sql
delete from QX_EMAIL_ROUTING
go
delete from QX_FILTER_ACCOUNT
go
delete from QX_ACCOUNT
go
alter table QX_ACCOUNT drop column EMAIL_DOMAIN
go
alter table QX_ACCOUNT drop column EMAIL_ACCOUNT_
v020_to_v021.sql
ALTER TABLE dbo.QX_FOCUS DROP CONSTRAINT PK_QX_FOCUS
GO
TRUNCATE TABLE dbo.QX_FOCUS;
ALTER TABLE dbo.QX_FOCUS ADD PKEY INT NOT NULL DEFAULT 0;
go
ALTER TABLE dbo.QX_FOCUS ADD CONSTRAINT PK_QX