PageRenderTime 116ms CodeModel.GetById 49ms app.highlight 62ms RepoModel.GetById 0ms app.codeStats 0ms

/install/sql/yabs-1.0-derby.sql

http://mp-rechnungs-und-kundenverwaltung.googlecode.com/
SQL | 1668 lines | 1383 code | 285 blank | 0 comment | 0 complexity | 558ee7e4247e1702e9a0e2207e049509 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

Large files files are truncated, but you can click here to view the full file

   1CREATE TABLE ACCOUNTS  (
   2	IDS             	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
   3	INTACCOUNTCLASS 	SMALLINT DEFAULT 0,
   4	CNAME           	VARCHAR(250) NOT NULL,
   5	DESCRIPTION     	VARCHAR(250) NOT NULL,
   6	TAXVALUE        	DOUBLE NOT NULL DEFAULT 0,
   7	DATEADDED       	DATE NOT NULL,
   8	INTADDEDBY      	BIGINT(20) DEFAULT 0,
   9	INTPARENTACCOUNT	BIGINT(20) DEFAULT 0,
  10	GROUPSIDS       	BIGINT(20) DEFAULT 1,
  11	INVISIBLE       	SMALLINT DEFAULT 0,
  12	INTACCOUNTTYPE  	SMALLINT NOT NULL,
  13	INTPROFITFID    	SMALLINT NOT NULL,
  14	INTTAXFID       	SMALLINT NOT NULL,
  15	INTTAXUID       	SMALLINT NOT NULL,
  16	FRAME           	VARCHAR(25) NOT NULL,
  17	HIERARCHYPATH   	VARCHAR(250) DEFAULT NULL
  18);
  19
  20CREATE TABLE ADDRESSES  (
  21	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
  22	GROUPSIDS  	BIGINT(20) DEFAULT 1,
  23	CONTACTSIDS	BIGINT(20),
  24	TITLE      	VARCHAR(250) DEFAULT NULL,
  25	TAXNUMBER  	VARCHAR(250),
  26	PRENAME    	VARCHAR(250) DEFAULT NULL,
  27	CNAME      	VARCHAR(250) DEFAULT NULL,
  28	STREET     	VARCHAR(250) DEFAULT NULL,
  29	ZIP        	VARCHAR(50) DEFAULT NULL,
  30	CITY       	VARCHAR(300) DEFAULT NULL,
  31	COMPANY    	VARCHAR(250) DEFAULT NULL,
  32	DEPARTMENT 	VARCHAR(250) DEFAULT NULL,
  33	COUNTRY    	VARCHAR(50) DEFAULT NULL,
  34	ISMALE     	SMALLINT DEFAULT 0,
  35	INTADDEDBY 	BIGINT(20) DEFAULT 0,
  36	DATEADDED  	DATE DEFAULT NULL,
  37	INTTYPE    	SMALLINT DEFAULT 0,
  38	RESERVE1   	VARCHAR(500) DEFAULT NULL,
  39	RESERVE2   	VARCHAR(500) DEFAULT NULL
  40);
  41
  42CREATE TABLE COMPS  (
  43	IDS          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
  44	GROUPSIDS    	BIGINT(20) DEFAULT 1,
  45	CNAME        	VARCHAR(250) DEFAULT NULL,
  46	STATE        	VARCHAR(250) DEFAULT NULL,
  47	PHONEPREFIX  	VARCHAR(250) DEFAULT NULL,
  48	BUSINESS     	VARCHAR(250) DEFAULT NULL,
  49	TAXADVISOR   	VARCHAR(250) DEFAULT NULL,
  50	CITY         	VARCHAR(250) DEFAULT NULL,
  51	TAXADVJOB    	VARCHAR(250) DEFAULT NULL,
  52	STREET       	VARCHAR(250) DEFAULT NULL,
  53	STB          	VARCHAR(250) DEFAULT NULL,
  54	EMAIL        	VARCHAR(250) DEFAULT NULL,
  55	NAME         	VARCHAR(250) DEFAULT NULL,
  56	ZIPCODE      	VARCHAR(250) DEFAULT NULL,
  57	PHONE        	VARCHAR(250) DEFAULT NULL,
  58	FIRSTNAME    	VARCHAR(250) DEFAULT NULL,
  59	TAXAUTHORITY 	VARCHAR(250) DEFAULT NULL,
  60	TAXNUMBER    	VARCHAR(250) DEFAULT NULL,
  61	TAXADVMANDANT	VARCHAR(250) DEFAULT NULL,
  62	DATEADDED    	DATE NOT NULL,
  63	ISMALE       	SMALLINT DEFAULT 0,
  64	ISENABLED    	SMALLINT DEFAULT 1,
  65	INTADDEDBY   	BIGINT(20) DEFAULT 0,
  66	INVISIBLE    	SMALLINT DEFAULT 0,
  67	RESERVE1     	VARCHAR(500) DEFAULT NULL,
  68	RESERVE2     	VARCHAR(500) DEFAULT NULL
  69);
  70
  71CREATE TABLE CONTACTS  (
  72	IDS           	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
  73	CNUMBER       	VARCHAR(250) DEFAULT NULL,
  74	TAXNUMBER     	VARCHAR(250),
  75	TITLE         	VARCHAR(250) DEFAULT NULL,
  76	GROUPSIDS     	BIGINT(20) DEFAULT 1,
  77	COUNTRY       	VARCHAR(50) DEFAULT NULL,
  78	PRENAME       	VARCHAR(250) DEFAULT NULL,
  79	CNAME         	VARCHAR(250) DEFAULT NULL,
  80	STREET        	VARCHAR(250) DEFAULT NULL,
  81	ZIP           	VARCHAR(50) DEFAULT NULL,
  82	CITY          	VARCHAR(300) DEFAULT NULL,
  83	MAINPHONE     	VARCHAR(250) DEFAULT NULL,
  84	FAX           	VARCHAR(250) DEFAULT NULL,
  85	MOBILEPHONE   	VARCHAR(250) DEFAULT NULL,
  86	WORKPHONE     	VARCHAR(250) DEFAULT NULL,
  87	MAILADDRESS   	VARCHAR(350) DEFAULT NULL,
  88	COMPANY       	VARCHAR(250) DEFAULT NULL,
  89	DEPARTMENT    	VARCHAR(250) DEFAULT NULL,
  90	WEBSITE       	VARCHAR(350) DEFAULT NULL,
  91	NOTES         	VARCHAR(10000),
  92	DATEADDED     	DATE NOT NULL,
  93	ISACTIVE      	SMALLINT DEFAULT 0,
  94	ISCUSTOMER    	SMALLINT DEFAULT 0,
  95	ISMANUFACTURER	SMALLINT DEFAULT 0,
  96	ISSUPPLIER    	SMALLINT DEFAULT 0,
  97	ISCOMPANY     	SMALLINT DEFAULT 0,
  98	ISMALE        	SMALLINT DEFAULT 0,
  99	ISENABLED     	SMALLINT DEFAULT 1,
 100	INTADDEDBY    	BIGINT(20) DEFAULT 0,
 101	INVISIBLE     	SMALLINT DEFAULT 0,
 102	RESERVE1      	VARCHAR(500) DEFAULT NULL,
 103	RESERVE2      	VARCHAR(500) DEFAULT NULL
 104);
 105
 106CREATE TABLE COUNTRIES  (
 107	IDS      	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 108	CNAME    	VARCHAR(250) NOT NULL,
 109	ISO      	SMALLINT NOT NULL,
 110	GROUPSIDS	BIGINT(20) DEFAULT 1,
 111	RESERVE1 	VARCHAR(500) DEFAULT NULL,
 112	RESERVE2 	VARCHAR(500) DEFAULT NULL
 113);
 114
 115CREATE TABLE EXPENSES  (
 116	IDS            	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 117	GROUPSIDS      	BIGINT(20) DEFAULT 1,
 118	CNUMBER        	VARCHAR(250) DEFAULT NULL,
 119	CNAME          	VARCHAR(250) DEFAULT NULL,
 120	ACCOUNTSIDS    	BIGINT(20),
 121	NETVALUE       	DOUBLE DEFAULT 0,
 122	TAXPERCENTVALUE	DOUBLE DEFAULT 0,
 123	BRUTVALUE      	DOUBLE DEFAULT 0,
 124	DESCRIPTION    	VARCHAR(5000) DEFAULT NULL,
 125	DATEADDED      	DATE NOT NULL,
 126	INTADDEDBY     	BIGINT(20) DEFAULT 0,
 127	INVISIBLE      	SMALLINT DEFAULT 0,
 128	RESERVE1       	VARCHAR(500) DEFAULT NULL,
 129	RESERVE2       	VARCHAR(500) DEFAULT NULL
 130);
 131
 132CREATE TABLE FAVOURITES  (
 133	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 134	CNAME     	VARCHAR(250) NOT NULL,
 135	USERSIDS  	BIGINT(20),
 136	GROUPSIDS 	BIGINT(20) DEFAULT 1,
 137	ITEMSIDS  	BIGINT(20) NOT NULL,
 138	DATEADDED 	DATE NOT NULL,
 139	INTADDEDBY	BIGINT(20) DEFAULT 0,
 140	INVISIBLE 	SMALLINT DEFAULT 0,
 141	RESERVE1  	VARCHAR(500) DEFAULT NULL,
 142	RESERVE2  	VARCHAR(500) DEFAULT NULL
 143);
 144
 145CREATE TABLE FILES  (
 146	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 147	CNAME     	VARCHAR(25) NOT NULL,
 148	GROUPSIDS 	BIGINT(20) DEFAULT 1,
 149	DATEADDED 	DATE NOT NULL,
 150	DATA      	BLOB(5242880) NOT NULL,
 151	FILESIZE  	BIGINT(20) NOT NULL,
 152	INTADDEDBY	BIGINT(20) DEFAULT 0,
 153	INVISIBLE 	SMALLINT DEFAULT 0
 154);
 155
 156CREATE TABLE FILESTOCONTACTS  (
 157	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 158	CNAME      	VARCHAR(250) NOT NULL,
 159	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 160	CONTACTSIDS	BIGINT(20) NOT NULL,
 161	FILENAME   	VARCHAR(25) NOT NULL,
 162	INTSIZE    	BIGINT(20) DEFAULT 0,
 163	MIMETYPE   	VARCHAR(25) DEFAULT NULL,
 164	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 165	DATEADDED  	DATE NOT NULL,
 166	GROUPSIDS  	BIGINT(20) DEFAULT 1
 167);
 168
 169CREATE TABLE FILESTOITEMS  (
 170	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 171	CNAME      	VARCHAR(250) NOT NULL,
 172	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 173	ITEMSIDS   	BIGINT(20) NOT NULL,
 174	FILENAME   	VARCHAR(25) NOT NULL,
 175	INTSIZE    	BIGINT(20) DEFAULT 0,
 176	MIMETYPE   	VARCHAR(25) DEFAULT NULL,
 177	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 178	DATEADDED  	DATE NOT NULL,
 179	GROUPSIDS  	BIGINT(20) DEFAULT 1
 180);
 181
 182CREATE TABLE FILESTOPRODUCTS  (
 183	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 184	CNAME      	VARCHAR(250) NOT NULL,
 185	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 186	PRODUCTSIDS	BIGINT(20) NOT NULL,
 187	FILENAME   	VARCHAR(25) NOT NULL,
 188	INTSIZE    	BIGINT(20) DEFAULT 0,
 189	MIMETYPE   	VARCHAR(25) DEFAULT NULL,
 190	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 191	DATEADDED  	DATE NOT NULL,
 192	GROUPSIDS  	BIGINT(20) DEFAULT 1
 193);
 194
 195CREATE TABLE FORMATSTOUSERS  (
 196	IDS     	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 197	CNAME   	VARCHAR(250) NOT NULL,
 198	USERSIDS	BIGINT(20),
 199	INTTYPE 	SMALLINT DEFAULT 0
 200);
 201
 202CREATE TABLE GLOBALSETTINGS  (
 203	IDS      	BIGINT(20) DEFAULT 1,
 204	CNAME    	VARCHAR(250) NOT NULL,
 205	GROUPSIDS	BIGINT(20) DEFAULT 1,
 206	VALUE    	VARCHAR(250) NOT NULL
 207	);
 208
 209CREATE TABLE GROUPS  (
 210	IDS          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 211	CNAME        	VARCHAR(250) NOT NULL,
 212	DESCRIPTION  	VARCHAR(750) DEFAULT NULL,
 213	DEFAULTS     	VARCHAR(250) DEFAULT NULL,
 214	GROUPSIDS    	BIGINT(20) DEFAULT 0,
 215	DATEADDED    	DATE NOT NULL,
 216	RESERVE1     	VARCHAR(500) DEFAULT NULL,
 217	INTADDEDBY   	BIGINT(20) DEFAULT 0,
 218	HIERARCHYPATH	VARCHAR(500) DEFAULT NULL,
 219	RESERVE2     	VARCHAR(500) DEFAULT NULL
 220);
 221
 222CREATE TABLE HISTORY  (
 223	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 224	CNAME     	VARCHAR(250) NOT NULL,
 225	USERNAME  	VARCHAR(250) NOT NULL,
 226	DBIDENTITY	VARCHAR(25) NOT NULL,
 227	INTITEM   	SMALLINT NOT NULL,
 228	GROUPSIDS 	BIGINT(20) DEFAULT 0,
 229	DATEADDED 	DATE NOT NULL,
 230	INTADDEDBY	BIGINT(20) DEFAULT 0,
 231	RESERVE1  	VARCHAR(500) DEFAULT NULL,
 232	RESERVE2  	VARCHAR(500) DEFAULT NULL
 233);
 234
 235CREATE TABLE ITEMS  (
 236	IDS          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 237	CNAME        	VARCHAR(250) NOT NULL,
 238	CNUMBER      	VARCHAR(250) NOT NULL,
 239	DESCRIPTION  	VARCHAR(2500) DEFAULT NULL,
 240	GROUPSIDS    	BIGINT(20) DEFAULT 1,
 241	ACCOUNTSIDS  	BIGINT(20) DEFAULT 1,
 242	CONTACTSIDS  	BIGINT(20),
 243	NETVALUE     	DOUBLE DEFAULT 0,
 244	TAXVALUE     	DOUBLE DEFAULT 0,
 245	DISCOUNTVALUE	DOUBLE DEFAULT 0,
 246	SHIPPINGVALUE	DOUBLE DEFAULT 0,
 247	DATETODO     	DATE DEFAULT NULL,
 248	DATEEND      	DATE DEFAULT NULL,
 249	INTREMINDERS 	INTEGER DEFAULT 0,
 250	INTTYPE      	SMALLINT DEFAULT 0,
 251	DATEADDED    	DATE NOT NULL,
 252	INTADDEDBY   	BIGINT(20) DEFAULT 0,
 253	INVISIBLE    	SMALLINT DEFAULT 0,
 254	INTSTATUS    	SMALLINT DEFAULT 0,
 255	HIERARCHYPATH	VARCHAR(500) DEFAULT NULL,
 256	RESERVE1     	VARCHAR(500) DEFAULT NULL,
 257	RESERVE2     	VARCHAR(500) DEFAULT NULL
 258);
 259
 260CREATE TABLE ITEMSTOACCOUNTS  (
 261	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 262	ITEMSIDS   	BIGINT(20) NOT NULL,
 263	ACCOUNTSIDS	BIGINT(20),
 264	RESERVE1   	VARCHAR(500) DEFAULT NULL,
 265	RESERVE2   	VARCHAR(500) DEFAULT NULL
 266);
 267
 268CREATE TABLE LANGUAGES  (
 269	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 270	CNAME     	VARCHAR(250) NOT NULL,
 271	GROUPSIDS 	BIGINT(20) DEFAULT 1,
 272	LONGNAME  	VARCHAR(250) NOT NULL,
 273	FILENAME  	VARCHAR(25) NOT NULL,
 274	DATEADDED 	DATE NOT NULL,
 275	INTADDEDBY	BIGINT(20) DEFAULT 0,
 276	INVISIBLE 	SMALLINT DEFAULT 0,
 277	RESERVE1  	VARCHAR(500) DEFAULT NULL,
 278	RESERVE2  	VARCHAR(500) DEFAULT NULL
 279);
 280
 281CREATE TABLE MAILS  (
 282	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 283	CNAME      	VARCHAR(1000) NOT NULL,
 284	DATEADDED  	DATE NOT NULL,
 285	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 286	GROUPSIDS  	BIGINT(20) DEFAULT 1,
 287	INVISIBLE  	SMALLINT DEFAULT 0,
 288	USERSIDS   	BIGINT(20),
 289	DESCRIPTION	VARCHAR(5000) NOT NULL
 290);
 291
 292CREATE TABLE PLUGINS  (
 293	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 294	CNAME      	VARCHAR(250) NOT NULL,
 295	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 296	FILENAME   	VARCHAR(25) NOT NULL,
 297	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 298	DATEADDED  	DATE NOT NULL,
 299	GROUPSIDS  	BIGINT(20) DEFAULT 1
 300);
 301
 302CREATE TABLE PLUGINSTOUSERS  (
 303	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 304	CNAME     	VARCHAR(250) NOT NULL,
 305	USERSIDS  	BIGINT(20) NOT NULL,
 306	PLUGINSIDS	BIGINT(20) NOT NULL,
 307	INTADDEDBY	BIGINT(20) DEFAULT 0,
 308	DATEADDED 	DATE NOT NULL,
 309	GROUPSIDS 	BIGINT(20) DEFAULT 1
 310);
 311
 312CREATE TABLE PRODUCTGROUPS  (
 313	IDS             	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 314	CNAME           	VARCHAR(250) NOT NULL,
 315	DESCRIPTION     	VARCHAR(750) DEFAULT NULL,
 316	DEFAULTS        	VARCHAR(250) DEFAULT NULL,
 317	GROUPSIDS       	BIGINT(20) DEFAULT 0,
 318	PRODUCTGROUPSIDS	BIGINT(20) DEFAULT 0,
 319	DATEADDED       	DATE NOT NULL,
 320	HIERARCHYPATH   	VARCHAR(500) DEFAULT NULL,
 321	RESERVE1        	VARCHAR(500) DEFAULT NULL,
 322	INTADDEDBY      	BIGINT(20) DEFAULT 0,
 323	RESERVE2        	VARCHAR(500) DEFAULT NULL
 324);
 325
 326CREATE TABLE PRODUCTLISTITEMS  (
 327	IDS                	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 328	CNAME              	VARCHAR(2500) DEFAULT NULL,
 329	LINKURL            	VARCHAR(250) DEFAULT NULL,
 330	GROUPSIDS          	BIGINT(20) DEFAULT 1,
 331	PRODUCTLISTSIDS    	BIGINT(20),
 332	ORIGINALPRODUCTSIDS	BIGINT(20),
 333	COUNTVALUE         	DOUBLE NOT NULL DEFAULT 0,
 334	QUANTITYVALUE      	DOUBLE NOT NULL DEFAULT 0,
 335	MEASURE            	VARCHAR(250) NOT NULL,
 336	DESCRIPTION        	VARCHAR(1000) DEFAULT NULL,
 337	INTERNALVALUE      	DOUBLE DEFAULT 0,
 338	TOTALNETVALUE      	DOUBLE DEFAULT 0,
 339	TOTALBRUTVALUE     	DOUBLE DEFAULT 0,
 340	EXTERNALVALUE      	DOUBLE DEFAULT 0,
 341	TAXPERCENTVALUE    	DOUBLE NOT NULL DEFAULT 0,
 342	DATEADDED          	DATE NOT NULL,
 343	INTADDEDBY         	BIGINT(20) DEFAULT 0,
 344	INVISIBLE          	SMALLINT DEFAULT 0,
 345	RESERVE1           	VARCHAR(500) DEFAULT NULL,
 346	RESERVE2           	VARCHAR(500) DEFAULT NULL
 347);
 348
 349CREATE TABLE PRODUCTLISTS  (
 350	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 351	CNAME      	VARCHAR(2500) DEFAULT NULL,
 352	GROUPSIDS  	BIGINT(20) DEFAULT 1,
 353	DESCRIPTION	VARCHAR(1000) DEFAULT NULL,
 354	DATEADDED  	DATE NOT NULL,
 355	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 356	INVISIBLE  	SMALLINT DEFAULT 0,
 357	RESERVE1   	VARCHAR(500) DEFAULT NULL,
 358	RESERVE2   	VARCHAR(500) DEFAULT NULL
 359);
 360
 361CREATE TABLE PRODUCTS  (
 362	IDS             	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 363	CNAME           	VARCHAR(500) NOT NULL,
 364	CNUMBER         	VARCHAR(250) NOT NULL,
 365	DESCRIPTION     	VARCHAR(5000),
 366	EXTERNALNETVALUE	DOUBLE DEFAULT 0,
 367	INTERNALNETVALUE	DOUBLE DEFAULT 0,
 368	MEASURE         	VARCHAR(250) NOT NULL,
 369	TAXIDS          	BIGINT(20),
 370	MANUFACTURERSIDS	BIGINT(20) DEFAULT 0,
 371	SUPPLIERSIDS    	BIGINT(20) DEFAULT 0,
 372	GROUPSIDS       	BIGINT(20) DEFAULT 1,
 373	PRODUCTGROUPSIDS	BIGINT(20) DEFAULT 1,
 374	URL             	VARCHAR(250) DEFAULT NULL,
 375	EAN             	VARCHAR(25) DEFAULT NULL,
 376	REFERENCE       	VARCHAR(50) DEFAULT NULL,
 377	DATEADDED       	DATE NOT NULL,
 378	INTADDEDBY      	BIGINT(20) DEFAULT 0,
 379	INVISIBLE       	SMALLINT DEFAULT 0,
 380	INTTYPE         	SMALLINT NOT NULL,
 381	DEFAULTIMAGE    	VARCHAR(30) DEFAULT NULL,
 382	RESERVE1        	VARCHAR(500) DEFAULT NULL,
 383	RESERVE2        	VARCHAR(500) DEFAULT NULL
 384);
 385
 386CREATE TABLE REMINDERS  (
 387	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 388	CNAME      	VARCHAR(250) NOT NULL,
 389	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 390	STAGESIDS  	BIGINT(20) NOT NULL,
 391	ITEMSIDS   	BIGINT(20) NOT NULL,
 392	EXTRAVALUE 	DOUBLE DEFAULT 0,
 393	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 394	DATEADDED  	DATE NOT NULL,
 395	GROUPSIDS  	BIGINT(20) DEFAULT 1
 396);
 397
 398CREATE TABLE REVENUES  (
 399	IDS            	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 400	GROUPSIDS      	BIGINT(20) DEFAULT 1,
 401	CNUMBER        	VARCHAR(250) DEFAULT NULL,
 402	CNAME          	VARCHAR(250) DEFAULT NULL,
 403	ACCOUNTSIDS    	BIGINT(20),
 404	NETVALUE       	DOUBLE DEFAULT 0,
 405	TAXPERCENTVALUE	DOUBLE DEFAULT 0,
 406	BRUTVALUE      	DOUBLE DEFAULT 0,
 407	DESCRIPTION    	VARCHAR(5000) DEFAULT NULL,
 408	DATEADDED      	DATE NOT NULL,
 409	INTADDEDBY     	BIGINT(20) DEFAULT 0,
 410	INVISIBLE      	SMALLINT DEFAULT 0,
 411	RESERVE1       	VARCHAR(500) DEFAULT NULL,
 412	RESERVE2       	VARCHAR(500) DEFAULT NULL
 413);
 414
 415CREATE TABLE SCHEDULE  (
 416	IDS          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 417	CNAME        	VARCHAR(250) NOT NULL,
 418	GROUPSIDS    	BIGINT(20) DEFAULT 1,
 419	USERSIDS     	BIGINT(20),
 420	ITEMSIDS     	BIGINT(20),
 421	STOPDATE     	DATE NOT NULL,
 422	STARTDATE    	DATE NOT NULL,
 423	NEXTDATE     	DATE NOT NULL,
 424	ISDONE       	SMALLINT DEFAULT 0,
 425	INTERVALMONTH	SMALLINT NOT NULL,
 426	DATEADDED    	DATE NOT NULL,
 427	INTADDEDBY   	BIGINT(20) DEFAULT 0,
 428	INVISIBLE    	SMALLINT DEFAULT 0,
 429	RESERVE1     	VARCHAR(500) DEFAULT NULL,
 430	RESERVE2     	VARCHAR(500) DEFAULT NULL
 431);
 432
 433CREATE TABLE SEARCHINDEX  (
 434	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 435	DBIDENTITY	VARCHAR(25) NOT NULL,
 436	GROUPSIDS 	BIGINT(20),
 437	ROWID     	BIGINT(20) NOT NULL,
 438	TEXT      	VARCHAR(5000) DEFAULT NULL
 439	);
 440
 441CREATE TABLE STAGES  (
 442	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 443	CNAME      	VARCHAR(250) NOT NULL,
 444	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 445	EXTRAVALUE 	DOUBLE DEFAULT 0,
 446	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 447	DATEADDED  	DATE NOT NULL,
 448	GROUPSIDS  	BIGINT(20) DEFAULT 1
 449);
 450
 451CREATE TABLE SUBITEMS  (
 452	IDS                	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 453	CNAME              	VARCHAR(5000) DEFAULT NULL,
 454	ITEMSIDS           	BIGINT(20),
 455	GROUPSIDS          	BIGINT(20) DEFAULT 1,
 456	ORIGINALPRODUCTSIDS	BIGINT(20) DEFAULT NULL,
 457	COUNTVALUE         	DOUBLE NOT NULL DEFAULT 0,
 458	QUANTITYVALUE      	DOUBLE NOT NULL DEFAULT 0,
 459	MEASURE            	VARCHAR(250) NOT NULL,
 460	LINKURL            	VARCHAR(1000) DEFAULT NULL,
 461	DESCRIPTION        	VARCHAR(1000) DEFAULT NULL,
 462	INTERNALVALUE      	DOUBLE DEFAULT 0,
 463	TOTALNETVALUE      	DOUBLE DEFAULT 0,
 464	TOTALBRUTVALUE     	DOUBLE DEFAULT 0,
 465	EXTERNALVALUE      	DOUBLE DEFAULT 0,
 466	TAXPERCENTVALUE    	DOUBLE NOT NULL DEFAULT 0,
 467	DATEDELIVERY       	DATE DEFAULT NULL,
 468	DATEADDED          	DATE NOT NULL,
 469	INTADDEDBY         	BIGINT(20) DEFAULT 0,
 470	INVISIBLE          	SMALLINT DEFAULT 0,
 471	RESERVE1           	VARCHAR(500) DEFAULT NULL,
 472	RESERVE2           	VARCHAR(500) DEFAULT NULL
 473);
 474
 475CREATE TABLE TABLELOCK  (
 476	IDS     	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 477	CNAME   	VARCHAR(250),
 478	ROWID   	BIGINT(20) NOT NULL,
 479	USERSIDS	BIGINT(20),
 480	RESERVE1	VARCHAR(500) DEFAULT NULL,
 481	RESERVE2	VARCHAR(500) DEFAULT NULL
 482);
 483
 484CREATE TABLE TAX  (
 485	IDS       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 486	CNAME     	VARCHAR(250),
 487	TAXVALUE  	DOUBLE DEFAULT 0,
 488	IDENTIFIER	VARCHAR(250) DEFAULT NULL,
 489	GROUPSIDS 	BIGINT(20) DEFAULT 1,
 490	COUNTRY   	VARCHAR(50) DEFAULT NULL,
 491	DATEADDED 	DATE NOT NULL,
 492	INTADDEDBY	BIGINT(20) DEFAULT 0,
 493	INVISIBLE 	SMALLINT DEFAULT 0,
 494	RESERVE1  	VARCHAR(500) DEFAULT NULL,
 495	RESERVE2  	VARCHAR(500) DEFAULT NULL
 496);
 497
 498CREATE TABLE TEMPLATES  (
 499	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 500	CNAME      	VARCHAR(250) NOT NULL,
 501	FORMAT     	VARCHAR(55) DEFAULT NULL,
 502	DESCRIPTION	VARCHAR(550) DEFAULT NULL,
 503	INTSIZE    	BIGINT(20) DEFAULT 0,
 504	MIMETYPE   	VARCHAR(25) DEFAULT NULL,
 505	FILENAME   	VARCHAR(25) NOT NULL,
 506	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 507	DATEADDED  	DATE NOT NULL,
 508	GROUPSIDS  	BIGINT(20) DEFAULT 1
 509);
 510
 511CREATE TABLE TEMPLATESTOUSERS  (
 512	IDS         	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 513	CNAME       	VARCHAR(250) NOT NULL,
 514	USERSIDS    	BIGINT(20),
 515	TEMPLATESIDS	BIGINT(20) NOT NULL,
 516	GROUPSIDS   	BIGINT(20) DEFAULT 1
 517);
 518
 519CREATE TABLE TRASHBIN  (
 520	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 521	CNAME      	VARCHAR(500),
 522	ROWID      	BIGINT(20) NOT NULL,
 523	DESCRIPTION	VARCHAR(2500),
 524	DELETEME   	SMALLINT DEFAULT 1,
 525	RESERVE1   	VARCHAR(500) DEFAULT NULL,
 526	RESERVE2   	VARCHAR(500) DEFAULT NULL
 527);
 528
 529CREATE TABLE USERPROPERTIES  (
 530	IDS       	BIGINT(20) DEFAULT 1,
 531	CNAME     	VARCHAR(250) NOT NULL,
 532	VALUE     	VARCHAR(250) NOT NULL,
 533	USERSIDS  	BIGINT(20) NOT NULL,
 534	DATEADDED 	DATE NOT NULL,
 535	INTADDEDBY	BIGINT(20) DEFAULT 0,
 536	GROUPSIDS 	BIGINT(20) DEFAULT 1,
 537	INVISIBLE 	SMALLINT DEFAULT 0
 538	);
 539
 540CREATE TABLE USERS  (
 541	IDS              	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 542	CNAME            	VARCHAR(250) NOT NULL,
 543	GROUPSIDS        	BIGINT(20) DEFAULT 1,
 544	INTDEFAULTACCOUNT	BIGINT(20) DEFAULT 1,
 545	COMPSIDS         	BIGINT(20) DEFAULT 0,
 546	INTDEFAULTSTATUS 	BIGINT(20) DEFAULT 1,
 547	FULLNAME         	VARCHAR(250) NOT NULL,
 548	PASSWORD         	VARCHAR(250) NOT NULL,
 549	LAF              	VARCHAR(50) DEFAULT NULL,
 550	LOCALE           	VARCHAR(50) DEFAULT NULL,
 551	DEFCOUNTRY       	VARCHAR(50) DEFAULT NULL,
 552	MAIL             	VARCHAR(50) DEFAULT NULL,
 553	LANGUAGE         	VARCHAR(50) DEFAULT NULL,
 554	INTHIGHESTRIGHT  	SMALLINT DEFAULT 3,
 555	ISENABLED        	SMALLINT DEFAULT 1,
 556	ISRGROUPED       	SMALLINT DEFAULT 0,
 557	ISLOGGEDIN       	SMALLINT DEFAULT 0,
 558	DATELASTLOG      	DATE DEFAULT NULL,
 559	DATEADDED        	DATE NOT NULL,
 560	INTADDEDBY       	BIGINT(20) DEFAULT 0,
 561	INVISIBLE        	SMALLINT DEFAULT 0,
 562	RESERVE1         	VARCHAR(500) DEFAULT NULL,
 563	RESERVE2         	VARCHAR(500) DEFAULT NULL
 564);
 565
 566CREATE TABLE WEBSHOPS  (
 567	IDS                 	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 568	CNAME               	VARCHAR(250) NOT NULL,
 569	DESCRIPTION         	VARCHAR(750) DEFAULT NULL,
 570	GROUPSIDS           	BIGINT(20) DEFAULT 0,
 571	DATEADDED           	DATE NOT NULL,
 572	ISREQUESTCOMPRESSION	SMALLINT DEFAULT 0,
 573	ISAUTHENTICATED     	SMALLINT DEFAULT 0,
 574	USERNAME            	VARCHAR(50) DEFAULT NULL,
 575	PASSWORD            	VARCHAR(50) DEFAULT NULL,
 576	RESERVE1            	VARCHAR(500) DEFAULT NULL,
 577	INTADDEDBY          	BIGINT(20) DEFAULT 0,
 578	INTERVAL            	BIGINT(20) DEFAULT 0,
 579	URL                 	VARCHAR(500) DEFAULT NULL,
 580	RESERVE2            	VARCHAR(500) DEFAULT NULL
 581);
 582
 583CREATE TABLE WSCONTACTSMAPPING  (
 584	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 585	WEBSHOPSIDS	BIGINT(20),
 586	CNAME      	VARCHAR(250) NOT NULL,
 587	GROUPSIDS  	BIGINT(20),
 588	CONTACTSIDS	BIGINT(20),
 589	WSCONTACT  	VARCHAR(250) NOT NULL,
 590	DATEADDED  	DATE DEFAULT NULL,
 591	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 592	INVISIBLE  	SMALLINT DEFAULT 0,
 593	RESERVE1   	VARCHAR(500) DEFAULT NULL,
 594	RESERVE2   	VARCHAR(500) DEFAULT NULL
 595);
 596
 597CREATE TABLE WSITEMSMAPPING  (
 598	IDS        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,
 599	WEBSHOPSIDS	BIGINT(20),
 600	CNAME      	VARCHAR(250) NOT NULL,
 601	GROUPSIDS  	BIGINT(20),
 602	ITEMSIDS   	BIGINT(20),
 603	WSITEM     	VARCHAR(250) NOT NULL,
 604	DATEADDED  	DATE DEFAULT NULL,
 605	INTADDEDBY 	BIGINT(20) DEFAULT 0,
 606	INVISIBLE  	SMALLINT DEFAULT 0,
 607	RESERVE1   	VARCHAR(500) DEFAULT NULL,
 608	RESERVE2   	VARCHAR(500) DEFAULT NULL
 609);
 610
 611CREATE UNIQUE INDEX SQL091006084310810
 612	ON GROUPS(CNAME);
 613
 614CREATE UNIQUE INDEX SQL091006084310820
 615	ON GROUPS(IDS);
 616
 617CREATE UNIQUE INDEX SQL091006084311391
 618	ON PRODUCTGROUPS(CNAME, GROUPSIDS);
 619
 620CREATE UNIQUE INDEX SQL091006084311390
 621	ON PRODUCTGROUPS(IDS);
 622
 623CREATE UNIQUE INDEX SQL091006084311800
 624	ON HISTORY(IDS);
 625
 626CREATE UNIQUE INDEX SQL091006084312110
 627	ON COUNTRIES(ISO);
 628
 629CREATE UNIQUE INDEX SQL091006084312111
 630	ON COUNTRIES(IDS);
 631
 632CREATE UNIQUE INDEX SQL091006084312620
 633	ON GLOBALSETTINGS(CNAME, GROUPSIDS);
 634
 635CREATE UNIQUE INDEX SQL091006084312900
 636	ON TAX(IDS);
 637
 638CREATE INDEX SQL091006084312890
 639	ON TAX(GROUPSIDS);
 640
 641CREATE UNIQUE INDEX SQL091006084313452
 642	ON CONTACTS(CNUMBER, GROUPSIDS);
 643
 644CREATE UNIQUE INDEX SQL091006084313451
 645	ON CONTACTS(IDS);
 646
 647CREATE INDEX SQL091006084313450
 648	ON CONTACTS(GROUPSIDS);
 649
 650CREATE UNIQUE INDEX SQL091006084313971
 651	ON USERS(CNAME, GROUPSIDS);
 652
 653CREATE UNIQUE INDEX SQL091006084313970
 654	ON USERS(IDS);
 655
 656CREATE INDEX SQL091006084313960
 657	ON USERS(GROUPSIDS);
 658
 659CREATE UNIQUE INDEX SQL091006084314570
 660	ON FILES(CNAME);
 661
 662CREATE UNIQUE INDEX SQL091006084314572
 663	ON FILES(IDS);
 664
 665CREATE INDEX SQL091006084314571
 666	ON FILES(GROUPSIDS);
 667
 668CREATE UNIQUE INDEX SQL091006084315174
 669	ON LANGUAGES(CNAME, GROUPSIDS);
 670
 671CREATE UNIQUE INDEX SQL091006084315171
 672	ON LANGUAGES(LONGNAME);
 673
 674CREATE UNIQUE INDEX SQL091006084315173
 675	ON LANGUAGES(IDS);
 676
 677CREATE INDEX SQL091006084315170
 678	ON LANGUAGES(GROUPSIDS);
 679
 680CREATE INDEX SQL091006084315172
 681	ON LANGUAGES(FILENAME);
 682
 683CREATE UNIQUE INDEX SQL091006084315882
 684	ON FAVOURITES(IDS);
 685
 686CREATE INDEX SQL091006084315880
 687	ON FAVOURITES(USERSIDS);
 688
 689CREATE INDEX SQL091006084315881
 690	ON FAVOURITES(GROUPSIDS);
 691
 692CREATE UNIQUE INDEX SQL091006084316451
 693	ON ACCOUNTS(IDS);
 694
 695CREATE INDEX SQL091006084316450
 696	ON ACCOUNTS(GROUPSIDS);
 697
 698CREATE UNIQUE INDEX SQL091006084316862
 699	ON ITEMS(CNUMBER, INTTYPE);
 700
 701CREATE UNIQUE INDEX SQL091006084316861
 702	ON ITEMS(IDS);
 703
 704CREATE INDEX SQL091006084316850
 705	ON ITEMS(GROUPSIDS);
 706
 707CREATE INDEX SQL091006084316851
 708	ON ITEMS(ACCOUNTSIDS);
 709
 710CREATE INDEX SQL091006084316860
 711	ON ITEMS(CONTACTSIDS);
 712
 713CREATE UNIQUE INDEX SQL091006084317902
 714	ON SUBITEMS(IDS);
 715
 716CREATE INDEX SQL091006084317900
 717	ON SUBITEMS(ITEMSIDS);
 718
 719CREATE INDEX SQL091006084317901
 720	ON SUBITEMS(GROUPSIDS);
 721
 722CREATE UNIQUE INDEX SQL091006084318483
 723	ON SCHEDULE(IDS);
 724
 725CREATE INDEX SQL091006084318480
 726	ON SCHEDULE(GROUPSIDS);
 727
 728CREATE INDEX SQL091006084318481
 729	ON SCHEDULE(USERSIDS);
 730
 731CREATE INDEX SQL091006084318482
 732	ON SCHEDULE(ITEMSIDS);
 733
 734CREATE UNIQUE INDEX SQL091006084319621
 735	ON PRODUCTS(CNUMBER, GROUPSIDS);
 736
 737CREATE UNIQUE INDEX SQL091006084319620
 738	ON PRODUCTS(IDS);
 739
 740CREATE INDEX SQL091006084319610
 741	ON PRODUCTS(TAXIDS);
 742
 743CREATE INDEX SQL091006084319611
 744	ON PRODUCTS(GROUPSIDS);
 745
 746CREATE INDEX SQL091006084319612
 747	ON PRODUCTS(PRODUCTGROUPSIDS);
 748
 749CREATE UNIQUE INDEX SQL091006084320591
 750	ON PRODUCTLISTS(IDS);
 751
 752CREATE INDEX SQL091006084320590
 753	ON PRODUCTLISTS(GROUPSIDS);
 754
 755CREATE UNIQUE INDEX SQL091006084321141
 756	ON PRODUCTLISTITEMS(IDS);
 757
 758CREATE INDEX SQL091006084321130
 759	ON PRODUCTLISTITEMS(GROUPSIDS);
 760
 761CREATE INDEX SQL091006084321131
 762	ON PRODUCTLISTITEMS(PRODUCTLISTSIDS);
 763
 764CREATE INDEX SQL091006084321140
 765	ON PRODUCTLISTITEMS(ORIGINALPRODUCTSIDS);
 766
 767CREATE INDEX SQL091006084322190
 768	ON USERPROPERTIES(GROUPSIDS);
 769
 770CREATE UNIQUE INDEX SQL091006084322552
 771	ON MAILS(IDS);
 772
 773CREATE INDEX SQL091006084322550
 774	ON MAILS(GROUPSIDS);
 775
 776CREATE INDEX SQL091006084322551
 777	ON MAILS(USERSIDS);
 778
 779CREATE UNIQUE INDEX SQL091006084323381
 780	ON COMPS(IDS);
 781
 782CREATE INDEX SQL091006084323380
 783	ON COMPS(GROUPSIDS);
 784
 785CREATE UNIQUE INDEX SQL091006084324160
 786	ON EXPENSES(IDS);
 787
 788CREATE INDEX SQL091006084324140
 789	ON EXPENSES(GROUPSIDS);
 790
 791CREATE INDEX SQL091006084324141
 792	ON EXPENSES(ACCOUNTSIDS);
 793
 794CREATE UNIQUE INDEX SQL091006084324810
 795	ON REVENUES(IDS);
 796
 797CREATE INDEX SQL091006084324790
 798	ON REVENUES(GROUPSIDS);
 799
 800CREATE INDEX SQL091006084324800
 801	ON REVENUES(ACCOUNTSIDS);
 802
 803CREATE UNIQUE INDEX SQL091006084325551
 804	ON WEBSHOPS(CNAME, GROUPSIDS);
 805
 806CREATE UNIQUE INDEX SQL091006084325550
 807	ON WEBSHOPS(IDS);
 808
 809CREATE UNIQUE INDEX SQL091006084326054
 810	ON WSCONTACTSMAPPING(WSCONTACT, GROUPSIDS, WEBSHOPSIDS);
 811
 812CREATE UNIQUE INDEX SQL091006084326053
 813	ON WSCONTACTSMAPPING(IDS);
 814
 815CREATE INDEX SQL091006084326050
 816	ON WSCONTACTSMAPPING(WEBSHOPSIDS);
 817
 818CREATE INDEX SQL091006084326051
 819	ON WSCONTACTSMAPPING(GROUPSIDS);
 820
 821CREATE INDEX SQL091006084326052
 822	ON WSCONTACTSMAPPING(CONTACTSIDS);
 823
 824CREATE UNIQUE INDEX SQL091006084326881
 825	ON WSITEMSMAPPING(WSITEM, GROUPSIDS, WEBSHOPSIDS);
 826
 827CREATE UNIQUE INDEX SQL091006084326880
 828	ON WSITEMSMAPPING(IDS);
 829
 830CREATE INDEX SQL091006084326870
 831	ON WSITEMSMAPPING(WEBSHOPSIDS);
 832
 833CREATE INDEX SQL091006084326871
 834	ON WSITEMSMAPPING(GROUPSIDS);
 835
 836CREATE INDEX SQL091006084326872
 837	ON WSITEMSMAPPING(ITEMSIDS);
 838
 839CREATE UNIQUE INDEX SQL091006084327910
 840	ON TABLELOCK(IDS);
 841
 842CREATE UNIQUE INDEX SQL091006084327911
 843	ON TABLELOCK(CNAME, ROWID);
 844
 845CREATE INDEX SQL091006084327890
 846	ON TABLELOCK(USERSIDS);
 847
 848CREATE UNIQUE INDEX SQL091006084328480
 849	ON ITEMSTOACCOUNTS(IDS);
 850
 851CREATE INDEX SQL091006084328460
 852	ON ITEMSTOACCOUNTS(ITEMSIDS);
 853
 854CREATE INDEX SQL091006084328461
 855	ON ITEMSTOACCOUNTS(ACCOUNTSIDS);
 856
 857CREATE UNIQUE INDEX SQL091006084329120
 858	ON TRASHBIN(IDS);
 859
 860CREATE UNIQUE INDEX SQL091006084329671
 861	ON FILESTOCONTACTS(IDS);
 862
 863CREATE INDEX SQL091006084329650
 864	ON FILESTOCONTACTS(CONTACTSIDS);
 865
 866CREATE INDEX SQL091006084329651
 867	ON FILESTOCONTACTS(FILENAME);
 868
 869CREATE INDEX SQL091006084329670
 870	ON FILESTOCONTACTS(GROUPSIDS);
 871
 872CREATE UNIQUE INDEX SQL091006084330492
 873	ON TEMPLATES(IDS);
 874
 875CREATE INDEX SQL091006084330490
 876	ON TEMPLATES(FILENAME);
 877
 878CREATE INDEX SQL091006084330491
 879	ON TEMPLATES(GROUPSIDS);
 880
 881CREATE UNIQUE INDEX SQL091006084331263
 882	ON FILESTOITEMS(IDS);
 883
 884CREATE INDEX SQL091006084331260
 885	ON FILESTOITEMS(ITEMSIDS);
 886
 887CREATE INDEX SQL091006084331261
 888	ON FILESTOITEMS(FILENAME);
 889
 890CREATE INDEX SQL091006084331262
 891	ON FILESTOITEMS(GROUPSIDS);
 892
 893CREATE UNIQUE INDEX SQL091006084332163
 894	ON FILESTOPRODUCTS(IDS);
 895
 896CREATE INDEX SQL091006084332160
 897	ON FILESTOPRODUCTS(PRODUCTSIDS);
 898
 899CREATE INDEX SQL091006084332161
 900	ON FILESTOPRODUCTS(FILENAME);
 901
 902CREATE INDEX SQL091006084332162
 903	ON FILESTOPRODUCTS(GROUPSIDS);
 904
 905CREATE UNIQUE INDEX SQL091006084333560
 906	ON PLUGINS(IDS);
 907
 908CREATE INDEX SQL091006084333550
 909	ON PLUGINS(FILENAME);
 910
 911CREATE INDEX SQL091006084333551
 912	ON PLUGINS(GROUPSIDS);
 913
 914CREATE UNIQUE INDEX SQL091006084334241
 915	ON PLUGINSTOUSERS(IDS);
 916
 917CREATE INDEX SQL091006084334230
 918	ON PLUGINSTOUSERS(PLUGINSIDS);
 919
 920CREATE INDEX SQL091006084334240
 921	ON PLUGINSTOUSERS(GROUPSIDS);
 922
 923CREATE UNIQUE INDEX SQL091006084334891
 924	ON FORMATSTOUSERS(IDS);
 925
 926CREATE INDEX SQL091006084334890
 927	ON FORMATSTOUSERS(USERSIDS);
 928
 929CREATE UNIQUE INDEX SQL091006084335461
 930	ON TEMPLATESTOUSERS(IDS);
 931
 932CREATE INDEX SQL091006084335450
 933	ON TEMPLATESTOUSERS(USERSIDS);
 934
 935CREATE INDEX SQL091006084335451
 936	ON TEMPLATESTOUSERS(TEMPLATESIDS);
 937
 938CREATE INDEX SQL091006084335460
 939	ON TEMPLATESTOUSERS(GROUPSIDS);
 940
 941CREATE UNIQUE INDEX SQL091006084336332
 942	ON ADDRESSES(IDS);
 943
 944CREATE INDEX SQL091006084336330
 945	ON ADDRESSES(GROUPSIDS);
 946
 947CREATE INDEX SQL091006084336331
 948	ON ADDRESSES(CONTACTSIDS);
 949
 950CREATE UNIQUE INDEX SQL091006084336882
 951	ON REMINDERS(IDS);
 952
 953CREATE INDEX SQL091006084336880
 954	ON REMINDERS(ITEMSIDS);
 955
 956CREATE INDEX SQL091006084336881
 957	ON REMINDERS(GROUPSIDS);
 958
 959CREATE UNIQUE INDEX SQL091006084337581
 960	ON STAGES(IDS);
 961
 962CREATE INDEX SQL091006084337580
 963	ON STAGES(GROUPSIDS);
 964
 965	ALTER TABLE CONTACTS
 966	ADD CONSTRAINT CONST3
 967	 UNIQUE (CNUMBER, GROUPSIDS) ;
 968
 969ALTER TABLE COUNTRIES
 970	ADD CONSTRAINT SQL091006084312110
 971	 UNIQUE (ISO) ;
 972
 973ALTER TABLE FILES
 974	ADD CONSTRAINT SQL091006084314570
 975	 UNIQUE (CNAME) ;
 976
 977ALTER TABLE GLOBALSETTINGS
 978	ADD CONSTRAINT CONST2
 979	 UNIQUE (CNAME, GROUPSIDS) ;
 980
 981ALTER TABLE GROUPS
 982	ADD CONSTRAINT SQL091006084310810
 983	 UNIQUE (CNAME) ;
 984
 985ALTER TABLE ITEMS
 986	ADD CONSTRAINT CONST7
 987	 UNIQUE (CNUMBER, INTTYPE) ;
 988
 989ALTER TABLE LANGUAGES
 990	ADD CONSTRAINT SQL091006084315171
 991	 UNIQUE (LONGNAME) ;
 992
 993ALTER TABLE LANGUAGES
 994	ADD CONSTRAINT CONST6
 995	 UNIQUE (CNAME, GROUPSIDS) ;
 996
 997ALTER TABLE PRODUCTGROUPS
 998	ADD CONSTRAINT CONST1
 999	 UNIQUE (CNAME, GROUPSIDS) ;
1000
1001ALTER TABLE PRODUCTS
1002	ADD CONSTRAINT CONST8
1003	 UNIQUE (CNUMBER, GROUPSIDS) ;
1004
1005ALTER TABLE TABLELOCK
1006	ADD CONSTRAINT ONE_LOCK
1007	 UNIQUE (CNAME, ROWID) ;
1008
1009ALTER TABLE USERS
1010	ADD CONSTRAINT CONST4
1011	 UNIQUE (CNAME, GROUPSIDS) ;
1012
1013ALTER TABLE WEBSHOPS
1014	ADD CONSTRAINT CONST9
1015	 UNIQUE (CNAME, GROUPSIDS) ;
1016
1017ALTER TABLE WSCONTACTSMAPPING
1018	ADD CONSTRAINT CONST10
1019	 UNIQUE (WSCONTACT, GROUPSIDS, WEBSHOPSIDS) ;
1020
1021ALTER TABLE WSITEMSMAPPING
1022	ADD CONSTRAINT CONST11
1023	 UNIQUE (WSITEM, GROUPSIDS, WEBSHOPSIDS) ;
1024
1025ALTER TABLE ACCOUNTS
1026	ADD CONSTRAINT SQL091006084316450
1027	FOREIGN KEY(GROUPSIDS)
1028	REFERENCES GROUPS(IDS);
1029
1030ALTER TABLE ADDRESSES
1031	ADD CONSTRAINT SQL091006084336331
1032	FOREIGN KEY(CONTACTSIDS)
1033	REFERENCES CONTACTS(IDS);
1034
1035ALTER TABLE ADDRESSES
1036	ADD CONSTRAINT SQL091006084336330
1037	FOREIGN KEY(GROUPSIDS)
1038	REFERENCES GROUPS(IDS);
1039
1040ALTER TABLE COMPS
1041	ADD CONSTRAINT SQL091006084323380
1042	FOREIGN KEY(GROUPSIDS)
1043	REFERENCES GROUPS(IDS);
1044
1045ALTER TABLE CONTACTS
1046	ADD CONSTRAINT SQL091006084313450
1047	FOREIGN KEY(GROUPSIDS)
1048	REFERENCES GROUPS(IDS);
1049
1050ALTER TABLE EXPENSES
1051	ADD CONSTRAINT SQL091006084324141
1052	FOREIGN KEY(ACCOUNTSIDS)
1053	REFERENCES ACCOUNTS(IDS);
1054
1055ALTER TABLE EXPENSES
1056	ADD CONSTRAINT SQL091006084324140
1057	FOREIGN KEY(GROUPSIDS)
1058	REFERENCES GROUPS(IDS);
1059
1060ALTER TABLE FAVOURITES
1061	ADD CONSTRAINT SQL091006084315881
1062	FOREIGN KEY(GROUPSIDS)
1063	REFERENCES GROUPS(IDS);
1064
1065ALTER TABLE FAVOURITES
1066	ADD CONSTRAINT SQL091006084315880
1067	FOREIGN KEY(USERSIDS)
1068	REFERENCES USERS(IDS)
1069	ON DELETE CASCADE ;
1070
1071ALTER TABLE FILES
1072	ADD CONSTRAINT SQL091006084314571
1073	FOREIGN KEY(GROUPSIDS)
1074	REFERENCES GROUPS(IDS);
1075
1076ALTER TABLE FILESTOCONTACTS
1077	ADD CONSTRAINT SQL091006084329670
1078	FOREIGN KEY(GROUPSIDS)
1079	REFERENCES GROUPS(IDS);
1080
1081ALTER TABLE FILESTOCONTACTS
1082	ADD CONSTRAINT SQL091006084329651
1083	FOREIGN KEY(FILENAME)
1084	REFERENCES FILES(CNAME)
1085	ON DELETE CASCADE ;
1086
1087ALTER TABLE FILESTOCONTACTS
1088	ADD CONSTRAINT SQL091006084329650
1089	FOREIGN KEY(CONTACTSIDS)
1090	REFERENCES CONTACTS(IDS)
1091	ON DELETE CASCADE ;
1092
1093ALTER TABLE FILESTOITEMS
1094	ADD CONSTRAINT SQL091006084331262
1095	FOREIGN KEY(GROUPSIDS)
1096	REFERENCES GROUPS(IDS);
1097
1098ALTER TABLE FILESTOITEMS
1099	ADD CONSTRAINT SQL091006084331261
1100	FOREIGN KEY(FILENAME)
1101	REFERENCES FILES(CNAME)
1102	ON DELETE CASCADE ;
1103
1104ALTER TABLE FILESTOITEMS
1105	ADD CONSTRAINT SQL091006084331260
1106	FOREIGN KEY(ITEMSIDS)
1107	REFERENCES ITEMS(IDS)
1108	ON DELETE CASCADE ;
1109
1110ALTER TABLE FILESTOPRODUCTS
1111	ADD CONSTRAINT SQL091006084332162
1112	FOREIGN KEY(GROUPSIDS)
1113	REFERENCES GROUPS(IDS);
1114
1115ALTER TABLE FILESTOPRODUCTS
1116	ADD CONSTRAINT SQL091006084332161
1117	FOREIGN KEY(FILENAME)
1118	REFERENCES FILES(CNAME)
1119	ON DELETE CASCADE ;
1120
1121ALTER TABLE FILESTOPRODUCTS
1122	ADD CONSTRAINT SQL091006084332160
1123	FOREIGN KEY(PRODUCTSIDS)
1124	REFERENCES PRODUCTS(IDS)
1125	ON DELETE CASCADE ;
1126
1127ALTER TABLE FORMATSTOUSERS
1128	ADD CONSTRAINT SQL091006084334890
1129	FOREIGN KEY(USERSIDS)
1130	REFERENCES USERS(IDS)
1131	ON DELETE CASCADE ;
1132
1133ALTER TABLE ITEMS
1134	ADD CONSTRAINT SQL091006084316860
1135	FOREIGN KEY(CONTACTSIDS)
1136	REFERENCES CONTACTS(IDS)
1137	ON DELETE CASCADE ;
1138
1139ALTER TABLE ITEMS
1140	ADD CONSTRAINT SQL091006084316851
1141	FOREIGN KEY(ACCOUNTSIDS)
1142	REFERENCES ACCOUNTS(IDS);
1143
1144ALTER TABLE ITEMS
1145	ADD CONSTRAINT SQL091006084316850
1146	FOREIGN KEY(GROUPSIDS)
1147	REFERENCES GROUPS(IDS);
1148
1149ALTER TABLE ITEMSTOACCOUNTS
1150	ADD CONSTRAINT SQL091006084328461
1151	FOREIGN KEY(ACCOUNTSIDS)
1152	REFERENCES ACCOUNTS(IDS)
1153	ON DELETE CASCADE ;
1154
1155ALTER TABLE ITEMSTOACCOUNTS
1156	ADD CONSTRAINT SQL091006084328460
1157	FOREIGN KEY(ITEMSIDS)
1158	REFERENCES ITEMS(IDS)
1159	ON DELETE CASCADE ;
1160
1161ALTER TABLE LANGUAGES
1162	ADD CONSTRAINT SQL091006084315172
1163	FOREIGN KEY(FILENAME)
1164	REFERENCES FILES(CNAME)
1165	ON DELETE CASCADE ;
1166
1167ALTER TABLE LANGUAGES
1168	ADD CONSTRAINT SQL091006084315170
1169	FOREIGN KEY(GROUPSIDS)
1170	REFERENCES GROUPS(IDS);
1171
1172ALTER TABLE MAILS
1173	ADD CONSTRAINT SQL091006084322551
1174	FOREIGN KEY(USERSIDS)
1175	REFERENCES USERS(IDS)
1176	ON DELETE CASCADE ;
1177
1178ALTER TABLE MAILS
1179	ADD CONSTRAINT SQL091006084322550
1180	FOREIGN KEY(GROUPSIDS)
1181	REFERENCES GROUPS(IDS);
1182
1183ALTER TABLE PLUGINS
1184	ADD CONSTRAINT SQL091006084333551
1185	FOREIGN KEY(GROUPSIDS)
1186	REFERENCES GROUPS(IDS);
1187
1188ALTER TABLE PLUGINS
1189	ADD CONSTRAINT SQL091006084333550
1190	FOREIGN KEY(FILENAME)
1191	REFERENCES FILES(CNAME)
1192	ON DELETE CASCADE ;
1193
1194ALTER TABLE PLUGINSTOUSERS
1195	ADD CONSTRAINT SQL091006084334240
1196	FOREIGN KEY(GROUPSIDS)
1197	REFERENCES GROUPS(IDS);
1198
1199ALTER TABLE PLUGINSTOUSERS
1200	ADD CONSTRAINT SQL091006084334230
1201	FOREIGN KEY(PLUGINSIDS)
1202	REFERENCES PLUGINS(IDS)
1203	ON DELETE CASCADE ;
1204
1205ALTER TABLE PRODUCTLISTITEMS
1206	ADD CONSTRAINT SQL091006084321140
1207	FOREIGN KEY(ORIGINALPRODUCTSIDS)
1208	REFERENCES PRODUCTS(IDS)
1209	ON DELETE CASCADE ;
1210
1211ALTER TABLE PRODUCTLISTITEMS
1212	ADD CONSTRAINT SQL091006084321131
1213	FOREIGN KEY(PRODUCTLISTSIDS)
1214	REFERENCES PRODUCTLISTS(IDS)
1215	ON DELETE CASCADE ;
1216
1217ALTER TABLE PRODUCTLISTITEMS
1218	ADD CONSTRAINT SQL091006084321130
1219	FOREIGN KEY(GROUPSIDS)
1220	REFERENCES GROUPS(IDS);
1221
1222ALTER TABLE PRODUCTLISTS
1223	ADD CONSTRAINT SQL091006084320590
1224	FOREIGN KEY(GROUPSIDS)
1225	REFERENCES GROUPS(IDS);
1226
1227ALTER TABLE PRODUCTS
1228	ADD CONSTRAINT SQL091006084319612
1229	FOREIGN KEY(PRODUCTGROUPSIDS)
1230	REFERENCES PRODUCTGROUPS(IDS);
1231
1232ALTER TABLE PRODUCTS
1233	ADD CONSTRAINT SQL091006084319611
1234	FOREIGN KEY(GROUPSIDS)
1235	REFERENCES GROUPS(IDS);
1236
1237ALTER TABLE PRODUCTS
1238	ADD CONSTRAINT SQL091006084319610
1239	FOREIGN KEY(TAXIDS)
1240	REFERENCES TAX(IDS);
1241
1242ALTER TABLE REMINDERS
1243	ADD CONSTRAINT SQL091006084336881
1244	FOREIGN KEY(GROUPSIDS)
1245	REFERENCES GROUPS(IDS);
1246
1247ALTER TABLE REMINDERS
1248	ADD CONSTRAINT SQL091006084336880
1249	FOREIGN KEY(ITEMSIDS)
1250	REFERENCES ITEMS(IDS)
1251	ON DELETE CASCADE ;
1252
1253ALTER TABLE REVENUES
1254	ADD CONSTRAINT SQL091006084324800
1255	FOREIGN KEY(ACCOUNTSIDS)
1256	REFERENCES ACCOUNTS(IDS);
1257
1258ALTER TABLE REVENUES
1259	ADD CONSTRAINT SQL091006084324790
1260	FOREIGN KEY(GROUPSIDS)
1261	REFERENCES GROUPS(IDS);
1262
1263ALTER TABLE SCHEDULE
1264	ADD CONSTRAINT SQL091006084318482
1265	FOREIGN KEY(ITEMSIDS)
1266	REFERENCES ITEMS(IDS)
1267	ON DELETE CASCADE ;
1268
1269ALTER TABLE SCHEDULE
1270	ADD CONSTRAINT SQL091006084318481
1271	FOREIGN KEY(USERSIDS)
1272	REFERENCES USERS(IDS)
1273	ON DELETE CASCADE ;
1274
1275ALTER TABLE SCHEDULE
1276	ADD CONSTRAINT SQL091006084318480
1277	FOREIGN KEY(GROUPSIDS)
1278	REFERENCES GROUPS(IDS);
1279
1280ALTER TABLE STAGES
1281	ADD CONSTRAINT SQL091006084337580
1282	FOREIGN KEY(GROUPSIDS)
1283	REFERENCES GROUPS(IDS);
1284
1285ALTER TABLE SUBITEMS
1286	ADD CONSTRAINT SQL091006084317901
1287	FOREIGN KEY(GROUPSIDS)
1288	REFERENCES GROUPS(IDS);
1289
1290ALTER TABLE SUBITEMS
1291	ADD CONSTRAINT SQL091006084317900
1292	FOREIGN KEY(ITEMSIDS)
1293	REFERENCES ITEMS(IDS)
1294	ON DELETE CASCADE ;
1295
1296ALTER TABLE TABLELOCK
1297	ADD CONSTRAINT SQL091006084327890
1298	FOREIGN KEY(USERSIDS)
1299	REFERENCES USERS(IDS)
1300	ON DELETE CASCADE ;
1301
1302ALTER TABLE TAX
1303	ADD CONSTRAINT SQL091006084312890
1304	FOREIGN KEY(GROUPSIDS)
1305	REFERENCES GROUPS(IDS);
1306
1307ALTER TABLE TEMPLATES
1308	ADD CONSTRAINT SQL091006084330491
1309	FOREIGN KEY(GROUPSIDS)
1310	REFERENCES GROUPS(IDS);
1311
1312ALTER TABLE TEMPLATES
1313	ADD CONSTRAINT SQL091006084330490
1314	FOREIGN KEY(FILENAME)
1315	REFERENCES FILES(CNAME)
1316	ON DELETE CASCADE ;
1317
1318ALTER TABLE TEMPLATESTOUSERS
1319	ADD CONSTRAINT SQL091006084335460
1320	FOREIGN KEY(GROUPSIDS)
1321	REFERENCES GROUPS(IDS);
1322
1323ALTER TABLE TEMPLATESTOUSERS
1324	ADD CONSTRAINT SQL091006084335451
1325	FOREIGN KEY(TEMPLATESIDS)
1326	REFERENCES TEMPLATES(IDS)
1327	ON DELETE CASCADE ;
1328
1329ALTER TABLE TEMPLATESTOUSERS
1330	ADD CONSTRAINT SQL091006084335450
1331	FOREIGN KEY(USERSIDS)
1332	REFERENCES USERS(IDS)
1333	ON DELETE CASCADE ;
1334
1335ALTER TABLE USERPROPERTIES
1336	ADD CONSTRAINT SQL091006084322190
1337	FOREIGN KEY(GROUPSIDS)
1338	REFERENCES GROUPS(IDS);
1339
1340ALTER TABLE USERS
1341	ADD CONSTRAINT SQL091006084313960
1342	FOREIGN KEY(GROUPSIDS)
1343	REFERENCES GROUPS(IDS);
1344
1345ALTER TABLE WSCONTACTSMAPPING
1346	ADD CONSTRAINT SQL091006084326052
1347	FOREIGN KEY(CONTACTSIDS)
1348	REFERENCES CONTACTS(IDS)
1349	ON DELETE CASCADE ;
1350
1351ALTER TABLE WSCONTACTSMAPPING
1352	ADD CONSTRAINT SQL091006084326051
1353	FOREIGN KEY(GROUPSIDS)
1354	REFERENCES GROUPS(IDS)
1355	ON DELETE CASCADE ;
1356
1357ALTER TABLE WSCONTACTSMAPPING
1358	ADD CONSTRAINT SQL091006084326050
1359	FOREIGN KEY(WEBSHOPSIDS)
1360	REFERENCES WEBSHOPS(IDS)
1361	ON DELETE CASCADE ;
1362
1363ALTER TABLE WSITEMSMAPPING
1364	ADD CONSTRAINT SQL091006084326872
1365	FOREIGN KEY(ITEMSIDS)
1366	REFERENCES CONTACTS(IDS)
1367	ON DELETE CASCADE ;
1368
1369ALTER TABLE WSITEMSMAPPING
1370	ADD CONSTRAINT SQL091006084326871
1371	FOREIGN KEY(GROUPSIDS)
1372	REFERENCES GROUPS(IDS)
1373	ON DELETE CASCADE ;
1374
1375ALTER TABLE WSITEMSMAPPING
1376	ADD CONSTRAINT SQL091006084326870
1377	FOREIGN KEY(WEBSHOPSIDS)
1378	REFERENCES WEBSHOPS(IDS)
1379	ON DELETE CASCADE ;
1380
1381CREATE TRIGGER CONTACTS_INDEXER1
1382	AFTER INSERT ON CONTACTS
1383	REFERENCING NEW AS NEWDATA
1384	FOR EACH ROW  MODE DB2SQL
1385	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);
1386
1387CREATE TRIGGER CONTACTS_INDEXER2
1388	AFTER UPDATE ON CONTACTS
1389	REFERENCING NEW AS NEWDATA
1390	FOR EACH ROW  MODE DB2SQL
1391	DELETE FROM searchindex WHERE dbidentity = 'contacts' AND  rowid = newdata.ids;
1392
1393CREATE TRIGGER CONTACTS_INDEXER3
1394	AFTER UPDATE ON CONTACTS
1395	REFERENCING NEW AS NEWDATA
1396	FOR EACH ROW  MODE DB2SQL
1397	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);
1398
1399CREATE TRIGGER CONTACTS_INDEXER4
1400	AFTER DELETE ON CONTACTS
1401	REFERENCING OLD AS NEWDATA
1402	FOR EACH ROW  MODE DB2SQL
1403	DELETE FROM searchindex WHERE dbidentity = 'contacts' AND  rowid = newdata.ids;
1404
1405CREATE TRIGGER CONTACTS_TRASH1
1406	AFTER UPDATE ON CONTACTS
1407	REFERENCING NEW AS NEWDATA
1408	FOR EACH ROW  MODE DB2SQL
1409	INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'contacts',newdata.ids,newdata.cnumber||' ('|| newdata.cname||')');
1410
1411CREATE TRIGGER CONTACTS_TRASH2
1412	AFTER DELETE ON CONTACTS
1413	REFERENCING OLD AS NEWDATA
1414	FOR EACH ROW  MODE DB2SQL
1415	DELETE FROM trashbin WHERE cname = 'contacts' AND  rowid = newdata.ids;
1416
1417CREATE TRIGGER EXPENSES_INDEXER1
1418	AFTER INSERT ON EXPENSES
1419	REFERENCING NEW AS NEWDATA
1420	FOR EACH ROW  MODE DB2SQL
1421	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'expenses',newdata.ids,newdata.cname||' '||newdata.dateadded);
1422
1423CREATE TRIGGER EXPENSES_INDEXER2
1424	AFTER UPDATE ON EXPENSES
1425	REFERENCING NEW AS NEWDATA
1426	FOR EACH ROW  MODE DB2SQL
1427	DELETE FROM searchindex WHERE dbidentity = 'expenses' AND  rowid = newdata.ids;
1428
1429CREATE TRIGGER EXPENSES_INDEXER3
1430	AFTER UPDATE ON EXPENSES
1431	REFERENCING NEW AS NEWDATA
1432	FOR EACH ROW  MODE DB2SQL
1433	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'expenses',newdata.ids,newdata.cname||' '||newdata.dateadded);
1434
1435CREATE TRIGGER EXPENSES_INDEXER4
1436	AFTER DELETE ON EXPENSES
1437	REFERENCING OLD AS NEWDATA
1438	FOR EACH ROW  MODE DB2SQL
1439	DELETE FROM searchindex WHERE dbidentity = 'expenses' AND  rowid = newdata.ids;
1440
1441CREATE TRIGGER EXPENSES_TRASH1
1442	AFTER UPDATE ON EXPENSES
1443	REFERENCING NEW AS NEWDATA
1444	FOR EACH ROW  MODE DB2SQL
1445	INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'expenses',newdata.ids,newdata.cname);
1446
1447CREATE TRIGGER EXPENSES_TRASH2
1448	AFTER DELETE ON EXPENSES
1449	REFERENCING OLD AS NEWDATA
1450	FOR EACH ROW  MODE DB2SQL
1451	DELETE FROM trashbin WHERE cname = 'expenses' AND  rowid = newdata.ids;
1452
1453CREATE TRIGGER FILESTOCONTACTS_INDEXER1
1454	AFTER INSERT ON FILESTOCONTACTS
1455	REFERENCING NEW AS NEWDATA
1456	FOR EACH ROW  MODE DB2SQL
1457	INSERT INTO searchindex (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'filestocontacts',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.filename);
1458
1459CREATE TRIGGER FILESTOCONTACTS_INDEXER2
1460	AFTER UPDATE ON FILESTOCONTACTS
1461	REFERENCING NEW AS NEWDATA
1462	FOR EACH ROW  MODE DB2SQL
1463	DELETE FROM searchindex WHERE dbidentity = 'filestocontacts' AND  rowid = newdata.ids;
1464
1465CREATE TRIGGER FILESTOCONTACTS_INDEXER3
1466	AFTER UPDATE ON FILESTOCONTACTS
1467	REFERENCING NEW AS NEWDATA
1468	FOR EACH ROW  MODE DB2SQL
1469	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'filestocontacts',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.filename);
1470
1471CREATE TRIGGER FILESTOCONTACTS_INDEXER4
1472	AFTER DELETE ON FILESTOCONTACTS
1473	REFERENCING OLD AS NEWDATA
1474	FOR EACH ROW  MODE DB2SQL
1475	DELETE FROM searchindex WHERE dbidentity = 'filestocontacts' AND  rowid = newdata.ids;
1476
1477CREATE TRIGGER GROUPS_INDEXER1
1478	AFTER INSERT ON GROUPS
1479	REFERENCING NEW AS NEWDATA
1480	FOR EACH ROW  MODE DB2SQL
1481	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'groups',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded);
1482
1483CREATE TRIGGER GROUPS_INDEXER2
1484	AFTER UPDATE ON GROUPS
1485	REFERENCING NEW AS NEWDATA
1486	FOR EACH ROW  MODE DB2SQL
1487	DELETE FROM searchindex WHERE dbidentity = 'groups' AND  rowid = newdata.ids;
1488
1489CREATE TRIGGER GROUPS_INDEXER3
1490	AFTER UPDATE ON GROUPS
1491	REFERENCING NEW AS NEWDATA
1492	FOR EACH ROW  MODE DB2SQL
1493	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'groups',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded);
1494
1495CREATE TRIGGER GROUPS_INDEXER4
1496	AFTER DELETE ON GROUPS
1497	REFERENCING OLD AS NEWDATA
1498	FOR EACH ROW  MODE DB2SQL
1499	DELETE FROM searchindex WHERE dbidentity = 'groups' AND  rowid = newdata.ids;
1500
1501CREATE TRIGGER ITEMS_INDEXER1
1502	AFTER INSERT ON ITEMS
1503	REFERENCING NEW AS NEWDATA
1504	FOR EACH ROW  MODE DB2SQL
1505	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'items',newdata.ids,newdata.cname||' '||newdata.dateadded);
1506
1507CREATE TRIGGER ITEMS_INDEXER2
1508	AFTER UPDATE ON ITEMS
1509	REFERENCING NEW AS NEWDATA
1510	FOR EACH ROW  MODE DB2SQL
1511	DELETE FROM searchindex WHERE dbidentity = 'items' AND  rowid = newdata.ids;
1512
1513CREATE TRIGGER ITEMS_INDEXER3
1514	AFTER UPDATE ON ITEMS
1515	REFERENCING NEW AS NEWDATA
1516	FOR EACH ROW  MODE DB2SQL
1517	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'items',newdata.ids,newdata.cname||' '||newdata.dateadded);
1518
1519CREATE TRIGGER ITEMS_INDEXER4
1520	AFTER DELETE ON ITEMS
1521	REFERENCING OLD AS NEWDATA
1522	FOR EACH ROW  MODE DB2SQL
1523	DELETE FROM searchindex WHERE dbidentity = 'items' AND  rowid = newdata.ids;
1524
1525CREATE TRIGGER ITEMS_TRASH1
1526	AFTER UPDATE ON ITEMS
1527	REFERENCING NEW AS NEWDATA
1528	FOR EACH ROW  MODE DB2SQL
1529	INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'items',newdata.ids,newdata.cname);
1530
1531CREATE TRIGGER ITEMS_TRASH2
1532	AFTER DELETE ON ITEMS
1533	REFERENCING OLD AS NEWDATA
1534	FOR EACH ROW  MODE DB2SQL
1535	DELETE FROM trashbin WHERE cname = 'items' AND  rowid = newdata.ids;
1536
1537CREATE TRIGGER PRODUCTS_INDEXER1
1538	AFTER INSERT ON PRODUCTS
1539	REFERENCING NEW AS NEWDATA
1540	FOR EACH ROW  MODE DB2SQL
1541	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'products',newdata.ids,newdata.cname||' '||newdata.cnumber||' '||newdata.description||' '||newdata.dateadded);
1542
1543CREATE TRIGGER PRODUCTS_INDEXER2
1544	AFTER UPDATE ON PRODUCTS
1545	REFERENCING NEW AS NEWDATA
1546	FOR EACH ROW  MODE DB2SQL
1547	DELETE FROM searchindex WHERE dbidentity = 'products' AND  rowid = newdata.ids;
1548
1549CREATE TRIGGER PRODUCTS_INDEXER3
1550	AFTER UPDATE ON PRODUCTS
1551	REFERENCING NEW AS NEWDATA
1552	FOR EACH ROW  MODE DB2SQL
1553	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'products',newdata.ids,newdata.cname||' '||newdata.cnumber||' '||newdata.description||' '||newdata.dateadded);
1554
1555CREATE TRIGGER PRODUCTS_INDEXER4
1556	AFTER DELETE ON PRODUCTS
1557	REFERENCING OLD AS NEWDATA
1558	FOR EACH ROW  MODE DB2SQL
1559	DELETE FROM searchindex WHERE dbidentity = 'products' AND  rowid = newdata.ids;
1560
1561CREATE TRIGGER PRODUCTS_TRASH1
1562	AFTER UPDATE ON PRODUCTS
1563	REFERENCING NEW AS NEWDATA
1564	FOR EACH ROW  MODE DB2SQL
1565	INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible, 'products',newdata.ids,newdata.cnumber||' ('|| newdata.cname||')');
1566
1567CREATE TRIGGER PRODUCTS_TRASH2
1568	AFTER DELETE ON PRODUCTS
1569	REFERENCING OLD AS NEWDATA
1570	FOR EACH ROW  MODE DB2SQL
1571	DELETE FROM trashbin WHERE cname = 'products' AND  rowid = newdata.ids;
1572
1573CREATE TRIGGER REVENUES_INDEXER1
1574	AFTER INSERT ON REVENUES
1575	REFERENCING NEW AS NEWDATA
1576	FOR EACH ROW  MODE DB2SQL
1577	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'revenues',newdata.ids,newdata.cname||' '||newdata.dateadded);
1578
1579CREATE TRIGGER REVENUES_INDEXER2
1580	AFTER UPDATE ON REVENUES
1581	REFERENCING NEW AS NEWDATA
1582	FOR EACH ROW  MODE DB2SQL
1583	DELETE FROM searchindex WHERE dbidentity = 'revenues' AND  rowid = newdata.ids;
1584
1585CREATE TRIGGER REVENUES_INDEXER3
1586	AFTER UPDATE ON REVENUES
1587	REFERENCING NEW AS NEWDATA
1588	FOR EACH ROW  MODE DB2SQL
1589	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'revenues',newdata.ids,newdata.cname||' '||newdata.dateadded);
1590
1591CREATE TRIGGER REVENUES_INDEXER4
1592	AFTER DELETE ON REVENUES
1593	REFERENCING OLD AS NEWDATA
1594	FOR EACH ROW  MODE DB2SQL
1595	DELETE FROM searchindex WHERE dbidentity = 'revenues' AND  rowid = newdata.ids;
1596
1597CREATE TRIGGER REVENUES_TRASH1
1598	AFTER UPDATE ON REVENUES
1599	REFERENCING NEW AS NEWDATA
1600	FOR EACH ROW  MODE DB2SQL
1601	INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (newdata.invisible,'revenues',newdata.ids,newdata.cname);
1602
1603CREATE TRIGGER REVENUES_TRASH2
1604	AFTER DELETE ON REVENUES
1605	REFERENCING OLD AS NEWDATA
1606	FOR EACH ROW  MODE DB2SQL
1607	DELETE FROM trashbin WHERE cname = 'revenues' AND  rowid = newdata.ids;
1608
1609CREATE TRIGGER SUBITEMS_INDEXER1
1610	AFTER INSERT ON SUBITEMS
1611	REFERENCING NEW AS NEWDATA
1612	FOR EACH ROW  MODE DB2SQL
1613	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'subitems',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded);
1614
1615CREATE TRIGGER SUBITEMS_INDEXER2
1616	AFTER UPDATE ON SUBITEMS
1617	REFERENCING NEW AS NEWDATA
1618	FOR EACH ROW  MODE DB2SQL
1619	DELETE FROM searchindex WHERE dbidentity = 'subitems' AND  rowid = newdata.ids;
1620
1621CREATE TRIGGER SUBITEMS_INDEXER3
1622	AFTER UPDATE ON SUBITEMS
1623	REFERENCING NEW AS NEWDATA
1624	FOR EACH ROW  MODE DB2SQL
1625	INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (newdata.groupsids,'subitems',newdata.ids,newdata.cname||' '||newdata.description||' '||newdata.dateadded);
1626
1627CREATE TRIGGER SUBITEMS_INDEXER4
1628	AFTER DELETE ON SUBITEMS
1629	REFERENCING OLD AS NEWDATA
1630	FOR EACH ROW  MODE DB2SQL
1631	DELETE FROM searchindex WHERE dbidentity = 'subitems' AND  rowid = newdata.ids;
1632
1633CREATE TRIGGER THRASH_HANDLER1
1634	AFTER INSERT ON TRASHBIN
1635	FOR EACH STATEMENT  MODE DB2SQL
1636	DELETE FROM trashbin WHERE deleteme = 0;
1637
1638CREATE TRIGGER THRASH_HANDLER2
1639	AFTER INSERT ON TRASHBIN
1640	FOR EACH STATEMENT  MODE DB2SQL
1641	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) ) );
1642
1643
1644INSERT INTO GROUPS(CNAME, DESCRIPTION, DEFAULTS, GROUPSIDS, DATEADDED, RESERVE1, INTADDEDBY, HIERARCHYPATH, RESERVE2)
1645  VALUES( 'All Groups', 'This group is visible to everyone.', NULL, 0, '2009-04-03', NULL, 0, NULL, NULL);
1646INSERT INTO ACCOUNTS(INTACCOUNTCLASS, CNAME, DESCRIPTION, TAXVALUE, DATEADDED, INTADDEDBY, INTPA…

Large files files are truncated, but you can click here to view the full file