| | |
|---|
| | | [sess_id] [varchar] (32) COLLATE Latin1_General_CI_AI NOT NULL ,
|
|---|
| | | [created] [datetime] NOT NULL ,
|
|---|
| | | [changed] [datetime] NULL ,
|
|---|
| | | [ip] [varchar] (15) COLLATE Latin1_General_CI_AI NOT NULL ,
|
|---|
| | | [ip] [varchar] (40) COLLATE Latin1_General_CI_AI NOT NULL ,
|
|---|
| | | [vars] [text] COLLATE Latin1_General_CI_AI NOT NULL
|
|---|
| | | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|---|
| | | GO
|
|---|
| | |
|---|
| | | CONSTRAINT [DF_session_ip] DEFAULT ('') FOR [ip]
|
|---|
| | | GO
|
|---|
| | |
|
|---|
| | | CREATE INDEX [IX_session_changed] ON [dbo].[session]([changed]) ON [PRIMARY]
|
|---|
| | | GO
|
|---|
| | |
|
|---|
| | | ALTER TABLE [dbo].[users] ADD
|
|---|
| | | CONSTRAINT [DF_users_username] DEFAULT ('') FOR [username],
|
|---|
| | | CONSTRAINT [DF_users_mail_host] DEFAULT ('') FOR [mail_host],
|
|---|
