Diffusion invenio-infoscience (master) History

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

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.

Aug 29 2005

modified oaiHARVEST table to suit bibharvest admin.
4670cd400f08
·Alberto Pepe on Aug 29 2005, 15:04.

Mar 15 2005

Add table rnkPAGEVIEWS.
773c3527436a
·Tibor Simko on Mar 15 2005, 19:50.
Create rnkCITATIONDATA and rnkDOWNLOADS tables only if they don't exist.
1b7e87fa3ded
·Tibor Simko on Mar 15 2005, 19:36.
Add rnkDOWNLOADS and rnkCITATIONDATA tables.
33ef22a957b6
·Tibor Simko on Mar 15 2005, 19:34.

Mar 4 2005

Added index on session.uid, thanks to Frederic.
4f31c3b59549
·Tibor Simko on Mar 4 2005, 10:43.

Jan 6 2005

Updated copyright years.
84b18f1b27c5
·Tibor Simko on Jan 6 2005, 17:41.

Sep 15 2004

change "status" column of schTASK table.
4eb756b73013
·Thomas Baron on Sep 15 2004, 14:11.

Sep 8 2004

New BibRank tables.
f0feb11e877a
·Tibor Simko on Sep 8 2004, 17:13.

Aug 23 2004

Revert previous TEXT-into-BLOB changes, since they didn't work with MySQL 4.1.3…
f1563f9b6df5
·Tibor Simko on Aug 23 2004, 13:56.
Changed BLOB to TEXT for the sake of MySQLdb 1.0.0 compliancy. Changed…
a1d87725292b
·Tibor Simko on Aug 23 2004, 09:48.

Jul 28 2004

turned schTASK/arguments column into longtext
468329f0d743
·Thomas Baron on Jul 28 2004, 14:07.

Jul 14 2004

Remove unnecessary trailing commas (causing troubles on some systems).
6720297eb195
·Tibor Simko on Jul 14 2004, 16:41.

May 27 2004

corrected sbmCOLLECTION_sbmDOCTYPE table definition id_son is now a 10…
d6b6f020e185
·Thomas Baron on May 27 2004, 14:27.

Apr 15 2004

Remove unwanted auto_increment attribute for several I18N-related fooBARNAME…
8fead3a5b8b1
·Tibor Simko on Apr 15 2004, 16:32.

Mar 5 2004

Adapt to new I18N naming policy. Remove unnecessary user_rules and rules tables.
19dcf64c0a68
·Tibor Simko on Mar 5 2004, 15:37.
OAI related tables modified.
1348faf8e6e0
·Martin Vesely on Mar 5 2004, 12:26.

Mar 4 2004

oaiset table extended by setDefinition column for virtual oai sets definition.
945a51364017
·Martin Vesely on Mar 4 2004, 15:45.

Mar 2 2004

increased from 10 to 50 the size of the sbmFIELDDESC/marccode column
8c5c4357cde9
·Thomas Baron on Mar 2 2004, 17:06.

Mar 1 2004

dropped table sbmMODIFY - replaced with a new column in sbmFIELDDESC
ea48f4f87b9c
·Thomas Baron on Mar 1 2004, 14:13.

Feb 27 2004

small change in file db structure
85ffa13756b5
·Thomas Baron on Feb 27 2004, 17:54.
new file management system
4a0824f21dc8
·Thomas Baron on Feb 27 2004, 11:45.

Feb 25 2004

Fixed idxINDEX_field regexp treatment.
fad68c274e3b
·Tibor Simko on Feb 25 2004, 11:34.
Use term/termlist instead of word/wordlist.
ea3bccc4caf5
·Tibor Simko on Feb 25 2004, 11:22.

Feb 23 2004

bibwords->bibindex. idxRANK introduced.
c9ff88c49bd1
·Tibor Simko on Feb 23 2004, 17:51.

Feb 13 2004

Add language argument to collection_portalbox.
98f64e93ece5
·Tibor Simko on Feb 13 2004, 16:40.

Feb 5 2004

no need of sbmCOOKIE table anymore
d74321306909
·Thomas Baron on Feb 5 2004, 16:28.

Dec 2 2003

ace->acc prefix change
dff91c342db4
·Mikael Vik on Dec 2 2003, 20:51.

Jul 10 2003

did changes, but forgot one comma in aceARGUMENT
ce3861c78db5
·Mikael Vik on Jul 10 2003, 17:27.
Added auto_increment to tables in access control engine (aceROLE, aceACTION and…
6a7f3c3da1e7
·Mikael Vik on Jul 10 2003, 15:57.

Jul 4 2003

Added tables for access control engine.
80ccb4ecccb2
·Mikael Vik on Jul 4 2003, 15:38.

Jun 26 2003

schTASK table cleaning. New indexes for ``bibfmt''.
0d7695476cbe
·Tibor Simko on Jun 26 2003, 17:51.