Hi all,
I am doing a tutorial to make a shopping cart. I need to make a mysql db or
convert an sql db to mysql.
Can anyone give me any pointers as to how to make the following tables?
The Microsoft SQL Server 2000 creation script is below the tables. Thanks a
lot for any pointers to get me started off- I will use php admin to make the
table
Categories:
int_CategoryID int IDENTITY
txt_Category nvarchar(100)
bit_Active bit
Clients:
int_ClientID int IDENTITY
txt_ClientName nvarchar(100)
txt_ClientEmail ntext(16)
txt_Username nvarchar(30)
txt_Password nvarchar(30)
bit_Active bit
int_CFID int
txt_CFTOKEN nvarchar(100)
Products:
int_ProductID int IDENTITY
txt_ProductTitle nvarchar(100)
txt_ProductDescription ntext(16)
flt_ProductPrice float
bit_Active bit
int_CategoryID int
PurchasedProducts:
int_saleCart int IDENTITY
int_ClientID int
int_ProductID int
int_Quantity int
WebCart:
int_CartID int IDENTITY
int_ProductID int
int_Quantity int
int_ClientID int
Microsoft SQL Server 2000 creation scripts:
<!----- SQL Create Script Begins ------>
if exists (select * from sysobjects where id =
object_id(N'[dbo].[Categories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Categories]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[Clients]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Clients]
GO
if exists (select * from sysobjects where id =
object_id(N'[dbo].[Products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Products]
GO
if exists (select * from sysobjects where id =
object_id(N'[dbo].[PurchasedProducts]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[PurchasedProducts]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[WebCart]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WebCart]
GO
CREATE TABLE [dbo].[Categories] (
[int_CategoryID] [int] IDENTITY (1, 1) NOT NULL ,
[txt_Category] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bit_Active] [bit] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Clients] (
[int_ClientID] [int] IDENTITY (1, 1) NOT NULL ,
[txt_ClientName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[txt_ClientEmail] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[txt_Username] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[txt_Password] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[bit_Active] [bit] NULL ,
[int_CFID] [int] NULL ,
[txt_CFTOKEN] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[Products] (
[int_ProductID] [int] IDENTITY (1, 1) NOT NULL ,
[txt_ProductTitle] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[txt_ProductDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[flt_ProductPrice] [float] NULL ,
[bit_Active] [bit] NULL ,
[int_CategoryID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[PurchasedProducts] (
[int_saleCart] [int] IDENTITY (1, 1) NOT NULL ,
[int_ClientID] [int] NULL ,
[int_ProductID] [int] NULL ,
[int_Quantity] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[WebCart] (
[int_CartID] [int] IDENTITY (1, 1) NOT NULL ,
[int_ProductID] [int] NULL ,
[int_Quantity] [int] NULL ,
[int_ClientID] [int] NULL
) ON [PRIMARY]
GO
<!------- SQL Create Script Ends -------->
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
