Posted by DonJ on 10/20/05 14:41

Sure

CREATE TABLE `company` (
`company_id` int(11) NOT NULL auto_increment,
`company_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`company_id`),
UNIQUE KEY `company_name` (`company_name`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `company` VALUES (1, 'samplecompany');

CREATE TABLE `variable` (
`variable_id` int(11) NOT NULL auto_increment,
`variable_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`variable_id`),
UNIQUE KEY `variable_name` (`variable_name`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;


INSERT INTO `variable` VALUES (1, 'sample_var1');
INSERT INTO `variable` VALUES (2, 'sample_var2');

CREATE TABLE `variable_value` (
`variable_id` int(11) NOT NULL default '0',
`company_id` int(11) NOT NULL default '0',
`variable_value` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

[Back to original message]