code_junkie

How do you structure config data in a database?

Nov 11th, 2011
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. CREATE TABLE [dbo].[MyOption] (
  2. [GUID] uniqueidentifier CONSTRAINT [dfMyOptions_GUID] DEFAULT newsequentialid() ROWGUIDCOL NOT NULL,
  3. [Logo] varbinary(max) NULL,
  4. [X] char(1) CONSTRAINT [dfMyOptions_X] DEFAULT 'X' NOT NULL,
  5. CONSTRAINT [MyOptions_pk] PRIMARY KEY CLUSTERED ([GUID]),
  6. CONSTRAINT [MyOptions_ck] CHECK ([X]='X')
  7. )
Add Comment
Please, Sign In to add comment