Sales - add full text index to orderconf table
[tine20] / tine20 / Sales / Setup / setup.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <application>
3     <name>Sales</name>
4     <version>10.9</version>
5     <order>50</order>
6     <status>enabled</status>
7     <tables>
8         <table>
9             <name>sales_numbers</name>
10             <version>2</version>
11             <declaration>
12                 <field>
13                     <name>id</name>
14                     <type>text</type>
15                     <length>40</length>
16                     <notnull>true</notnull>
17                 </field>
18                 <field>
19                     <name>number</name>
20                     <type>integer</type>
21                     <notnull>true</notnull>
22                     <default>0</default>
23                 </field>
24                 <field>
25                     <name>account_id</name>
26                     <type>text</type>
27                     <length>40</length>
28                     <notnull>true</notnull>
29                 </field>
30                 <field>
31                     <name>model</name>
32                     <type>text</type>
33                     <length>128</length>
34                     <notnull>true</notnull>
35                 </field>
36                 <field>
37                     <name>update_time</name>
38                     <type>datetime</type>
39                 </field> 
40                 <index>
41                     <name>id</name>
42                     <primary>true</primary>
43                     <field>
44                         <name>id</name>
45                     </field>
46                 </index>
47                 <index>
48                     <name>model</name>
49                     <unique>model</unique>
50                     <field>
51                         <name>model</name>
52                     </field>
53                 </index>
54             </declaration>
55         </table>
56         <table>
57             <name>sales_contracts</name>
58             <version>9</version>
59             <declaration>
60                 <field>
61                     <name>id</name>
62                     <type>text</type>
63                     <length>40</length>
64                     <notnull>true</notnull>
65                 </field>
66                 <field>
67                     <name>container_id</name>
68                     <type>integer</type>
69                     <notnull>true</notnull>
70                 </field>
71                 <field>
72                     <name>parent_id</name>
73                     <type>text</type>
74                     <length>40</length>
75                     <notnull>false</notnull>
76                 </field>
77                 <field>
78                     <name>number</name>
79                     <type>text</type>
80                     <length>64</length>
81                     <notnull>true</notnull>
82                 </field>
83                 <field>
84                     <name>title</name>
85                     <type>text</type>
86                     <length>255</length>
87                     <notnull>true</notnull>
88                 </field>
89                 <field>
90                     <name>description</name>
91                     <type>text</type>
92                 </field>
93                 <field>
94                     <name>start_date</name>
95                     <type>datetime</type>
96                 </field>
97                 <field>
98                     <name>end_date</name>
99                     <type>datetime</type>
100                 </field>
101                 <field>
102                     <name>billing_address_id</name>
103                     <type>text</type>
104                     <length>40</length>
105                     <notnull>false</notnull>
106                 </field>
107                 <field>
108                     <name>created_by</name>
109                     <type>text</type>
110                     <length>40</length>
111                 </field>
112                 <field>
113                     <name>creation_time</name>
114                     <type>datetime</type>
115                 </field> 
116                 <field>
117                     <name>last_modified_by</name>
118                     <type>text</type>
119                     <length>40</length>
120                 </field>
121                 <field>
122                     <name>last_modified_time</name>
123                     <type>datetime</type>
124                 </field>
125                 <field>
126                     <name>is_deleted</name>
127                     <type>boolean</type>
128                     <default>false</default>
129                 </field>
130                 <field>
131                     <name>deleted_by</name>
132                     <type>text</type>
133                     <length>40</length>
134                 </field>
135                 <field>
136                     <name>deleted_time</name>
137                     <type>datetime</type>
138                 </field>
139                 <field>
140                     <name>seq</name>
141                     <type>integer</type>
142                     <notnull>true</notnull>
143                     <default>0</default>
144                 </field>
145                 <index>
146                     <name>id</name>
147                     <primary>true</primary>
148                     <field>
149                         <name>id</name>
150                     </field>
151                 </index>
152                 <index>
153                     <name>container_id</name>
154                     <field>
155                         <name>container_id</name>
156                     </field>
157                 </index>
158                 <index>
159                     <name>sales_contracts::container_id--container::id</name>
160                     <field>
161                         <name>container_id</name>
162                     </field>
163                     <foreign>true</foreign>
164                     <reference>
165                         <table>container</table>
166                         <field>id</field>
167                     </reference>
168                 </index>
169                 <index>
170                     <name>description</name>
171                     <fulltext>true</fulltext>
172                     <field>
173                         <name>description</name>
174                     </field>
175                 </index>
176             </declaration>
177         </table>
178         <table>
179             <name>sales_products</name>
180             <version>7</version>
181             <declaration>
182                 <field>
183                     <name>id</name>
184                     <type>text</type>
185                     <length>40</length>
186                     <notnull>true</notnull>
187                 </field>
188                 <field>
189                     <name>number</name>
190                     <type>text</type>
191                     <length>64</length>
192                     <notnull>true</notnull>
193                 </field>
194                 <field>
195                     <name>gtin</name>
196                     <type>text</type>
197                     <length>64</length>
198                     <notnull>false</notnull>
199                 </field>
200                 <field>
201                     <name>name</name>
202                     <type>text</type>
203                     <length>255</length>
204                     <notnull>true</notnull>
205                 </field>
206                 <field>
207                     <name>description</name>
208                     <type>text</type>
209                     <notnull>false</notnull>
210                 </field>
211                 <field>
212                     <name>manufacturer</name>
213                     <type>text</type>
214                     <length>255</length>
215                     <notnull>false</notnull>
216                 </field>
217                 <field>
218                     <name>category</name>
219                     <type>text</type>
220                     <length>255</length>
221                     <notnull>false</notnull>
222                 </field>
223                 <field>
224                     <name>purchaseprice</name>
225                     <type>float</type>
226                     <notnull>false</notnull>
227                 </field>
228                 <field>
229                     <name>salesprice</name>
230                     <type>float</type>
231                     <notnull>false</notnull>
232                 </field>
233                 <field>
234                     <name>accountable</name>
235                     <type>text</type>
236                     <length>40</length>
237                 </field>
238                 <field>
239                     <name>lifespan_start</name>
240                     <type>datetime</type>
241                 </field>
242                 <field>
243                     <name>lifespan_end</name>
244                     <type>datetime</type>
245                 </field>
246                 <field>
247                     <name>is_active</name>
248                     <type>boolean</type>
249                     <default>false</default>
250                 </field>
251                 <field>
252                     <name>created_by</name>
253                     <type>text</type>
254                     <length>40</length>
255                 </field>
256                 <field>
257                     <name>creation_time</name>
258                     <type>datetime</type>
259                 </field> 
260                 <field>
261                     <name>last_modified_by</name>
262                     <type>text</type>
263                     <length>40</length>
264                 </field>
265                 <field>
266                     <name>last_modified_time</name>
267                     <type>datetime</type>
268                 </field>
269                 <field>
270                     <name>is_deleted</name>
271                     <type>boolean</type>
272                     <default>false</default>
273                 </field>
274                 <field>
275                     <name>deleted_by</name>
276                     <type>text</type>
277                     <length>40</length>
278                 </field>
279                 <field>
280                     <name>deleted_time</name>
281                     <type>datetime</type>
282                 </field>
283                 <field>
284                     <name>seq</name>
285                     <type>integer</type>
286                     <notnull>true</notnull>
287                     <default>0</default>
288                 </field>
289                 <index>
290                     <name>id</name>
291                     <primary>true</primary>
292                     <field>
293                         <name>id</name>
294                     </field>
295                 </index>
296                 <index>
297                     <name>description</name>
298                     <fulltext>true</fulltext>
299                     <field>
300                         <name>description</name>
301                     </field>
302                 </index>
303             </declaration>
304         </table>
305         <table>
306             <name>sales_cost_centers</name>
307             <version>3</version>
308             <declaration>
309                 <field>
310                     <name>id</name>
311                     <type>text</type>
312                     <length>40</length>
313                     <notnull>true</notnull>
314                 </field>
315                 <field>
316                     <name>number</name>
317                     <type>text</type>
318                     <length>64</length>
319                     <notnull>true</notnull>
320                 </field>
321                 <field>
322                     <name>remark</name>
323                     <type>text</type>
324                     <length>255</length>
325                     <notnull>false</notnull>
326                 </field>
327                 <field>
328                     <name>created_by</name>
329                     <type>text</type>
330                     <length>40</length>
331                 </field>
332                 <field>
333                     <name>creation_time</name>
334                     <type>datetime</type>
335                 </field> 
336                 <field>
337                     <name>last_modified_by</name>
338                     <type>text</type>
339                     <length>40</length>
340                 </field>
341                 <field>
342                     <name>last_modified_time</name>
343                     <type>datetime</type>
344                 </field>
345                 <field>
346                     <name>is_deleted</name>
347                     <type>boolean</type>
348                     <default>false</default>
349                 </field>
350                 <field>
351                     <name>deleted_by</name>
352                     <type>text</type>
353                     <length>40</length>
354                 </field>
355                 <field>
356                     <name>deleted_time</name>
357                     <type>datetime</type>
358                 </field>
359                 <field>
360                     <name>seq</name>
361                     <type>integer</type>
362                     <notnull>true</notnull>
363                     <default>0</default>
364                 </field>
365                 <index>
366                     <name>id</name>
367                     <primary>true</primary>
368                     <field>
369                         <name>id</name>
370                     </field>
371                 </index>
372                 <index>
373                     <name>number</name>
374                     <unique>true</unique>
375                     <field>
376                         <name>number</name>
377                     </field>
378                 </index>
379             </declaration>
380         </table>
381         <table>
382             <name>sales_divisions</name>
383             <version>2</version>
384             <declaration>
385                 <field>
386                     <name>id</name>
387                     <type>text</type>
388                     <length>40</length>
389                     <notnull>true</notnull>
390                 </field>
391                 <field>
392                     <name>title</name>
393                     <type>text</type>
394                     <length>128</length>
395                     <notnull>true</notnull>
396                 </field>
397                 <field>
398                     <name>created_by</name>
399                     <type>text</type>
400                     <length>40</length>
401                 </field>
402                 <field>
403                     <name>creation_time</name>
404                     <type>datetime</type>
405                 </field> 
406                 <field>
407                     <name>last_modified_by</name>
408                     <type>text</type>
409                     <length>40</length>
410                 </field>
411                 <field>
412                     <name>last_modified_time</name>
413                     <type>datetime</type>
414                 </field>
415                 <field>
416                     <name>is_deleted</name>
417                     <type>boolean</type>
418                     <default>false</default>
419                 </field>
420                 <field>
421                     <name>deleted_by</name>
422                     <type>text</type>
423                     <length>40</length>
424                 </field>
425                 <field>
426                     <name>deleted_time</name>
427                     <type>datetime</type>
428                 </field>
429                 <field>
430                     <name>seq</name>
431                     <type>integer</type>
432                     <notnull>true</notnull>
433                     <default>0</default>
434                 </field>
435                 <index>
436                     <name>id</name>
437                     <primary>true</primary>
438                     <field>
439                         <name>id</name>
440                     </field>
441                 </index>
442             </declaration>
443         </table>
444         <table>
445             <name>sales_customers</name>
446             <version>2</version>
447             <declaration>
448                 <field>
449                     <name>id</name>
450                     <type>text</type>
451                     <length>40</length>
452                     <notnull>true</notnull>
453                 </field>
454                 <field>
455                     <name>number</name>
456                     <type>integer</type>
457                     <notnull>true</notnull>
458                     <default>0</default>
459                     <length>32</length>
460                 </field>
461                 <field>
462                     <name>name</name>
463                     <type>text</type>
464                     <notnull>true</notnull>
465                 </field>
466                 <field>
467                     <name>url</name>
468                     <type>text</type>
469                     <notnull>false</notnull>
470                 </field>
471                 <field>
472                     <name>description</name>
473                     <type>text</type>
474                     <notnull>false</notnull>
475                 </field>
476                 <field>
477                     <name>cpextern_id</name>
478                     <type>text</type>
479                     <length>40</length>
480                     <notnull>false</notnull>
481                 </field>
482                 <field>
483                     <name>cpintern_id</name>
484                     <type>text</type>
485                     <length>40</length>
486                     <notnull>false</notnull>
487                 </field>
488                 <field>
489                     <name>vatid</name>
490                     <type>text</type>
491                     <notnull>false</notnull>
492                 </field>
493                 <field>
494                     <name>iban</name>
495                     <type>text</type>
496                     <notnull>false</notnull>
497                 </field>
498                 <field>
499                     <name>bic</name>
500                     <type>text</type>
501                     <notnull>false</notnull>
502                 </field>
503                 <field>
504                     <name>credit_term</name>
505                     <type>integer</type>
506                     <notnull>false</notnull>
507                     <length>10</length>
508                 </field>
509                 <field>
510                     <name>currency</name>
511                     <type>text</type>
512                     <notnull>false</notnull>
513                     <length>4</length>
514                 </field>
515                 <field>
516                     <name>currency_trans_rate</name>
517                     <type>float</type>
518                     <notnull>false</notnull>
519                 </field>
520                 <field>
521                     <name>discount</name>
522                     <type>float</type>
523                     <notnull>false</notnull>
524                 </field>
525                 <field>
526                     <name>created_by</name>
527                     <type>text</type>
528                     <length>40</length>
529                 </field>
530                 <field>
531                     <name>creation_time</name>
532                     <type>datetime</type>
533                 </field> 
534                 <field>
535                     <name>last_modified_by</name>
536                     <type>text</type>
537                     <length>40</length>
538                 </field>
539                 <field>
540                     <name>last_modified_time</name>
541                     <type>datetime</type>
542                 </field>
543                 <field>
544                     <name>is_deleted</name>
545                     <type>boolean</type>
546                     <default>false</default>
547                 </field>
548                 <field>
549                     <name>deleted_by</name>
550                     <type>text</type>
551                     <length>40</length>
552                 </field>
553                 <field>
554                     <name>deleted_time</name>
555                     <type>datetime</type>
556                 </field>
557                 <field>
558                     <name>seq</name>
559                     <type>integer</type>
560                     <notnull>true</notnull>
561                     <default>0</default>
562                 </field>
563                 <index>
564                     <name>id</name>
565                     <primary>true</primary>
566                     <field>
567                         <name>id</name>
568                     </field>
569                 </index>
570                 <index>
571                     <name>description</name>
572                     <fulltext>true</fulltext>
573                     <field>
574                         <name>description</name>
575                     </field>
576                 </index>
577             </declaration>
578         </table>
579         <table>
580             <name>sales_suppliers</name>
581             <version>2</version>
582             <declaration>
583                 <field>
584                     <name>id</name>
585                     <type>text</type>
586                     <length>40</length>
587                     <notnull>true</notnull>
588                 </field>
589                 <field>
590                     <name>number</name>
591                     <type>integer</type>
592                     <notnull>true</notnull>
593                     <default>0</default>
594                     <length>32</length>
595                 </field>
596                 <field>
597                     <name>name</name>
598                     <type>text</type>
599                     <notnull>true</notnull>
600                 </field>
601                 <field>
602                     <name>url</name>
603                     <type>text</type>
604                     <notnull>false</notnull>
605                 </field>
606                 <field>
607                     <name>description</name>
608                     <type>text</type>
609                     <notnull>false</notnull>
610                 </field>
611                 <field>
612                     <name>cpextern_id</name>
613                     <type>text</type>
614                     <length>40</length>
615                     <notnull>false</notnull>
616                 </field>
617                 <field>
618                     <name>cpintern_id</name>
619                     <type>text</type>
620                     <length>40</length>
621                     <notnull>false</notnull>
622                 </field>
623                 <field>
624                     <name>vatid</name>
625                     <type>text</type>
626                     <notnull>false</notnull>
627                 </field>
628                 <field>
629                     <name>iban</name>
630                     <type>text</type>
631                     <notnull>false</notnull>
632                 </field>
633                 <field>
634                     <name>bic</name>
635                     <type>text</type>
636                     <notnull>false</notnull>
637                 </field>
638                 <field>
639                     <name>currency</name>
640                     <type>text</type>
641                     <notnull>false</notnull>
642                     <length>4</length>
643                 </field>
644                 <field>
645                     <name>currency_trans_rate</name>
646                     <type>float</type>
647                     <notnull>false</notnull>
648                 </field>
649                 <field>
650                     <name>created_by</name>
651                     <type>text</type>
652                     <length>40</length>
653                 </field>
654                 <field>
655                     <name>creation_time</name>
656                     <type>datetime</type>
657                 </field> 
658                 <field>
659                     <name>last_modified_by</name>
660                     <type>text</type>
661                     <length>40</length>
662                 </field>
663                 <field>
664                     <name>last_modified_time</name>
665                     <type>datetime</type>
666                 </field>
667                 <field>
668                     <name>is_deleted</name>
669                     <type>boolean</type>
670                     <default>false</default>
671                 </field>
672                 <field>
673                     <name>deleted_by</name>
674                     <type>text</type>
675                     <length>40</length>
676                 </field>
677                 <field>
678                     <name>deleted_time</name>
679                     <type>datetime</type>
680                 </field>
681                 <field>
682                     <name>seq</name>
683                     <type>integer</type>
684                     <notnull>true</notnull>
685                     <default>0</default>
686                 </field>
687                 <index>
688                     <name>id</name>
689                     <primary>true</primary>
690                     <field>
691                         <name>id</name>
692                     </field>
693                 </index>
694                 <index>
695                     <name>description</name>
696                     <fulltext>true</fulltext>
697                     <field>
698                         <name>description</name>
699                     </field>
700                 </index>
701             </declaration>
702         </table>
703         <table>
704             <name>sales_addresses</name>
705             <version>2</version>
706             <declaration>
707                 <field>
708                     <name>id</name>
709                     <type>text</type>
710                     <length>40</length>
711                     <notnull>true</notnull>
712                 </field>
713                 <field>
714                     <name>customer_id</name>
715                     <type>text</type>
716                     <length>40</length>
717                     <notnull>true</notnull>
718                 </field>
719                 <field>
720                     <name>prefix1</name>
721                     <type>text</type>
722                     <notnull>false</notnull>
723                 </field>
724                 <field>
725                     <name>prefix2</name>
726                     <type>text</type>
727                     <notnull>false</notnull>
728                 </field>
729                 <field>
730                     <name>street</name>
731                     <type>text</type>
732                     <notnull>false</notnull>
733                 </field>
734                 <field>
735                     <name>postalcode</name>
736                     <type>text</type>
737                     <notnull>false</notnull>
738                 </field>
739                 <field>
740                     <name>locality</name>
741                     <type>text</type>
742                     <notnull>false</notnull>
743                 </field>
744                 <field>
745                     <name>region</name>
746                     <type>text</type>
747                     <notnull>false</notnull>
748                 </field>
749                 <field>
750                     <name>countryname</name>
751                     <type>text</type>
752                     <notnull>false</notnull>
753                 </field>
754                 <field>
755                     <name>pobox</name>
756                     <type>text</type>
757                     <notnull>false</notnull>
758                 </field>
759                 <field>
760                     <name>custom1</name>
761                     <type>text</type>
762                     <notnull>false</notnull>
763                 </field>
764                 <field>
765                     <name>type</name>
766                     <type>text</type>
767                     <notnull>true</notnull>
768                     <default>postal</default>
769                     <length>64</length>
770                 </field>
771                 <field>
772                     <name>created_by</name>
773                     <type>text</type>
774                     <length>40</length>
775                 </field>
776                 <field>
777                     <name>creation_time</name>
778                     <type>datetime</type>
779                 </field> 
780                 <field>
781                     <name>last_modified_by</name>
782                     <type>text</type>
783                     <length>40</length>
784                 </field>
785                 <field>
786                     <name>last_modified_time</name>
787                     <type>datetime</type>
788                 </field>
789                 <field>
790                     <name>is_deleted</name>
791                     <type>boolean</type>
792                     <default>false</default>
793                 </field>
794                 <field>
795                     <name>deleted_by</name>
796                     <type>text</type>
797                     <length>40</length>
798                 </field>
799                 <field>
800                     <name>deleted_time</name>
801                     <type>datetime</type>
802                 </field>
803                 <field>
804                     <name>seq</name>
805                     <type>integer</type>
806                     <notnull>true</notnull>
807                     <default>0</default>
808                 </field>
809                 <index>
810                     <name>id</name>
811                     <primary>true</primary>
812                     <field>
813                         <name>id</name>
814                     </field>
815                 </index>
816             </declaration>
817         </table>
818         <table>
819             <name>sales_purchase_invoices</name>
820             <version>5</version>
821             <declaration>
822                 <field>
823                     <name>id</name>
824                     <type>text</type>
825                     <length>40</length>
826                     <notnull>true</notnull>
827                 </field>
828                 <field>
829                     <name>number</name>
830                     <type>text</type>
831                     <length>64</length>
832                     <notnull>true</notnull>
833                 </field>
834                 <field>
835                     <name>description</name>
836                     <type>text</type>
837                 </field>
838                 <field>
839                     <name>date</name>
840                     <type>date</type>
841                 </field>
842                 <field>
843                     <name>due_in</name>
844                     <type>integer</type>
845                     <notnull>true</notnull>
846                     <length>10</length>
847                 </field>
848                 <field>
849                     <name>due_at</name>
850                     <type>date</type>
851                     <notnull>true</notnull>
852                 </field>
853                 <field>
854                     <name>pay_at</name>
855                     <type>date</type>
856                 </field>
857                 <field>
858                     <name>overdue_at</name>
859                     <type>date</type>
860                 </field>
861                 <field>
862                     <name>is_payed</name>
863                     <type>boolean</type>
864                     <default>false</default>
865                 </field>
866                 <field>
867                     <name>payed_at</name>
868                     <type>datetime</type>
869                 </field> 
870                 <field>
871                     <name>dunned_at</name>
872                     <type>datetime</type>
873                 </field> 
874                 <field>
875                     <name>payment_method</name>
876                     <type>text</type>
877                     <length>254</length>
878                 </field>
879                 <field>
880                     <name>discount</name>
881                     <type>integer</type>
882                     <notnull>true</notnull>
883                     <length>10</length>
884                 </field>
885                 <field>
886                     <name>discount_until</name>
887                     <type>date</type>
888                 </field>
889                 <field>
890                     <name>is_approved</name>
891                     <type>boolean</type>
892                     <default>false</default>
893                 </field>
894                 <field>
895                     <name>price_net</name>
896                     <type>float</type>
897                     <unsigned>false</unsigned>
898                     <notnull>false</notnull>
899                 </field>
900                 <field>
901                     <name>price_gross</name>
902                     <type>float</type>
903                     <unsigned>false</unsigned>
904                     <notnull>false</notnull>
905                 </field>
906                 <field>
907                     <name>price_gross2</name>
908                     <type>float</type>
909                     <unsigned>false</unsigned>
910                     <notnull>false</notnull>
911                 </field>
912                 <field>
913                     <name>price_tax</name>
914                     <type>float</type>
915                     <unsigned>false</unsigned>
916                     <notnull>false</notnull>
917                 </field>
918                 <field>
919                     <name>sales_tax</name>
920                     <type>float</type>
921                     <notnull>false</notnull>
922                 </field>
923                 <field>
924                     <name>price_total</name>
925                     <type>float</type>
926                     <unsigned>false</unsigned>
927                     <notnull>false</notnull>
928                 </field>
929                 <field>
930                     <name>created_by</name>
931                     <type>text</type>
932                     <length>40</length>
933                 </field>
934                 <field>
935                     <name>creation_time</name>
936                     <type>datetime</type>
937                 </field> 
938                 <field>
939                     <name>last_modified_by</name>
940                     <type>text</type>
941                     <length>40</length>
942                 </field>
943                 <field>
944                     <name>last_modified_time</name>
945                     <type>datetime</type>
946                 </field>
947                 <field>
948                     <name>is_deleted</name>
949                     <type>boolean</type>
950                     <default>false</default>
951                 </field>
952                 <field>
953                     <name>deleted_by</name>
954                     <type>text</type>
955                     <length>40</length>
956                 </field>
957                 <field>
958                     <name>deleted_time</name>
959                     <type>datetime</type>
960                 </field>
961                 <field>
962                     <name>seq</name>
963                     <type>integer</type>
964                     <notnull>true</notnull>
965                     <default>0</default>
966                 </field>
967                 <index>
968                     <name>id</name>
969                     <primary>true</primary>
970                     <field>
971                         <name>id</name>
972                     </field>
973                 </index>
974                 <index>
975                     <name>description</name>
976                     <fulltext>true</fulltext>
977                     <field>
978                         <name>description</name>
979                     </field>
980                 </index>
981             </declaration>
982         </table>
983         <table>
984             <name>sales_sales_invoices</name>
985             <version>7</version>
986             <declaration>
987                 <field>
988                     <name>id</name>
989                     <type>text</type>
990                     <length>40</length>
991                     <notnull>true</notnull>
992                 </field>
993                 <field>
994                     <name>number</name>
995                     <type>text</type>
996                     <length>64</length>
997                     <notnull>false</notnull>
998                 </field>
999                 <field>
1000                     <name>description</name>
1001                     <type>text</type>
1002                     <length>255</length>
1003                     <notnull>true</notnull>
1004                 </field>
1005                 <field>
1006                     <name>address_id</name>
1007                     <type>text</type>
1008                     <length>40</length>
1009                     <notnull>true</notnull>
1010                 </field>
1011                 <field>
1012                     <name>fixed_address</name>
1013                     <type>text</type>
1014                     <notnull>false</notnull>
1015                 </field>
1016                 <field>
1017                     <name>is_auto</name>
1018                     <type>boolean</type>
1019                     <default>false</default>
1020                 </field>
1021                 <field>
1022                     <name>date</name>
1023                     <type>date</type>
1024                 </field>
1025                 <field>
1026                     <name>credit_term</name>
1027                     <type>integer</type>
1028                     <notnull>false</notnull>
1029                     <length>10</length>
1030                 </field>
1031                 <field>
1032                     <name>price_net</name>
1033                     <type>float</type>
1034                     <unsigned>false</unsigned>
1035                     <notnull>false</notnull>
1036                 </field>
1037                 <field>
1038                     <name>price_tax</name>
1039                     <type>float</type>
1040                     <unsigned>false</unsigned>
1041                     <notnull>false</notnull>
1042                 </field>
1043                 <field>
1044                     <name>price_gross</name>
1045                     <type>float</type>
1046                     <unsigned>false</unsigned>
1047                     <notnull>false</notnull>
1048                 </field>
1049                 <field>
1050                     <name>sales_tax</name>
1051                     <type>float</type>
1052                     <notnull>false</notnull>
1053                 </field>
1054                 <field>
1055                     <name>inventory_change</name>
1056                     <type>float</type>
1057                     <unsigned>false</unsigned>
1058                     <notnull>false</notnull>
1059                 </field>
1060                 <field>
1061                     <name>costcenter_id</name>
1062                     <type>text</type>
1063                     <length>40</length>
1064                     <notnull>true</notnull>
1065                 </field>
1066                 <field>
1067                     <name>cleared</name>
1068                     <type>text</type>
1069                     <length>64</length>
1070                     <default>TO_CLEAR</default>
1071                 </field>
1072                 <field>
1073                     <name>type</name>
1074                     <type>text</type>
1075                 </field>
1076                 <field>
1077                     <name>start_date</name>
1078                     <type>datetime</type>
1079                 </field> 
1080                 <field>
1081                     <name>end_date</name>
1082                     <type>datetime</type>
1083                 </field>
1084                 <field>
1085                     <name>created_by</name>
1086                     <type>text</type>
1087                     <length>40</length>
1088                 </field>
1089                 <field>
1090                     <name>creation_time</name>
1091                     <type>datetime</type>
1092                 </field> 
1093                 <field>
1094                     <name>last_modified_by</name>
1095                     <type>text</type>
1096                     <length>40</length>
1097                 </field>
1098                 <field>
1099                     <name>last_modified_time</name>
1100                     <type>datetime</type>
1101                 </field>
1102                 <field>
1103                     <name>is_deleted</name>
1104                     <type>boolean</type>
1105                     <default>false</default>
1106                 </field>
1107                 <field>
1108                     <name>deleted_by</name>
1109                     <type>text</type>
1110                     <length>40</length>
1111                 </field>
1112                 <field>
1113                     <name>deleted_time</name>
1114                     <type>datetime</type>
1115                 </field>
1116                 <field>
1117                     <name>seq</name>
1118                     <type>integer</type>
1119                     <notnull>true</notnull>
1120                     <default>0</default>
1121                 </field>
1122                 <index>
1123                     <name>id</name>
1124                     <primary>true</primary>
1125                     <field>
1126                         <name>id</name>
1127                     </field>
1128                 </index>
1129                 <index>
1130                     <name>description</name>
1131                     <fulltext>true</fulltext>
1132                     <field>
1133                         <name>description</name>
1134                     </field>
1135                 </index>
1136             </declaration>
1137         </table>
1138         <table>
1139             <name>sales_product_agg</name>
1140             <version>5</version>
1141             <declaration>
1142                 <field>
1143                     <name>id</name>
1144                     <type>text</type>
1145                     <length>40</length>
1146                     <notnull>true</notnull>
1147                 </field>
1148                 <field>
1149                     <name>product_id</name>
1150                     <type>text</type>
1151                     <length>40</length>
1152                     <notnull>true</notnull>
1153                 </field>
1154                 <field>
1155                     <name>contract_id</name>
1156                     <type>text</type>
1157                     <length>40</length>
1158                     <notnull>true</notnull>
1159                 </field>
1160                 <field>
1161                     <name>quantity</name>
1162                     <type>integer</type>
1163                     <notnull>false</notnull>
1164                     <default>null</default>
1165                 </field>
1166                 <field>
1167                     <name>interval</name>
1168                     <type>integer</type>
1169                     <notnull>true</notnull>
1170                     <default>1</default>
1171                 </field>
1172                 <field>
1173                     <name>last_autobill</name>
1174                     <type>datetime</type>
1175                     <notnull>false</notnull>
1176                     <default>null</default>
1177                 </field>
1178                 <field>
1179                     <name>billing_point</name>
1180                     <type>text</type>
1181                     <length>64</length>
1182                     <notnull>false</notnull>
1183                 </field>
1184                 <field>
1185                     <name>start_date</name>
1186                     <type>datetime</type>
1187                 </field>
1188                 <field>
1189                     <name>end_date</name>
1190                     <type>datetime</type>
1191                 </field>
1192                 <field>
1193                     <name>created_by</name>
1194                     <type>text</type>
1195                     <length>40</length>
1196                 </field>
1197                 <field>
1198                     <name>creation_time</name>
1199                     <type>datetime</type>
1200                 </field> 
1201                 <field>
1202                     <name>last_modified_by</name>
1203                     <type>text</type>
1204                     <length>40</length>
1205                 </field>
1206                 <field>
1207                     <name>last_modified_time</name>
1208                     <type>datetime</type>
1209                 </field>
1210                 <field>
1211                     <name>is_deleted</name>
1212                     <type>boolean</type>
1213                     <default>false</default>
1214                 </field>
1215                 <field>
1216                     <name>deleted_by</name>
1217                     <type>text</type>
1218                     <length>40</length>
1219                 </field>
1220                 <field>
1221                     <name>deleted_time</name>
1222                     <type>datetime</type>
1223                 </field>
1224                 <field>
1225                     <name>seq</name>
1226                     <type>integer</type>
1227                     <notnull>true</notnull>
1228                     <default>0</default>
1229                 </field>
1230                 <field>
1231                     <name>json_attributes</name>
1232                     <type>text</type>
1233                 </field>
1234                 <index>
1235                     <name>id</name>
1236                     <primary>true</primary>
1237                     <field>
1238                         <name>id</name>
1239                     </field>
1240                 </index>
1241                 <index>
1242                     <name>product_id</name>
1243                     <field>
1244                         <name>product_id</name>
1245                     </field>
1246                 </index>
1247                 <index>
1248                     <name>contract_id</name>
1249                     <field>
1250                         <name>contract_id</name>
1251                     </field>
1252                 </index>
1253             </declaration>
1254         </table>
1255         <table>
1256             <name>sales_orderconf</name>
1257             <version>2</version>
1258             <declaration>
1259                 <field>
1260                     <name>id</name>
1261                     <type>text</type>
1262                     <length>40</length>
1263                     <notnull>true</notnull>
1264                 </field>
1265                 <field>
1266                     <name>title</name>
1267                     <type>text</type>
1268                     <length>128</length>
1269                     <notnull>true</notnull>
1270                 </field>
1271                 <field>
1272                     <name>number</name>
1273                     <type>text</type>
1274                     <length>64</length>
1275                     <notnull>true</notnull>
1276                 </field>
1277                 <field>
1278                     <name>description</name>
1279                     <type>text</type>
1280                 </field>
1281                 <field>
1282                     <name>created_by</name>
1283                     <type>text</type>
1284                     <length>40</length>
1285                 </field>
1286                 <field>
1287                     <name>creation_time</name>
1288                     <type>datetime</type>
1289                 </field> 
1290                 <field>
1291                     <name>last_modified_by</name>
1292                     <type>text</type>
1293                     <length>40</length>
1294                 </field>
1295                 <field>
1296                     <name>last_modified_time</name>
1297                     <type>datetime</type>
1298                 </field>
1299                 <field>
1300                     <name>is_deleted</name>
1301                     <type>boolean</type>
1302                     <default>false</default>
1303                 </field>
1304                 <field>
1305                     <name>deleted_by</name>
1306                     <type>text</type>
1307                     <length>40</length>
1308                 </field>
1309                 <field>
1310                     <name>deleted_time</name>
1311                     <type>datetime</type>
1312                 </field>
1313                 <field>
1314                     <name>seq</name>
1315                     <type>integer</type>
1316                     <notnull>true</notnull>
1317                     <default>0</default>
1318                 </field>
1319                 <index>
1320                     <name>id</name>
1321                     <primary>true</primary>
1322                     <field>
1323                         <name>id</name>
1324                     </field>
1325                 </index>
1326                 <index>
1327                     <name>description</name>
1328                     <fulltext>true</fulltext>
1329                     <field>
1330                         <name>description</name>
1331                     </field>
1332                 </index>
1333             </declaration>
1334         </table>
1335         <table>
1336             <name>sales_invoice_positions</name>
1337             <version>2</version>
1338             <declaration>
1339                 <field>
1340                     <name>id</name>
1341                     <type>text</type>
1342                     <length>40</length>
1343                     <notnull>true</notnull>
1344                 </field>
1345                 <field>
1346                     <name>invoice_id</name>
1347                     <type>text</type>
1348                     <length>40</length>
1349                     <notnull>true</notnull>
1350                 </field>
1351                 <field>
1352                     <name>accountable_id</name>
1353                     <type>text</type>
1354                     <length>40</length>
1355                     <notnull>true</notnull>
1356                 </field>
1357                 <field>
1358                     <name>model</name>
1359                     <type>text</type>
1360                     <length>255</length>
1361                     <notnull>true</notnull>
1362                 </field>
1363                 <field>
1364                     <name>title</name>
1365                     <type>text</type>
1366                     <length>255</length>
1367                     <notnull>true</notnull>
1368                 </field>
1369                 <field>
1370                     <name>month</name>
1371                     <type>text</type>
1372                     <length>7</length>
1373                     <notnull>true</notnull>
1374                 </field>
1375                 <field>
1376                     <name>unit</name>
1377                     <type>text</type>
1378                     <length>128</length>
1379                     <notnull>true</notnull>
1380                 </field>
1381                 <field>
1382                     <name>quantity</name>
1383                     <type>float</type>
1384                     <notnull>true</notnull>
1385                     <default>1</default>
1386                 </field>
1387                 <index>
1388                     <name>id</name>
1389                     <primary>true</primary>
1390                     <field>
1391                         <name>id</name>
1392                     </field>
1393                 </index>
1394                 <index>
1395                     <name>invoice_id</name>
1396                     <field>
1397                         <name>invoice_id</name>
1398                     </field>
1399                 </index>
1400             </declaration>
1401         </table>
1402         <table>
1403             <name>sales_offers</name>
1404             <version>2</version>
1405             <declaration>
1406                 <field>
1407                     <name>id</name>
1408                     <type>text</type>
1409                     <length>40</length>
1410                     <notnull>true</notnull>
1411                 </field>
1412                 <field>
1413                     <name>title</name>
1414                     <type>text</type>
1415                     <length>128</length>
1416                     <notnull>true</notnull>
1417                 </field>
1418                 <field>
1419                     <name>number</name>
1420                     <type>text</type>
1421                     <length>64</length>
1422                     <notnull>true</notnull>
1423                 </field>
1424                 <field>
1425                     <name>description</name>
1426                     <type>text</type>
1427                 </field>
1428                 <field>
1429                     <name>created_by</name>
1430                     <type>text</type>
1431                     <length>40</length>
1432                 </field>
1433                 <field>
1434                     <name>creation_time</name>
1435                     <type>datetime</type>
1436                 </field> 
1437                 <field>
1438                     <name>last_modified_by</name>
1439                     <type>text</type>
1440                     <length>40</length>
1441                 </field>
1442                 <field>
1443                     <name>last_modified_time</name>
1444                     <type>datetime</type>
1445                 </field>
1446                 <field>
1447                     <name>is_deleted</name>
1448                     <type>boolean</type>
1449                     <default>false</default>
1450                 </field>
1451                 <field>
1452                     <name>deleted_by</name>
1453                     <type>text</type>
1454                     <length>40</length>
1455                 </field>
1456                 <field>
1457                     <name>deleted_time</name>
1458                     <type>datetime</type>
1459                 </field>
1460                 <field>
1461                     <name>seq</name>
1462                     <type>integer</type>
1463                     <notnull>true</notnull>
1464                     <default>0</default>
1465                 </field>
1466                 <index>
1467                     <name>id</name>
1468                     <primary>true</primary>
1469                     <field>
1470                         <name>id</name>
1471                     </field>
1472                 </index>
1473                 <index>
1474                     <name>description</name>
1475                     <fulltext>true</fulltext>
1476                     <field>
1477                         <name>description</name>
1478                     </field>
1479                 </index>
1480             </declaration>
1481         </table>
1482     </tables>
1483 </application>