[IsActive] [bit] NOT NULL ,
਍ऀ嬀䰀愀猀琀唀瀀搀愀琀攀崀 嬀搀愀琀攀琀椀洀攀崀 一唀䰀䰀 Ⰰഀഀ
     [LastUpdateByFK] [int] NULL 
਍⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀ഀഀ
GO

GO
INSERT INTO tblEMailMsgs (EMailMsgType, Subject, Body, LangFK, IsActive)
     VALUES ('CASE_UPDATED_REP', 'Case #[CASEID] Updated', 'Case #[CASEID] has been updated by the requestor of this case. ...  
GO
INSERT INTO tblEMailMsgs (EMailMsgType, Subject, Body, LangFK, IsActive)

     VALUES (jforum_posts_seq.nextval, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE, ?)
PostModel.addNewPostText = INSERT INTO jforum_posts_text ( post_text, post_id, post_subject ) VALUES (EMPTY_BLOB(), ?, ?)
PostModel.addNewPostTextField = SELECT post_text from jforum_posts_text WHERE post_id = ? FOR UPDATE
PostModel.updatePostText = UPDATE jforum_posts_text SET post_subject = ?, post_text = EMPTY_BLOB() WHERE post_id = ?
PostModel.lastGeneratedPostId = SELECT jforum_posts_seq.currval FROM DUAL

GroupModel.canDelete = SELECT COUNT(1) AS total FROM jforum_user_groups WHERE group_id = ?
GroupModel.delete = DELETE FROM jforum_groups WHERE group_id = ?
GroupModel.update = UPDATE jforum_groups SET group_name = ?, parent_id = ?, group_description = ? WHERE group_id = ?
GroupModel.addNew = INSERT INTO jforum_groups (group_name, group_description, parent_id) VALUES (?, ?, ?)
GroupModel.selectUsersIds = SELECT user_id FROM jforum_user_groups WHERE group_id = ?

INSERT INTO jforum_role_values ( role_id, role_value) VALUES (33, '1');
--
-- Update sequences
--
SELECT SETVAL('jforum_posts_seq', MAX(post_id)) FROM jforum_posts;

UPDATE defaults
                SET invnumber = '1002';
UPDATE defaults

UPDATE defaults
                SET invnumber = '1001';
UPDATE defaults

SELECT spp_portscan2_drop();
SELECT icmp_cache_update();
SELECT event_cache_update();
SELECT sid_stats_update();

--
-- UPDATE ... SET <col> = DEFAULT;
--
CREATE TABLE update_test (

--
-- UPDATE ... SET <col> = DEFAULT;
--
CREATE TABLE update_test (

--
-- UPDATE ... SET <col> = DEFAULT;
--
CREATE TABLE update_test (

GRANT UPDATE ON IIT TO MANAGER;

GRANT UPDATE ON IIT TO DATAS;

GRANT UPDATE ON IIT TO DBMS;

GRANT UPDATE ON IIT TO DATAS;

REVOKE UPDATE ON IIT FROM MANAGER;

REVOKE UPDATE ON IIT FROM DBMS;

UPDATE DOMAIN IIT SET WHERE DEPT='EE';

UPDATE DOMAIN IIT SET DEPT='CSE' WHERE;

UPDATE IIT SET WHERE DEPT='EE';

UPDATE IIT SET DEPT='CSE' WHERE;

UPDATE ID IIT SET WHERE DEPT='EE';

UPDATE ID IIT SET DEPT='CSE' WHERE;

UPDATE DOMAIN IIT SET WHERE DEPT='EE';

UPDATE DOMAIN IIT SET DEPT='CSE' WHERE;