· 8 years ago · Jan 06, 2018, 11:42 PM
1IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'fornecedor_maisSom')
2CREATE TABLE [dbo].[fornecedor_maisSom](
3 [numero] [numeric](10, 0) NOT NULL,
4 [nome] [varchar](55) NOT NULL,
5 [fax] [varchar](60) NOT NULL,
6 [telefone] [varchar](60) NOT NULL,
7 [contacto] [varchar](30) NOT NULL,
8 [morada] [varchar](55) NOT NULL,
9 [codpostal] [varchar](10) NOT NULL,
10 [localidade] [varchar](33) NOT NULL,
11 [ncontribuinte] [varchar](20) NOT NULL,
12 [zona] [numeric](5, 0) NOT NULL,
13 [tipo] [varchar](20) NOT NULL,
14 [desconto] [numeric](5, 2) NOT NULL,
15 [vencimento] [numeric](3, 0) NOT NULL,
16 [funcaocontacto] [varchar](15) NOT NULL,
17 [email] [varchar](45) NOT NULL,
18 [nacionalidade] [int] NOT NULL,
19 [telemovel] [varchar](45) NOT NULL,
20 [saldo] [numeric](19, 6) NOT NULL,
21 [plafond] [numeric](19, 6) NOT NULL,
22 [classe] [int] NOT NULL,
23 [data_criacao] [date] NOT NULL,
24 [data_ult_gravacao] [date] NOT NULL,
25)
26ELSE
27 TRUNCATE TABLE fornecedor_maisSom
28
29IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'familias_maisSom')
30CREATE TABLE [dbo].[familias_maisSom](
31 [codigo] [int] IDENTITY(1,1) NOT NULL,
32 [nome] [varchar](60) NULL,
33 [data_criacao] [date] NOT NULL,
34 [data_ult_gravacao] [date] NOT NULL,
35)
36ELSE
37 TRUNCATE TABLE familias_maisSom
38
39IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'entidade_maisSom')
40CREATE TABLE [dbo].[entidade_maisSom](
41 [nome] [varchar](55) NOT NULL,
42 [numero] [numeric](10, 0) NOT NULL,
43 [ncontribuinte] [varchar](20) NOT NULL,
44 [morada] [varchar](50) NOT NULL,
45 [localidade] [varchar](43) NOT NULL,
46 [codpostal] [varchar](45) NOT NULL,
47 [telefone] [varchar](60) NOT NULL,
48 [fax] [varchar](60) NOT NULL,
49 [contacto] [varchar](40) NOT NULL,
50 [profissao] [varchar](20) NOT NULL,
51 [email] [varchar](45) NOT NULL,
52 [tlmvl] [varchar](45) NOT NULL,
53 [data_criacao] [datetime] NOT NULL,
54 [hora_criacao] [varchar](8) NOT NULL,
55 [dara_ult_gravacao] [datetime] NOT NULL,
56 [hora_ult_gravacao] [varchar](8) NOT NULL,
57 [nib] [varchar](28) NOT NULL,
58)
59
60ELSE
61 TRUNCATE TABLE entidade_maisSom
62
63IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'documentosfaturacaolinha_maisSom')
64CREATE TABLE [dbo].[documentosfaturacaolinha_maisSom](
65 [flstamp] [char](25) NOT NULL,
66 [ftstamp] [char](25) NOT NULL,
67 [anodocumento] [numeric](4, 0) NOT NULL,
68 [numerodocumento] [varchar](20) NOT NULL,
69 [datadocumento] [date] NOT NULL,
70 [lordem] [numeric](10, 0) NOT NULL,
71 [armazem] [numeric](5, 0) NOT NULL,
72 [centrocusto] [int] NOT NULL,
73 [produto] [char](18) NOT NULL,
74 [quantidade] [numeric](14, 4) NOT NULL,
75 [codigotaxaiva] [int] NOT NULL,
76 [precounitario] [numeric](19, 6) NOT NULL,
77 [valoriliquido] [numeric](19, 6) NOT NULL,
78 [valordesconto] [numeric](19, 6) NOT NULL,
79 [precocusto] [numeric](19, 2) NOT NULL,
80 [data_criacao] [date] NOT NULL,
81 [data_ult_gravacao] [date] NOT NULL,
82)
83
84ELSE
85 TRUNCATE TABLE documentosfaturacaolinha_maisSom
86
87IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'documentosfaturacao_maisSom')
88CREATE TABLE [dbo].[documentosfaturacao_maisSom](
89 [ftstamp] [char](25) NOT NULL,
90 [anodocumento] [numeric](4, 0) NOT NULL,
91 [numerodocumento] [numeric](10, 0) NOT NULL,
92 [datadocumento] [date] NOT NULL,
93 [cliente] [numeric](10, 0) NOT NULL,
94 [funcionario] [numeric](6, 0) NOT NULL,
95 [zona] [numeric](5, 0) NOT NULL,
96 [vendedor] [numeric](4, 0) NOT NULL,
97 [datapagamento] [date] NOT NULL,
98 [moeda] [int] NOT NULL,
99 [totaliliquidoprods] [numeric](19, 6) NOT NULL,
100 [totaldesconto] [numeric](19, 6) NOT NULL,
101 [totalfrete] [numeric](19, 6) NOT NULL,
102 [totalbaseincidenciaiva] [numeric](19, 6) NOT NULL,
103 [totaliva] [numeric](19, 6) NOT NULL,
104 [valortotalfinal] [numeric](19, 6) NOT NULL,
105 [precocustototal] [numeric](19, 6) NOT NULL,
106 [data_criacao] [date] NOT NULL,
107 [data_ult_gravacao] [date] NOT NULL,
108)
109ELSE
110 TRUNCATE TABLE documentosfaturacao_maisSom
111
112IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'departamento_maisSom')
113CREATE TABLE [dbo].[departamento_maisSom](
114 [codigo] [int] IDENTITY(1,1) NOT NULL,
115 [departamento] [nvarchar](20) NOT NULL,
116)
117ELSE
118 TRUNCATE TABLE departamento_maisSom
119
120IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'cliente_maisSom')
121
122CREATE TABLE [dbo].[cliente_maisSom](
123 [nome] [varchar](55) NOT NULL,
124 [numero] [numeric](10, 0) NOT NULL,
125 [ncontribuinte] [varchar](20) NOT NULL,
126 [saldo] [numeric](19, 6) NOT NULL,
127 [fax] [varchar](60) NOT NULL,
128 [telefone] [varchar](60) NOT NULL,
129 [contacto] [varchar](30) NOT NULL,
130 [morada] [varchar](55) NOT NULL,
131 [lugar] [varchar](43) NOT NULL,
132 [codpostal] [varchar](10) NOT NULL,
133 [localidade] [varchar](33) NULL,
134 [zona] [numeric](5, 0) NULL,
135 [tipocliente] [int] NOT NULL,
136 [vendedor] [numeric](4, 0) NOT NULL,
137 [vencimento] [numeric](3, 0) NOT NULL,
138 [plafond] [numeric](19, 6) NOT NULL,
139 [nib] [varchar](28) NOT NULL,
140 [tiposegmento] [int] NOT NULL,
141 [email] [varchar](45) NOT NULL,
142 [centrocusto] [int] NOT NULL,
143 [tlmvl] [varchar](45) NOT NULL,
144 [data_criacao] [date] NOT NULL,
145 [data_ult_gravacao] [date] NOT NULL,
146)
147ELSE
148 TRUNCATE TABLE cliente_maisSom
149
150IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'classificacao_maisSom')
151CREATE TABLE [dbo].[classificacao_maisSom](
152 [codigo] [int] IDENTITY(1,1) NOT NULL,
153 [classificacao] [nvarchar](20) NOT NULL,
154)
155ELSE
156 TRUNCATE TABLE classificacao_maisSom
157
158IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'classesfornecedor_maisSom')
159CREATE TABLE [dbo].[classesfornecedor_maisSom](
160 [codigo] [int] IDENTITY(1,1) NOT NULL,
161 [classe] [nvarchar](25) NOT NULL,
162)
163ELSE
164 TRUNCATE TABLE classesfornecedor_maisSom
165
166IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'centrocusto_maisSom')
167CREATE TABLE [dbo].[centrocusto_maisSom](
168 [codigo] [int] IDENTITY(1,1) NOT NULL,
169 [centrocusto] [nvarchar](10) NOT NULL,
170)
171ELSE
172 TRUNCATE TABLE centrocusto_maisSom
173
174IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'categoria_maisSom')
175CREATE TABLE [dbo].[categoria_maisSom](
176 [Codigo] [int] IDENTITY(1,1) NOT NULL,
177 [Categoria] [varchar](35) NULL,
178)
179ELSE
180 TRUNCATE TABLE categoria_maisSom
181
182IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'armazem_maisSom')
183CREATE TABLE [dbo].[armazem_maisSom](
184 [codigo] [numeric](5, 0) NOT NULL,
185 [armazem] [varchar](50) NULL,
186)
187ELSE
188 TRUNCATE TABLE armazem_maisSom
189
190IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'zona_maisSom')
191CREATE TABLE [dbo].[zona_maisSom](
192 [codigo] [numeric](5, 0) NOT NULL,
193 [zona] [varchar](50) NULL,
194)
195ELSE
196 TRUNCATE TABLE zona_maisSom
197
198IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'vendedor_maisSom')
199CREATE TABLE [dbo].[vendedor_maisSom](
200 [vendedor] [varchar](20) NOT NULL,
201 [codigo] [numeric](4, 0) NOT NULL,
202 [nome] [varchar](40) NOT NULL,
203 [morada] [varchar](40) NOT NULL,
204 [codpost] [varchar](10) NOT NULL,
205 [local] [varchar](33) NOT NULL,
206 [telefone] [varchar](60) NOT NULL,
207 [email] [varchar](45) NOT NULL,
208 [data_criacao] [date] NOT NULL,
209 [data_ult_gravacao] [date] NOT NULL,
210)
211ELSE
212 TRUNCATE TABLE vendedor_maisSom
213
214IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'tipocliente_maisSom')
215CREATE TABLE [dbo].[tipocliente_maisSom](
216 [Codigo] [int] IDENTITY(1,1) NOT NULL,
217 [TipoCliente] [nchar](20) NOT NULL,
218)
219ELSE
220 TRUNCATE TABLE tipocliente_maisSom
221
222IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'taxasiva_maisSom')
223CREATE TABLE [dbo].[taxasiva_maisSom](
224 [Codigo] [int] IDENTITY(1,1) NOT NULL,
225 [TaxaIva] [numeric](4, 2) NOT NULL,
226)
227ELSE
228 TRUNCATE TABLE taxasiva_maisSom
229
230IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'produto_maisSom')
231CREATE TABLE [dbo].[produto_maisSom](
232 [referencia] [char](18) NOT NULL,
233 [designacao] [char](60) NOT NULL,
234 [familia] [int] NOT NULL,
235 [stock] [numeric](13, 3) NOT NULL,
236 [precovenda] [numeric](19, 6) NOT NULL,
237 [pontoencomenda] [numeric](10, 3) NOT NULL,
238 [fornecedor] [numeric](10, 0) NOT NULL,
239 [stockminimo] [numeric](13, 3) NOT NULL,
240 [dataabertura] [date] NOT NULL,
241 [categoria] [int] NOT NULL,
242 [classificacao] [int] NOT NULL,
243 [precocusto] [numeric](19, 6) NOT NULL,
244 [quantidadecativa] [numeric](13, 3) NOT NULL,
245 [taxaiva] [numeric](2, 0) NOT NULL,
246 [data_criacao] [date] NOT NULL,
247 [data_ult_gravacao] [date] NOT NULL,
248)
249ELSE
250 TRUNCATE TABLE produto_maisSom
251
252IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'nacionalidade_maisSom')
253CREATE TABLE [dbo].[nacionalidade_maisSom](
254 [codigo] [int] IDENTITY(1,1) NOT NULL,
255 [nacionalidade] [nvarchar](20) NOT NULL,
256)
257ELSE
258 TRUNCATE TABLE nacionalidade_maisSom
259
260IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'moeda_maisSom')
261CREATE TABLE [dbo].[moeda_maisSom](
262 [codigo] [int] IDENTITY(1,1) NOT NULL,
263 [moeda] [nchar](20) NOT NULL,
264)
265ELSE
266 TRUNCATE TABLE moeda_maisSom
267
268IF NOT EXISTS (SELECT name FROM sys.tables WHERE name = 'funcionario_maisSom')
269CREATE TABLE [dbo].[funcionario_maisSom](
270 [numero] [numeric](6, 0) NOT NULL,
271 [iniciais] [varchar](3) NOT NULL,
272 [codigo] [varchar](20) NOT NULL,
273 [nome_proprio] [nvarchar](20) NOT NULL,
274 [apelido] [nvarchar](20) NOT NULL,
275 [grupo] [varchar](20) NOT NULL,
276 [departamento] [int] NOT NULL,
277 [email] [varchar](100) NOT NULL,
278 [chefe] [numeric](6, 0) NULL,
279 [data_criacao] [date] NOT NULL,
280 [data_ult_gravacao] [date] NOT NULL,
281)
282ELSE
283 TRUNCATE TABLE funcionario_maisSom