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 (
)
)
Link to this page:
//www.vb-net.com/wanted/message/Table.htm
|
|