001_LogStore.sql 481 B

1234567891011121314151617
  1. BEGIN TRANSACTION
  2. CREATE TABLE [logs] (
  3. [logID] [int] NOT NULL,
  4. [target] [varchar](36) default NULL,
  5. [server] [varchar](64) default NULL,
  6. [method] [varchar](64) default NULL,
  7. [arguments] [varchar](255) default NULL,
  8. [priority] [int] default NULL,
  9. [message] [ntext],
  10. PRIMARY KEY CLUSTERED
  11. (
  12. [logID] ASC
  13. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  14. ) ON [PRIMARY]
  15. COMMIT