Файл: pay/nextpay_sms.sql
Строк: 20
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[nextpay_sms]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[nextpay_sms]
GO
CREATE TABLE [dbo].[nextpay_sms]
(
[id] [varchar] (255) COLLATE Cyrillic_General_CI_AS NOT NULL
,
[date_created] [datetime] NOT NULL ,
[amount_usd] [float] NOT NULL
,
[number] [varchar] (255) COLLATE Cyrillic_General_CI_AS NOT NULL
,
[text] [text] COLLATE Cyrillic_General_CI_AS NOT NULL ,
[prefix]
[varchar] (255) COLLATE Cyrillic_General_CI_AS NOT NULL ,
[hash] [varchar]
(255) COLLATE Cyrillic_General_CI_AS NOT NULL ,
[country] [varchar] (255)
COLLATE Cyrillic_General_CI_AS NOT NULL ,
[op] [varchar] (255) COLLATE
Cyrillic_General_CI_AS NOT NULL ,
[sms_date] [varchar] (255) COLLATE
Cyrillic_General_CI_AS NOT NULL ,
[amount] [float] NOT NULL ,
[phone]
[varchar] (255) COLLATE Cyrillic_General_CI_AS NOT NULL ,
[last_modified]
[datetime] NOT NULL ,
[status] [int] NOT NULL ,
[eup] [float] NULL
) ON
[PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO