PageRenderTime 51ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/src/mpv5/db/common/DatabaseInstallation.java

http://mp-rechnungs-und-kundenverwaltung.googlecode.com/
Java | 307 lines | 275 code | 3 blank | 29 comment | 0 complexity | 181373f76d2409e1ca70f8e88cd41b1d MD5 | raw file
Possible License(s): LGPL-3.0, Apache-2.0, GPL-3.0, GPL-2.0, AGPL-3.0, JSON, BSD-3-Clause 
    

  1.   /*

    2. 

  2.  *  This file is part of YaBS.

    3. 

  3.  *

    4. 

  4.  *  YaBS is free software: you can redistribute it and/or modify

    5. 

  5.  *  it under the terms of the GNU General Public License as published by

    6. 

  6.  *  the Free Software Foundation, either version 3 of the License, or

    7. 

  7.  *  (at your option) any later version.

    8. 

  8.  *

    9. 

  9.  *  YaBS is distributed in the hope that it will be useful,

    10. 

  10.  *  but WITHOUT ANY WARRANTY; without even the implied warranty of

    11. 

  11.  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    12. 

  12.  *  GNU General Public License for more details.

    13. 

  13.  *

    14. 

  14.  *  You should have received a copy of the GNU General Public License

    15. 

  15.  *  along with YaBS.  If not, see <http://www.gnu.org/licenses/>.

    16. 

  16.  */

    17. 

  17. package mpv5.db.common;

    18. 

  18. 

    19. 

  19. import javax.swing.UIManager;

    20. 

  20. import mpv5.db.objects.Account;

    21. 

  21. import mpv5.globals.Constants;

    22. 

  22. import mpv5.globals.Messages;

    23. 

  23. 

    24. 

  24. /**

    25. 

  25.  * 

    26. 

  26.  */

    27. 

  27. public class DatabaseInstallation {

    28. 

  28. 

    29. 

  29.     /**

    30. 

  30.      * This contains the database structure for mpv5

    31. 

  31.      *

    32. 

  32.      * As SQL.Views are currently not updateable from DERBY, i use two nearly identical tables here, to store user informations.

    33. 

  33.      * First one holds a users default data, where the second table holds additional address info.

    34. 

  34.      *

    35. 

  35.      */

    36. 

  36.     public final static String[] DERBY_STRUCTURE = new String[]{

    37. 

  37.         "CREATE TABLE groups (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(250) UNIQUE NOT NULL,description VARCHAR(750) DEFAULT NULL,defaults VARCHAR(250) DEFAULT NULL,groupsids BIGINT DEFAULT 0,dateadded DATE NOT NULL,reserve1 VARCHAR(500) DEFAULT NULL,intaddedby BIGINT DEFAULT 0, hierarchypath VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL, PRIMARY KEY  (ids))",

    38. 

  38.         "CREATE TABLE productgroups (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const1 UNIQUE (cname, groupsids), cname VARCHAR(250) NOT NULL,description VARCHAR(750) DEFAULT NULL,defaults VARCHAR(250) DEFAULT NULL,groupsids BIGINT DEFAULT 0, productgroupsids BIGINT DEFAULT 0,dateadded DATE NOT NULL, hierarchypath VARCHAR(500) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL,intaddedby BIGINT DEFAULT 0, reserve2 VARCHAR(500) DEFAULT NULL, PRIMARY KEY  (ids))",

    39. 

  39.         "CREATE TABLE history (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250)  NOT NULL, username VARCHAR(250) NOT NULL,dbidentity VARCHAR(25)  NOT NULL, INTitem SMALLINT NOT NULL,groupsids BIGINT DEFAULT 0, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    40. 

  40.         "CREATE TABLE countries (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(250) NOT NULL, iso SMALLINT  UNIQUE NOT NULL,groupsids BIGINT DEFAULT 1,reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    41. 

  41.         "CREATE TABLE searchindex (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),dbidentity VARCHAR(25) NOT NULL, groupsids BIGINT, rowID BIGINT NOT NULL,text VARCHAR(5000) DEFAULT NULL)",

    42. 

  42.         "CREATE TABLE globalsettings (IDS BIGINT DEFAULT 1,  CONSTRAINT const2 UNIQUE (cname, groupsids), cname VARCHAR(250) NOT NULL, groupsids BIGINT DEFAULT 1, value VARCHAR(250) NOT NULL)",

    43. 

  43.         //Main tables, must have ids, cname, groupsids, dateadded, intaddedby, invisible

    44. 

  44.         "CREATE TABLE tax (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(250), taxvalue DOUBLE DEFAULT 0,identifier VARCHAR(250) DEFAULT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,country VARCHAR(50) DEFAULT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    45. 

  45.         "CREATE TABLE contacts (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const3 UNIQUE (cnumber, groupsids), cnumber VARCHAR(250) DEFAULT NULL, taxnumber VARCHAR(250), title VARCHAR(250) DEFAULT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,country VARCHAR(50) DEFAULT NULL, prename VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, street VARCHAR(250) DEFAULT NULL,zip VARCHAR(50) DEFAULT NULL,city VARCHAR(300) DEFAULT NULL, mainphone VARCHAR(250) DEFAULT NULL,fax VARCHAR(250) DEFAULT NULL,mobilephone VARCHAR(250) DEFAULT NULL,workphone VARCHAR(250) DEFAULT NULL,mailaddress VARCHAR(350) DEFAULT NULL,company VARCHAR(250) DEFAULT NULL, department VARCHAR(250) DEFAULT NULL,website VARCHAR(350) DEFAULT NULL,notes VARCHAR(10000),dateadded DATE NOT NULL,isactive SMALLINT DEFAULT 0,iscustomer SMALLINT DEFAULT 0,ismanufacturer SMALLINT DEFAULT 0,issupplier SMALLINT DEFAULT 0,iscompany SMALLINT DEFAULT 0,ismale SMALLINT DEFAULT 0,isenabled SMALLINT DEFAULT 1,intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    46. 

  46.         "CREATE TABLE users (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const4 UNIQUE (cname, groupsids), cname VARCHAR(250) NOT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, intdefaultaccount BIGINT DEFAULT 1, compsids BIGINT DEFAULT 0, intdefaultstatus BIGINT DEFAULT 1,fullname VARCHAR(250) NOT NULL, password VARCHAR(250) NOT NULL,laf VARCHAR(150) DEFAULT NULL, locale VARCHAR(50) DEFAULT NULL, defcountry VARCHAR(50) DEFAULT '276', mail VARCHAR(50) DEFAULT NULL, language VARCHAR(150) DEFAULT NULL, inthighestright SMALLINT DEFAULT 3,isenabled SMALLINT DEFAULT 1,isrgrouped SMALLINT DEFAULT 0,isloggedin SMALLINT DEFAULT 0,datelastlog DATE DEFAULT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    47. 

  47.         "CREATE TABLE files (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(25) UNIQUE NOT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,dateadded DATE NOT NULL,data BLOB(50M) NOT NULL, filesize BIGINT NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,PRIMARY KEY  (ids))",

    48. 

  48.         "CREATE TABLE languages(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const6 UNIQUE (cname, groupsids), cname VARCHAR(250) NOT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, longname VARCHAR(250) UNIQUE NOT NULL, filename VARCHAR(25) NOT NULL REFERENCES files(cname) ON DELETE CASCADE,dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    49. 

  49.         "CREATE TABLE favourites (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, usersids BIGINT REFERENCES users (ids)  ON DELETE CASCADE,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,itemsids BIGINT NOT NULL,dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    50. 

  50.         "CREATE TABLE accounts(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), intaccountclass SMALLINT DEFAULT 0, cname VARCHAR(250) NOT NULL, description VARCHAR(250) NOT NULL, taxvalue DOUBLE NOT NULL DEFAULT 0, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0, intparentaccount BIGINT DEFAULT 0, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, invisible SMALLINT DEFAULT 0, intaccounttype SMALLINT NOT NULL, intprofitfid SMALLINT NOT NULL, inttaxfid SMALLINT NOT NULL, inttaxuid SMALLINT NOT NULL, frame VARCHAR(25) NOT NULL, hierarchypath VARCHAR(250) DEFAULT NULL, PRIMARY KEY  (ids))",

    51. 

  51.         "CREATE TABLE items (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const7 UNIQUE (cnumber, inttype), cname VARCHAR(250) NOT NULL, cnumber VARCHAR(250) NOT NULL, description VARCHAR(2500) DEFAULT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, accountsids BIGINT REFERENCES accounts(ids) DEFAULT 1,contactsids BIGINT REFERENCES contacts(ids)  ON DELETE CASCADE, netvalue DOUBLE DEFAULT 0,taxvalue DOUBLE DEFAULT 0, discountvalue DOUBLE DEFAULT 0, shippingvalue DOUBLE DEFAULT 0, datetodo DATE DEFAULT NULL, dateend DATE DEFAULT NULL, intreminders INTEGER DEFAULT 0, inttype SMALLINT DEFAULT 0, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,intstatus SMALLINT DEFAULT 0, hierarchypath VARCHAR(500) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL, PRIMARY KEY  (ids))",

    52. 

  52.         "CREATE TABLE subitems (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(5000) DEFAULT NULL,itemsids BIGINT REFERENCES items(ids)  ON DELETE CASCADE, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,originalproductsids BIGINT DEFAULT NULL, countvalue DOUBLE DEFAULT 0 NOT NULL, quantityvalue DOUBLE DEFAULT 0 NOT NULL, measure VARCHAR(250) NOT NULL, linkurl VARCHAR(1000) DEFAULT NULL,description VARCHAR(1000) DEFAULT NULL, internalvalue DOUBLE DEFAULT 0, totalnetvalue DOUBLE DEFAULT 0, totalbrutvalue DOUBLE DEFAULT 0, externalvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE DEFAULT 0 NOT NULL,datedelivery DATE DEFAULT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    53. 

  53.         "CREATE TABLE schedule (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,usersids BIGINT REFERENCES users (ids)  ON DELETE CASCADE,itemsids BIGINT REFERENCES items (ids)  ON DELETE CASCADE,stopdate DATE NOT NULL,startdate DATE NOT NULL,nextdate DATE NOT NULL, isdone SMALLINT DEFAULT 0, intervalmonth SMALLINT NOT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    54. 

  54.         "CREATE TABLE products (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const8 UNIQUE (cnumber, groupsids), cname VARCHAR(500) NOT NULL, cnumber VARCHAR(250) NOT NULL, description VARCHAR(5000), externalnetvalue DOUBLE DEFAULT 0, internalnetvalue DOUBLE DEFAULT 0, measure VARCHAR(250) NOT NULL, taxids BIGINT REFERENCES tax(ids), manufacturersids BIGINT DEFAULT 0, suppliersids BIGINT DEFAULT 0, groupsids  BIGINT  REFERENCES groups(ids) DEFAULT 1, productgroupsids  BIGINT  REFERENCES productgroups(ids) DEFAULT 1, url VARCHAR(250) DEFAULT NULL,ean VARCHAR(25) DEFAULT NULL, reference VARCHAR(50) DEFAULT NULL,dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0, inttype SMALLINT NOT NULL, defaultimage VARCHAR(30) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    55. 

  55.         "CREATE TABLE productlists (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(2500) DEFAULT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, description VARCHAR(1000) DEFAULT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    56. 

  56.         "CREATE TABLE productlistitems (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), cname VARCHAR(2500) DEFAULT NULL, linkurl VARCHAR(250) DEFAULT NULL, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, productlistsids BIGINT REFERENCES productlists(ids) ON DELETE CASCADE,originalproductsids BIGINT REFERENCES products(ids) ON DELETE CASCADE, countvalue DOUBLE DEFAULT 0 NOT NULL, quantityvalue DOUBLE DEFAULT 0 NOT NULL, measure VARCHAR(250) NOT NULL,description VARCHAR(1000) DEFAULT NULL, internalvalue DOUBLE DEFAULT 0, totalnetvalue DOUBLE DEFAULT 0, totalbrutvalue DOUBLE DEFAULT 0, externalvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE DEFAULT 0 NOT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0,invisible SMALLINT DEFAULT 0,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    57. 

  57.         "CREATE TABLE userproperties(IDS BIGINT DEFAULT 1,cname VARCHAR(250) NOT NULL, value VARCHAR(250) NOT NULL, usersids BIGINT NOT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,invisible SMALLINT DEFAULT 0)",

    58. 

  58.         "CREATE TABLE mails(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(1000) NOT NULL, dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,invisible SMALLINT DEFAULT 0, usersids BIGINT REFERENCES users(ids) ON DELETE CASCADE, description VARCHAR(5000) NOT NULL, PRIMARY KEY  (ids))",

    59. 

  59.         "CREATE TABLE comps (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, cname VARCHAR(250) DEFAULT NULL,state VARCHAR(250) DEFAULT NULL,phoneprefix VARCHAR(250) DEFAULT NULL,business VARCHAR(250) DEFAULT NULL,taxadvisor VARCHAR(250) DEFAULT NULL,city  VARCHAR(250) DEFAULT NULL,taxadvjob VARCHAR(250) DEFAULT NULL,street VARCHAR(250) DEFAULT NULL,stb  VARCHAR(250) DEFAULT NULL,email  VARCHAR(250) DEFAULT NULL,name  VARCHAR(250) DEFAULT NULL,zipcode VARCHAR(250) DEFAULT NULL,phone VARCHAR(250) DEFAULT NULL,firstname  VARCHAR(250) DEFAULT NULL,taxauthority VARCHAR(250) DEFAULT NULL,taxnumber VARCHAR(250) DEFAULT NULL,taxadvmandant VARCHAR(250) DEFAULT NULL,dateadded DATE NOT NULL,ismale SMALLINT DEFAULT 0,isenabled SMALLINT DEFAULT 1,intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    60. 

  60.         "CREATE TABLE expenses (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, cnumber VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, accountsids BIGINT REFERENCES accounts(ids), netvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE DEFAULT 0, brutvalue DOUBLE DEFAULT 0, description VARCHAR(5000) DEFAULT NULL,dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    61. 

  61.         "CREATE TABLE revenues (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, cnumber VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, accountsids BIGINT REFERENCES accounts(ids), netvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE DEFAULT 0, brutvalue DOUBLE DEFAULT 0, description VARCHAR(5000) DEFAULT NULL,dateadded DATE NOT NULL,intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    62. 

  62.         "CREATE TABLE webshops (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), CONSTRAINT const9 UNIQUE (cname, groupsids), cname VARCHAR(250) NOT NULL,description VARCHAR(750) DEFAULT NULL,groupsids BIGINT DEFAULT 0,dateadded DATE NOT NULL, isrequestcompression SMALLINT DEFAULT 0, isauthenticated SMALLINT DEFAULT 0, username VARCHAR(50) DEFAULT NULL, passw VARCHAR(50) DEFAULT NULL,reserve1 VARCHAR(500) DEFAULT NULL,intaddedby BIGINT DEFAULT 0, interv BIGINT DEFAULT 0, url VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL, PRIMARY KEY  (ids))",

    63. 

  63.         "CREATE TABLE wscontactsmapping (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), webshopsids BIGINT REFERENCES webshops(ids) ON DELETE CASCADE, cname VARCHAR(250) NOT NULL, groupsids BIGINT REFERENCES groups(ids) ON DELETE CASCADE,contactsids BIGINT REFERENCES contacts(ids) ON DELETE CASCADE, wscontact VARCHAR(250) NOT NULL, dateadded DATE DEFAULT NULL, intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, CONSTRAINT const10 UNIQUE (wscontact, groupsids, webshopsids), reserve2 VARCHAR(500) DEFAULT NULL, PRIMARY KEY  (ids))",

    64. 

  64.         "CREATE TABLE wsitemsmapping (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), webshopsids BIGINT REFERENCES webshops(ids) ON DELETE CASCADE, cname VARCHAR(250) NOT NULL, groupsids BIGINT REFERENCES groups(ids) ON DELETE CASCADE,itemsids BIGINT REFERENCES contacts(ids) ON DELETE CASCADE, wsitem VARCHAR(250) NOT NULL, dateadded DATE DEFAULT NULL, intaddedby BIGINT DEFAULT 0, invisible SMALLINT DEFAULT 0, CONSTRAINT const11 UNIQUE (wsitem, groupsids, webshopsids), reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    65. 

  65.         //sub tables #2

    66. 

  66.         "CREATE TABLE tablelock (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250), rowID BIGINT NOT NULL, usersids BIGINT REFERENCES users(ids) ON DELETE CASCADE,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids), CONSTRAINT one_lock UNIQUE(cname, rowid))",

    67. 

  67.         "CREATE TABLE itemstoaccounts (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), itemsids BIGINT NOT NULL REFERENCES items(ids) ON DELETE CASCADE, accountsids BIGINT REFERENCES accounts(ids) ON DELETE CASCADE,reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    68. 

  68.         "CREATE TABLE trashbin (IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(500), rowID BIGINT NOT NULL, description VARCHAR(2500), deleteme SMALLINT DEFAULT 1, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    69. 

  69.         "CREATE TABLE filestocontacts(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, contactsids BIGINT NOT NULL REFERENCES contacts(ids) ON DELETE CASCADE, filename VARCHAR(25) NOT NULL REFERENCES files(cname) ON DELETE CASCADE, intsize BIGINT DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    70. 

  70.         "CREATE TABLE templates(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, format VARCHAR(55) DEFAULT NULL, description VARCHAR(550) DEFAULT NULL, intsize BIGINT DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, filename VARCHAR(25) NOT NULL REFERENCES files(cname) ON DELETE CASCADE, intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    71. 

  71.         "CREATE TABLE filestoitems(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, itemsids BIGINT NOT NULL REFERENCES items(ids) ON DELETE CASCADE,filename VARCHAR(25) NOT NULL REFERENCES files(cname) ON DELETE CASCADE,intsize BIGINT DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    72. 

  72.         "CREATE TABLE filestoproducts(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, productsids BIGINT NOT NULL REFERENCES products(ids) ON DELETE CASCADE,filename VARCHAR(25) NOT NULL REFERENCES files(cname) ON DELETE CASCADE,intsize BIGINT DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    73. 

  73.         "CREATE TABLE plugins(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL,filename VARCHAR(25) NOT NULL REFERENCES files(cname) ON DELETE CASCADE,intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    74. 

  74.         "CREATE TABLE pluginstousers(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, usersids BIGINT NOT NULL, pluginsids BIGINT NOT NULL REFERENCES plugins(ids) ON DELETE CASCADE,intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    75. 

  75.         "CREATE TABLE formatstousers(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, usersids BIGINT REFERENCES users(ids) ON DELETE CASCADE, inttype SMALLINT  DEFAULT 0,PRIMARY KEY (ids))",

    76. 

  76.         "CREATE TABLE templatestousers(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, usersids BIGINT REFERENCES users(ids) ON DELETE CASCADE, templatesids BIGINT NOT NULL REFERENCES templates(ids) ON DELETE CASCADE, groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1, PRIMARY KEY (ids))",

    77. 

  77.         "CREATE TABLE addresses(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,contactsids BIGINT REFERENCES contacts(ids),title VARCHAR(250) DEFAULT NULL, taxnumber VARCHAR(250),prename VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, street VARCHAR(250) DEFAULT NULL,zip VARCHAR(50) DEFAULT NULL,city VARCHAR(300) DEFAULT NULL, company VARCHAR(250) DEFAULT NULL, department VARCHAR(250) DEFAULT NULL,country VARCHAR(50) DEFAULT NULL, ismale SMALLINT DEFAULT 0,intaddedby BIGINT DEFAULT 0,dateadded DATE DEFAULT NULL,inttype SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL,reserve2 VARCHAR(500) DEFAULT NULL,PRIMARY KEY  (ids))",

    78. 

  78.         "CREATE TABLE reminders(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, stagesids BIGINT NOT NULL,itemsids BIGINT NOT NULL REFERENCES items(ids) ON DELETE CASCADE, extravalue DOUBLE DEFAULT 0, intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    79. 

  79.         "CREATE TABLE stages(IDS BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, extravalue DOUBLE DEFAULT 0, intaddedby BIGINT DEFAULT 0,dateadded DATE NOT NULL,groupsids BIGINT  REFERENCES groups(ids) DEFAULT 1,PRIMARY KEY  (ids))",

    80. 

  80.         //Trigger

    81. 

  81.         "CREATE TRIGGER contacts_indexer1 AFTER INSERT ON contacts REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids, 'contacts',newdata.ids,newdata.cnumber||' '||newdata.taxnumber||' '||newdata.title||' '||newdata.country||' '|| newdata.prename||' '|| newdata.cname||' '|| newdata.street||' '||newdata.zip||' '|| newdata.city ||' '||newdata.mainphone||' '||newdata.fax||' '||newdata.mobilephone||' '||newdata.workphone||' '||newdata.mailaddress||' '||newdata.company||' '|| newdata.department||' '||newdata.website||' '||newdata.notes)",

    82. 

  82.         "CREATE TRIGGER contacts_indexer2 AFTER UPDATE ON contacts REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'contacts' AND  rowid = newdata.ids",

    83. 

  83.         "CREATE TRIGGER contacts_indexer3 AFTER UPDATE ON contacts REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'contacts',newdata.ids,newdata.cnumber||' '||newdata.taxnumber||' '||newdata.title||' '||newdata.country||' '|| newdata.prename||' '|| newdata.cname||' '|| newdata.street||' '||newdata.zip||' '|| newdata.city ||' '||newdata.mainphone||' '||newdata.fax||' '||newdata.mobilephone||' '||newdata.workphone||' '||newdata.mailaddress||' '||newdata.company||' '|| newdata.department||' '||newdata.website||' '||newdata.notes)",

    84. 

  84.         "CREATE TRIGGER contacts_indexer4 AFTER DELETE ON contacts REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'contacts' AND  rowid = newdata.ids",

    85. 

  85.         "CREATE TRIGGER contacts_trash1   AFTER UPDATE ON contacts REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'contacts',newdata.ids,newdata.cnumber||' ('|| newdata.cname||')')",

    86. 

  86.         "CREATE TRIGGER contacts_trash2 AFTER DELETE ON contacts REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM trashbin WHERE cname = 'contacts' AND  rowid = newdata.ids",

    87. 

  87.         "CREATE TRIGGER filestocontacts_indexer1 AFTER INSERT ON filestocontacts REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'filestocontacts',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.filename)",

    88. 

  88.         "CREATE TRIGGER filestocontacts_indexer2 AFTER UPDATE ON filestocontacts REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'filestocontacts' AND  rowid = newdata.ids",

    89. 

  89.         "CREATE TRIGGER filestocontacts_indexer3 AFTER UPDATE ON filestocontacts REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'filestocontacts',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.filename)",

    90. 

  90.         "CREATE TRIGGER filestocontacts_indexer4 AFTER DELETE ON filestocontacts REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'filestocontacts' AND  rowid = newdata.ids",

    91. 

  91.         "CREATE TRIGGER groups_indexer1 AFTER INSERT ON groups REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'groups',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded)",

    92. 

  92.         "CREATE TRIGGER groups_indexer2 AFTER UPDATE ON groups REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'groups' AND  rowid = newdata.ids",

    93. 

  93.         "CREATE TRIGGER groups_indexer3 AFTER UPDATE ON groups REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'groups',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded)",

    94. 

  94.         "CREATE TRIGGER groups_indexer4 AFTER DELETE ON groups REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'groups' AND  rowid = newdata.ids",

    95. 

  95.         "CREATE TRIGGER items_indexer1 AFTER INSERT ON items REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'items',newdata.ids,newdata.cname||' '||newdata.dateadded)",

    96. 

  96.         "CREATE TRIGGER items_indexer2 AFTER UPDATE ON items REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'items' AND  rowid = newdata.ids",

    97. 

  97.         "CREATE TRIGGER items_indexer3 AFTER UPDATE ON items REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'items',newdata.ids,newdata.cname||' '||newdata.dateadded)",

    98. 

  98.         "CREATE TRIGGER items_indexer4 AFTER DELETE ON items REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'items' AND  rowid = newdata.ids",

    99. 

  99.         "CREATE TRIGGER items_trash2 AFTER DELETE ON items REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM trashbin WHERE cname = 'items' AND  rowid = newdata.ids",

    100. 

  100.         "CREATE TRIGGER items_trash1 AFTER UPDATE ON items REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'items',newdata.ids,newdata.cname)",

    101. 

  101.         "CREATE TRIGGER expenses_indexer1 AFTER INSERT ON expenses REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'expenses',newdata.ids,newdata.cname||' '||newdata.dateadded)",

    102. 

  102.         "CREATE TRIGGER expenses_indexer2 AFTER UPDATE ON expenses REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'expenses' AND  rowid = newdata.ids",

    103. 

  103.         "CREATE TRIGGER expenses_indexer3 AFTER UPDATE ON expenses REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'expenses',newdata.ids,newdata.cname||' '||newdata.dateadded)",

    104. 

  104.         "CREATE TRIGGER expenses_indexer4 AFTER DELETE ON expenses REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'expenses' AND  rowid = newdata.ids",

    105. 

  105.         "CREATE TRIGGER expenses_trash2 AFTER DELETE ON expenses REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM trashbin WHERE cname = 'expenses' AND  rowid = newdata.ids",

    106. 

  106.         "CREATE TRIGGER expenses_trash1 AFTER UPDATE ON expenses REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'expenses',newdata.ids,newdata.cname)",

    107. 

  107.         "CREATE TRIGGER revenues_indexer1 AFTER INSERT ON revenues REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'revenues',newdata.ids,newdata.cname||' '||newdata.dateadded)",

    108. 

  108.         "CREATE TRIGGER revenues_indexer2 AFTER UPDATE ON revenues REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'revenues' AND  rowid = newdata.ids",

    109. 

  109.         "CREATE TRIGGER revenues_indexer3 AFTER UPDATE ON revenues REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'revenues',newdata.ids,newdata.cname||' '||newdata.dateadded)",

    110. 

  110.         "CREATE TRIGGER revenues_indexer4 AFTER DELETE ON revenues REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'revenues' AND  rowid = newdata.ids",

    111. 

  111.         "CREATE TRIGGER revenues_trash2 AFTER DELETE ON revenues REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM trashbin WHERE cname = 'revenues' AND  rowid = newdata.ids",

    112. 

  112.         "CREATE TRIGGER revenues_trash1 AFTER UPDATE ON revenues REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'revenues',newdata.ids,newdata.cname)",

    113. 

  113.         "CREATE TRIGGER subitems_indexer1 AFTER INSERT ON subitems REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'subitems',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded)",

    114. 

  114.         "CREATE TRIGGER subitems_indexer2 AFTER UPDATE ON subitems REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'subitems' AND  rowid = newdata.ids",

    115. 

  115.         "CREATE TRIGGER subitems_indexer3 AFTER UPDATE ON subitems REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'subitems',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded)",

    116. 

  116.         "CREATE TRIGGER subitems_indexer4 AFTER DELETE ON subitems REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'subitems' AND  rowid = newdata.ids",

    117. 

  117.         "CREATE TRIGGER products_indexer1 AFTER INSERT ON products REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'products',newdata.ids,newdata.cname||' '||newdata.cnumber||' '||newdata.description||' '||newdata.dateadded)",

    118. 

  118.         "CREATE TRIGGER products_indexer2 AFTER UPDATE ON products REFERENCING NEW AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'products' AND  rowid = newdata.ids",

    119. 

  119.         "CREATE TRIGGER products_indexer3 AFTER UPDATE ON products REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'products',newdata.ids,newdata.cname||' '||newdata.cnumber||' '||newdata.description||' '||newdata.dateadded)",

    120. 

  120.         "CREATE TRIGGER products_indexer4 AFTER DELETE ON products REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM searchindex WHERE dbidentity = 'products' AND  rowid = newdata.ids",

    121. 

  121.         "CREATE TRIGGER products_trash1 AFTER UPDATE ON products REFERENCING NEW AS newdata FOR EACH ROW INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible, 'products',newdata.ids,newdata.cnumber||' ('|| newdata.cname||')')",

    122. 

  122.         "CREATE TRIGGER products_trash2 AFTER DELETE ON products REFERENCING OLD AS newdata FOR EACH ROW DELETE FROM trashbin WHERE cname = 'products' AND  rowid = newdata.ids",

    123. 

  123.         "CREATE TRIGGER thrash_handler1 AFTER INSERT ON trashbin FOR EACH STATEMENT DELETE FROM trashbin WHERE deleteme = 0",

    124. 

  124.         "CREATE TRIGGER thrash_handler2 AFTER INSERT ON trashbin FOR EACH STATEMENT DELETE FROM trashbin WHERE ids IN (SELECT ids FROM trashbin WHERE EXISTS( SELECT ids FROM trashbin AS tmptable WHERE trashbin.cname = tmptable.cname AND trashbin.rowid = tmptable.rowid HAVING trashbin.ids < MAX(tmptable.ids) ) )",};

    125. 

  125.     public static String[] MYSQL_STRUCTURE = new String[]{

    126. 

  126.         "CREATE TABLE accounts ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, intaccountclass SMALLINT DEFAULT 0, cname VARCHAR(250) NOT NULL, description VARCHAR(250) NOT NULL, taxvalue DOUBLE NOT NULL DEFAULT 0, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, intparentaccount BIGINT(20) DEFAULT 0, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, invisible SMALLINT DEFAULT 0, intaccounttype SMALLINT NOT NULL, intprofitfid SMALLINT NOT NULL, inttaxfid SMALLINT NOT NULL, inttaxuid SMALLINT NOT NULL, frame VARCHAR(25) NOT NULL, hierarchypath VARCHAR(250) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    127. 

  127.         "CREATE TABLE addresses ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, contactsids BIGINT(20) UNSIGNED NOT NULL, title VARCHAR(250) DEFAULT NULL, taxnumber VARCHAR(250) DEFAULT NULL, prename VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, street VARCHAR(250) DEFAULT NULL, zip VARCHAR(50) DEFAULT NULL, city VARCHAR(300) DEFAULT NULL, company VARCHAR(250) DEFAULT NULL, department VARCHAR(250) DEFAULT NULL, country VARCHAR(50) DEFAULT NULL, ismale SMALLINT DEFAULT 0, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE DEFAULT NULL, inttype SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    128. 

  128.         "CREATE TABLE comps ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, cname VARCHAR(250) DEFAULT NULL, state VARCHAR(250) DEFAULT NULL, phoneprefix VARCHAR(250) DEFAULT NULL, business VARCHAR(250) DEFAULT NULL, taxadvisor VARCHAR(250) DEFAULT NULL, city VARCHAR(250) DEFAULT NULL, taxadvjob VARCHAR(250) DEFAULT NULL, street VARCHAR(250) DEFAULT NULL, stb VARCHAR(250) DEFAULT NULL, email VARCHAR(250) DEFAULT NULL, name VARCHAR(250) DEFAULT NULL, zipcode VARCHAR(250) DEFAULT NULL, phone VARCHAR(250) DEFAULT NULL, firstname VARCHAR(250) DEFAULT NULL, taxauthority VARCHAR(250) DEFAULT NULL, taxnumber VARCHAR(250) DEFAULT NULL, taxadvmandant VARCHAR(250) DEFAULT NULL, dateadded DATE NOT NULL, ismale SMALLINT DEFAULT 0, isenabled SMALLINT DEFAULT 1, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    129. 

  129.         "CREATE TABLE contacts ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cnumber VARCHAR(250) DEFAULT NULL, taxnumber VARCHAR(250), title VARCHAR(250) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, country VARCHAR(50) DEFAULT NULL, prename VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, street VARCHAR(250) DEFAULT NULL, zip VARCHAR(50) DEFAULT NULL, city VARCHAR(300) DEFAULT NULL, mainphone VARCHAR(250) DEFAULT NULL, fax VARCHAR(250) DEFAULT NULL, mobilephone VARCHAR(250) DEFAULT NULL, workphone VARCHAR(250) DEFAULT NULL, mailaddress VARCHAR(350) DEFAULT NULL, company VARCHAR(250) DEFAULT NULL, department VARCHAR(250) DEFAULT NULL, website VARCHAR(350) DEFAULT NULL, notes VARCHAR(10000), dateadded DATE NOT NULL, isactive SMALLINT DEFAULT 0, iscustomer SMALLINT DEFAULT 0, ismanufacturer SMALLINT DEFAULT 0, issupplier SMALLINT DEFAULT 0, iscompany SMALLINT DEFAULT 0, ismale SMALLINT DEFAULT 0, isenabled SMALLINT DEFAULT 1, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    130. 

  130.         "CREATE TABLE countries ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, iso SMALLINT NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    131. 

  131.         "CREATE TABLE expenses ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, cnumber VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, accountsids BIGINT(20) UNSIGNED NOT NULL, netvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE DEFAULT 0, brutvalue DOUBLE DEFAULT 0, description VARCHAR(5000) DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    132. 

  132.         "CREATE TABLE favourites ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, usersids BIGINT(20) UNSIGNED NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, itemsids BIGINT(20) UNSIGNED NOT NULL NOT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    133. 

  133.         "CREATE TABLE files ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(25) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, dateadded DATE NOT NULL, DATA BLOB(5242880) NOT NULL, filesize BIGINT(20) NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    134. 

  134.         "CREATE TABLE filestocontacts ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, contactsids BIGINT(20) UNSIGNED NOT NULL NOT NULL, filename VARCHAR(25) NOT NULL, intsize BIGINT(20) DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    135. 

  135.         "CREATE TABLE filestoitems ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, itemsids BIGINT(20) UNSIGNED NOT NULL NOT NULL, filename VARCHAR(25) NOT NULL, intsize BIGINT(20) DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    136. 

  136.         "CREATE TABLE filestoproducts ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, productsids BIGINT(20) UNSIGNED NOT NULL NOT NULL, filename VARCHAR(25) NOT NULL, intsize BIGINT(20) DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, intaddedby BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    137. 

  137.         "CREATE TABLE formatstousers ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, usersids BIGINT(20) UNSIGNED NOT NULL, inttype SMALLINT DEFAULT 0 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    138. 

  138.         "CREATE TABLE globalsettings ( ids BIGINT(20) DEFAULT 1, cname VARCHAR(250) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, VALUE VARCHAR(250) NOT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    139. 

  139.         "CREATE TABLE groups ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(750) DEFAULT NULL, defaults VARCHAR(250) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, dateadded DATE NOT NULL, reserve1 VARCHAR(500) DEFAULT NULL, intaddedby BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, hierarchypath VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    140. 

  140.         "CREATE TABLE history ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, username VARCHAR(250) NOT NULL, dbidentity VARCHAR(25) NOT NULL, intitem SMALLINT NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    141. 

  141.         "CREATE TABLE items ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, cnumber VARCHAR(250) NOT NULL, description VARCHAR(2500) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, accountsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, contactsids BIGINT(20) UNSIGNED NOT NULL, netvalue DOUBLE DEFAULT 0, taxvalue DOUBLE DEFAULT 0, discountvalue DOUBLE DEFAULT 0, shippingvalue DOUBLE DEFAULT 0, datetodo DATE DEFAULT NULL, dateend DATE DEFAULT NULL, intreminders INTEGER DEFAULT 0, inttype SMALLINT DEFAULT 0, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, intstatus SMALLINT DEFAULT 0, hierarchypath VARCHAR(500) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    142. 

  142.         "CREATE TABLE itemstoaccounts ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, itemsids BIGINT(20) UNSIGNED NOT NULL NOT NULL, accountsids BIGINT(20) UNSIGNED NOT NULL, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    143. 

  143.         "CREATE TABLE languages ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, longname VARCHAR(250) NOT NULL, filename VARCHAR(25) NOT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    144. 

  144.         "CREATE TABLE mails ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(1000) NOT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, invisible SMALLINT DEFAULT 0, usersids BIGINT(20) UNSIGNED NOT NULL, description VARCHAR(5000) NOT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    145. 

  145.         "CREATE TABLE plugins ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, filename VARCHAR(25) NOT NULL, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    146. 

  146.         "CREATE TABLE pluginstousers ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, usersids BIGINT(20) UNSIGNED NOT NULL NOT NULL, pluginsids BIGINT(20) UNSIGNED NOT NULL NOT NULL, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    147. 

  147.         "CREATE TABLE productgroups ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(750) DEFAULT NULL, defaults VARCHAR(250) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, productgroupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, dateadded DATE NOT NULL, hierarchypath VARCHAR(500) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL, intaddedby BIGINT(20) DEFAULT 0, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    148. 

  148.         "CREATE TABLE productlistitems ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(2500) DEFAULT NULL, linkurl VARCHAR(250) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, productlistsids BIGINT(20) UNSIGNED NOT NULL, originalproductsids BIGINT(20) UNSIGNED NOT NULL, countvalue DOUBLE NOT NULL DEFAULT 0, quantityvalue DOUBLE NOT NULL DEFAULT 0, measure VARCHAR(250) NOT NULL, description VARCHAR(1000) DEFAULT NULL, internalvalue DOUBLE DEFAULT 0, totalnetvalue DOUBLE DEFAULT 0, totalbrutvalue DOUBLE DEFAULT 0, externalvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE NOT NULL DEFAULT 0, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    149. 

  149.         "CREATE TABLE productlists ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(2500) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, description VARCHAR(1000) DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    150. 

  150.         "CREATE TABLE products ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(500) NOT NULL, cnumber VARCHAR(250) NOT NULL, description VARCHAR(5000), externalnetvalue DOUBLE DEFAULT 0, internalnetvalue DOUBLE DEFAULT 0, measure VARCHAR(250) NOT NULL, taxids BIGINT(20) UNSIGNED NOT NULL, manufacturersids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, suppliersids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, productgroupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, url VARCHAR(250) DEFAULT NULL, ean VARCHAR(25) DEFAULT NULL, reference VARCHAR(50) DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, inttype SMALLINT NOT NULL, defaultimage VARCHAR(30) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    151. 

  151.         "CREATE TABLE reminders ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, stagesids BIGINT(20) UNSIGNED NOT NULL, itemsids BIGINT(20) UNSIGNED NOT NULL, extravalue DOUBLE DEFAULT 0, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    152. 

  152.         "CREATE TABLE revenues ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, cnumber VARCHAR(250) DEFAULT NULL, cname VARCHAR(250) DEFAULT NULL, accountsids BIGINT(20) UNSIGNED NOT NULL, netvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE DEFAULT 0, brutvalue DOUBLE DEFAULT 0, description VARCHAR(5000) DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    153. 

  153.         "CREATE TABLE schedule ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, usersids BIGINT(20) UNSIGNED NOT NULL, itemsids BIGINT(20) UNSIGNED NOT NULL, stopdate DATE NOT NULL, startdate DATE NOT NULL, nextdate DATE NOT NULL, isdone SMALLINT DEFAULT 0, intervalmonth SMALLINT NOT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    154. 

  154.         "CREATE TABLE searchindex ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, dbidentity VARCHAR(25) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL, rowid BIGINT(20) NOT NULL, TEXT VARCHAR(5000) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    155. 

  155.         "CREATE TABLE stages ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(550) DEFAULT NULL, extravalue DOUBLE DEFAULT 0, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    156. 

  156.         "CREATE TABLE subitems ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(5000) DEFAULT NULL, itemsids BIGINT(20) UNSIGNED NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, originalproductsids BIGINT(20) UNSIGNED DEFAULT NULL, countvalue DOUBLE NOT NULL DEFAULT 0, quantityvalue DOUBLE NOT NULL DEFAULT 0, measure VARCHAR(250) NOT NULL, linkurl VARCHAR(1000) DEFAULT NULL, description VARCHAR(1000) DEFAULT NULL, internalvalue DOUBLE DEFAULT 0, totalnetvalue DOUBLE DEFAULT 0, totalbrutvalue DOUBLE DEFAULT 0, externalvalue DOUBLE DEFAULT 0, taxpercentvalue DOUBLE NOT NULL DEFAULT 0, datedelivery DATE DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    157. 

  157.         "CREATE TABLE tablelock ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250), rowid BIGINT(20) NOT NULL, usersids BIGINT(20) UNSIGNED NOT NULL, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    158. 

  158.         "CREATE TABLE tax ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250), taxvalue DOUBLE DEFAULT 0, identifier VARCHAR(250) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, country VARCHAR(50) DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    159. 

  159.         "CREATE TABLE templates ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, format VARCHAR(55) DEFAULT NULL, description VARCHAR(550) DEFAULT NULL, intsize BIGINT(20) DEFAULT 0, mimetype VARCHAR(25) DEFAULT NULL, filename VARCHAR(25) NOT NULL, intaddedby BIGINT(20) DEFAULT 0, dateadded DATE NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    160. 

  160.         "CREATE TABLE templatestousers ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, usersids BIGINT(20) UNSIGNED NOT NULL, templatesids BIGINT(20) UNSIGNED NOT NULL NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    161. 

  161.         "CREATE TABLE trashbin ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(500), rowid BIGINT(20) NOT NULL, description VARCHAR(2500), deleteme SMALLINT DEFAULT 1, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    162. 

  162.         "CREATE TABLE userproperties ( ids BIGINT(20) DEFAULT 1, cname VARCHAR(250) NOT NULL, VALUE VARCHAR(250) NOT NULL, usersids BIGINT(20) UNSIGNED NOT NULL NOT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, invisible SMALLINT DEFAULT 0 ) ENGINE=myisam DEFAULT CHARSET=utf8",

    163. 

  163.         "CREATE TABLE users ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, intdefaultaccount BIGINT(20) DEFAULT 1, compsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, intdefaultstatus BIGINT(20) DEFAULT 1, fullname VARCHAR(250) NOT NULL, PASSWORD VARCHAR(250) NOT NULL, laf VARCHAR(50) DEFAULT NULL, locale VARCHAR(50) DEFAULT NULL, defcountry VARCHAR(50) DEFAULT NULL, mail VARCHAR(50) DEFAULT NULL, LANGUAGE VARCHAR(50) DEFAULT NULL, inthighestright SMALLINT DEFAULT 3, isenabled SMALLINT DEFAULT 1, isrgrouped SMALLINT DEFAULT 0, isloggedin SMALLINT DEFAULT 0, datelastlog DATE DEFAULT NULL, dateadded DATE NOT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    164. 

  164.         "CREATE TABLE webshops ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, cname VARCHAR(250) NOT NULL, description VARCHAR(750) DEFAULT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, dateadded DATE NOT NULL, isrequestcompression SMALLINT DEFAULT 0, isauthenticated SMALLINT DEFAULT 0, username VARCHAR(50) DEFAULT NULL, passw VARCHAR(50) DEFAULT NULL, reserve1 VARCHAR(500) DEFAULT NULL, intaddedby BIGINT(20) DEFAULT 0, interv BIGINT(20) DEFAULT 0, url VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    165. 

  165.         "CREATE TABLE wscontactsmapping ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, webshopsids BIGINT(20) UNSIGNED NOT NULL, cname VARCHAR(250) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL, contactsids BIGINT(20) UNSIGNED NOT NULL, wscontact VARCHAR(250) NOT NULL, dateadded DATE DEFAULT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    166. 

  166.         "CREATE TABLE wsitemsmapping ( ids BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, webshopsids BIGINT(20) UNSIGNED NOT NULL, cname VARCHAR(250) NOT NULL, groupsids BIGINT(20) UNSIGNED NOT NULL, itemsids BIGINT(20) UNSIGNED NOT NULL, wsitem VARCHAR(250) NOT NULL, dateadded DATE DEFAULT NULL, intaddedby BIGINT(20) DEFAULT 0, invisible SMALLINT DEFAULT 0, reserve1 VARCHAR(500) DEFAULT NULL, reserve2 VARCHAR(500) DEFAULT NULL ) ENGINE=myisam DEFAULT CHARSET=utf8",

    167. 

  167.         "CREATE UNIQUE INDEX sql091006084310810 ON groups(cname)",

    168. 

  168.         "CREATE UNIQUE INDEX sql091006084310820 ON groups(ids)",

    169. 

  169.         "CREATE UNIQUE INDEX sql091006084311391 ON productgroups(cname, groupsids)",

    170. 

  170.         "CREATE UNIQUE INDEX sql091006084311390 ON productgroups(ids)",

    171. 

  171.         "CREATE UNIQUE INDEX sql091006084311800 ON history(ids)",

    172. 

  172.         "CREATE UNIQUE INDEX sql091006084312110 ON countries(iso)",

    173. 

  173.         "CREATE UNIQUE INDEX sql091006084312111 ON countries(ids)",

    174. 

  174.         "CREATE UNIQUE INDEX sql091006084312620 ON globalsettings(cname, groupsids)",

    175. 

  175.         "CREATE UNIQUE INDEX sql091006084312900 ON tax(ids)",

    176. 

  176.         "CREATE INDEX sql091006084312890 ON tax(groupsids)",

    177. 

  177.         "CREATE UNIQUE INDEX sql091006084313451 ON contacts(ids)",

    178. 

  178.         "CREATE INDEX sql091006084313450 ON contacts(groupsids)",

    179. 

  179.         "CREATE UNIQUE INDEX sql091006084313971 ON users(cname, groupsids)",

    180. 

  180.         "CREATE UNIQUE INDEX sql091006084313970 ON users(ids)",

    181. 

  181.         "CREATE INDEX sql091006084313960 ON users(groupsids)",

    182. 

  182.         "CREATE UNIQUE INDEX sql091006084314570 ON files(cname)",

    183. 

  183.         "CREATE UNIQUE INDEX sql091006084314572 ON files(ids)",

    184. 

  184.         "CREATE INDEX sql091006084314571 ON files(groupsids)",

    185. 

  185.         "CREATE UNIQUE INDEX sql091006084315174 ON languages(cname, groupsids)",

    186. 

  186.         "CREATE UNIQUE INDEX sql091006084315171 ON languages(longname)",

    187. 

  187.         "CREATE UNIQUE INDEX sql091006084315173 ON languages(ids)",

    188. 

  188.         "CREATE INDEX sql091006084315170 ON languages(groupsids)",

    189. 

  189.         "CREATE INDEX sql091006084315172 ON languages(filename)",

    190. 

  190.         "CREATE UNIQUE INDEX sql091006084315882 ON favourites(ids)",

    191. 

  191.         "CREATE INDEX sql091006084315880 ON favourites(usersids)",

    192. 

  192.         "CREATE INDEX sql091006084315881 ON favourites(groupsids)",

    193. 

  193.         "CREATE UNIQUE INDEX sql091006084316451 ON accounts(ids)",

    194. 

  194.         "CREATE INDEX sql091006084316450 ON accounts(groupsids)",

    195. 

  195.         "CREATE UNIQUE INDEX sql091006084316862 ON items(cnumber, inttype)",

    196. 

  196.         "CREATE UNIQUE INDEX sql091006084316861 ON items(ids)",

    197. 

  197.         "CREATE INDEX sql091006084316850 ON items(groupsids)",

    198. 

  198.         "CREATE INDEX sql091006084316851 ON items(accountsids)",

    199. 

  199.         "CREATE INDEX sql091006084316860 ON items(contactsids)",

    200. 

  200.         "CREATE UNIQUE INDEX sql091006084317902 ON subitems(ids)",

    201. 

  201.         "CREATE INDEX sql091006084317900 ON subitems(itemsids)",

    202. 

  202.         "CREATE INDEX sql091006084317901 ON subitems(groupsids)",

    203. 

  203.         "CREATE UNIQUE INDEX sql091006084318483 ON schedule(ids)",

    204. 

  204.         "CREATE INDEX sql091006084318480 ON schedule(groupsids)",

    205. 

  205.         "CREATE INDEX sql091006084318481 ON schedule(usersids)",

    206. 

  206.         "CREATE INDEX sql091006084318482 ON schedule(itemsids)",

    207. 

  207.         "CREATE UNIQUE INDEX sql091006084319621 ON products(cnumber, groupsids)",

    208. 

  208.         "CREATE UNIQUE INDEX sql091006084319620 ON products(ids)",

    209. 

  209.         "CREATE INDEX sql091006084319610 ON products(taxids)",

    210. 

  210.         "CREATE INDEX sql091006084319611 ON products(groupsids)",

    211. 

  211.         "CREATE INDEX sql091006084319612 ON products(productgroupsids)",

    212. 

  212.         "CREATE UNIQUE INDEX sql091006084320591 ON productlists(ids)",

    213. 

  213.         "CREATE INDEX sql091006084320590 ON productlists(groupsids)",

    214. 

  214.         "CREATE UNIQUE INDEX sql091006084321141 ON productlistitems(ids)",

    215. 

  215.         "CREATE INDEX sql091006084321130 ON productlistitems(groupsids)",

    216. 

  216.         "CREATE INDEX sql091006084321131 ON productlistitems(productlistsids)",

    217. 

  217.         "CREATE INDEX sql091006084321140 ON productlistitems(originalproductsids)",

    218. 

  218.         "CREATE INDEX sql091006084322190 ON userproperties(groupsids)",

    219. 

  219.         "CREATE UNIQUE INDEX sql091006084322552 ON mails(ids)",

    220. 

  220.         "CREATE INDEX sql091006084322550 ON mails(groupsids)",

    221. 

  221.         "CREATE INDEX sql091006084322551 ON mails(usersids)",

    222. 

  222.         "CREATE UNIQUE INDEX sql091006084323381 ON comps(ids)",

    223. 

  223.         "CREATE INDEX sql091006084323380 ON comps(groupsids)",

    224. 

  224.         "CREATE UNIQUE INDEX sql091006084324160 ON expenses(ids)",

    225. 

  225.         "CREATE INDEX sql091006084324140 ON expenses(groupsids)",

    226. 

  226.         "CREATE INDEX sql091006084324141 ON expenses(accountsids)",

    227. 

  227.         "CREATE UNIQUE INDEX sql091006084324810 ON revenues(ids)",

    228. 

  228.         "CREATE INDEX sql091006084324790 ON revenues(groupsids)",

    229. 

  229.         "CREATE INDEX sql091006084324800 ON revenues(accountsids)",

    230. 

  230.         "CREATE UNIQUE INDEX sql091006084325551 ON webshops(cname, groupsids)",

    231. 

  231.         "CREATE UNIQUE INDEX sql091006084325550 ON webshops(ids)",

    232. 

  232.         "CREATE UNIQUE INDEX sql091006084326054 ON wscontactsmapping(wscontact, groupsids, webshopsids)",

    233. 

  233.         "CREATE UNIQUE INDEX sql091006084326053 ON wscontactsmapping(ids)",

    234. 

  234.         "CREATE INDEX sql091006084326050 ON wscontactsmapping(webshopsids)",

    235. 

  235.         "CREATE INDEX sql091006084326051 ON wscontactsmapping(groupsids)",

    236. 

  236.         "CREATE INDEX sql091006084326052 ON wscontactsmapping(contactsids)",

    237. 

  237.         "CREATE UNIQUE INDEX sql091006084326881 ON wsitemsmapping(wsitem, groupsids, webshopsids)",

    238. 

  238.         "CREATE UNIQUE INDEX sql091006084326880 ON wsitemsmapping(ids)",

    239. 

  239.         "CREATE INDEX sql091006084326870 ON wsitemsmapping(webshopsids)",

    240. 

  240.         "CREATE INDEX sql091006084326871 ON wsitemsmapping(groupsids)",

    241. 

  241.         "CREATE INDEX sql091006084326872 ON wsitemsmapping(itemsids)",

    242. 

  242.         "CREATE UNIQUE INDEX sql091006084327910 ON tablelock(ids)",

    243. 

  243.         "CREATE UNIQUE INDEX sql091006084327911 ON tablelock(cname, rowid)",

    244. 

  244.         "CREATE INDEX sql091006084327890 ON tablelock(usersids)",

    245. 

  245.         "CREATE UNIQUE INDEX sql091006084328480 ON itemstoaccounts(ids)",

    246. 

  246.         "CREATE INDEX sql091006084328460 ON itemstoaccounts(itemsids)",

    247. 

  247.         "CREATE INDEX sql091006084328461 ON itemstoaccounts(accountsids)",

    248. 

  248.         "CREATE UNIQUE INDEX sql091006084329120 ON trashbin(ids)",

    249. 

  249.         "CREATE UNIQUE INDEX sql091006084329671 ON filestocontacts(ids)",

    250. 

  250.         "CREATE INDEX sql091006084329650 ON filestocontacts(contactsids)",

    251. 

  251.         "CREATE INDEX sql091006084329651 ON filestocontacts(filename)",

    252. 

  252.         "CREATE INDEX sql091006084329670 ON filestocontacts(groupsids)",

    253. 

  253.         "CREATE UNIQUE INDEX sql091006084330492 ON templates(ids)",

    254. 

  254.         "CREATE INDEX sql091006084330490 ON templates(filename)",

    255. 

  255.         "CREATE INDEX sql091006084330491 ON templates(groupsids)",

    256. 

  256.         "CREATE UNIQUE INDEX sql091006084331263 ON filestoitems(ids)",

    257. 

  257.         "CREATE INDEX sql091006084331260 ON filestoitems(itemsids)",

    258. 

  258.         "CREATE INDEX sql091006084331261 ON filestoitems(filename)",

    259. 

  259.         "CREATE INDEX sql091006084331262 ON filestoitems(groupsids)",

    260. 

  260.         "CREATE UNIQUE INDEX sql091006084332163 ON filestoproducts(ids)",

    261. 

  261.         "CREATE INDEX sql091006084332160 ON filestoproducts(productsids)",

    262. 

  262.         "CREATE INDEX sql091006084332161 ON filestoproducts(filename)",

    263. 

  263.         "CREATE INDEX sql091006084332162 ON filestoproducts(groupsids)",

    264. 

  264.         "CREATE UNIQUE INDEX sql091006084333560 ON plugins(ids)",

    265. 

  265.         "CREATE INDEX sql091006084333550 ON plugins(filename)",

    266. 

  266.         "CREATE INDEX sql091006084333551 ON plugins(groupsids)",

    267. 

  267.         "CREATE UNIQUE INDEX sql091006084334241 ON pluginstousers(ids)",

    268. 

  268.         "CREATE INDEX sql091006084334230 ON pluginstousers(pluginsids)",

    269. 

  269.         "CREATE INDEX sql091006084334240 ON pluginstousers(groupsids)",

    270. 

  270.         "CREATE UNIQUE INDEX sql091006084334891 ON formatstousers(ids)",

    271. 

  271.         "CREATE INDEX sql091006084334890 ON formatstousers(usersids)",

    272. 

  272.         "CREATE UNIQUE INDEX sql091006084335461 ON templatestousers(ids)",

    273. 

  273.         "CREATE INDEX sql091006084335450 ON templatestousers(usersids)",

    274. 

  274.         "CREATE INDEX sql091006084335451 ON templatestousers(templatesids)",

    275. 

  275.         "CREATE INDEX sql091006084335460 ON templatestousers(groupsids)",

    276. 

  276.         "CREATE UNIQUE INDEX sql091006084336332 ON addresses(ids)",

    277. 

  277.         "CREATE INDEX sql091006084336330 ON addresses(groupsids)",

    278. 

  278.         "CREATE INDEX sql091006084336331 ON addresses(contactsids)",

    279. 

  279.         "CREATE UNIQUE INDEX sql091006084336882 ON reminders(ids)",

    280. 

  280.         "CREATE INDEX sql091006084336880 ON reminders(itemsids)",

    281. 

  281.         "CREATE INDEX sql091006084336881 ON reminders(groupsids)",

    282. 

  282.         "CREATE UNIQUE INDEX sql091006084337581 ON stages(ids)",

    283. 

  283.         "CREATE INDEX sql091006084337580 ON stages(groupsids)",

    284. 

  284.         "ALTER TABLE contacts ADD CONSTRAINT const3 UNIQUE (cnumber, groupsids)",

    285. 

  285.         "ALTER TABLE countries ADD CONSTRAINT sql0910060843121101 UNIQUE (iso)",

    286. 

  286.         "ALTER TABLE files ADD CONSTRAINT sql0910060843145701 UNIQUE (cname)",

    287. 

  287.         "ALTER TABLE globalsettings ADD CONSTRAINT const2 UNIQUE (cname, groupsids)",

    288. 

  288.         "ALTER TABLE groups ADD CONSTRAINT sql0910060843108101 UNIQUE (cname)",

    289. 

  289.         "ALTER TABLE items ADD CONSTRAINT const7 UNIQUE (cnumber, inttype)",

    290. 

  290.         "ALTER TABLE languages ADD CONSTRAINT sql0910060843151711 UNIQUE (longname)",

    291. 

  291.         "ALTER TABLE languages ADD CONSTRAINT const8 UNIQUE (cname, groupsids)",

    292. 

  292.         "ALTER TABLE productgroups ADD CONSTRAINT const1 UNIQUE (cname, groupsids)",

    293. 

  293.         "ALTER TABLE products ADD CONSTRAINT const8 UNIQUE (cnumber, groupsids)",

    294. 

  294.         "ALTER TABLE tablelock ADD CONSTRAINT one_lock UNIQUE (cname, rowid)",

    295. 

  295.         "ALTER TABLE users ADD CONSTRAINT const4 UNIQUE (cname, groupsids)",

    296. 

  296.         "ALTER TABLE webshops ADD CONSTRAINT const9 UNIQUE (cname, groupsids)",

    297. 

  297.         "ALTER TABLE wscontactsmapping ADD CONSTRAINT const10 UNIQUE (wscontact, groupsids, webshopsids)",

    298. 

  298.         "ALTER TABLE wsitemsmapping ADD CONSTRAINT const11 UNIQUE (wsitem, groupsids, webshopsids)",

    299. 

  299.         "ALTER TABLE accounts ADD CONSTRAINT sql0910060843164501 FOREIGN KEY(groupsids) REFERENCES groups(ids)",

    300. 

  300.         "ALTER TABLE addresses ADD CONSTRAINT sql0910060843363311 FOREIGN KEY(contactsids) REFERENCES contacts(ids)",

    301. 

  301.         "ALTER TABLE addresses ADD CONSTRAINT sql0910060843363301 FOREIGN KEY(groupsids) REFERENCES groups(ids)",

    302. 

  302.         "ALTER TABLE comps ADD CONSTRAINT sql0910060843233801 FOREIGN KEY(groupsids) REFERENCES groups(ids)",

    303. 

  303.         "ALTER TABLE contacts ADD CONSTRAINT sql0910060843134501 FOREIGN KEY(groupsids) REFERENCES groups(ids)",

    304. 

  304.         "ALTER TABLE expenses ADD CONSTRAINT sql0910060843241411 FOREIGN KEY(accountsids) REFERENCES accounts(ids)",

    305. 

  305.         "ALTER TABLE expenses ADD CONSTRAINT sql0910060843241401 FOREIGN KEY(groupsids) REFERENCES groups(ids)",

    306. 

  306.         "ALTER TABLE favourites ADD CONSTRAINT sql0910060843158811 FOREIGN KEY(groupsids) REFERENCES groups(ids)",

    307. 

  307.         "ALTER TABLE favourites ADD CONSTRAINT sq
    308.