[UN]Jake
07-10-2003, 01:52 PM
CREATE TABLE `plans` (
`planID` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`name` CHAR( 32 ) NOT NULL ,
`description` TINYTEXT NOT NULL ,
`price` FLOAT( 6, 2 ) NOT NULL ,
`setup` VARCHAR( 6, 2 ) NOT NULL ,
`active` CHAR( 3 ) NOT NULL ,
PRIMARY KEY ( `planID` )
)
`planID` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`name` CHAR( 32 ) NOT NULL ,
`description` TINYTEXT NOT NULL ,
`price` FLOAT( 6, 2 ) NOT NULL ,
`setup` VARCHAR( 6, 2 ) NOT NULL ,
`active` CHAR( 3 ) NOT NULL ,
PRIMARY KEY ( `planID` )
)
