BM5XTVvm

1-- ---
2-- Globals
3-- ---
4
5-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
6-- SET FOREIGN_KEY_CHECKS=0;
7
8-- ---
9-- Table 'gt_debt_application'
10-- Заявки
11-- ---
12
13DROP TABLE IF EXISTS `gt_debt_application`;
14		
15CREATE TABLE `gt_debt_application` (
16  `ID` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
17  `DEAL_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Сделка',
18  `RESPONSIBLE_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Ответственный',
19  `CONTRACT_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Договор',
20  `CONTRACTOR_REQUISITE_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Реквизит контрагента (из журнала договоров)',
21  `ORGANIZATION_REQUISITE_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Реквизит нашей организации (из журнала договоров)',
22  `APPLICATION_VIEW_MODE_ID` INTEGER NULL DEFAULT NULL COMMENT 'Количество счетов (из списка)',
23  `CONTENT_VIEW_MODE_ID` INTEGER NULL DEFAULT NULL COMMENT 'Содержание счета (из списка)',
24  PRIMARY KEY (`ID`)
25) COMMENT 'Заявки';
26
27-- ---
28-- Table 'gt_debt_application_item'
29-- Товары/услуги по заявке
30-- ---
31
32DROP TABLE IF EXISTS `gt_debt_application_item`;
33		
34CREATE TABLE `gt_debt_application_item` (
35  `ID` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
36  `APPLICATION_ID` INTEGER NULL DEFAULT NULL COMMENT 'Заявка',
37  `PRODUCT_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Товар из CRM',
38  `PRICE` DECIMAL(18,4) NOT NULL DEFAULT NULL COMMENT 'Сумма',
39  PRIMARY KEY (`ID`)
40) COMMENT 'Товары/услуги по заявке';
41
42-- ---
43-- Table 'b_crm_deal'
44-- Сделки
45-- ---
46
47DROP TABLE IF EXISTS `b_crm_deal`;
48		
49CREATE TABLE `b_crm_deal` (
50  `ID` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
51  PRIMARY KEY (`ID`)
52) COMMENT 'Сделки';
53
54-- ---
55-- Table 'b_crm_product_row'
56-- Товары
57-- ---
58
59DROP TABLE IF EXISTS `b_crm_product_row`;
60		
61CREATE TABLE `b_crm_product_row` (
62  `ID` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
63  PRIMARY KEY (`ID`)
64) COMMENT 'Товары';
65
66-- ---
67-- Table 'gt_debt_application_schedule'
68-- График оплат
69-- ---
70
71DROP TABLE IF EXISTS `gt_debt_application_schedule`;
72		
73CREATE TABLE `gt_debt_application_schedule` (
74  `ID` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
75  `APPLICATION_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Заявка',
76  `DATE` DATE NOT NULL DEFAULT 'NULL' COMMENT 'Дата',
77  `PRICE` DECIMAL(18,4) NOT NULL DEFAULT NULL COMMENT 'Сумма',
78  PRIMARY KEY (`ID`)
79) COMMENT 'График оплат';
80
81-- ---
82-- Table 'Список: Журнал договоров'
83-- 
84-- ---
85
86DROP TABLE IF EXISTS `Список: Журнал договоров`;
87		
88CREATE TABLE `Список: Журнал договоров` (
89  `ID` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
90  PRIMARY KEY (`ID`)
91);
92
93-- ---
94-- Table 'gt_debt_application_invoice'
95-- Счета по заявкам
96-- ---
97
98DROP TABLE IF EXISTS `gt_debt_application_invoice`;
99		
100CREATE TABLE `gt_debt_application_invoice` (
101  `ID` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NULL,
102  `APPLICATION_ID` INTEGER NOT NULL DEFAULT NULL COMMENT 'Заявка',
103  `DATE` DATE NOT NULL DEFAULT 'NULL' COMMENT 'Дата',
104  PRIMARY KEY (`ID`)
105) COMMENT 'Счета по заявкам';
106
107-- ---
108-- Foreign Keys 
109-- ---
110
111ALTER TABLE `gt_debt_application` ADD FOREIGN KEY (DEAL_ID) REFERENCES `b_crm_deal` (`ID`);
112ALTER TABLE `gt_debt_application` ADD FOREIGN KEY (CONTRACT_ID) REFERENCES `Список: Журнал договоров` (`ID`);
113ALTER TABLE `gt_debt_application_item` ADD FOREIGN KEY (APPLICATION_ID) REFERENCES `gt_debt_application` (`ID`);
114ALTER TABLE `gt_debt_application_item` ADD FOREIGN KEY (PRODUCT_ID) REFERENCES `b_crm_product_row` (`ID`);
115ALTER TABLE `gt_debt_application_schedule` ADD FOREIGN KEY (APPLICATION_ID) REFERENCES `gt_debt_application` (`ID`);
116ALTER TABLE `gt_debt_application_invoice` ADD FOREIGN KEY (APPLICATION_ID) REFERENCES `gt_debt_application` (`ID`);
117
118-- ---
119-- Table Properties
120-- ---
121
122-- ALTER TABLE `gt_debt_application` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
123-- ALTER TABLE `gt_debt_application_item` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
124-- ALTER TABLE `b_crm_deal` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
125-- ALTER TABLE `b_crm_product_row` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
126-- ALTER TABLE `gt_debt_application_schedule` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
127-- ALTER TABLE `Список: Журнал договоров` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
128-- ALTER TABLE `gt_debt_application_invoice` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
129
130-- ---
131-- Test Data
132-- ---
133
134-- INSERT INTO `gt_debt_application` (`ID`,`DEAL_ID`,`RESPONSIBLE_ID`,`CONTRACT_ID`,`CONTRACTOR_REQUISITE_ID`,`ORGANIZATION_REQUISITE_ID`,`APPLICATION_VIEW_MODE_ID`,`CONTENT_VIEW_MODE_ID`) VALUES
135-- ('','','','','','','','');
136-- INSERT INTO `gt_debt_application_item` (`ID`,`APPLICATION_ID`,`PRODUCT_ID`,`PRICE`) VALUES
137-- ('','','','');
138-- INSERT INTO `b_crm_deal` (`ID`) VALUES
139-- ('');
140-- INSERT INTO `b_crm_product_row` (`ID`) VALUES
141-- ('');
142-- INSERT INTO `gt_debt_application_schedule` (`ID`,`APPLICATION_ID`,`DATE`,`PRICE`) VALUES
143-- ('','','','');
144-- INSERT INTO `Список: Журнал договоров` (`ID`) VALUES
145-- ('');
146-- INSERT INTO `gt_debt_application_invoice` (`ID`,`APPLICATION_ID`,`DATE`) VALUES
147-- ('','','');