Hello.
You might be interesting a bit about this: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html Ed wrote: > 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 --------> > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
