/db/changes/024_create_recurring_invoice_tables.sql

https://github.com/mblix/ODOL · SQL · 169 lines · 134 code · 12 blank · 23 comment · 0 complexity · 66e968e716077d08014fd3c73d384a24 MD5 · raw file 

    

  1. -- phpMyAdmin SQL Dump
    2. 

  2. -- version 2.11.8.1deb1ubuntu0.2
    3. 

  3. -- http://www.phpmyadmin.net
    4. 

  4. --
    5. 

  5. -- Host: localhost
    6. 

  6. -- Generation Time: Apr 23, 2010 at 11:36 AM
    7. 

  7. -- Server version: 5.0.67
    8. 

  8. -- PHP Version: 5.2.6-2ubuntu4.6
    9. 

  9. 

  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    11. 

  11. 

  12. --
    13. 

  13. -- Database: `BLIX_SOLUTIONS_AS`
    14. 

  14. --
    15. 

  15. 

  16. -- --------------------------------------------------------
    17. 

  17. 

  18. --
    19. 

  19. -- Table structure for table `recurring`
    20. 

  20. --
    21. 

  21. 

  22. CREATE TABLE IF NOT EXISTS `recurring` (
    23. 

  23.   `RecurringID` bigint(20) NOT NULL auto_increment,
    24. 

  24.   `StartDate` date NOT NULL,
    25. 

  25.   `TimeInterval` varchar(20) NOT NULL,
    26. 

  26.   `LastDate` date NOT NULL,
    27. 

  27.   PRIMARY KEY  (`RecurringID`)
    28. 

  28. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10968 ;
    29. 

  29. 

  30. -- --------------------------------------------------------
    31. 

  31. 

  32. --
    33. 

  33. -- Table structure for table `recurringout`
    34. 

  34. --
    35. 

  35. 

  36. CREATE TABLE IF NOT EXISTS `recurringout` (
    37. 

  37.   `RecurringID` bigint(20) NOT NULL auto_increment,
    38. 

  38.   `CompanyID` int(11) NOT NULL default '0',
    39. 

  39.   `ContactPersonID` int(11) NOT NULL default '0',
    40. 

  40.   `TotalCustPrice` decimal(16,2) NOT NULL default '0.00',
    41. 

  41.   `DName` varchar(255) NOT NULL default '',
    42. 

  42.   `DAddress` varchar(255) NOT NULL default '',
    43. 

  43.   `DZipCode` varchar(10) NOT NULL default '',
    44. 

  44.   `DCity` varchar(255) NOT NULL default '',
    45. 

  45.   `DCountry` varchar(255) NOT NULL default '',
    46. 

  46.   `Status` varchar(10) NOT NULL default '0',
    47. 

  47.   `InvoiceDate` date NOT NULL default '0000-00-00',
    48. 

  48.   `DueDate` date NOT NULL default '0000-00-00',
    49. 

  49.   `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    50. 

  50.   `ProjectID` int(11) NOT NULL default '0',
    51. 

  51.   `ProjectNameInternal` varchar(255) NOT NULL default '',
    52. 

  52.   `PaymentDate` datetime NOT NULL default '0000-00-00 00:00:00',
    53. 

  53.   `Active` tinyint(4) NOT NULL default '0',
    54. 

  54.   `CreatedByID` int(11) NOT NULL default '0',
    55. 

  55.   `ProjectStartDate` date NOT NULL default '0000-00-00',
    56. 

  56.   `ProjectStopDate` date NOT NULL default '0000-00-00',
    57. 

  57.   `CommentCustomer` text NOT NULL,
    58. 

  58.   `CommentInternal` text NOT NULL,
    59. 

  59.   `DeliveryCondition` varchar(255) NOT NULL default '',
    60. 

  60.   `PaymentCondition` varchar(255) NOT NULL default '',
    61. 

  61.   `IAddress` varchar(255) NOT NULL default '',
    62. 

  62.   `IZipCode` varchar(10) NOT NULL default '',
    63. 

  63.   `ICity` varchar(255) NOT NULL default '',
    64. 

  64.   `ICountry` varchar(255) NOT NULL default '',
    65. 

  65.   `DeliveryDate` date NOT NULL default '0000-00-00',
    66. 

  66.   `OrderDate` date NOT NULL default '0000-00-00',
    67. 

  67.   `VATDuty` tinyint(4) NOT NULL default '0',
    68. 

  68.   `TotalVat` decimal(16,2) NOT NULL default '0.00',
    69. 

  69.   `IName` varchar(255) NOT NULL default '',
    70. 

  70.   `InvoiceType` set('order','project') default NULL,
    71. 

  71.   `FromCompanyID` int(11) NOT NULL default '0',
    72. 

  72.   `CreatedDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
    73. 

  73.   `AccountPlanID` bigint(20) default NULL,
    74. 

  74.   `DEmail` varchar(50) NOT NULL default '',
    75. 

  75.   `IEmail` varchar(50) NOT NULL default '',
    76. 

  76.   `RefCustomer` varchar(255) NOT NULL default '',
    77. 

  77.   `YourRef` varchar(255) default NULL,
    78. 

  78.   `BankAccount` varchar(15) NOT NULL default '',
    79. 

  79.   `Phone` varchar(20) NOT NULL default '',
    80. 

  80.   `ProjectNameCustomer` varchar(255) NOT NULL default '',
    81. 

  81.   `IPoBox` varchar(255) NOT NULL default '',
    82. 

  82.   `IPoBoxCity` varchar(255) NOT NULL default '',
    83. 

  83.   `IPoBoxZipCode` varchar(255) NOT NULL default '',
    84. 

  84.   `IPoBoxZipCodeCity` varchar(255) NOT NULL default '',
    85. 

  85.   `DPoBoxZipCode` varchar(255) NOT NULL default '',
    86. 

  86.   `DPoBoxZipCodeCity` varchar(255) NOT NULL default '',
    87. 

  87.   `InvoiceFileID` int(11) NOT NULL default '0',
    88. 

  88.   `Discount` decimal(16,2) default NULL,
    89. 

  89.   `PersonID` int(11) NOT NULL default '0',
    90. 

  90.   `ResponsiblePersonID` int(11) default '0',
    91. 

  91.   `RequiredDate` datetime default NULL,
    92. 

  92.   `Freight` decimal(16,2) default '0.00',
    93. 

  93.   `ValidFrom` datetime default NULL,
    94. 

  94.   `ValidTo` datetime default NULL,
    95. 

  95.   `TaxFree` tinyint(4) default '0',
    96. 

  96.   `DateShipped` date default NULL,
    97. 

  97.   `CreatedByPersonID` int(11) NOT NULL default '0',
    98. 

  98.   `UpdatedByPersonID` int(11) NOT NULL default '0',
    99. 

  99.   `TotalCostPrice` decimal(16,2) NOT NULL default '0.00',
    100. 

  100.   `IAddressID` int(11) default NULL,
    101. 

  101.   `DAddressID` int(11) default NULL,
    102. 

  102.   `AddressID` int(11) NOT NULL default '0',
    103. 

  103.   `DPoBoxCity` varchar(255) default NULL,
    104. 

  104.   `InvoiceSalePersonID` int(11) default NULL,
    105. 

  105.   `DPoBox` varchar(255) default NULL,
    106. 

  106.   `RefInternal` varchar(255) default NULL,
    107. 

  107.   `SalePersonID` int(11) NOT NULL default '0',
    108. 

  108.   `EnableTaxFree` smallint(6) NOT NULL default '0',
    109. 

  109.   `VAddressNumber` varchar(10) NOT NULL default '',
    110. 

  110.   `IAddressNumber` varchar(10) NOT NULL default '',
    111. 

  111.   `DAddressNumber` varchar(10) NOT NULL default '',
    112. 

  112.   `MailSendtDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
    113. 

  113.   `CustomerViewedDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
    114. 

  114.   `CustomerViewedPersonID` int(11) NOT NULL default '0',
    115. 

  115.   `MailExpireDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
    116. 

  116.   `VPoBoxZipCodeCity` varchar(255) default NULL,
    117. 

  117.   `InsertedByPersonID` int(11) default NULL,
    118. 

  118.   `InsertedDateTime` datetime default NULL,
    119. 

  119.   `DepartmentID` int(11) default NULL,
    120. 

  120.   `DepartmentCustomer` varchar(255) default NULL,
    121. 

  121.   `Period` varchar(7) default NULL,
    122. 

  122.   `KID` varchar(30) default NULL,
    123. 

  123.   `CurrencyID` varchar(4) default 'NOK',
    124. 

  124.   `CustomerAccountPlanID` bigint(20) default NULL,
    125. 

  125.   `SupplierAccountPlanID` bigint(20) default NULL,
    126. 

  126.   `ExternalID` int(11) NOT NULL default '0',
    127. 

  127.   `JournalID` int(11) NOT NULL default '0',
    128. 

  128.   `Note` varchar(255) default NULL,
    129. 

  129.   `FakturabankID` bigint(20) default NULL,
    130. 

  130.   `VoucherType` char(3) default NULL,
    131. 

  131.   PRIMARY KEY  (`RecurringID`)
    132. 

  132. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10968 ;
    133. 

  133. 

  134. -- --------------------------------------------------------
    135. 

  135. 

  136. --
    137. 

  137. -- Table structure for table `recurringoutline`
    138. 

  138. --
    139. 

  139. 

  140. CREATE TABLE IF NOT EXISTS `recurringoutline` (
    141. 

  141.   `LineID` int(11) NOT NULL auto_increment,
    142. 

  142.   `RecurringID` bigint(20) default NULL,
    143. 

  143.   `ProductNumber` varchar(255) NOT NULL default '',
    144. 

  144.   `ProductID` int(11) NOT NULL default '0',
    145. 

  145.   `UnitCostPrice` decimal(16,2) NOT NULL default '0.00',
    146. 

  146.   `UnitCustPrice` decimal(16,2) NOT NULL default '0.00',
    147. 

  147.   `QuantityOrdered` decimal(16,2) NOT NULL default '0.00',
    148. 

  148.   `QuantityDelivered` decimal(16,2) NOT NULL default '0.00',
    149. 

  149.   `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    150. 

  150.   `Vat` decimal(16,2) NOT NULL default '0.00',
    151. 

  151.   `Active` smallint(6) NOT NULL default '1',
    152. 

  152.   `ProductName` varchar(255) NOT NULL default '',
    153. 

  153.   `Comment` varchar(255) NOT NULL default '',
    154. 

  154.   `VatID` int(11) NOT NULL default '0',
    155. 

  155.   `TaxFree` smallint(6) NOT NULL default '1',
    156. 

  156.   `ProductVariantID` int(11) NOT NULL default '0',
    157. 

  157.   `ValidFromDate` datetime default NULL,
    158. 

  158.   `ValidToDate` datetime default NULL,
    159. 

  159.   `InsertedByPersonID` bigint(20) NOT NULL default '0',
    160. 

  160.   `UpdatedByPersonID` bigint(20) NOT NULL default '0',
    161. 

  161.   `InsertedDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
    162. 

  162.   `LineNum` int(11) NOT NULL default '0',
    163. 

  163.   `TaxAmount` decimal(16,5) default NULL,
    164. 

  164.   `Discount` decimal(16,5) default NULL,
    165. 

  165.   `UnitCustPriceCurrencyID` varchar(4) default 'NOK',
    166. 

  166.   `UnitCostPriceCurrencyID` varchar(4) default 'NOK',
    167. 

  167.   PRIMARY KEY  (`LineID`)
    168. 

  168. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
    169.