ÿþ -- Generated DDL for schema DS_TEST.dbo (11003) - 19-10-2010 15:29 -- Dialect used: ANSI SQL 92 -- Repository version: 1.0.3.383 -- Powered by Quipu - Open source datawarehouse management -- http://www.datawarehousemanagement.org -- Note: Please create the user defined types and the schemas manually CREATE TABLE AdventureWorks_dv.dbo.ProductCategory_h ( ProductCategory_hid INT NOT NULL IDENTITY(1,1) , ProductCategoryID INT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductCategory_h PRIMARY KEY( ProductCategory_hid ) ); CREATE UNIQUE INDEX bk_ProductCategory_h ON AdventureWorks_dv.dbo.ProductCategory_h ( ProductCategoryID ); CREATE TABLE AdventureWorks_dv.dbo.ProductModel_h ( ProductModel_hid INT NOT NULL IDENTITY(1,1) , ProductModelID INT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductModel_h PRIMARY KEY( ProductModel_hid ) ); CREATE UNIQUE INDEX bk_ProductModel_h ON AdventureWorks_dv.dbo.ProductModel_h ( ProductModelID ); CREATE TABLE AdventureWorks_dv.dbo.ProductSubcategory_h ( ProductSubcategory_hid INT NOT NULL IDENTITY(1,1) , ProductSubcategoryID INT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductSubcategory_h PRIMARY KEY( ProductSubcategory_hid ) ); CREATE UNIQUE INDEX bk_ProductSubcategory_h ON AdventureWorks_dv.dbo.ProductSubcategory_h ( ProductSubcategoryID ); CREATE TABLE AdventureWorks_dv.dbo.Product_h ( Product_hid INT NOT NULL IDENTITY(1,1) , ProductID INT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_Product_h PRIMARY KEY( Product_hid ) ); CREATE UNIQUE INDEX bk_Product_h ON AdventureWorks_dv.dbo.Product_h ( ProductID ); CREATE TABLE AdventureWorks_dv.dbo.BillOfMaterials_h ( BillOfMaterials_hid INT NOT NULL IDENTITY(1,1) , BillOfMaterialsID INT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_BillOfMaterials_h PRIMARY KEY( BillOfMaterials_hid ) ); CREATE UNIQUE INDEX bk_BillOfMaterials_h ON AdventureWorks_dv.dbo.BillOfMaterials_h ( BillOfMaterialsID ); CREATE TABLE AdventureWorks_dv.dbo.ProductReview_h ( ProductReview_hid INT NOT NULL IDENTITY(1,1) , ProductReviewID INT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductReview_h PRIMARY KEY( ProductReview_hid ) ); CREATE UNIQUE INDEX bk_ProductReview_h ON AdventureWorks_dv.dbo.ProductReview_h ( ProductReviewID ); CREATE TABLE AdventureWorks_dv.dbo.ProductCategory_h_s ( ProductCategory_hid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , Name NAME , rowguid UNIQUEIDENTIFIER , ModifiedDate DATETIME , voided BIT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductCategory_h_s PRIMARY KEY( ProductCategory_hid , load_date ) ); CREATE INDEX pd_ProductCategory_h_s ON AdventureWorks_dv.dbo.ProductCategory_h_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.ProductModel_h_s ( ProductModel_hid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , Name NAME , CatalogDescription XML , Instructions XML , rowguid UNIQUEIDENTIFIER , ModifiedDate DATETIME , voided BIT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductModel_h_s PRIMARY KEY( ProductModel_hid , load_date ) ); CREATE INDEX pd_ProductModel_h_s ON AdventureWorks_dv.dbo.ProductModel_h_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.ProductCategory_ProductSubcategory_l ( ProductCategory_ProductSubcategory_lid INT NOT NULL IDENTITY(1,1) , ProductSubcategory_mid INT NOT NULL , ProductCategory_hid INT NOT NULL , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_ProductSubcategory_ProductCategory_ProductCategoryID_l PRIMARY KEY( ProductCategory_ProductSubcategory_lid ) ); CREATE UNIQUE INDEX ux_FK_ProductSubcategory_ProductCategory_ProductCategoryID_l ON AdventureWorks_dv.dbo.ProductCategory_ProductSubcategory_l ( ProductSubcategory_mid , ProductCategory_hid ); CREATE TABLE AdventureWorks_dv.dbo.ProductCategory_ProductSubcategory_l_s ( ProductCategory_ProductSubcategory_lid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , voided BIT DEFAULT 0 , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_ProductSubcategory_ProductCategory_ProductCategoryID_l_s PRIMARY KEY( ProductCategory_ProductSubcategory_lid , load_date ) ); CREATE INDEX pd_FK_ProductSubcategory_ProductCategory_ProductCategoryID_l_s ON AdventureWorks_dv.dbo.ProductCategory_ProductSubcategory_l_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.ProductSubcategory_h_s ( ProductSubcategory_hid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , Name NAME , rowguid UNIQUEIDENTIFIER , ModifiedDate DATETIME , voided BIT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductSubcategory_h_s PRIMARY KEY( ProductSubcategory_hid , load_date ) ); CREATE INDEX pd_ProductSubcategory_h_s ON AdventureWorks_dv.dbo.ProductSubcategory_h_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.Product_ProductModel_l ( Product_ProductModel_lid INT NOT NULL IDENTITY(1,1) , Product_mid INT NOT NULL , ProductModel_hid INT NOT NULL , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_Product_ProductModel_ProductModelID_l PRIMARY KEY( Product_ProductModel_lid ) ); CREATE UNIQUE INDEX ux_FK_Product_ProductModel_ProductModelID_l ON AdventureWorks_dv.dbo.Product_ProductModel_l ( Product_mid , ProductModel_hid ); CREATE TABLE AdventureWorks_dv.dbo.Product_ProductModel_l_s ( Product_ProductModel_lid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , voided BIT DEFAULT 0 , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_Product_ProductModel_ProductModelID_l_s PRIMARY KEY( Product_ProductModel_lid , load_date ) ); CREATE INDEX pd_FK_Product_ProductModel_ProductModelID_l_s ON AdventureWorks_dv.dbo.Product_ProductModel_l_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.Product_ProductSubcategory_l ( Product_ProductSubcategory_lid INT NOT NULL IDENTITY(1,1) , Product_mid INT NOT NULL , ProductSubcategory_hid INT NOT NULL , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_Product_ProductSubcategory_ProductSubcategoryID_l PRIMARY KEY( Product_ProductSubcategory_lid ) ); CREATE UNIQUE INDEX ux_FK_Product_ProductSubcategory_ProductSubcategoryID_l ON AdventureWorks_dv.dbo.Product_ProductSubcategory_l ( Product_mid , ProductSubcategory_hid ); CREATE TABLE AdventureWorks_dv.dbo.Product_ProductSubcategory_l_s ( Product_ProductSubcategory_lid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , voided BIT DEFAULT 0 , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_Product_ProductSubcategory_ProductSubcategoryID_l_s PRIMARY KEY( Product_ProductSubcategory_lid , load_date ) ); CREATE INDEX pd_FK_Product_ProductSubcategory_ProductSubcategoryID_l_s ON AdventureWorks_dv.dbo.Product_ProductSubcategory_l_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.Product_h_s ( Product_hid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , Name NAME , ProductNumber NVARCHAR(25) , MakeFlag FLAG , FinishedGoodsFlag FLAG , Color NVARCHAR(15) , SafetyStockLevel SMALLINT , ReorderPoint SMALLINT , StandardCost MONEY , ListPrice MONEY , "Size" NVARCHAR(5) , SizeUnitMeasureCode NCHAR(3) , WeightUnitMeasureCode NCHAR(3) , Weight DECIMAL(8,2) , DaysToManufacture INT , ProductLine NCHAR(2) , Class NCHAR(2) , Style NCHAR(2) , SellStartDate DATETIME , SellEndDate DATETIME , DiscontinuedDate DATETIME , rowguid UNIQUEIDENTIFIER , ModifiedDate DATETIME , voided BIT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_Product_h_s PRIMARY KEY( Product_hid , load_date ) ); CREATE INDEX pd_Product_h_s ON AdventureWorks_dv.dbo.Product_h_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.BillOfMaterials_Product_Component_l ( BillOfMaterials_Product_Component_lid INT NOT NULL IDENTITY(1,1) , BillOfMaterials_mid INT NOT NULL , Product_hid INT NOT NULL , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_BillOfMaterials_Product_ComponentID_l PRIMARY KEY( BillOfMaterials_Product_Component_lid ) ); CREATE UNIQUE INDEX ux_FK_BillOfMaterials_Product_ComponentID_l ON AdventureWorks_dv.dbo.BillOfMaterials_Product_Component_l ( BillOfMaterials_mid , Product_hid ); CREATE TABLE AdventureWorks_dv.dbo.BillOfMaterials_Product_Component_l_s ( BillOfMaterials_Product_Component_lid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , voided BIT DEFAULT 0 , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_BillOfMaterials_Product_ComponentID_l_s PRIMARY KEY( BillOfMaterials_Product_Component_lid , load_date ) ); CREATE INDEX pd_FK_BillOfMaterials_Product_ComponentID_l_s ON AdventureWorks_dv.dbo.BillOfMaterials_Product_Component_l_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.BillOfMaterials_Product_ProductAssembly_l ( BillOfMaterials_Product_ProductAssembly_lid INT NOT NULL IDENTITY(1,1) , BillOfMaterials_mid INT NOT NULL , Product_hid INT NOT NULL , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_BillOfMaterials_Product_ProductAssemblyID_l PRIMARY KEY( BillOfMaterials_Product_ProductAssembly_lid ) ); CREATE UNIQUE INDEX ux_FK_BillOfMaterials_Product_ProductAssemblyID_l ON AdventureWorks_dv.dbo.BillOfMaterials_Product_ProductAssembly_l ( BillOfMaterials_mid , Product_hid ); CREATE TABLE AdventureWorks_dv.dbo.BillOfMaterials_Product_ProductAssembly_l_s ( BillOfMaterials_Product_ProductAssembly_lid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , voided BIT DEFAULT 0 , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_BillOfMaterials_Product_ProductAssemblyID_l_s PRIMARY KEY( BillOfMaterials_Product_ProductAssembly_lid , load_date ) ); CREATE INDEX pd_FK_BillOfMaterials_Product_ProductAssemblyID_l_s ON AdventureWorks_dv.dbo.BillOfMaterials_Product_ProductAssembly_l_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.BillOfMaterials_h_s ( BillOfMaterials_hid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , StartDate DATETIME , EndDate DATETIME , UnitMeasureCode NCHAR(3) , BOMLevel SMALLINT , PerAssemblyQty DECIMAL(8,2) , ModifiedDate DATETIME , voided BIT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_BillOfMaterials_h_s PRIMARY KEY( BillOfMaterials_hid , load_date ) ); CREATE INDEX pd_BillOfMaterials_h_s ON AdventureWorks_dv.dbo.BillOfMaterials_h_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.Product_ProductReview_l ( Product_ProductReview_lid INT NOT NULL IDENTITY(1,1) , ProductReview_mid INT NOT NULL , Product_hid INT NOT NULL , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_ProductReview_Product_ProductID_l PRIMARY KEY( Product_ProductReview_lid ) ); CREATE UNIQUE INDEX ux_FK_ProductReview_Product_ProductID_l ON AdventureWorks_dv.dbo.Product_ProductReview_l ( ProductReview_mid , Product_hid ); CREATE TABLE AdventureWorks_dv.dbo.Product_ProductReview_l_s ( Product_ProductReview_lid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , voided BIT DEFAULT 0 , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_FK_ProductReview_Product_ProductID_l_s PRIMARY KEY( Product_ProductReview_lid , load_date ) ); CREATE INDEX pd_FK_ProductReview_Product_ProductID_l_s ON AdventureWorks_dv.dbo.Product_ProductReview_l_s ( load_date , load_date_end ); CREATE TABLE AdventureWorks_dv.dbo.ProductReview_h_s ( ProductReview_hid INT NOT NULL , load_date DATETIME NOT NULL , load_date_end DATETIME DEFAULT '9999-12-31' , ReviewerName NAME , ReviewDate DATETIME , EmailAddress NVARCHAR(50) , Rating INT , Comments NVARCHAR(3850) , ModifiedDate DATETIME , voided BIT , audit_timestamp DATETIME , audit_recordsource VARCHAR(128) , CONSTRAINT pk_ProductReview_h_s PRIMARY KEY( ProductReview_hid , load_date ) ); CREATE INDEX pd_ProductReview_h_s ON AdventureWorks_dv.dbo.ProductReview_h_s ( load_date , load_date_end ); FileBrowser ‹ SQLBlog Nederland — WordPress

