Diffusion invenio-infoscience (master) History

sql
master6a496db6e9fd2bfced044b8…

Sep 19 2008

a comment was badly formed
38362b914128
·Marko Niinimaki on Sep 19 2008, 17:18.
clean after
3218bffb8373
·Marko Niinimaki on Sep 19 2008, 15:33.

Sep 18 2008

better names for db fields
9102f753821b
·Marko Niinimaki on Sep 18 2008, 14:03.

Sep 17 2008

collection based kb's
6019409f09a0
·Marko Niinimaki on Sep 17 2008, 17:04.

Sep 12 2008

consitency with Makefile
95bbe7f782a9
·Marko Niinimaki on Sep 12 2008, 14:02.
default values are always recommended
3bd7b39f8041
·Marko Niinimaki on Sep 12 2008, 13:59.

Sep 4 2008

prepared for taxonomy type kbs
babfd8badc33
·Marko Niinimaki on Sep 4 2008, 10:52.

Aug 29 2008

Holding pen prototype
f34700ca03ee
·Piotr Praczyk on Aug 29 2008, 17:32.

Aug 22 2008

Preliminary release of the BibExport module, featuring general infrastructure…
12968e9f379d
·Tibor Simko on Aug 22 2008, 18:09.

Aug 21 2008

removal of one unnecessary table
3832d5c29b5d
·Piotr Praczyk on Aug 21 2008, 12:05.
Added logging when harvesting record and later (when inserting into teh…
2bd13ab78c6e
·Piotr Praczyk on Aug 21 2008, 11:52.
changed defualt date to date not datetime format
70d3179c9462
·Marko Niinimaki on Aug 21 2008, 10:43.

Aug 15 2008

sql error fix
e8c7c271651f
·Piotr Praczyk on Aug 15 2008, 15:26.
Little changes in SQL tables connected with logging
349d2e584685
·Piotr Praczyk on Aug 15 2008, 13:59.

Aug 13 2008

Add tables of BibCirculation Module
c3c3537153f8
·Joaquim Rodrigues Silvestre on Aug 13 2008, 15:36.

Aug 11 2008

New interface for viewing the harvesting history ( splited into months/days ...
6a21a6e38585
·Piotr Praczyk on Aug 11 2008, 18:06.

Aug 7 2008

Logging of harvested records ( new parameter for bibupload indicating the id of…
ea500c914561
·Piotr Praczyk on Aug 7 2008, 17:32.

Jul 24 2008

Changed 'docname' column of bibdoc table to utf8_bin collation, so that…
47b62ddfb8a6
·Jerome Caffaro on Jul 24 2008, 13:52.
Increased length from 20 chars to 40 chars of column 'name' in table…
e27fa0c794f7
·Jerome Caffaro on Jul 24 2008, 11:07.

Jul 8 2008

Allow client_host to be NULL in cmtACTIONHISTORY table. This fixes the problem…
05498abc3ce2
·Tibor Simko on Jul 8 2008, 10:20.

Jul 3 2008

Added the details of a new parameter (newrnin) to the function…
c5b0b7d9e488
·Nicholas Robinson on Jul 3 2008, 09:45.

Jul 2 2008

Added 'Print_Success_Approval_Request' WebSubmit function.
86bf94f2bb0e
·Nicholas Robinson on Jul 2 2008, 15:46.
Added the details of the 'Mail_Approval_Withdrawn_to_Referee' function.
473662e6e9d1
·Nicholas Robinson on Jul 2 2008, 10:14.

Jul 1 2008

Added the details of the 'Mail_Approval_Request_to_Referee' function.
f1f85f9b8b21
·Nicholas Robinson on Jul 1 2008, 16:40.
Added details of the 'Register_Referee_Decision' function.
f8bbdc2bc54f
·Nicholas Robinson on Jul 1 2008, 16:01.
Added the details of the 'Withdraw_Approval_Request' function; Added another…
484c2317a739
·Nicholas Robinson on Jul 1 2008, 15:55.
The function 'Stamp_and_Replace_Single_File_Approval' was renamed as…
b9fee1907743
·Nicholas Robinson on Jul 1 2008, 10:00.

Jun 30 2008

Added details of the WebSubmit function 'Stamp_and_Replace_Single_File_Approval…
d57c0fb4a6f9
·Nicholas Robinson on Jun 30 2008, 18:47.
hstDOCUMENT.docsize to bigint(15).
d2709acc02cf
·Samuele Kaplun on Jun 30 2008, 12:23.

Jun 29 2008

Dropping final R from rnkAUTHORDATAR since there are no forward/reverse twin…
2ceb4a11bc9d
·Tibor Simko on Jun 29 2008, 23:30.

Jun 26 2008

Added the details of the 'Second_Report_Number_Generation' WebSubmit function.
62c39637bb4b
·Nicholas Robinson on Jun 26 2008, 15:52.

Jun 25 2008

Added rnkAUTHORDATAR.
d68d96a8609f
·Tibor Simko on Jun 25 2008, 19:20.
Added rnkCITATIONDATAEXT.
a841c3ed7fd1
·Tibor Simko on Jun 25 2008, 19:19.
Added XML RefWorks output format. Thanks to Theodoros Theodoropoulos for the…
f5aaccc48d1a
·Tibor Simko on Jun 25 2008, 14:36.

Jun 12 2008

Added a new text field "note" to the sbmAPPROVAL table so that notes relating…
d8c4defef8f9
·Nicholas Robinson on Jun 12 2008, 15:31.

Jun 11 2008

Added details of the WebSubmit function "Register_Approval_Request" and its…
6388016dae80
·Nicholas Robinson on Jun 11 2008, 10:25.

Jun 6 2008

Added the WebSubmit function "User_is_Record_Owner_or_Curator" to…
fcdb51d32c77
·Nicholas Robinson on Jun 6 2008, 12:32.

Jun 4 2008

Added details of the WebSubmit function "Ask_For_Record_Details_Confirmation".
6ce0656e0fa0
·Nicholas Robinson on Jun 4 2008, 18:33.
Added details of "Print_Success_DEL" and "Send_Delete_Mail" WebSubmit functions.
78807fdb0efd
·Nicholas Robinson on Jun 4 2008, 18:23.

May 29 2008

Update to sbmPARAMETERS table. Changed the "value" column from varchar(200) to…
b3ed56478fb9
·Nicholas Robinson on May 29 2008, 11:43.

May 9 2008

Put the new rnkCITATIONDATAEXT key definition into the table definition, as…
0c6230cfa8c9
·Tibor Simko on May 9 2008, 17:45.
index creation for missing citations table
7f52b9ff625d
·Marko Niinimaki on May 9 2008, 17:33.

Apr 25 2008

Priority support in BibSched/BibTasks. Tasks have gained new -P/--priority…
f7f206a04438
·Samuele Kaplun on Apr 25 2008, 18:17.

Apr 24 2008

Added new index #11 tables.
2989f1f03e42
·Tibor Simko on Apr 24 2008, 15:22.

Apr 23 2008

Initial release of the 'journal' index (no special treatment yet).
830792ce7f2a
·Tibor Simko on Apr 23 2008, 19:26.

Apr 15 2008

Mega commit that includes: Added support for keeping comments and descriptions…
9840677d2f4a
·Samuele Kaplun on Apr 15 2008, 16:02.

Apr 8 2008

Added HTML citesummary format.
5205319780b9
·Tibor Simko on Apr 8 2008, 17:03.

Apr 7 2008

Fixed table definition of rnkCITATIONDATA. Added some comment cosmetics to…
9bc57b9d39ca
·Tibor Simko on Apr 7 2008, 16:18.

Apr 4 2008

Cleaned rnkCITATIONDATA table creation and insertion.
7c832161471b
·Samuele Kaplun on Apr 4 2008, 18:05.

Apr 2 2008

Added drop for hstTASK.
5bfa2af54598
·Samuele Kaplun on Apr 2 2008, 19:30.
New BibSched purging of BibTask implementation. Not critical tasks are garbage…
006e34bed813
·Samuele Kaplun on Apr 2 2008, 18:24.

Mar 31 2008

changed doc, column name, added index
503d77e837fe
·Marko Niinimaki on Mar 31 2008, 12:24.
tables for missing citations, author citations
b8b9b3605ca3
·Marko Niinimaki on Mar 31 2008, 11:04.

Mar 25 2008

Do not index URL fields (856*) in the "any field" global word index anymore.
97d84a3a5781
·Tibor Simko on Mar 25 2008, 11:10.

Mar 14 2008

Commented out doi field.
c50dd427fef3
·Samuele Kaplun on Mar 14 2008, 19:46.
Added isbn to books (when possible).
592614249c0c
·Samuele Kaplun on Mar 14 2008, 10:10.

Mar 9 2008

+ Added "decision_file" parameter to functions "Update_Approval_DB"…
c1e7ad4b7bd7
·Nicholas Robinson on Mar 9 2008, 09:33.

Mar 7 2008

Added details of the "Make_Dummy_MARC_XML_Record" function.
318c133a3bc9
·Nicholas Robinson on Mar 7 2008, 23:48.

Mar 3 2008

Added details of the WebSubmit function 'Stamp_Uploaded_Files'.
ceb6867dc61c
·Nicholas Robinson on Mar 3 2008, 11:07.

Feb 28 2008

Removed rnkMETHODNAME and fieldname I18N inserts that are now being done via…
0bb0b828dec4
·Tibor Simko on Feb 28 2008, 18:52.
Added forgotten collection_clsMETHOD table.
0830be67579d
·Tibor Simko on Feb 28 2008, 16:46.

Feb 27 2008

Removed NASA-instruments which doesn't bring any results. Updated bibclassify…
1e42f60d4e9b
·Samuele Kaplun on Feb 27 2008, 14:27.

Feb 25 2008

Moved away authentication from SQL script.
dadee558b50d
·Samuele Kaplun on Feb 25 2008, 19:27.
Added good indexes to bibrec, bibdoc, and added collection_clsMETHOD table.
862cf89a81cd
·Samuele Kaplun on Feb 25 2008, 19:27.

Feb 14 2008

Removed flx* tables and values now that BibFormat in PHP is gone.
1ec25e6584e0
·Tibor Simko on Feb 14 2008, 15:35.

Feb 12 2008

Syncronized tabcreate.sql and root Makefile.am plus fixed some table (e.g.
3d792d328b4c
·Samuele Kaplun on Feb 12 2008, 12:33.

Feb 6 2008

Renamed table 'collectiondetailedpagetabs' to…
471c5a449a75
·Jerome Caffaro on Feb 6 2008, 07:41.

Feb 5 2008

Updated default tab settings for new '/usage' url.
d5ad194201ca
·Jerome Caffaro on Feb 5 2008, 16:14.

Feb 4 2008

Updated copyright years.
eceb995a1b50
·Tibor Simko on Feb 4 2008, 18:38.

Feb 1 2008

Fixed comment spacing in order to make tabcreate.sql syntactically correct.
ade7d37307a5
·Samuele Kaplun on Feb 1 2008, 10:51.

Jan 31 2008

Removed unnecessary FILESWML variable.
f422775c4db3
·Tibor Simko on Jan 31 2008, 14:12.

Jan 30 2008

Install SQL files into "lib" too, so that they can be eventually used even…
60e966d49d0b
·Tibor Simko on Jan 30 2008, 18:50.
Removed WML dependency from tabfill.sql. The current WML-less version no…
5b09dcaab599
·Tibor Simko on Jan 30 2008, 18:49.
Added jrnISSUE.
a293d49a4ff1
·Tibor Simko on Jan 30 2008, 17:56.

Jan 17 2008

Removed UNIQUE attribute to idxPHRASE* indexes since indexes of phrases are…
df99bbd084ae
·Samuele Kaplun on Jan 17 2008, 18:36.

Jan 15 2008

Implemented idxPHRASE indexes that should help when searching for exact phrases…
22223b2f9e3d
·Samuele Kaplun on Jan 15 2008, 18:14.

Jan 11 2008

Made a clearer distinction between BibHarvest and OAIRepository. Added…
5335f14bc43e
·Jerome Caffaro on Jan 11 2008, 16:25.

Jan 10 2008

Moved stemming support from static index config variable structure to column…
0affefbcb29c
·Samuele Kaplun on Jan 10 2008, 17:47.

Jan 7 2008

additions of self citation index/search
75594093d637
·Marko Niinimaki on Jan 7 2008, 11:20.

Dec 19 2007

new table structure for citations
11f15472691a
·Marko Niinimaki on Dec 19 2007, 15:05.

Dec 18 2007

Phased out unnecessary WML source files for database access and I18N.
00cf59226ebd
·Tibor Simko on Dec 18 2007, 11:20.

Dec 14 2007

added a simple method to find self citations and database field to store them
0d3537e827af
·Marko Niinimaki on Dec 14 2007, 15:12.

Dec 13 2007

added issue table for webjournal
21b10e23fc4c
·Gabriel Hase on Dec 13 2007, 15:29.
gave human names to some tags
4bb0518c86fc
·Marko Niinimaki on Dec 13 2007, 12:33.

Dec 12 2007

changed back since the id's have foreign key constraints
42780715bdbc
·Marko Niinimaki on Dec 12 2007, 18:56.
fixed names institute -> publication
dcb77549dec0
·Marko Niinimaki on Dec 12 2007, 14:44.
added some more English names for MARC tags
d5089f71951f
·Marko Niinimaki on Dec 12 2007, 14:12.

Dec 6 2007

Added hstRECORD table.
01bc190de734
·Tibor Simko on Dec 6 2007, 17:58.
Fixed wrong id_bibdoc column type of the rnkDOWNLOADS table. Added hstRECORD…
23360c6c5ece
·Tibor Simko on Dec 6 2007, 17:58.
Added missing jrnJOURNAL table.
3fd88e7ec5a8
·Tibor Simko on Dec 6 2007, 17:45.
New bibdocfile library for handling fulltextes, to be used in place of file.py.
1b0dac2bf837
·Samuele Kaplun on Dec 6 2007, 17:33.
added table for webjournal module
ed8102e13cd0
·Gabriel Hase on Dec 6 2007, 15:10.

Dec 4 2007

Reverted creation of bibdoclog table until its name/structure will be finalized.
56a4eaf5e6f6
·Samuele Kaplun on Dec 4 2007, 15:11.
First proposal for implementing logging on database of bibdocfile library…
d48d96c94d07
·Samuele Kaplun on Dec 4 2007, 12:52.

Nov 6 2007

Added new action viewrestrdoc, to add rights/restriction for downloading…
a9beee30e526
·Samuele Kaplun on Nov 6 2007, 17:53.

Nov 1 2007

New support for checking correctness of email addresses provided at local…
ff426b6617e9
·Samuele Kaplun on Nov 1 2007, 12:06.
Added delete column to accMAILCOOKIE table in order to mark cookie as deleted…
286af06ebb7f
·Samuele Kaplun on Nov 1 2007, 11:01.

Oct 18 2007

Added details of 'Move_Files_to_Storage' function.
25b81679cf6a
·Nicholas Robinson on Oct 18 2007, 11:54.

Sep 14 2007

Added checkbox to display/hide output formats in list of output formats on…
e467d4e47eea
·Jerome Caffaro on Sep 14 2007, 15:37.

Sep 9 2007

Added IF NOT EXISTS for sbmCPLXAPPROVAL table creation statement.
35dfc35e4ce6
·Tibor Simko on Sep 9 2007, 21:23.

R3600/modules/miscutil/sqlmaster6a496db6e9fd2bfced044b8…

Sep 19 2008

Sep 18 2008

Sep 17 2008

Sep 12 2008

Sep 4 2008

Aug 29 2008

Aug 22 2008

Aug 21 2008

Aug 15 2008

Aug 13 2008

Aug 11 2008

Aug 7 2008

Jul 24 2008

Jul 8 2008

Jul 3 2008

Jul 2 2008

Jul 1 2008

Jun 30 2008

Jun 29 2008

Jun 26 2008

Jun 25 2008

Jun 12 2008

Jun 11 2008

Jun 6 2008

Jun 4 2008

May 29 2008

May 9 2008

Apr 25 2008

Apr 24 2008

Apr 23 2008

Apr 15 2008

Apr 8 2008

Apr 7 2008

Apr 4 2008

Apr 2 2008

Mar 31 2008

Mar 25 2008

Mar 14 2008

Mar 9 2008

Mar 7 2008

Mar 3 2008

Feb 28 2008

Feb 27 2008

Feb 25 2008

Feb 14 2008

Feb 12 2008

Feb 6 2008

Feb 5 2008

Feb 4 2008

Feb 1 2008

Jan 31 2008

Jan 30 2008

Jan 17 2008

Jan 15 2008

Jan 11 2008

Jan 10 2008

Jan 7 2008

Dec 19 2007

Dec 18 2007

Dec 14 2007

Dec 13 2007

Dec 12 2007

Dec 6 2007

Dec 4 2007

Nov 6 2007

Nov 1 2007

Oct 18 2007

Sep 14 2007

Sep 9 2007

R3600/modules/miscutil/sql
master6a496db6e9fd2bfced044b8…