Author: EvaV Date: 2010-02-26 10:27:47 +0100 (Fri, 26 Feb 2010) New Revision: 1897 Added: others/dbs/script/28/fill_tables2.sql Log: smysluplna data do db Added: others/dbs/script/28/fill_tables2.sql =================================================================== --- others/dbs/script/28/fill_tables2.sql (rev 0) +++ others/dbs/script/28/fill_tables2.sql 2010-02-26 09:27:47 UTC (rev 1897) @@ -0,0 +1,257 @@ + +-- +-- version (table with just last version of DB) +insert into db_info (version, info, release_date, update_date) + values (28, '28- new role competency & company address', '2010-02-22', now()); +-- +-- + + + + + + +-- type_plug +insert into type_plug(id,componentClass) values(1,'fake-class_document'); +insert into type_plug(id,componentClass) values(2,'fake-class_url'); +insert into type_plug(id,componentClass) values(3,'fake-class_text'); +insert into type_plug(id,componentClass) values(4,'fake-class_dynamic'); +insert into type_plug(id,componentClass) values(5,'fake-class_video'); +insert into type_plug(id,componentClass) values(6,'fake-class_presentation'); + +-- file type +insert into file_type(id,type, suffixes, icon, storage_class) + values(1,'document','pdf','/images/documents/pdf.jpg','elvys.server.bl.file.FileStorageManagerPdf'); +insert into file_type(id,type, suffixes, icon, storage_class) + values(2,'video','avi, mov, mpeg, mpg, wmv, flv','/images/documents/video.gif','elvys.server.bl.file.FileStorageManagerVideo'); + +-- content_type +insert into content_type(id,type,plug,file_type) values(1,'document',1,1); +insert into content_type(id,type,plug,file_type) values(2,'url',2,null); +insert into content_type(id,type,plug,file_type) values(3,'text',3,null); +insert into content_type(id,type,plug,file_type) values(4,'dynamic',4,null); +insert into content_type(id,type,plug,file_type) values(5,'video',5,2); +insert into content_type(id,type,plug,file_type) values(6,'presentation',6,1); + +-- roles +insert into role(role,user_competency,admin_competency) values('user' ,06,02); +insert into role(role,user_competency,admin_competency) values('admin' ,03,06); +insert into role(role,user_competency,admin_competency) values('superadmin',02,10); +insert into role(role,user_competency,admin_competency) values('manager' ,10,03); + +-- comp_setting +insert into comp_setting(id) values (1); +insert into comp_setting(id) values (2); +insert into comp_setting(id) values (3); +insert into comp_setting(id) values (4); +insert into comp_setting(id) values (5); + +-- companies +insert into company(id,name,email,human,tel,city,address,zipcode,system,setting,disabled) values (1,'system','-','-','-','no city','no address','no zipcode', 1,1,false); +insert into company(id,name,email,human,tel,city,address,zipcode,system,setting,disabled) values (2,'Sun','sun@xxxxxxx','Josef Vomáčka','771679140','Praha','Veletržní 95','182 00', 0,2,false); +insert into company(id,name,email,human,tel,city,address,zipcode,system,setting,disabled) values (3,'Microsoft','micro@xxxxxxxx','Bill Gates','609112567','Praha','U lanovky 14','184 12', 0,3,false); +insert into company(id,name,email,human,tel,city,address,zipcode,system,setting,disabled) values (4,'Statutární město Přerov', 'posta@xxxxxxxxxxxx', 'Jan Máslo', '+420 581 268 111','Přerov','Okružní 11','750 11', 0, 4,false); +insert into company(id,name,email,human,tel,city,address,zipcode,system,setting,disabled) values (5,'Magistrát města Olomouce', 'infocentrum@xxxxxxxxxx', 'Milan Dlouhý', '585 513 111','Olomouc','Palackého náměstí 5','779 00', 0, 5,false); + + +-- comp_permitted_type +insert into comp_permitted_type(company, content) values (2,1); +insert into comp_permitted_type(company, content) values (2,2); +insert into comp_permitted_type(company, content) values (2,3); +insert into comp_permitted_type(company, content) values (2,4); +insert into comp_permitted_type(company, content) values (2,5); +insert into comp_permitted_type(company, content) values (4,1); +insert into comp_permitted_type(company, content) values (4,2); +insert into comp_permitted_type(company, content) values (4,3); +insert into comp_permitted_type(company, content) values (4,4); +insert into comp_permitted_type(company, content) values (4,5); +insert into comp_permitted_type(company, content) values (5,1); +insert into comp_permitted_type(company, content) values (5,2); +insert into comp_permitted_type(company, content) values (5,3); +insert into comp_permitted_type(company, content) values (5,4); +insert into comp_permitted_type(company, content) values (5,5); + + + +-- users +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (2,1,'myuser','user','prijmeni','aaaaaaaaa@xxxxxxxxxxxxxxx','+420 777 777 777', '1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (2,2,'myadmin','admin','prijmeni','aaaaaaaaa@xxxxxxxxxxxxxxx','+420 777 777 777', '1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (2,2,'a','admin','prijmeni','aaaaaaaaa@xxxxxxxxxxxxxxx','+420 777 777 777','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (3,2,'mymicroadmin','admin','prijmeni','aaaaaaaaa@xxxxxxxxxxxxxxx','+420 777 777 777','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (1,3,'sa','-','-','borec@xxxxxxxxx','+420 721 757 757','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',1,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,2,'horky','Jiří','Horký','horky@xxxxxxxxx','+420 777 489 730','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,2,'benda','Jaroslav','Benda','benda@xxxxxxxx','+420 777 707 707','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,2,'kusak','David','Kusák','david@xxxxxxxx','+420 723 779 177','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,4,'kusakm','David','Kusák','david@xxxxxxxx','+420 723 779 177','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,2,'mizera','Jiří','Mizera','mizera@xxxxxxxxxx','+420 777 237 567','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,2,'viktorinova','Eva','Viktorinová','evik@xxxxxxxxx','777 123 321','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,1,'prerov_user','Jan','Noha','noha@xxxxxxxxx','+420 777 787 077','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (4,2,'prerov_admin','Petr','Pálka','palka@xxxxxxxxx','+420 777 273 574','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (5,1,'olomouc_user','Milan','Krátký','kratky@xxxxxxxxxx','605 207 209','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); +insert into user(company,role,username,realname,surname,email,phone,password,locale,system,disabled) + values (5,2,'olomouc_admin','Jana','Šílená','silena@xxxxxxxxxx','+420 721 123 321','1101740027a4f1f8b7a7629e2e1de172478759ac','cs',0,false); + +-- aspect_ratio +insert into aspect_ratio(x_base,y_base,ratio) values (16,9,1.77778); +insert into aspect_ratio(x_base,y_base,ratio) values (4,3,1.33333); +insert into aspect_ratio(x_base,y_base,ratio) values (8,5,1.6); +insert into aspect_ratio(x_base,y_base,ratio) values (5,4,1.25000); + +-- resolution +insert into resolution(res_x, res_y, aspect_ratio) values (1600,900,1); +insert into resolution(res_x, res_y, aspect_ratio) values (1920,1080,1); +insert into resolution(res_x, res_y, aspect_ratio) values (2048,1152,1); +insert into resolution(res_x, res_y, aspect_ratio) values (3840,2160,1); +insert into resolution(res_x, res_y, aspect_ratio) values (1024,748,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1152,864,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1400,1050,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1440,1080,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1600,1200,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1792,1344,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1856,1392,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1920,1440,2); +insert into resolution(res_x, res_y, aspect_ratio) values (2048,1536,2); +insert into resolution(res_x, res_y, aspect_ratio) values (1280,800,3); +insert into resolution(res_x, res_y, aspect_ratio) values (1440,900,3); +insert into resolution(res_x, res_y, aspect_ratio) values (1680,1050,3); +insert into resolution(res_x, res_y, aspect_ratio) values (1920,1200,3); +insert into resolution(res_x, res_y, aspect_ratio) values (2560,1600,3); +insert into resolution(res_x, res_y, aspect_ratio) values (3840,2400,3); +insert into resolution(res_x, res_y, aspect_ratio) values (1280,1024,4); +insert into resolution(res_x, res_y, aspect_ratio) values (1800,1440,4); +insert into resolution(res_x, res_y, aspect_ratio) values (2560,2048,4); + +-- layout +-- insert into layout(type, path, sect_count, company, name, aspect_ratio) values (1,'layout1.xml',7,2,'sest plus jedna', 1); +-- insert into layout(type, path, sect_count, company, name, aspect_ratio) values (1,'layout2.xml',9,2,'osm plus jedna', 1); +-- insert into layout(type, path, sect_count, company, name, aspect_ratio) values (0,'layout3.xml',2,2,'nocni', 1); +-- insert into layout(type, path, sect_count, company, name, aspect_ratio) values (1,'layout4.xml',4,2,'tri plus jedna', 1); +-- insert into layout(type, path, sect_count, company, name, aspect_ratio) values (1,'layout5.xml',9,2,'osm plus jedna updated', 1); +-- insert into layout(type, path, sect_count, company, name, aspect_ratio) values (1,'layout6.xml',8,2,'luxusni, 8-pozic', 1); + +-- layout_position +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 1, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 2, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 3, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 4, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 5, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 6, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (1, 7, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 1, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 2, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 3, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 4, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 5, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 6, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 7, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 8, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (2, 9, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (3, 1, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (3, 2, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (4, 1, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (4, 2, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (4, 3, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (4, 4, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 1, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 2, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 3, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 4, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 5, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 6, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 7, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 8, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (5, 9, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 1, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 2, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 3, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 4, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 5, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 6, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 7, 0.0, 0.0, 0.0, 0.0); +-- insert into layout_position(layout, position, xpos, ypos, width, height) values (6, 8, 0.0, 0.0, 0.0, 0.0); + + +-- elvys setting + + +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); + + + +-- elvys +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (2, 2, 'virtual 1', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'virtual-city', 'Praha, Opletalova', '11000', 0, null, 14, false); + +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (3, 2, 'virtual 2', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'virtual-city', 'Praha, Zbraslav', '11000', 0, null, 16, false); + + +-- elvys prerov +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (12, 4, 'Přerov k1', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'Přerov', 'Bratrská 34, 750 11 Přerov', '11000', 0, null, 2, false); + +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (13, 4, 'Přerov k2', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'Přerov', 'Nám. T. G. Masaryka 1, 750 11 Přerov', '11000', 0, null, 2, false); + +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (14, 4, 'Přerov k3', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'Přerov', 'Smetanova 7, 750 11 Přerov', '11000', 0, null, 2, false); + +-- elvys olomouc +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (15, 5, 'Olomouc k1', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'Olomouc', 'Palackého náměstí 4, 779 00 Olomouc', '11000', 0, null, 2, false); + +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (16, 5, 'Olomouc k2', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'Olomouc', 'Na bělidle 91, 779 Olomouc', '11000', 0, null, 2, false); + +insert into elvys_setting( night_mode, night_start, night_end) +values (0, null, null); +insert into elvys_group(name,disabled) +values ('not-named-group', false); +insert into elvys(id,company, name, setting, elvys_group, city, address, psc, active, img_date, resolution, disabled) +values (17, 5, 'Olomouc k3', (SELECT max(id) from elvys_setting), (select max(id) from elvys_group), 'Olomouc', 'Okružní 792, 779 Olomouc', '11000', 0, null, 2, false); +