Creating the Required Tables Using SQL

 

Introduction.  We are developing this functioning web under fairly minimal assumptions.  For example, we are assuming that you do not have superuser sorts of capabilities on the host server.  This is the reason for using a tool like Homesite for development, some sort of FTP for uploading files and DSN-less connections.  We are also assuming that you are going to need to make use of SQL to create, update, and select from tables rather than using some sort of direct connection interface tool.  I prefer this approach because it is more minimalist and I think your learning is more complete.  You don't have some sort of overly developed IDE hiding all kinds of issues from you.

Now we are about to go through what may seem like a limitless number of ASP files just to create our tables with fields and keys.  After these ASPs have been executed once in your web they cannot be used again since the tables will have been created.

The Endless Code.  Since you have essentially seen all of this code when working with SQL Server databases you should copy each into a file.  All in all there are 16 tables to create.  Upload each of them and run them each once to create the tables.  After you have gotten through all of these ASPs you are very likely going to want to delete them from your web account, but definitely not from your client computer.  In fact, I would put them all in their own directory out of the way of your more often used code.

 

Table Name ASP File
Attributes CreateAttributes.asp
AttributesCategory CreateAttributesCategory.asp
Basket CreateBasket.asp
BasketItem CreateBasketItem.asp
Department CreateDepartment.asp
DepartmentProducts CreateDepartmentProducts.asp
FreeShip CreateFreeShip.asp
OrderData CreateOrderData.asp
OrderStatus CreateOrderStatus.asp
PaymentData CreatePaymentData.asp
ProductAttibute CreateProductAttribute.asp
Products CreateProducts.asp
RelatedProducts CreateRelatedProducts.asp
Shipping CreateShipping.asp
Shopper CreateShopper.asp
Tax CreateTax.asp

 

