解码器代码--Woods‘sBlog

解码器代码

2006-12-1 9:56:00

安装解码器
MP3
代码:
sudo apt-get install gstreamer0.10-plugins-ugly

电影
代码:
sudo apt-get install gstreamer0.10-ffmpeg gstreamer0.10-gl gstreamer0.10-plugins-base gstreamer0.10-plugins-good gstreamer0.10-plugins-ugly gstreamer0.10-plugins-ugly-multiverse libxine-extracodecs ffmpeg lame faad sox mjpegtools libxine-main1

By 胡狼 | 阅读全文 | 回复(1) | 引用通告 | 编辑

Re:解码器代码

2008-9-28 1:10:00

CREATE VIEW sysconstraints AS SELECT
constid = convert(int, id),
id = convert(int, parent_obj),
colid = convert(smallint, info),
spare1 = convert(tinyint, 0),
status = convert(int,
CASE xtype
WHEN 'PK' THEN 1 WHEN 'UQ' THEN 2 WHEN 'F' THEN 3
WHEN 'C' THEN 4 WHEN 'D' THEN 5 ELSE 0 END
+ CASE WHEN info != 0 -- CNST_COLUMN / CNST_TABLE
THEN (16) ELSE (32) END
+ CASE WHEN (status & 16)!=0 -- CNST_CLINDEX
THEN (512) ELSE 0 END
+ CASE WHEN (status & 32)!=0 -- CNST_NCLINDEX
THEN (1024) ELSE 0 END
+ (2048) -- CNST_NOTDEFERRABLE
+ CASE WHEN (status & 256)!=0 -- CNST_DISABLE
THEN (16384) ELSE 0 END
+ CASE WHEN (status & 512)!=0 -- CNST_ENABLE
THEN (32767) ELSE 0 END
+ CASE WHEN (status & 4)!=0 -- CNST_NONAME
THEN (131072) ELSE 0 END
+ CASE WHEN (status & 1)!=0 -- CNST_NEW
THEN (1048576) ELSE 0 END
+ CASE WHEN (status & 1024)!=0 -- CNST_REPL
THEN (2097152) ELSE 0 END),
actions = convert(int, 4096),
error = convert(int, 0)
FROM sysobjects WHERE xtype in ('C', 'F', 'PK', 'UQ', 'D')
AND (status & 64) = 0

By 访客uYPc6G(游客) | 个人主页 | 引用 | 返回 | 删除 | 回复

发表评论：