Attachment #69686 for bug #16735

View | Details | Raw Unified | Return to bug 16735
Collapse All | Expand All

Lines 1-5 Link Here

(-)a/installer/data/mysql/en/optional/sample_libraries.sql (-2 lines)
1	-- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
2
3	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES	1	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
4		2
5	('MPL','Midway','372 Forest Street'),	3	('MPL','Midway','372 Forest Street'),

Lines 1-5 Link Here

(-)a/installer/data/mysql/es-ES/optional/sample_libraries.sql (-4 lines)
1	-- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
2
3	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES	1	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
4		2
5	('MPL','Midway','372 Forest Street'),	3	('MPL','Midway','372 Forest Street'),
Lines 15-19 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES Link Here
15	('LPL','Liberty','East Hills'),	13	('LPL','Liberty','East Hills'),
16	('UPL','Union','Chestnut Hollow')	14	('UPL','Union','Chestnut Hollow')
17	;	15	;
18
19	-- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES

Lines 1-5 Link Here

(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql (-4 lines)
1	-- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
2
3	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES	1	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
4		2
5	('MPL','Midway','372 Forest Street'),	3	('MPL','Midway','372 Forest Street'),
Lines 15-19 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES Link Here
15	('LPL','Liberty','East Hills'),	13	('LPL','Liberty','East Hills'),
16	('UPL','Union','Chestnut Hollow')	14	('UPL','Union','Chestnut Hollow')
17	;	15	;
18
19	-- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES

Lines 1-5 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_libraries.sql (-4 lines)
1	-- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
2
3	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES	1	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
4		2
5	('MPL','Midway','372 Forest Street'),	3	('MPL','Midway','372 Forest Street'),
Lines 15-19 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES Link Here
15	('LPL','Liberty','East Hills'),	13	('LPL','Liberty','East Hills'),
16	('UPL','Union','Chestnut Hollow')	14	('UPL','Union','Chestnut Hollow')
17	;	15	;
18
19	-- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES

Lines 1-6 Link Here

(-)a/installer/data/mysql/ru-RU/optional/example_branches.sql (-20 lines)
1	TRUNCATE branches;	1	TRUNCATE branches;
2	TRUNCATE branchcategories;
3	TRUNCATE branchrelations;
4		2
5	INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchaddress2`, `branchaddress3`, `branchphone`, `branchfax`, `branchemail`, `issuing`, `branchip`, `branchprinter`) VALUES	3	INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchaddress2`, `branchaddress3`, `branchphone`, `branchfax`, `branchemail`, `issuing`, `branchip`, `branchprinter`) VALUES
6	('AB', 'Абонемент',	4	('AB', 'Абонемент',
Lines 19-38 INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchadd Link Here
19	'Украина', 'м. Тернопіль', 'ул. Руська 56, кабинет 5 (второй корпус)', '8 (0352) 52-53-45', '', 'lib@tu.edu.te.ua', NULL, '', NULL),	17	'Украина', 'м. Тернопіль', 'ул. Руська 56, кабинет 5 (второй корпус)', '8 (0352) 52-53-45', '', 'lib@tu.edu.te.ua', NULL, '', NULL),
20	('NPLU', 'Национальная парламентская библиотека Украины',	18	('NPLU', 'Национальная парламентская библиотека Украины',
21	'Украина', 'г. Киев', 'ул. Грушевского, 1', '38 (044) 278-85-12', '38 (044) 278-85-12', 'office@nplu.org', NULL, '192.168.1.*', NULL);	19	'Украина', 'г. Киев', 'ул. Грушевского, 1', '38 (044) 278-85-12', '38 (044) 278-85-12', 'office@nplu.org', NULL, '192.168.1.*', NULL);
22
23	INSERT INTO `branchcategories` (`categorycode`, `categoryname`, `codedescription`, `categorytype`) VALUES
24	('HOME', 'Дом', 'Может устанавливаться как домашняя библиотека', 'properties'),
25	('ISSUE', 'Книговыдача', 'Может выдавать книги', 'properties'),
26	('NATIOS', 'Национальные библиотеки', 'Поисковая область национальных библиотек', 'searchdomain'),
27	('PUBLS', 'Публичные библиотеки', 'Поисковая область публичных библиотек', 'searchdomain'),
28	('UNIVS', 'Университетские библиотеки', 'Поисковая область университетских библиотек', 'searchdomain');
29
30	INSERT INTO `branchrelations` (`branchcode`, `categorycode`) VALUES
31	('AB', 'ISSUE'),
32	('ABH', 'ISSUE'),
33	('LNSL', 'HOME'),
34	('LNSL', 'NATIOS'),
35	('NPLU', 'HOME'),
36	('NPLU', 'NATIOS'),
37	('STL', 'HOME'),
38	('STL', 'UNIVS');
39	-

Return to bug 16735