Bugzilla – Attachment 18835 Details for
Bug 10443
Table borrower_files does not exists in kohastructure.sql file
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Patch to modify kohastructure.sql file
Bug-10443-Table-borrower_files-does-not-exists-in-ko.patch (text/plain), 1.35 KB, created by
Juan Romay Sieira
on 2013-06-11 09:42:36 UTC
(
hide
)
Description:
Patch to modify kohastructure.sql file
Filename:
MIME Type:
Creator:
Juan Romay Sieira
Created:
2013-06-11 09:42:36 UTC
Size:
1.35 KB
patch
obsolete
>From f6a1834205873327c12c6aed04009a8fa8ea6f49 Mon Sep 17 00:00:00 2001 >From: Juan Romay Sieira <juan.sieira@xercode.es> >Date: Tue, 11 Jun 2013 11:36:48 +0200 >Subject: [PATCH] Bug 10443 - Table borrower_files does not exists in kohastructure.sql file >Content-Type: text/plain; charset="utf-8" > >--- > installer/data/mysql/kohastructure.sql | 17 +++++++++++++++++ > 1 files changed, 17 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index ca2f2b2..11d58a1 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2519,6 +2519,23 @@ CREATE TABLE `message_transports` ( > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > -- >+-- Table structure for table `borrower_files` >+-- >+ >+DROP TABLE IF EXISTS `borrower_files`; >+CREATE TABLE IF NOT EXISTS `borrower_files` ( >+ `file_id` int(11) NOT NULL AUTO_INCREMENT, >+ `borrowernumber` int(11) NOT NULL, >+ `file_name` varchar(255) NOT NULL, >+ `file_type` varchar(255) NOT NULL, >+ `file_description` varchar(255) DEFAULT NULL, >+ `file_content` longblob NOT NULL, >+ `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, >+ PRIMARY KEY (`file_id`), >+ KEY `borrowernumber` (`borrowernumber`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ >+-- > -- Table structure for table `borrower_message_preferences` > -- > >-- >1.7.2.5 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10443
:
18835
|
18988
|
19001