*********************************************************************************
*
*     Insert default languages(s)
*
*********************************************************************************

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')
SET @LANGLABEL_ID = (SELECT LangLabelPK FROM tblLanguageLabels WHERE LangLabel='Active')     
     INSERT INTO tblLanguageTexts (LangFK, LangLabelFK, LangText) VALUES (@LANG_ID, @LANGLABEL_ID, 'Active')

# GroupModel
# #############
GroupModel.addNew = INSERT INTO jforum_groups (group_id, group_name, group_description, parent_id) VALUES (jforum_groups_se...  
# #############
# CategoryModel

-- de l'install et tous les sigles '--' sont supprims.
--
insert into llx_cond_reglement(rowid, code, sortorder, actif, libelle, libelle_facture, fdm, nbjour) values (1,'RECEP',    ...  
insert into llx_cond_reglement(rowid, code, sortorder, actif, libelle, libelle_facture, fdm, nbjour) values (2,'30D',      ...  
insert into llx_cond_reglement(rowid, code, sortorder, actif, libelle, libelle_facture, fdm, nbjour) values (3,'30DENDMONTH...  

-- Dumping data for table `ast_conf_rooms`
-- 
INSERT INTO `ast_conf_rooms` (`confId`, `confNumber`, `confPassword`, `confAccessTimeStart`, `confAccessTimeStop`, `confAcc...  
INSERT INTO `ast_conf_rooms` (`confId`, `confNumber`, `confPassword`, `confAccessTimeStart`, `confAccessTimeStop`, `confAcc...  
-- --------------------------------------------------------

-- de l'install et tous les sigles '--' sont supprims.
--
INSERT INTO llx_c_methode_commande_fournisseur (rowid, code, libelle, active) VALUES (1, 'OrderByMail',  'Courrier',  1);
INSERT INTO llx_c_methode_commande_fournisseur (rowid, code, libelle, active) VALUES (2, 'OrderByFax',   'Fax',       1);
INSERT INTO llx_c_methode_commande_fournisseur (rowid, code, libelle, active) VALUES (3, 'OrderByEMail', 'EMail',     1);

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 = ?
# #############

--  Groups
-- 
INSERT INTO jforum_groups (group_id, group_name, group_description ) VALUES (1, 'General', 'General Users');
INSERT INTO jforum_groups (group_id, group_name, group_description ) VALUES (2, 'Administration', 'Admin Users');
--

drop wordtmp
create btree wordtmp
insert wordtmp ("Ababa", 8)
insert wordtmp ("abbey", 18)
insert wordtmp ("abed", 28)

drop wordtmp
create btree wordtmp
insert wordtmp ("Ababa", 8)
insert wordtmp ("abbey", 18)
insert wordtmp ("abed", 28)

GRANT INSERT ON IIT MANAGER;

GRANT INSERT ON IIT MANAGER;

INSERT INTO FOREN VALUES('RAJKUMAR');

INSERT INTO FOREN VALUES('RAJKUMAR');

GRANT INSERT ON IIT MANAGER;

GRANT INSERT ON IIT MANAGER;

INSERT INTO Data VALUES (1)

INSERT INTO Data VALUES (2)

--- LISTA DELLE PROVINCE
INSERT INTO PROVINCE (NOME) VALUES ( 'Modena Comune' );
INSERT INTO PROVINCE (NOME) VALUES ( 'Modena Provincia' );
INSERT INTO PROVINCE (NOME) VALUES ( 'Estero' );

INSERT INTO PRES VALUES(10248,11);
INSERT INTO PRES VALUES(10248,42);
INSERT INTO PRES VALUES(10248,72);

INSERT INTO PRES VALUES(10248,11);
INSERT INTO PRES VALUES(10248,42);
INSERT INTO PRES VALUES(10248,72);

INSERT INTO PRES VALUES(10248,11);
INSERT INTO PRES VALUES(10248,42);
INSERT INTO PRES VALUES(10248,72);

INSERT INTO PRES VALUES(10248,11);
INSERT INTO PRES VALUES(10248,42);
INSERT INTO PRES VALUES(10248,72);

INSERT INTO PRES VALUES(10248,11);
INSERT INTO PRES VALUES(10248,42);
INSERT INTO PRES VALUES(10248,72);

INSERT INTO PRES VALUES(10248,11);
INSERT INTO PRES VALUES(10248,42);
INSERT INTO PRES VALUES(10248,72);