Diffusion invenio-infoscience (master) History

sql
masterde7724058d9a2dc02bcf734…

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.
Added forgotten clsMETHOD table.
3da5f7950074
·Tibor Simko on Sep 9 2007, 21:22.
Added forgotten sbmCPLXAPPROVAL table.
ebb204b371f8
·Tibor Simko on Sep 9 2007, 21:19.

Sep 7 2007

Initial experimental release of the complex approval and refereeing workflow.
1d6f473921b5
·Axel Voitier on Sep 7 2007, 14:59.

Sep 3 2007

Added clsMETHOD table for the BibClassify daemon.
ac2bf61da8b3
·Tibor Simko on Sep 3 2007, 14:57.

Aug 6 2007

Fixed column
662c3b14e23a
·Tibor Simko on Aug 6 2007, 17:03.

Jul 31 2007

Corrected typo , -> ;
3d9380546c50
·Samuele Kaplun on Jul 31 2007, 10:06.

Jul 27 2007

First(!) commit of extended WebStat.
d1d2b1e335b8
·Marcus Johansson on Jul 27 2007, 10:18.

Jul 20 2007

"Detailed record" pages reorganisation.
6311159a7fb5
·Jerome Caffaro on Jul 20 2007, 14:30.

Jul 2 2007

Moved migration of password into new automatic password_migration_kit.
c4006f196924
·Samuele Kaplun on Jul 2 2007, 14:18.

Jun 29 2007

Changed boolean values to integer to make happy mysql 4.1.
575231f4751a
·Samuele Kaplun on Jun 29 2007, 17:12.
Added the boolean encrypted column to the user table, in order to assert when…
ad47adbd370f
·Samuele Kaplun on Jun 29 2007, 11:13.

Jun 26 2007

New refactored api for sending email (send_mail in mailutils.py). Includes new…
8ab9f0e7bb4d
·Samuele Kaplun on Jun 26 2007, 12:16.

Jun 22 2007

Fixed a small after-friday-commit-bug.
d22163733183
·Samuele Kaplun on Jun 22 2007, 17:18.
Send via email a unique url to properly reset local lost password.
9acea6e4e420
·Samuele Kaplun on Jun 22 2007, 16:55.

Jun 21 2007

Encrypted local passwords and various fixes.
c12b0c767034
·Samuele Kaplun on Jun 21 2007, 17:42.

Jun 6 2007

Fixed typo.
4d447c7bb554
·Samuele Kaplun on Jun 6 2007, 09:36.

Jun 4 2007

Added runsessiongc new action for running sessiongc as a bibtask.
b2733173c6ec
·Samuele Kaplun on Jun 4 2007, 17:30.

May 15 2007

Many changes, including: * Implementation of a firewall like role definition…
ceaf067fa2cd
·Samuele Kaplun on May 15 2007, 19:35.

Apr 12 2007

Added general support infrastructure for the Chinese translations (zh_CN…
5581b841c09d
·Tibor Simko on Apr 12 2007, 17:19.
Lengthened language column in several tables in order to accomodate language…
0a617288fea3
·Tibor Simko on Apr 12 2007, 15:38.

Apr 2 2007

Added oaiHARVEST.bibfilterprogram.
81dd243329d7
·Tibor Simko on Apr 2 2007, 12:27.
Fixed default oaiHARVEST.postprocess mode value (harvest only).
bc75fd8d3971
·Tibor Simko on Apr 2 2007, 10:42.
Lengthen oaiHARVEST.postprocess column.
071ba819743f
·Tibor Simko on Apr 2 2007, 10:41.

Feb 23 2007

Updates to the Japanese translation, thanks to Toru Tsuboyama.
3d7c91b98121
·Tibor Simko on Feb 23 2007, 09:52.

Feb 19 2007

Lowered down the usergroup.login_method_name index length even more.
7cf5dcfe65fc
·Samuele Kaplun on Feb 19 2007, 14:58.
Limit the length of the usergroup.login_method_name composed index for better…
7d066d794184
·Tibor Simko on Feb 19 2007, 12:00.

Feb 15 2007

Increased group name length to 255 as required by some lengthy CERN group names.
83fbd28d3616
·Tibor Simko on Feb 15 2007, 18:34.

Feb 14 2007

Updated copyright years (2007).
df75ba0b1feb
·Tibor Simko on Feb 14 2007, 19:31.
Added support for external user groups and external user settings. Updated CERN…
852200695592
·Samuele Kaplun on Feb 14 2007, 18:19.

Feb 13 2007

Added the Get_Recid function.
abbdc0df1680
·Nicholas Robinson on Feb 13 2007, 12:34.

Feb 1 2007

Use double quotes enclosures when expanding WML variables, permitting CDSNAME…
f863c9275a60
·Tibor Simko on Feb 1 2007, 17:55.

Jan 16 2007

Create "admin" user in an already-activated account state (note=1), fixing…
12840a16c2bc
·Tibor Simko on Jan 16 2007, 15:31.
Changed "arguments" column type of the "schTASK" table from TEXT to BLOB…
65761e5e4904
·Tibor Simko on Jan 16 2007, 15:01.

Dec 19 2006

Modified oaiArchive table to have non null values.
4b5325d29a4f
·Jerome Caffaro on Dec 19 2006, 09:47.

Dec 7 2006

Moved (old) BibFormat KBs demo data from tabfill to democfgdata. Added new demo…
87ca41fef364
·Jerome Caffaro on Dec 7 2006, 07:44.

Nov 28 2006

Added column 'setspecs' to oaiHarvest table.
86e1a45826db
·Jerome Caffaro on Nov 28 2006, 10:17.

Nov 23 2006

Corrected case of the newly added score column of the sbmCATEGORIES table to…
701fed64dce9
·Tibor Simko on Nov 23 2006, 15:19.
Added column 'score' (unsigned tinyint) to definition of table 'sbmCATEGORIES'.
e1cb0dc9d171
·Nicholas Robinson on Nov 23 2006, 10:22.

Nov 13 2006

Added general support infrastructure for the Croatian translation, with dynamic…
e4bc8a5fca59
·Tibor Simko on Nov 13 2006, 12:27.

Nov 7 2006

Updated definition of 'sbmCATEGORIES' table to include a PRIMARY KEY on columns…
57af4d70d26e
·Nicholas Robinson on Nov 7 2006, 11:35.

Oct 10 2006

Harmonized action names to be the same as used during the upgrade.
8dabfe74a996
·Tibor Simko on Oct 10 2006, 11:54.

Sep 25 2006

Added schTASK table indexes on status and runtime columns.
419a97b53d4e
·Tibor Simko on Sep 25 2006, 18:11.

Sep 8 2006

Inclusion of the NLM format among the default ones.
db0813e0a421
·Tibor Simko on Sep 8 2006, 14:33.

Sep 5 2006

Added default EndNote output format.
1115bc8692f6
·Tibor Simko on Sep 5 2006, 18:51.

Sep 1 2006

Imporved database structure and configuration interface of the external…
876e049c6754
·Olivier Serres on Sep 1 2006, 16:03.

Aug 30 2006

Changed collection_externalcollection column types and added a primary key.
65027de65663
·Tibor Simko on Aug 30 2006, 16:00.

R3600/modules/miscutil/sqlmasterde7724058d9a2dc02bcf734…

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

Sep 7 2007

Sep 3 2007

Aug 6 2007

Jul 31 2007

Jul 27 2007

Jul 20 2007

Jul 2 2007

Jun 29 2007

Jun 26 2007

Jun 22 2007

Jun 21 2007

Jun 6 2007

Jun 4 2007

May 15 2007

Apr 12 2007

Apr 2 2007

Feb 23 2007

Feb 19 2007

Feb 15 2007

Feb 14 2007

Feb 13 2007

Feb 1 2007

Jan 16 2007

Dec 19 2006

Dec 7 2006

Nov 28 2006

Nov 23 2006

Nov 13 2006

Nov 7 2006

Oct 10 2006

Sep 25 2006

Sep 8 2006

Sep 5 2006

Sep 1 2006

Aug 30 2006

R3600/modules/miscutil/sql
masterde7724058d9a2dc02bcf734…