Index: lams_common/db/sql/shaun/lams_user_bulgarian.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_bulgarian.sql (.../lams_user_bulgarian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_bulgarian.sql (.../lams_user_bulgarian.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(11,null,'Bulgarian Workspace',11,11,now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (11,null,'Bulgarian Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (11,11,'Bulgarian Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(11,'bulgarian','bulgarian','Dr','Bulgarian','Test','11','Bulgarian Ave',null,'Sofia',null,'Bulgaria','0211111111','0211111112','0411111111','0211111113','bulgarian@xx.os',0,'20041223',1,11,1,3,'bg',null); Index: lams_common/db/sql/shaun/lams_user_chinese.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_chinese.sql (.../lams_user_chinese.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_chinese.sql (.../lams_user_chinese.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(12,null,'Chinese Workspace',12,12,now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (12,null,'Chinese Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (12,12,'Chinese Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(12,'chinese','chinese','Dr','Chinese','Test','12','Chinese Ave',null,'Beijing',null,'China','0211111111','0211111112','0411111111','0211111113','chinese@xx.os',0,'20041223',1,12,1,3,'zh',null); Index: lams_common/db/sql/shaun/lams_user_french.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_french.sql (.../lams_user_french.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_french.sql (.../lams_user_french.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(10,null,'French Workspace',10,10,now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (10,null,'French Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (10,10,'French Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(10,'french','french','Dr','French','Test','10','French Ave',null,'Paris',null,'France','0211111111','0211111112','0411111111','0211111113','french@xx.os',0,'20041223',1,10,1,3,'fr',null); Index: lams_common/db/sql/shaun/lams_user_german.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_german.sql (.../lams_user_german.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_german.sql (.../lams_user_german.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(13,null,'German Workspace',13,13, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (13,null,'German Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (13,13,'German Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(13,'german','german','Dr','German','Test','13', 'German Ave',null,'Berlin',null,'Germany','0211111111','0211111112','0411111111','0211111113','german@xx.os',0,'20041223',1,13,1,3,'de',null); Index: lams_common/db/sql/shaun/lams_user_hungarian.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_hungarian.sql (.../lams_user_hungarian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_hungarian.sql (.../lams_user_hungarian.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(21,null,'Hungarian Workspace',21,21, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (21,null,'Hungarian Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (21,21,'Hungarian Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(21,'hungarian','hungarian','Dr','Hungarian','Test','21', 'Hungarian Ave',null,'Bukarest',null,'Hungry','0211111111','0211111112','0411111111','0211111113','hungarian@xx.os',0,'20041223',1,21,1,3,'hu',null); Index: lams_common/db/sql/shaun/lams_user_italian.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_italian.sql (.../lams_user_italian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_italian.sql (.../lams_user_italian.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(16,null,'Italian Workspace',16,16, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (16,null,'Italian Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (16,16,'Italian Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(16,'italian','italian','Dr','Italian','Test','16', 'Italian Ave',null,'Rome',null,'Italy','0211111111','0211111112','0411111111','0211111113','italian@xx.os',0,'20041223',1,16,1,3,'it',null); Index: lams_common/db/sql/shaun/lams_user_korean.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_korean.sql (.../lams_user_korean.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_korean.sql (.../lams_user_korean.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(18,null,'Korean Workspace',18,18, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (18,null,'Korean Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (18,18,'Korean Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(18,'korean','korean','Dr','Korean','Test','18', 'Korean Ave',null,'Seoul',null,'Korea','0211111111','0211111112','0411111111','0211111113','korean@xx.os',0,'20041223',1,18,1,3,'ko',null); Index: lams_common/db/sql/shaun/lams_user_maori.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_maori.sql (.../lams_user_maori.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_maori.sql (.../lams_user_maori.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(20,null,'Maori Workspace',20,20, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (20,null,'Maori Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (20,20,'Maori Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(20,'maori','maori','Dr','Maori','Test','20', 'Maori Ave',null,'Auckland',null,'New Zealand','0211111111','0211111112','0411111111','0211111113','maori@xx.os',0,'20041223',1,20,1,3,'mi','nz'); Index: lams_common/db/sql/shaun/lams_user_norwegian.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_norwegian.sql (.../lams_user_norwegian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_norwegian.sql (.../lams_user_norwegian.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(14,null,'Norwegian Workspace',14,14, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (14,null,'Norwegian Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (14,14,'Norwegian Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(14,'norwegian','norwegian','Dr','Norwegian','Test','14', 'Norwegian Ave',null,'Oslo',null,'Norway','0211111111','0211111112','0411111111','0211111113','norwegian@xx.os',0,'20041223',1,14,1,3,'no',null); Index: lams_common/db/sql/shaun/lams_user_polish.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_polish.sql (.../lams_user_polish.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_polish.sql (.../lams_user_polish.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(17,null,'Polish Workspace',17,17, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (17,null,'Polish Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (17,17,'Polish Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(17,'polish','polish','Dr','Polish','Test','17', 'Polish Ave',null,'Warsaw',null,'Poland','0211111111','0211111112','0411111111','0211111113','polish@xx.os',0,'20041223',1,17,1,3,'pl',null); Index: lams_common/db/sql/shaun/lams_user_portbr.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_portbr.sql (.../lams_user_portbr.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_portbr.sql (.../lams_user_portbr.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(15,null,'Portuguese Workspace',15,15, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (15,null,'Portuguese Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (15,15,'Portuguese Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(15,'portuguese','portuguese','Dr','Portuguese','Test','15', 'Portuguese Ave',null,'Brasilia',null,'Brazil','0211111111','0211111112','0411111111','0211111113','portuguese@xx.os',0,'20041223',1,15,1,3,'pt','br'); Index: lams_common/db/sql/shaun/lams_user_spanish.sql =================================================================== diff -u -rc0668a550d7d31e3312555e8ac807f36f86b8d5c -r019539a3c81dc79e95929d91aeb122fc47379b8e --- lams_common/db/sql/shaun/lams_user_spanish.sql (.../lams_user_spanish.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) +++ lams_common/db/sql/shaun/lams_user_spanish.sql (.../lams_user_spanish.sql) (revision 019539a3c81dc79e95929d91aeb122fc47379b8e) @@ -3,7 +3,7 @@ -- need a new workspace_id and the name changes for each user. insert into lams_workspace_folder(workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) values(19,null,'Spanish Workspace',19,19, now(),now(),1); -insert into lams_workspace (workspace_id, root_folder_id, name) values (19,null,'Spanish Test'); +insert into lams_workspace (workspace_id, root_folder_id, name) values (19,19,'Spanish Test'); insert into lams_user(user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,city,state,country,day_phone,evening_phone,mobile_phone,fax,email,disabled_flag,create_date,authentication_method_id,workspace_id, flash_theme_id,html_theme_id,locale_language,locale_country) values(19,'spanish','spanish','Dr','Spanish','Test','19', 'Spanish Ave',null,'Madrid',null,'Spain','0211111111','0211111112','0411111111','0211111113','spanish@xx.os',0,'20041223',1,19,1,3,'es',null);