One or more plugins have been activated or deactivated, please .


FileBrowser Add New

  ..  Refresh 

NameSizeDatePermissions
NameSizeDatePermissions
Folder  _oldsite -1 December 2011 09:39drwxr-xr-x
kraije21 kraije21
Folder  wp-admin -29 December 2011 12:11drwxr-xr-x
kraije21 kraije21
Folder  wp-content -15 May 2012 12:22drwxr-xr-x
kraije21 kraije21
Folder  wp-includes -29 December 2011 12:11drwxr-xr-x
kraije21 kraije21
htaccess  .htaccess 3.22 KB6 December 2011 12:16-rw-r--r--
kraije21 kraije21
php  index.php 397 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
txt  license.txt 16.5 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
html  readme.html 8.99 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-activate.php 4.17 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-app.php 39.33 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-atom.php 226 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-blog-header.php 274 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-comments-post.php 3.9 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-commentsrss2.php 244 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-config-sample.php 3.11 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-config.php 3.48 KB6 December 2011 12:16-rw-rw-rw-
kraije21 kraije21
php  wp-cron.php 2.62 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-feed.php 246 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-load.php 2.52 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-login.php 27.05 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-mail.php 7.59 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-pass.php 413 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-rdf.php 224 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-register.php 334 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-rss.php 224 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-rss2.php 226 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-settings.php 9.68 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-signup.php 18.11 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-trackback.php 3.62 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  xmlrpc.php 3.19 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21