[elvystrac] r1897 - smysluplna data do db
- From: elvys@xxxxxxxxxxxxxxxxxxxxxx
- To: elvystrac@xxxxxxxxxxxxx
- Date: Fri, 26 Feb 2010 10:27:47 +0100
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);
+
Other related posts:
- » [elvystrac] r1897 - smysluplna data do db - elvys
