Attachment 65659 Details for Bug 16735 – Bug 16735 - Clean up sample data

[patch] Bug 16735 - Clean up sample data

Bug-16735---Clean-up-sample-data.patch (text/plain), 7.88 KB, created by Kyle M Hall (khall) on 2017-08-08 16:41:49 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2017-08-08 16:41:49 UTC

Size: 7.88 KB

patch

obsolete

>From de99216c9b05886219c140381f80f3bbbc3a5334 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Thu, 23 Jun 2016 13:24:54 +0000
>Subject: [PATCH] Bug 16735 - Clean up sample data
>
>Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
>---
> .../data/mysql/en/optional/sample_libraries.sql      |  2 --
> .../data/mysql/es-ES/optional/sample_libraries.sql   |  4 ----
> .../mysql/nb-NO/2-Valgfritt/sample_libraries.sql     |  4 ----
> .../data/mysql/pl-PL/optional/sample_libraries.sql   |  4 ----
> .../data/mysql/ru-RU/optional/example_branches.sql   | 19 -------------------
> .../data/mysql/uk-UA/optional/example_branches.sql   | 20 --------------------
> 6 files changed, 53 deletions(-)
>
>diff --git a/installer/data/mysql/en/optional/sample_libraries.sql b/installer/data/mysql/en/optional/sample_libraries.sql
>index cfbe0b1..234cba5 100644
>--- a/installer/data/mysql/en/optional/sample_libraries.sql
>+++ b/installer/data/mysql/en/optional/sample_libraries.sql
>@@ -1,5 +1,3 @@
>--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
>-
> INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> 
> ('MPL','Midway','372 Forest Street'),
>diff --git a/installer/data/mysql/es-ES/optional/sample_libraries.sql b/installer/data/mysql/es-ES/optional/sample_libraries.sql
>index a2fa52e..58dc24e 100644
>--- a/installer/data/mysql/es-ES/optional/sample_libraries.sql
>+++ b/installer/data/mysql/es-ES/optional/sample_libraries.sql
>@@ -1,5 +1,3 @@
>--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
>-
> INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> 
> ('MPL','Midway','372 Forest Street'),
>@@ -15,5 +13,3 @@ INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> ('LPL','Liberty','East Hills'),
> ('UPL','Union','Chestnut Hollow')
> ;
>-
>--- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
>diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql
>index a2fa52e..58dc24e 100644
>--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql
>+++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql
>@@ -1,5 +1,3 @@
>--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
>-
> INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> 
> ('MPL','Midway','372 Forest Street'),
>@@ -15,5 +13,3 @@ INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> ('LPL','Liberty','East Hills'),
> ('UPL','Union','Chestnut Hollow')
> ;
>-
>--- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
>diff --git a/installer/data/mysql/pl-PL/optional/sample_libraries.sql b/installer/data/mysql/pl-PL/optional/sample_libraries.sql
>index a2fa52e..58dc24e 100644
>--- a/installer/data/mysql/pl-PL/optional/sample_libraries.sql
>+++ b/installer/data/mysql/pl-PL/optional/sample_libraries.sql
>@@ -1,5 +1,3 @@
>--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
>-
> INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> 
> ('MPL','Midway','372 Forest Street'),
>@@ -15,5 +13,3 @@ INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
> ('LPL','Liberty','East Hills'),
> ('UPL','Union','Chestnut Hollow')
> ;
>-
>--- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
>diff --git a/installer/data/mysql/ru-RU/optional/example_branches.sql b/installer/data/mysql/ru-RU/optional/example_branches.sql
>index d4ec0de..51d1efe 100644
>--- a/installer/data/mysql/ru-RU/optional/example_branches.sql
>+++ b/installer/data/mysql/ru-RU/optional/example_branches.sql
>@@ -1,6 +1,4 @@
> TRUNCATE branches;
>-TRUNCATE branchcategories;
>-TRUNCATE branchrelations;
> 
> INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchaddress2`, `branchaddress3`, `branchphone`, `branchfax`, `branchemail`, `issuing`, `branchip`, `branchprinter`) VALUES
> ('AB',   'ÐÐ±Ð¾Ð½ÐµÐ¼ÐµÐ½Ñ', 
>@@ -19,20 +17,3 @@ INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchadd
>              'Ð£ÐºÑÐ°Ð¸Ð½Ð°', 'Ð¼. Ð¢ÐµÑÐ½Ð¾Ð¿ÑÐ»Ñ', 'ÑÐ». Ð ÑÑÑÐºÐ° 56, ÐºÐ°Ð±Ð¸Ð½ÐµÑ 5 (Ð²ÑÐ¾ÑÐ¾Ð¹ ÐºÐ¾ÑÐ¿ÑÑ)', '8 (0352) 52-53-45', '', 'lib@tu.edu.te.ua', NULL, '', NULL),
> ('NPLU', 'ÐÐ°ÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð°Ñ Ð¿Ð°ÑÐ»Ð°Ð¼ÐµÐ½ÑÑÐºÐ°Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ° Ð£ÐºÑÐ°Ð¸Ð½Ñ', 
>              'Ð£ÐºÑÐ°Ð¸Ð½Ð°', 'Ð³. ÐÐ¸ÐµÐ²', 'ÑÐ». ÐÑÑÑÐµÐ²ÑÐºÐ¾Ð³Ð¾, 1', '38 (044) 278-85-12', '38 (044) 278-85-12', 'office@nplu.org', NULL, '192.168.1.*', NULL);
>-
>-INSERT INTO `branchcategories` (`categorycode`, `categoryname`, `codedescription`, `categorytype`) VALUES
>-('HOME',   'ÐÐ¾Ð¼',                        'ÐÐ¾Ð¶ÐµÑ ÑÑÑÐ°Ð½Ð°Ð²Ð»Ð¸Ð²Ð°ÑÑÑÑ ÐºÐ°Ðº Ð´Ð¾Ð¼Ð°ÑÐ½ÑÑ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ°', 'properties'),
>-('ISSUE',  'ÐÐ½Ð¸Ð³Ð¾Ð²ÑÐ´Ð°ÑÐ°',                'ÐÐ¾Ð¶ÐµÑ Ð²ÑÐ´Ð°Ð²Ð°ÑÑ ÐºÐ½Ð¸Ð³Ð¸',                          'properties'),
>-('NATIOS', 'ÐÐ°ÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½ÑÐµ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸',    'ÐÐ¾Ð¸ÑÐºÐ¾Ð²Ð°Ñ Ð¾Ð±Ð»Ð°ÑÑÑ Ð½Ð°ÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½ÑÑ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐº',      'searchdomain'),
>-('PUBLS',  'ÐÑÐ±Ð»Ð¸ÑÐ½ÑÐµ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸',       'ÐÐ¾Ð¸ÑÐºÐ¾Ð²Ð°Ñ Ð¾Ð±Ð»Ð°ÑÑÑ Ð¿ÑÐ±Ð»Ð¸ÑÐ½ÑÑ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐº',         'searchdomain'),
>-('UNIVS',  'Ð£Ð½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑÑÐºÐ¸Ðµ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸', 'ÐÐ¾Ð¸ÑÐºÐ¾Ð²Ð°Ñ Ð¾Ð±Ð»Ð°ÑÑÑ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑÑÐºÐ¸Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐº',   'searchdomain');
>-
>-INSERT INTO `branchrelations` (`branchcode`, `categorycode`) VALUES
>-('AB',   'ISSUE'),
>-('ABH',  'ISSUE'),
>-('LNSL', 'HOME'),
>-('LNSL', 'NATIOS'),
>-('NPLU', 'HOME'),
>-('NPLU', 'NATIOS'),
>-('STL',  'HOME'),
>-('STL',  'UNIVS');
>diff --git a/installer/data/mysql/uk-UA/optional/example_branches.sql b/installer/data/mysql/uk-UA/optional/example_branches.sql
>index 1790dee..b8962f8 100644
>--- a/installer/data/mysql/uk-UA/optional/example_branches.sql
>+++ b/installer/data/mysql/uk-UA/optional/example_branches.sql
>@@ -1,6 +1,4 @@
> TRUNCATE branches;
>-TRUNCATE branchcategories;
>-TRUNCATE branchrelations;
> 
> INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchaddress2`, `branchaddress3`, `branchphone`, `branchfax`, `branchemail`, `issuing`, `branchip`, `branchprinter`) VALUES
> ('AB',   'ÐÐ±Ð¾Ð½ÐµÐ¼ÐµÐ½Ñ', 
>@@ -19,21 +17,3 @@ INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchadd
>              'Ð£ÐºÑÐ°ÑÐ½Ð°', 'Ð¼. Ð¢ÐµÑÐ½Ð¾Ð¿ÑÐ»Ñ', 'Ð²ÑÐ». Ð ÑÑÑÐºÐ° 56, ÐºÐ°Ð±ÑÐ½ÐµÑ 5 (Ð´ÑÑÐ³Ð¸Ð¹ ÐºÐ¾ÑÐ¿ÑÑ)', '8 (0352) 52-53-45', '', 'lib@tu.edu.te.ua', NULL, '', NULL),
> ('NPLU', 'ÐÐ°ÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð° Ð¿Ð°ÑÐ»Ð°Ð¼ÐµÐ½ÑÑÑÐºÐ° Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ° Ð£ÐºÑÐ°ÑÐ½Ð¸', 
>              'Ð£ÐºÑÐ°ÑÐ½Ð°', 'Ð¼. ÐÐ¸ÑÐ²', 'Ð²ÑÐ». ÐÑÑÑÐµÐ²ÑÑÐºÐ¾Ð³Ð¾, 1', '38 (044) 278-85-12', '38 (044) 278-85-12', 'office@nplu.org', NULL, '192.168.1.*', NULL);
>-
>-INSERT INTO `branchcategories` (`categorycode`, `categoryname`, `codedescription`, `categorytype`) VALUES
>-('HOME',   'ÐÐ¾Ð¼ÑÐ²ÐºÐ°',                    'ÐÐ¾Ð¶Ðµ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð»ÑÐ²Ð°ÑÐ¸ÑÑ ÑÐº Ð´Ð¾Ð¼Ð°ÑÐ½Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ°',   'properties'),
>-('ISSUE',  'ÐÐ½Ð¸Ð³Ð¾Ð²Ð¸Ð´Ð°ÑÐ°',                'ÐÐ¾Ð¶Ðµ Ð²Ð¸Ð´Ð°Ð²Ð°ÑÐ¸ ÐºÐ½Ð¸Ð³Ð¸',                          'properties'),
>-('NATIOS', 'ÐÐ°ÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð° Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ°',     'ÐÐ¾ÑÑÐºÐ¾Ð²Ð° Ð¾Ð±Ð»Ð°ÑÑÑ Ð½Ð°ÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¸Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐº',      'searchdomain'),
>-('PUBLS',  'ÐÑÐ±Ð»ÑÑÐ½Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ¸',        'ÐÐ¾ÑÑÐºÐ¾Ð²Ð° Ð¾Ð±Ð»Ð°ÑÑÑ Ð¿ÑÐ±Ð»ÑÑÐ½Ð¸Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐº',         'searchdomain'),
>-('UNIVS',  'Ð£Ð½ÑÐ²ÐµÑÑÐ¸ÑÐµÑÑÑÐºÑ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ¸', 'ÐÐ¾ÑÑÐºÐ¾Ð²Ð° Ð¾Ð±Ð»Ð°ÑÑÑ ÑÐ½ÑÐ²ÐµÑÑÐ¸ÑÐµÑÑÑÐºÐ¸Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐº',  'searchdomain');
>-
>-INSERT INTO `branchrelations` (`branchcode`, `categorycode`) VALUES
>-('AB',   'ISSUE'),
>-('ABH',  'ISSUE'),
>-('LNSL', 'HOME'),
>-('LNSL', 'NATIOS'),
>-('NPLU', 'HOME'),
>-('NPLU', 'NATIOS'),
>-('STL',  'HOME'),
>-('STL',  'UNIVS');
>-
>-- 
>2.10.2

Actions: View | Diff | Splinter Review

Attachments on bug 16735: 52732 | 52733 | 52734 | 52735 | 57098 | 57099 | 57100 | 57101 | 58087 | 58088 | 58089 | 58090 | 60497 | 60498 | 60499 | 60500 | 60501 | 60502 | 60503 | 60772 | 60773 | 60774 | 60775 | 60776 | 60777 | 60778 | 60779 | 65658 | 65659 | 65660 | 65661 | 65662 | 65663 | 65664 | 65665 | 69533 | 69534 | 69535 | 69536 | 69537 | 69538 | 69539 | 69540 | 69541 | 69684 | 69685 | 69686 | 69687 | 69688 | 69689 | 69690 | 69691 | 69692 | 69693 | 69694 | 71386 | 71393