Attachment 69535 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), 5.59 KB, created by Jonathan Druart on 2017-12-05 17:13:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2017-12-05 17:13:57 UTC

Size: 5.59 KB

patch

obsolete

>From ae53375d0188f83691a3e74b28ba8b441ce60405 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>
>---
> installer/data/mysql/en/optional/sample_libraries.sql |  2 --
> .../data/mysql/es-ES/optional/sample_libraries.sql    |  4 ----
> .../data/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 -------------------
> 5 files changed, 33 deletions(-)
>
>diff --git a/installer/data/mysql/en/optional/sample_libraries.sql b/installer/data/mysql/en/optional/sample_libraries.sql
>index cfbe0b158b..234cba5498 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 a2fa52e8c6..58dc24e249 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 a2fa52e8c6..58dc24e249 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 a2fa52e8c6..58dc24e249 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 d4ec0de816..51d1efe90f 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');
>-- 
>2.11.0

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