Creation and update of tables (e.g. with phpMyAdmin)


CREATE TABLE IF NOT EXISTS `cat` (
`cat_id` int(11) NOT NULL auto_increment,
`cat_name` varchar(30) NOT NULL,
`cat_remark` varchar(80) NOT NULL,
`cat_creusr` varchar(20) NOT NULL,
`cat_credate` date NOT NULL,
`cat_updusr` varchar(20) NOT NULL,
`cat_upddate` date NOT NULL,
PRIMARY KEY  (`cat_id`)
)

CREATE TABLE IF NOT EXISTS `cxc` (
`cxc_id` int(11) NOT NULL,
`cxc_ctc` int(11) NOT NULL,
`cxc_cat` int(11) NOT NULL,
`cxc_creusr` varchar(20) NOT NULL,
`cxc_credate` date NOT NULL,
`cxc_updusr` varchar(20) NOT NULL,
`cxc_upddate` date NOT NULL,
PRIMARY KEY  (`cxc_id`),
KEY `cxc_ctc` (`cxc_ctc`),
KEY `cxc_cat` (`cxc_cat`)
)

ALTER TABLE `ctc` ADD `ctc_mailuser` VARCHAR(30) NOT NULL,
 ADD `ctc_maildomain` VARCHAR(50) NOT NULL, 
 ADD `ctc_mailtld` VARCHAR(10) NOT NULL, 
 ADD `ctc_company` VARCHAR(50) NOT NULL, 
 ADD `ctc_maingroup` VARCHAR(30) NOT NULL, 
 ADD `ctc_remark` VARCHAR(80) NOT NULL, 
 ADD `ctc_approved` CHAR(1) NOT NULL, 
 ADD `ctc_creusr` VARCHAR(20) NOT NULL, 
 ADD `ctc_credate` DATE NOT NULL, 
 ADD `ctc_updusr` VARCHAR(20) NOT NULL, 
 ADD `ctc_upddate` DATE NOT NULL;


CREATE TABLE `fillmad`.`ctc` (
  `ctc_id` INT  NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ctc_id`)
)
ENGINE = MyISAM
CHARACTER SET utf8 COLLATE utf8_general_ci
COMMENT = 'Contact mailaddresses';

