Im using cake with mssql, im not a mssql fan and took me a while to figure out the right sintax for the table creation, so im posting it with the hope that could be useful for somebody else.
$sql = "CREATE TABLE [prospectzone] ( [id] Integer Identity(0,1) NOT NULL, [first_name] Varchar(75) NOT NULL , [last_name] Varchar(55) NOT NULL , [contact_time] Varchar(55) NULL , [email]Varchar(100) NOT NULL , [phone]Varchar(50) NOT NULL, [phone2]Varchar(50) NULL, [address_1_city] Varchar(55) NOT NULL , [address_1_state] Varchar(55) NOT NULL , [address_1_street1] Varchar(225) NOT NULL , [address_1_street2] Varchar(225) NULL , [address_1_zip] Varchar(25) NOT NULL , [insured_1_dobMM] Varchar(10) NOT NULL , [insured_1_dobDD] Varchar(10) NOT NULL , [insured_1_dobYYYY] Varchar(15) NOT NULL , [insured_1_gender] Varchar(10) NOT NULL , [insured_1_heightFT] Varchar(10) NOT NULL , [insured_1_heightIN] Varchar(10) NOT NULL , [insured_1_health_conditions_detail] Varchar(250) NOT NULL , [insured_1_current_medications_detail] Varchar(250) NOT NULL , [insured_1_smoker] Varchar(15) NOT NULL , [insured_1_weight] Varchar(15) NOT NULL , [ip_address] Varchar(40) NOT NULL , [question_felony] Varchar(50) NOT NULL , [question_hazardous_occupation] Varchar(30) NOT NULL , [question_licensed_pilot] Varchar(30) NOT NULL , [question_dui] Varchar(30) NOT NULL , [insured_1_tobacco_use] Varchar(30) NOT NULL , [insured_1_coverage_amount] Varchar(15)NOT NULL , [insured_1_term_length] Varchar(18) NOT NULL , [insured_1_health_class] Varchar(35) NOT NULL , [datatime_post] datetime NOT NULL, [response] Varchar(245) NULL , [callrep] Varchar(24) NULL , [screener] Varchar(24) NULL , [processor]Varchar(24) NULL , [leadid]Varchar(25) NULL , [healthclasi]Varchar(75) NULL , [typeinsur]Varchar(245) NULL , [hhincome]Varchar(50) NULL , [smokefreq]Varchar(50) NULL , [smokebrand]Varchar(50) NULL , [insured_1_health_conditions_detail_other]Varchar(50) NULL , [healthfamiliyhis]Varchar(245) NULL , [healthfamiliyhis_other]Varchar(245) NULL , [homeowner]Varchar(24) NULL , [freequote]Varchar(24) NULL , [haveten]Varchar(24) NULL , [wantquote]Varchar(24) NULL , Primary Key ([id]) )"; CREATE TABLE [groups] ( [id] Integer Identity(0,1) NOT NULL, [name] Varchar(50) NOT NULL , [created] datetime NOT NULL default '0000-00-00 00:00:00', [modified] datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ([id]) ); CREATE TABLE [groups_permissions] ( [group_id] int NOT NULL default '0', [permission_id] int NOT NULL default '0' ); CREATE INDEX group_id ON groups_permissions (group_id,permission_id); CREATE TABLE [permissions] ( [id] Integer Identity(0,1) NOT NULL, [name] Varchar(50) NOT NULL , [created] datetime NOT NULL default '0000-00-00 00:00:00', [modified] datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ([id]) ); CREATE INDEX name ON permissions (name); CREATE TABLE [users] ( [id] Integer Identity(0,1) NOT NULL, [username] varchar(50) NOT NULL default '', [password] varchar(32) NOT NULL default '', [name] varchar(50) NOT NULL default '', [email] varchar(100) NOT NULL default '', [last_visit] datetime NOT NULL default '0000-00-00 00:00:00', [group_id] int NOT NULL default '0', [active] int NOT NULL default '0', [created] datetime NOT NULL default '0000-00-00 00:00:00', [modified] datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ([id]) ); CREATE INDEX group_id ON users (group_id); CREATE UNIQUE INDEX username ON users (username); CREATE UNIQUE INDEX email ON users (email,username); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---