Revision 4080
Added by daigle about 16 years ago
| xmltables-sqlserver.sql | ||
|---|---|---|
| 30 | 30 |
drop table [dbo].[harvest_site_schedule]; |
| 31 | 31 |
drop table [dbo].[harvest_log]; |
| 32 | 32 |
drop table [dbo].[harvest_detail_log]; |
| 33 |
drop table [dbo].[db_version]; |
|
| 33 | 34 |
|
| 34 | 35 |
/* |
| 35 | 36 |
* ACL -- table to store ACL for XML documents by principals |
| ... | ... | |
| 237 | 238 |
GO |
| 238 | 239 |
|
| 239 | 240 |
/* |
| 241 |
* db_version -- table to store the version history of this database |
|
| 242 |
*/ |
|
| 243 |
CREATE TABLE [dbo].[db_version] ( |
|
| 244 |
[db_version_id] [bigint] IDENTITY (1, 1) NOT NULL , |
|
| 245 |
[version] [varchar] (250) NOT NULL , |
|
| 246 |
[status] [int] NOT NULL , |
|
| 247 |
[date_created] [datetime] NULL |
|
| 248 |
) ON [PRIMARY] |
|
| 249 |
GO |
|
| 250 |
|
|
| 251 |
/* |
|
| 240 | 252 |
* Constraints and indexes |
| 241 | 253 |
*/ |
| 242 | 254 |
ALTER TABLE [dbo].[xml_catalog] WITH NOCHECK ADD |
| ... | ... | |
| 310 | 322 |
) ON [PRIMARY] |
| 311 | 323 |
GO |
| 312 | 324 |
|
| 325 |
ALTER TABLE [dbo].[db_version] WITH NOCHECK ADD |
|
| 326 |
CONSTRAINT [PK_db_version] PRIMARY KEY CLUSTERED |
|
| 327 |
( |
|
| 328 |
[db_version_id] |
|
| 329 |
) ON [PRIMARY] |
|
| 330 |
GO |
|
| 331 |
|
|
| 313 | 332 |
ALTER TABLE [dbo].[xml_access] WITH NOCHECK ADD |
| 314 | 333 |
CONSTRAINT [CK_xml_access] CHECK ([begin_time] < [end_time]) |
| 315 | 334 |
GO |
Also available in: Unified diff
Merge 1.9 changes into Head