GO
DECLARE @LIST_ID Int
SET @LIST_ID = (SELECT ListItemPK FROM tblLists WHERE ItemName='STATUS_LIST')
INSERT INTO tblLists (ParentListItemFK, ItemOrder, ItemName, IsActive)
     VALUES (@LIST_ID, 0, 'Open', 1)

DECLARE @LANG_ID Int
DECLARE @LANGLABEL_ID Int
SET @LANG_ID = (SELECT LangPK FROM tblLanguages WHERE LangName='English')
SET @LANGLABEL_ID = (SELECT LangLabelPK FROM tblLanguageLabels WHERE LangLabel='Actions')     
     INSERT INTO tblLanguageTexts (LangFK, LangLabelFK, LangText) VALUES (@LANG_ID, @LANGLABEL_ID, 'Actions')

# ##########
UserModel.addNew = INSERT INTO jforum_users (user_id, username, user_password, user_email, user_regdate, user_actkey, user_...  
UserModel.selectAllByLimit = SELECT * FROM ( \
        SELECT user_email, user_id, user_posts, user_regdate, username, deleted, user_karma, user_from, user_website, user_...  
        FROM jforum_users ORDER BY username \

# UserModel
# ##########
UserModel.selectAllByLimit = SELECT user_email, user_id, user_posts, user_regdate, username, deleted, user_karma, user_from...  
     FROM jforum_users ORDER BY user_id OFFSET ? LIMIT ?
UserModel.lastGeneratedUserId = SELECT CURRVAL('jforum_users_seq')

# GroupModel 
# ############
GroupModel.selectAll = SELECT group_id, group_name, parent_id, group_description FROM jforum_groups ORDER BY group_name
GroupModel.selectById = SELECT group_id, group_name, parent_id, group_description FROM jforum_groups WHERE group_id = ?
GroupModel.canDelete = SELECT COUNT(1) AS total FROM jforum_user_groups WHERE group_id = ?

# UserModel
# ##########
UserModel.lastUserRegistered = SELECT TOP 1 user_id, username FROM jforum_users ORDER BY user_regdate DESC 
UserModel.selectAllByLimit = SELECT LIMIT ? ? user_email, user_id, user_posts, user_regdate, username, deleted, user_karma, \
     user_from, user_website, user_viewemail FROM jforum_users ORDER BY user_id

-- Update sequences
--
SELECT SETVAL('jforum_posts_seq', MAX(post_id)) FROM jforum_posts;
SELECT SETVAL('jforum_categories_seq', MAX(categories_id)) FROM jforum_categories;
SELECT SETVAL('jforum_forums_seq', MAX(forum_id)) FROM jforum_forums;

select (select 1);

select debug;
select @debug;
select explain;

select 1;

prepare select ?;

SELECT @@IDENTITY

SELECT @@IDENTITY

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT NULL;

SELECT 1;

SELECT 1;

SELECT 1;