Hi Muthu, Am Freitag, den 10.09.2010, 02:52 +0530 schrieb Ap.Muthu: > A TEXT/BLOB field cannot have a DEFAULT value even if it is NOT NULL. > Hence must the line 32 be: > `thisfile` text NOT NULL COMMENT 'care_menu_sub',
I know. There are some other inconsistencies in it. I do not know where they coming from but I fixed a lot of such things in the past. Somehow some phpmyadmin-data export routines like that idea to flag a column with NOT NULL default NULL idea. Let us discuss that next? I would like to add some PK/FK relationships as well and it seems that you have the same focus like me. Robert -- -- -------------------------------------------- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org ------------------------------------------------------------------------------ Automate Storage Tiering Simply Optimize IT performance and efficiency through flexible, powerful, automated storage tiering capabilities. View this brief to learn how you can reduce costs and improve performance. http://p.sf.net/sfu/dell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
