ext_tables.sql 3.26 KB
Newer Older
Dirk Wildt's avatar
Dirk Wildt committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
#
# INDEX
#
# tx_caddy_item
# tx_caddy_order



#
# Table structure for table 'tx_caddy_item'
#
CREATE TABLE tx_caddy_item (
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
18
  deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
19 20
	sorting int(10) DEFAULT '0' NOT NULL,

Dirk Wildt's avatar
Dirk Wildt committed
21 22 23
  externalTable tinytext,
  externalUid int(11) DEFAULT '0' NOT NULL,
  gross double(11,2) DEFAULT '0.00' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
  quantity int(11) DEFAULT '0' NOT NULL,
  sku tinytext,
  tax int(11) DEFAULT '0' NOT NULL,
  title tinytext,
	tx_caddy_order int(11) unsigned DEFAULT '0' NOT NULL,
  weight double(11,2) DEFAULT '0.00' NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
);



#
# Table structure for table 'tx_caddy_order'
#
CREATE TABLE tx_caddy_order (
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
46
  deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
47

Dirk Wildt's avatar
Dirk Wildt committed
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
  customerEmail tinytext,
  customerDebitBic tinytext,
  customerDebitIban tinytext,
  customerDebitOwner tinytext,
  customerDeliveryorderAddress tinytext,
  customerDeliveryorderCity tinytext,
  customerDeliveryorderCompany tinytext,
  customerDeliveryorderCountry tinytext,
  customerDeliveryorderFirstname tinytext,
  customerDeliveryorderLastname tinytext,
  customerDeliveryorderZip tinytext,
  customerInvoiceAddress tinytext,
  customerInvoiceCity tinytext,
  customerInvoiceCompany tinytext,
  customerInvoiceCountry tinytext,
  customerInvoiceFirstname tinytext,
  customerInvoiceLastname tinytext,
  customerInvoiceZip tinytext,
Dirk Wildt's avatar
Dirk Wildt committed
66
  customerUid tinytext,
Dirk Wildt's avatar
Dirk Wildt committed
67

Dirk Wildt's avatar
Dirk Wildt committed
68 69 70
  fe_cruser_id int(11) NOT NULL DEFAULT '0',
  fe_group varchar(100) NOT NULL DEFAULT '',

Dirk Wildt's avatar
Dirk Wildt committed
71 72 73 74 75
  fileDeliveryorder tinytext,
  fileInvoice tinytext,
  fileOrderconfirmation tinytext,
  fileRevocation tinytext,
  fileTerms tinytext,
Dirk Wildt's avatar
Dirk Wildt committed
76 77 78 79 80

  numberDeliveryorder int(11) DEFAULT '0' NOT NULL,
  numberInvoice int(11) DEFAULT '0' NOT NULL,
  numberOrder int(11) DEFAULT '0' NOT NULL,

Dirk Wildt's avatar
Dirk Wildt committed
81 82 83 84 85 86 87 88 89 90
  pdfDeliveryorderToCustomer smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfDeliveryorderToVendor smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfInvoiceToCustomer smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfInvoiceToVendor smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfOrderconfirmationToCustomer smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfOrderconfirmationToVendor smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfRevocationToCustomer smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfRevocationToVendor smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfTermsToCustomer smallint(5) unsigned DEFAULT '0' NOT NULL,
  pdfTermsToVendor smallint(5) unsigned DEFAULT '0' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
91 92 93

  quantity int(11) DEFAULT '0' NOT NULL,

Dirk Wildt's avatar
Dirk Wildt committed
94 95
  statisticValue01 tinytext,

Dirk Wildt's avatar
Dirk Wildt committed
96 97
  sumNet double(11,2) DEFAULT '0.00' NOT NULL,
  sumGross double(11,2) DEFAULT '0.00' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
98
  sumWeight double(11,2) DEFAULT '0.00' NOT NULL,
Dirk Wildt's avatar
Dirk Wildt committed
99 100 101
  sumTaxNormal double(11,2) DEFAULT '0.00' NOT NULL,
  sumTaxReduced double(11,2) DEFAULT '0.00' NOT NULL,

Dirk Wildt's avatar
Dirk Wildt committed
102 103
  tx_caddy_item tinytext,

Dirk Wildt's avatar
Dirk Wildt committed
104 105 106
  PRIMARY KEY (uid),
  KEY parent (pid)
);