This is the code you should call CreateAttributes.asp and upload it to your cisdev account and run it once. 

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.Attribute (idAttribute int IDENTITY (1, 1) NOT NULL , " & _
"chrAttributeName varchar (255) NULL , idAttributeCategory int NULL ," & _
"CONSTRAINT PK___3__12 PRIMARY KEY CLUSTERED ( idAttribute ) )"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

Now you want to copy this code into the CreateAttributesCategory.asp and run it on your web.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.AttributeCategory (idAttributeCategory int IDENTITY (1, 1) NOT NULL ," & _ 
"chrCategoryName varchar (255) NULL , CONSTRAINT PK___5__12 PRIMARY KEY CLUSTERED ( idAttributeCategory ) )"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you want to call CreateBasket.asp and do the usual with it.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.Basket ( idBasket int IDENTITY (1, 1) NOT NULL ," & _
"intQuantity int NULL CONSTRAINT DF_Basket_intQuantity_1__13 DEFAULT (0)," & _
"idShopper int NULL ,intOrderPlaced int NULL CONSTRAINT DF_Basket_intOrderPlaced11__12 DEFAULT (0)," & _
"intSubTotal int NULL CONSTRAINT DF_Basket_intSubTotal_13__12 DEFAULT (0)," & _
"intTotal int NULL CONSTRAINT DF_Basket_intTotal_15__12 DEFAULT (0)," & _
"intShipping int NULL CONSTRAINT DF_Basket_intShipping_12__12 DEFAULT (0)," & _
"intTax int NULL CONSTRAINT DF_Basket_intTax_14__12 DEFAULT (0)," & _
"dtCreated datetime NULL CONSTRAINT DF_Basket_dtCreated_1__12 DEFAULT (getdate())," & _
"intFreeShipping int NULL CONSTRAINT DF_Basket_intFreeShipping1__13 DEFAULT (0)," & _
"CONSTRAINT PK___9__12 PRIMARY KEY CLUSTERED ( idBasket ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateBasketItem.asp

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.BasketItem ( idBasketItem int IDENTITY (1, 1) NOT NULL ," & _
"idProduct int NULL , intPrice int NULL , chrName varchar (255) NULL ," & _
"intQuantity int NULL CONSTRAINT DF_BasketItem_intQuantity1__12 DEFAULT (0)," & _
"idBasket int NULL , chrSize varchar (50) NULL , " & _
"chrColor varchar (50) NULL , CONSTRAINT PK___10__12 PRIMARY KEY CLUSTERED (idBasketItem))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateDepartment.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.Department ( idDepartment int IDENTITY (1, 1) NOT NULL ," & _
"chrDeptName varchar (255) NULL , txtDeptDesc text NULL ,chrDeptImage varchar (255) NULL ," & _
"CONSTRAINT PK___1__12 PRIMARY KEY CLUSTERED ( idDepartment))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateDepartmentProducts.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.DepartmentProducts (idDepartmentProduct int IDENTITY (1, 1) NOT NULL ," & _
"idDepartment int NULL , idProduct int NULL ," & _
"CONSTRAINT PK___6__12 PRIMARY KEY CLUSTERED ( idDepartmentProduct ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateFreeShip.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.FreeShip ( intFreeShip int IDENTITY (1, 1) NOT NULL ," & _
"dtStartDate datetime NULL CONSTRAINT DF_FreeShip_dtStartDate_3__10 DEFAULT ('1/1/1900')," & _
"dtEndDate datetime NULL CONSTRAINT DF_FreeShip_dtEndDate_2__10 DEFAULT ('1/1/1900')," & _
"CONSTRAINT PK_FreeShip_4__10 PRIMARY KEY CLUSTERED ( intFreeShip ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateOrderData.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
strSQLCreate = "CREATE TABLE dbo.OrderData (idOrder int IDENTITY (1, 1) NOT NULL ," & _
"idShopper int NULL ,chrShipFirstName varchar (50) NULL ,chrShipLastName varchar (50) NULL ," & _
"chrShipAddress varchar (150) NULL , chrShipCity varchar (150) NULL ,chrShipState varchar (50) NULL ," & _
"chrShipZipCode varchar (15) NULL ,chrShipPhone varchar (25) NULL , chrShipFax varchar (25) NULL ," & _
"chrShipEmail varchar (100) NULL ,chrBillFirstName varchar (50) NULL ,chrBillLastName varchar (50) NULL ," & _
"chrBillAddress varchar (150) NULL , chrBillCity varchar (100) NULL ,chrBillState varchar (50) NULL ," & _
"chrBillZipCode varchar (15) NULL ,chrBillPhone varchar (25) NULL ,chrBillFax varchar (25) NULL ," & _
"chrBillEmail varchar (100) NULL ," & _
"dtOrdered datetime NULL CONSTRAINT DF_OrderData_dtOrdered_12__12 DEFAULT (getdate())," & _
"chrShipProvince varchar (150) NULL ,chrShipCountry varchar (150) NULL , chrBillProvince varchar (150) NULL ," & _
"chrBillCountry varchar (150) NULL , idBasket int NULL ," & _
"intFreeShipping int NULL CONSTRAINT DF_OrderData_intFreeShipp1__13 DEFAULT (0)," & _
"CONSTRAINT PK___11__12 PRIMARY KEY CLUSTERED ( idOrder ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateOrderStatus.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.OrderStatus ( idOrderStatus int IDENTITY (1, 1) NOT NULL ," & _
"idOrder int NULL , idStage int NULL CONSTRAINT DF_OrderStatu_idStage_14__12 DEFAULT (0)," & _
"dtShipped datetime NULL , dtFulfilled datetime NULL , dtProcessed datetime NULL ," & _
"txtNotes text NULL , chrShippingNum varchar (30) NULL ," & _
"intProcessed int NULL CONSTRAINT DF_OrderStatu_intProcesse1__12 DEFAULT (0)," & _
"CONSTRAINT PK___13__12 PRIMARY KEY CLUSTERED ( idOrderStatus ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreatePaymentData.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.PaymentData ( idPayment int IDENTITY (1, 1) NOT NULL ," & _
"idOrder int NULL ," & _
"chrCardType varchar (50) NULL ," & _
"chrCardNumber varchar (30) NULL ," & _
"chrExpDate varchar (25) NULL ," & _
"chrCardName varchar (150) NULL ," & _
"CONSTRAINT PK___12__12 PRIMARY KEY CLUSTERED ( idPayment ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateProductAttribute.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.ProductAttribute ( idProductAttribute int IDENTITY (1, 1) NOT NULL ," & _
"idAttribute int NULL ," & _
"idProduct int NULL ," & _
"CONSTRAINT PK___4__12 PRIMARY KEY CLUSTERED ( idProductAttribute ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateProducts.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.Products ( idProduct int IDENTITY (1, 1) NOT NULL ," & _
"chrProductName varchar (255) NULL ," & _
"txtDescription text NULL ," & _
"chrProductImage varchar (255) NULL ," & _
"intPrice int NULL CONSTRAINT DF_Products_intPrice_3__12 DEFAULT (0)," & _
"dtSaleStart datetime NULL CONSTRAINT DF_Products_dtSaleStart_2__12 DEFAULT ('1 / 1 / 80')," & _
"dtSaleEnd datetime NULL CONSTRAINT DF_Products_dtSaleEnd_1__12 DEFAULT ('1 / 1 / 80')," & _
"intSalePrice int NULL CONSTRAINT DF_Products_intSalePrice_4__12 DEFAULT (0)," & _
"intActive int NULL CONSTRAINT DF_Products_intActive_3__12 DEFAULT (0)," & _
"intFeatured tinyint NULL CONSTRAINT DF_Products_intFeatured_3__10 DEFAULT (0)," & _
"dtFeatureStart datetime NULL CONSTRAINT DF_Products_dtFeatureStar2__10 DEFAULT ('1/1/80')," & _
"dtFeatureEnd datetime NULL CONSTRAINT DF_Products_dtFeatureEnd_1__10 DEFAULT ('1/1/80')," & _
"CONSTRAINT PK___2__12 PRIMARY KEY CLUSTERED ( idProduct ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateRelatedProducts.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.RelatedProducts ( idRelatedProduct int IDENTITY (1, 1) NOT NULL ," & _
"idProductA int NULL CONSTRAINT DF_RelatedPro_idProductA_1__12 DEFAULT (0)," & _
"idProductB int NULL CONSTRAINT DF_RelatedPro_idProductB_2__12 DEFAULT (0)," & _
"idRelationType int NULL CONSTRAINT DF_RelatedPro_idRelationT3__12 DEFAULT (0)," & _
"CONSTRAINT PK___7__12 PRIMARY KEY CLUSTERED ( idRelatedProduct ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateShipping.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.Shipping ( idQuantityRange int IDENTITY (1, 1) NOT NULL ," & _
"intLowQuantity int NULL CONSTRAINT DF_Shipping_intLowQuantit3__12 DEFAULT (0)," & _
"intHighQuantity int NULL CONSTRAINT DF_Shipping_intHighQuanti2__12 DEFAULT (0)," & _
"intFee int NULL CONSTRAINT DF_Shipping_intFee_1__12 DEFAULT (0)," & _
"CONSTRAINT PK___14__12 PRIMARY KEY CLUSTERED ( idQuantityRange ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateShopper.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.Shopper ( idShopper int IDENTITY (1, 1) NOT NULL ," & _
"chrFirstName varchar (50) NULL ," & _
"chrLastName varchar (50) NULL ," & _
"chrAddress varchar (150) NULL ," & _
"chrCity varchar (100) NULL ," & _
"chrState varchar (2) NULL ," & _
"chrZipCode varchar (15) NULL ," & _
"chrPhone varchar (30) NULL ," & _
"chrFax varchar (30) NULL ," & _
"chrEmail varchar (150) NULL ," & _
"chrUserName varchar (25) NULL ," & _
"chrPassword varchar (25) NULL ," & _
"intCookie tinyint NULL CONSTRAINT DF_Shopper_intCookie_1__12 DEFAULT (0)," & _
"dtEntered datetime NULL CONSTRAINT DF_Shopper_dtEntered_1__12 DEFAULT (getdate())," & _
"chrProvince varchar (150) NULL ," & _
"chrCountry varchar (150) NULL ," & _
"CONSTRAINT PK___8__12 PRIMARY KEY CLUSTERED ( idShopper ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

 

The next set of code you should call CreateTax.asp.

<%@ Language=VBScript %>
<% Option Explicit %>
<!--#include File="adovbs.inc"-->

<%
' Open a connection to our SQL Server database
' We will use the ADO Driver connection
Dim connfoxFire, strSQLCreate
Set connfoxFire = Server.CreateObject("ADODB.Connection")
connfoxFire.ConnectionString="Driver={SQL Server}; Server=cisdev.quinnipiac.edu;" & _
"Database=YourUserName;UID=cis; PWD=csatqu"

connfoxFire.Open

' Creating the SQL String to create the table
 strSQLCreate = "CREATE TABLE dbo.Tax ( idState int IDENTITY (1, 1) NOT NULL ," & _
"chrState varchar (50) NULL ," & _
"fltTaxRate float NULL CONSTRAINT DF_Tax_fltTaxRate_1__13 DEFAULT (0)," & _
"CONSTRAINT PK___15__12 PRIMARY KEY CLUSTERED ( idState ))"

connfoxFire.execute(strSQLCreate)

connfoxFire.Close
Set connfoxFire = Nothing

Response.Write "<font size = 5>The SQL has executed</font>"

%>

 

Once you have uploaded each of these and executed them you can remove them from your web.