← Back to branch summary

~ubuntu-branches/ubuntu/trusty/jabref/trusty

« back to all changes in this revision

Viewing changes to src/java/net/sf/jabref/sql/SQLutil.java

  • Committer: Bazaar Package Importer
  • Author(s): gregor herrmann
  • Date: 2009-12-01 18:52:51 UTC
  • mfrom: (1.1.4 upstream)
  • Revision ID: james.westby@ubuntu.com-20091201185251-08e2unpn1jl8ijq8
Tags: 2.6~beta2-1
http://bugs.debian.org/447767
* Remove alternative dependency on sun-java5-jre which was removed from the
  archive. Also adjust README.Debian and /usr/bin/jabref.
* New upstream beta release:
  - fixes "allow to disable (re)storing of current tab for entries"
    (closes: #447767)
  - thanks again to Philip Rinn for his help with the upgrade
* debian/copyright: add new developer.
* Refresh patches 01_free_javac.patch and 06_BibtexEntry.patch.
* Adjust debian/jabref.links and debian/jabref.install to new jar file.
* Simplify debian/jabref.dirs.
* Add a presubj fragment for reportbug.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/java/net/sf/jabref/sql/SQLutil.java
776
776
            + ", \n"
777
777
            + "PRIMARY KEY (entry_types_id) \n"
778
778
            + ");" );
779
 
           
 
779
                                
780
780
        processDML(out,"CREATE TABLE entries ( \n"
781
781
            + "entries_id      INTEGER         NOT NULL AUTO_INCREMENT, \n"
782
782
                        + "jabref_eid      VARCHAR("
783
783
                        +  Util.getMinimumIntegerDigits()
784
784
                    + ")   DEFAULT NULL, \n"
785
 
            + "entry_types_id  INTEGER         DEFAULT NULL, \n"
 
785
            + "entry_types_id  INT UNSIGNED         DEFAULT NULL, \n"
786
786
            + "cite_key        VARCHAR(100)     DEFAULT NULL, \n"
787
787
            + dml2
788
788
            + ",\n"
789
789
            + "PRIMARY KEY (entries_id), \n"
790
 
            + "FOREIGN KEY (entry_types_id) REFERENCES entry_type(entry_types_id) \n"
 
790
                        + "INDEX(entry_types_id), \n"
 
791
            + "FOREIGN KEY (entry_types_id) REFERENCES entry_types(entry_types_id) \n"
791
792
            + ");");
792
793
 
793
794
        processDML(out,"CREATE TABLE strings ( \n"
819
820
        processDML(out,"CREATE TABLE entry_group ( \n"
820
821
            + "entries_id       INTEGER        NOT NULL AUTO_INCREMENT, \n"
821
822
            + "groups_id        INTEGER        DEFAULT NULL, \n"
822
 
            + "FOREIGN KEY (entries_id) REFERENCES entry_fields(entries_id), \n"
 
823
                        + "INDEX(entries_id), \n"
 
824
                        + "INDEX(groups_id), \n"
 
825
            + "FOREIGN KEY (entries_id) REFERENCES entries(entries_id), \n"
823
826
            + "FOREIGN KEY (groups_id)  REFERENCES groups(groups_id) \n"
824
827
            + ");");
825
828
 
859
862
            + ")");
860
863
          
861
864
        processDML(out,"ALTER TABLE entries ADD CONSTRAINT entries_fk "
862
 
                     + "FOREIGN KEY (\"entry_types_id\") REFERENCES \"entry_type\" (\"entry_types_id\")");
 
865
                     + "FOREIGN KEY (\"entry_types_id\") REFERENCES \"entry_types\" (\"entry_types_id\")");
863
866
 
864
867
        processDML(out,"CREATE TABLE group_types ( "
865
868
            + "group_types_id INT  NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, "