2 replies to this topic

[lol33d]

hi guys

i want create a table for account payment with BALANCE('POSITIVE','NEGATIVE')


this is my sample:

CREATE TABLE IF NOT EXISTS `payment` (

  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `PARENT` int(11) unsigned NOT NULL DEFAULT '0',

  `AMOUNT` int(11) unsigned NOT NULL DEFAULT '0',

  `BALANCE` enum('POSITIVE','NEGATIVE') NOT NULL DEFAULT 'NEGATIVE',

  PRIMARY KEY (`ID`)

) ENGINE=MyISAM;

please help for better table

thank you

---------- Post added at 09:57 PM ---------- Previous post was at 09:54 PM ----------

i dont need duble amount

i need a table for support (-) and (+)
for ex:
-15000
and
15000

[lol33d]

hello

[Orjan]

wouldn't it be easier to just create an signed int amount, and check if its less than 0 to be negative?