On 02/10/2012 10:04 PM, ITronic Harald Leithner wrote: > Hi, > > first there is an inconsistent in the create_table.sql and the upgrade > 2_2-3_0.sql > in create_table the some bigint columns are not unsigned for example: > part_id, physmessage_id, headername_id, headervalue_id > but in the upgrade file all bigint columns are unsigned, so I think that > all columns should be "BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0'". > > Second I created a upgrade sql which drops all foreign keys upgrades the > tables and add new keys. > I also changed most of the bigint(20) columns to bigint(20) UNSIGNED but > I'm sure if thats ok for Paul. > I hope that helps someone. If anyone confirms it functions maybe Paul > could add it to the packaged or I will add it to the wiki.
Please don't use the wiki: send me git patches. -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail