Yes I have actually. The problem is that as soon as I delete the lib.model.schema.sql file and then run propel:build-sql it again creates a sql file as my OP shows based on the propel:build-schema schema.yml file.
On Tue, Feb 8, 2011 at 1:46 PM, Justen Doherty <[email protected]> wrote: > Hi Gareth, > > have you tried creating the table directly in the database then create > schema from db? > > On Tue, Feb 8, 2011 at 11:27 AM, Gareth McCumskey <[email protected]>wrote: > >> Hi all, >> >> I am trying to create a few tables with a column called id. I do not, >> however, want symfony to do its automated stuff on this column. I have >> created my schema as per below: >> >> live_signature_fields: >> id: { type: integer, required: true, primary: true, autoIncrement: >> false } >> field_name: { type: varchar, size: 50 } >> default_value: { type: varchar, size: 100} >> domain: { type: varchar, size: 100, default: 0 } >> order_value: { type: integer, required: true } >> field_type: { type: integer, default: 0 } >> created_at: ~ >> updated_at: ~ >> >> However, when I run propel:build-sql I get: >> >> DROP TABLE IF EXISTS `live_signature_fields`; >> >> >> CREATE TABLE `live_signature_fields` >> ( >> `id` INTEGER NOT NULL AUTO_INCREMENT, >> `field_name` VARCHAR(50), >> `default_value` VARCHAR(100), >> `domain` VARCHAR(100) default '0', >> `order_value` INTEGER NOT NULL, >> `field_type` INTEGER default 0, >> `created_at` DATETIME, >> `updated_at` DATETIME, >> PRIMARY KEY (`id`) >> )Type=InnoDB; >> >> For some reason, it is still creating the column as an auto increment. I >> have cleared cache, tried autoIncrement as autoincrement etc and nothing >> seems to actually make that column a non-autoincrement column. Lastly, this >> is symfony 1.1 as we have PHP version issues and so cannot use a more recent >> version of symfony. >> >> Any ideas? >> >> -- >> Gareth McCumskey >> http://garethmccumskey.blogspot.com >> twitter: @garethmcc >> identi.ca: @garethmcc >> >> -- >> If you want to report a vulnerability issue on symfony, please send it to >> security at symfony-project.com >> >> You received this message because you are subscribed to the Google >> Groups "symfony users" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/symfony-users?hl=en >> > > > > -- > ----------------------------------------------------------------- > http://www.linkedin.com/in/justendoherty - LinkedIn > http://www.twitter.com/phpchap - Twitter > http://www.anotherwebdeveloper.com - Portfolio > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc identi.ca: @garethmcc -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
