00001: CREATE TABLE [dbo].[SY_MG_Debug] (
00002:     [ID] [int] NOT NULL ,
00003:     [RecipientType] [bit] NULL ,
00004:     [RecipientID] [int] NULL ,
00005:     [Code] [int] NULL ,
00006:     [Текст сообщения] [nvarchar] (3500) COLLATE Cyrillic_General_CI_AS NULL ,
00007:     [Заказ] [int] NULL ,
00008:     [К сообщению] [int] NULL ,
00009:     [Уведомление о получении] [bit] NULL ,
00010:     [Уведомление об исполнении] [bit] NULL ,
00011:     [Задача] [bit] NULL ,
00012:     [SenderID] [int] NULL ,
00013:     [Комп Отправителя] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00014:     [Дата] [datetime] NULL ,
00015:     [Время всплытия] [int] NULL ,
00016:     [Priority] [int] NULL ,
00017:     [Дата получения] [datetime] NULL ,
00018:     [Требуется уведомление] [bit] NULL ,
00019:     [Требуется подтверждение] [bit] NULL ,
00020:     [Требуется исполнение] [bit] NULL ,
00021:     [Комп Получателя] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00022:     [Дата исполнения] [datetime] NULL ,
00023:     [Комп исполнения] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00024:     [LiveType] [int] NULL ,
00025:     [Время жизни] [int] NULL ,
00026:     [Прилагается файл] [nvarchar] (256) COLLATE Cyrillic_General_CI_AS NULL ,
00027:     [FileContent] [ntext] COLLATE Cyrillic_General_CI_AS NULL ,
00028:     [Получатель] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00029:     [SenderUser_sName] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NULL ,
00030:     [SenderUser_FullName] [nvarchar] (250) COLLATE Cyrillic_General_CI_AS NULL ,
00031:     [Отправитель] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00032:     [RecipientUser_Name] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NULL ,
00033:     [RecipientUser_FullName] [nvarchar] (250) COLLATE Cyrillic_General_CI_AS NULL ,
00034:     [Приоритет] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00035:     [Срок жизни] [nvarchar] (3) COLLATE Cyrillic_General_CI_AS NULL ,
00036:     [Дата удаления] [datetime] NULL 
00037: ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
00038: GO
00039: 
00040: CREATE TABLE [dbo].[SY_MG_LiveTimeType] (
00041:     [sID] [int] NOT NULL ,
00042:     [sName] [nvarchar] (5) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00043:     [IsNothing] [bit] NOT NULL ,
00044:     [IsDay] [bit] NOT NULL ,
00045:     [IsMinute] [bit] NOT NULL ,
00046:     [IsSeans] [bit] NOT NULL 
00047: ) ON [PRIMARY]
00048: GO
00049: 
00050: CREATE TABLE [dbo].[SY_MG_Log] (
00051:     [ID] [int] IDENTITY (1, 1) NOT NULL ,
00052:     [RecipientType] [bit] NULL ,
00053:     [RecipientID] [int] NULL ,
00054:     [Code] [int] NULL ,
00055:     [Text] [nvarchar] (3500) COLLATE Cyrillic_General_CI_AS NULL ,
00056:     [ToOrder] [int] NULL ,
00057:     [ToMsg] [int] NULL ,
00058:     [SenderID] [int] NULL ,
00059:     [SenderComp] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00060:     [SenderDate] [datetime] NULL ,
00061:     [PopUpDelay] [int] NULL ,
00062:     [Priority] [int] NULL ,
00063:     [IsJob] [bit] NULL ,
00064:     [ReadNotif] [bit] NULL ,
00065:     [JobCompleteNotif] [bit] NULL ,
00066:     [ConfirmNeeded] [bit] NULL ,
00067:     [ReadDate] [datetime] NULL ,
00068:     [ReadComp] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00069:     [JobComleteDate] [datetime] NULL ,
00070:     [JobComleteComp] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00071:     [LiveType] [int] NULL ,
00072:     [LiveTime] [int] NULL ,
00073:     [sFilename] [nvarchar] (256) COLLATE Cyrillic_General_CI_AS NULL ,
00074:     [FileContent] [ntext] COLLATE Cyrillic_General_CI_AS NULL ,
00075:     [IsConfirm] [bit] NULL ,
00076:     [IsConfirmJob] [bit] NULL ,
00077:     [DeleteTime] [datetime] NULL 
00078: ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
00079: GO
00080: 
00081: CREATE TABLE [dbo].[SY_MG_Priority] (
00082:     [sID] [int] IDENTITY (1, 1) NOT NULL ,
00083:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL 
00084: ) ON [PRIMARY]
00085: GO
00086: 
00087: CREATE TABLE [dbo].[SY_MG_Profile] (
00088:     [sID] [int] IDENTITY (1, 1) NOT NULL ,
00089:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
00090:     [CurrentUser] [smallint] NOT NULL ,
00091:     [Priority] [int] NOT NULL ,
00092:     [LiveTime] [int] NULL ,
00093:     [LiveTimeType] [int] NOT NULL ,
00094:     [PopUP] [int] NULL ,
00095:     [IsTask] [bit] NULL ,
00096:     [IsTaskReplay] [bit] NULL ,
00097:     [IsAccept] [bit] NULL ,
00098:     [IsConfirm] [bit] NULL 
00099: ) ON [PRIMARY]
00100: GO
00101: 
00102: CREATE TABLE [dbo].[SY_MG_ST_AdmForm0] (
00103:     [id] [smallint] NOT NULL ,
00104:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00105:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00106:     [OrdinalNo] [int] NOT NULL ,
00107:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00108:     [TabIndex] [int] NOT NULL ,
00109:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00110:     [Width] [int] NOT NULL ,
00111:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00112:     [IsID] [bit] NOT NULL ,
00113:     [HeaderAlignment] [int] NOT NULL ,
00114:     [DataAlignment] [int] NOT NULL ,
00115:     [EditType] [int] NOT NULL ,
00116:     [MinWidth] [int] NOT NULL ,
00117:     [MinValue] [int] NOT NULL ,
00118:     [MaxValue] [int] NOT NULL ,
00119:     [DecimalPlaces] [int] NOT NULL 
00120: ) ON [PRIMARY]
00121: GO
00122: 
00123: CREATE TABLE [dbo].[SY_MG_ST_AdmForm1] (
00124:     [id] [smallint] NOT NULL ,
00125:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00126:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00127:     [OrdinalNo] [int] NOT NULL ,
00128:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00129:     [TabIndex] [int] NOT NULL ,
00130:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00131:     [Width] [int] NOT NULL ,
00132:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00133:     [IsID] [bit] NOT NULL ,
00134:     [HeaderAlignment] [int] NOT NULL ,
00135:     [DataAlignment] [int] NOT NULL ,
00136:     [EditType] [int] NOT NULL ,
00137:     [MinWidth] [int] NOT NULL ,
00138:     [MinValue] [int] NOT NULL ,
00139:     [MaxValue] [int] NOT NULL ,
00140:     [DecimalPlaces] [int] NOT NULL 
00141: ) ON [PRIMARY]
00142: GO
00143: 
00144: CREATE TABLE [dbo].[SY_MG_ST_AdmForm2] (
00145:     [id] [smallint] NOT NULL ,
00146:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00147:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00148:     [OrdinalNo] [int] NOT NULL ,
00149:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00150:     [TabIndex] [int] NOT NULL ,
00151:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00152:     [Width] [int] NOT NULL ,
00153:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00154:     [IsID] [bit] NOT NULL ,
00155:     [HeaderAlignment] [int] NOT NULL ,
00156:     [DataAlignment] [int] NOT NULL ,
00157:     [EditType] [int] NOT NULL ,
00158:     [MinWidth] [int] NOT NULL ,
00159:     [MinValue] [int] NOT NULL ,
00160:     [MaxValue] [int] NOT NULL ,
00161:     [DecimalPlaces] [int] NOT NULL 
00162: ) ON [PRIMARY]
00163: GO
00164: 
00165: CREATE TABLE [dbo].[SY_MG_ST_AdmForm3] (
00166:     [id] [smallint] NOT NULL ,
00167:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00168:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00169:     [OrdinalNo] [int] NOT NULL ,
00170:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00171:     [TabIndex] [int] NOT NULL ,
00172:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00173:     [Width] [int] NOT NULL ,
00174:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00175:     [IsID] [bit] NOT NULL ,
00176:     [HeaderAlignment] [int] NOT NULL ,
00177:     [DataAlignment] [int] NOT NULL ,
00178:     [EditType] [int] NOT NULL ,
00179:     [MinWidth] [int] NOT NULL ,
00180:     [MinValue] [int] NOT NULL ,
00181:     [MaxValue] [int] NOT NULL ,
00182:     [DecimalPlaces] [int] NOT NULL 
00183: ) ON [PRIMARY]
00184: GO
00185: 
00186: CREATE TABLE [dbo].[SY_MG_ST_AdmForm4] (
00187:     [id] [smallint] NOT NULL ,
00188:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00189:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00190:     [OrdinalNo] [int] NOT NULL ,
00191:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00192:     [TabIndex] [int] NOT NULL ,
00193:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00194:     [Width] [int] NOT NULL ,
00195:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00196:     [IsID] [bit] NOT NULL ,
00197:     [HeaderAlignment] [int] NOT NULL ,
00198:     [DataAlignment] [int] NOT NULL ,
00199:     [EditType] [int] NOT NULL ,
00200:     [MinWidth] [int] NOT NULL ,
00201:     [MinValue] [int] NOT NULL ,
00202:     [MaxValue] [int] NOT NULL ,
00203:     [DecimalPlaces] [int] NOT NULL 
00204: ) ON [PRIMARY]
00205: GO
00206: 
00207: CREATE TABLE [dbo].[SY_MG_ST_AdmForm5] (
00208:     [id] [smallint] NOT NULL ,
00209:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00210:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00211:     [OrdinalNo] [int] NOT NULL ,
00212:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00213:     [TabIndex] [int] NOT NULL ,
00214:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00215:     [Width] [int] NOT NULL ,
00216:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00217:     [IsID] [bit] NOT NULL ,
00218:     [HeaderAlignment] [int] NOT NULL ,
00219:     [DataAlignment] [int] NOT NULL ,
00220:     [EditType] [int] NOT NULL ,
00221:     [MinWidth] [int] NOT NULL ,
00222:     [MinValue] [int] NOT NULL ,
00223:     [MaxValue] [int] NOT NULL ,
00224:     [DecimalPlaces] [int] NOT NULL 
00225: ) ON [PRIMARY]
00226: GO
00227: 
00228: CREATE TABLE [dbo].[SY_MG_ST_NewForm] (
00229:     [id] [smallint] NOT NULL ,
00230:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00231:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00232:     [OrdinalNo] [int] NOT NULL ,
00233:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00234:     [TabIndex] [int] NOT NULL ,
00235:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00236:     [Width] [int] NOT NULL ,
00237:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00238:     [IsID] [bit] NOT NULL ,
00239:     [HeaderAlignment] [int] NOT NULL ,
00240:     [DataAlignment] [int] NOT NULL ,
00241:     [EditType] [int] NOT NULL ,
00242:     [MinWidth] [int] NOT NULL ,
00243:     [MinValue] [int] NOT NULL ,
00244:     [MaxValue] [int] NOT NULL ,
00245:     [DecimalPlaces] [int] NOT NULL 
00246: ) ON [PRIMARY]
00247: GO
00248: 
00249: CREATE TABLE [dbo].[SY_MG_ST_User] (
00250:     [id] [smallint] NOT NULL ,
00251:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00252:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00253:     [OrdinalNo] [int] NOT NULL ,
00254:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00255:     [TabIndex] [int] NOT NULL ,
00256:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00257:     [Width] [int] NOT NULL ,
00258:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00259:     [IsID] [bit] NOT NULL ,
00260:     [HeaderAlignment] [int] NOT NULL ,
00261:     [DataAlignment] [int] NOT NULL ,
00262:     [EditType] [int] NOT NULL ,
00263:     [MinWidth] [int] NOT NULL ,
00264:     [MinValue] [int] NOT NULL ,
00265:     [MaxValue] [int] NOT NULL ,
00266:     [DecimalPlaces] [int] NOT NULL 
00267: ) ON [PRIMARY]
00268: GO
00269: 
00270: CREATE TABLE [dbo].[SY_MG_ST_User1] (
00271:     [id] [smallint] NOT NULL ,
00272:     [RsFieldsName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00273:     [ColumnTag] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00274:     [OrdinalNo] [int] NOT NULL ,
00275:     [IsLoadForSortingToCombobox] [bit] NOT NULL ,
00276:     [TabIndex] [int] NOT NULL ,
00277:     [Code] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00278:     [Width] [int] NOT NULL ,
00279:     [sName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
00280:     [IsID] [bit] NOT NULL ,
00281:     [HeaderAlignment] [int] NOT NULL ,
00282:     [DataAlignment] [int] NOT NULL ,
00283:     [EditType] [int] NOT NULL ,
00284:     [MinWidth] [int] NOT NULL ,
00285:     [MinValue] [int] NOT NULL ,
00286:     [MaxValue] [int] NOT NULL ,
00287:     [DecimalPlaces] [int] NOT NULL 
00288: ) ON [PRIMARY]
00289: GO

Comments ( )