Diffusion invenio-infoscience (master) History

R3600/modules/miscutil/sql/tabcreate.sql
master9102f753821b8a1c38761ba…

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 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.

Jun 30 2008

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 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.

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 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 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

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.

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

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 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 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 10 2008

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

Dec 19 2007

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

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.

Dec 6 2007

Fixed wrong id_bibdoc column type of the rnkDOWNLOADS table. Added hstRECORD…
23360c6c5ece
·Tibor Simko on Dec 6 2007, 17:58.
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 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.

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.

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 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

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.

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

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 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.

Jan 16 2007

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.

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 7 2006

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

Sep 25 2006

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

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.
Add external collections searching.
be4a6f74a072
·Olivier Serres on Aug 30 2006, 12:25.

Jul 20 2006

Initial release of the new BibFormat in Python. The status is still…
688839a69c28
·Jerome Caffaro on Jul 20 2006, 17:47.

Jun 29 2006

Changed join policy and user status column types of group-related tables.
4ab1fc999d83
·Tibor Simko on Jun 29 2006, 21:34.

May 10 2006

Added missing table bskEXTFMT. Deleted doubly defined id key for bskEXTREC and…
dcc47c836518
·Tibor Simko on May 10 2006, 10:09.

May 5 2006

Merge of oaiSET and oaiARCHIVE tables. (Note: data conversion needed)
ffaeda9d6e55
·Martin Vesely on May 5 2006, 11:58.

May 4 2006

Implemented name change CDSware to CDS Invenio. Also, introduced new configure…
18b100fe8575
·Tibor Simko on May 4 2006, 16:34.

May 2 2006

Updated copyright years.
d5b36a574e3c
·Tibor Simko on May 2 2006, 14:54.

Apr 13 2006

Added new tables for new webbasket module. Removed tables created by old…
090520d0d0ed
·Gregory Favre on Apr 13 2006, 15:50.

Apr 12 2006

Adding OAI repository update changes in miscutil.
874376125fe9
·Martin Vesely on Apr 12 2006, 01:01.

Feb 2 2006

Delete superfluous `>' characters in the new oaiARCHIVE table definition.
5ea87c8c454b
·Tibor Simko on Feb 2 2006, 13:32.

Jan 31 2006

OAI repository database structure change. OAI db structure upgraded to…
fd092e87b53e
·Martin Vesely on Jan 31 2006, 17:44.

Jan 17 2006

Added a new table (cmtACTIONHISTORY). This table will be used by webcomment…
a8264682c1fc
·Gregory Favre on Jan 17 2006, 11:41.

Dec 14 2005

Added flxKBDBCOLLID2BIBTEX table for the BibTeX support.
ec7f194fb954
·Tibor Simko on Dec 14 2005, 14:53.

Nov 8 2005

Fixed to-be-eliminated comments.
badb3a146f27
·Tibor Simko on Nov 8 2005, 16:58.
Added tables for WebMessage.
cceca1c61a5e
·Gregory Favre on Nov 8 2005, 15:13.

Sep 13 2005

New table created for comments. Adding a nickname for admin. Setting up role…
ca1665a68ce5
·Paulo Cabral on Sep 13 2005, 20:11.

Aug 30 2005

Modified column names of table oaiHARVEST (removed CamelCase)
6c13eaf14724
·Alberto Pepe on Aug 30 2005, 12:17.