Code:
CREATE TABLE `customercaremodule_messages` (
`id` tinyint(3) NOT NULL auto_increment,
`orderid` varchar(255) default NULL,
`sender` varchar(255) default NULL,
`message` text,
`senddate` varchar(255) default NULL,
`reply` varchar(255) default NULL,
`idle` varchar(255) default 'closed',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
# --------------------------------------------------------
#
# Tablo yapısı : `customercaremodule_news`
#
CREATE TABLE `customercaremodule_news` (
`id` tinyint(3) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`news` text,
`adddate` varchar(255) default NULL,
`link_if_it_is` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
# --------------------------------------------------------
#
# Tablo yapısı : `customercaremodule_questions`
#
CREATE TABLE `customercaremodule_questions` (
`id` tinyint(3) NOT NULL auto_increment,
`value` varchar(255) default NULL,
`idle` tinyint(5) unsigned default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
# --------------------------------------------------------
#
# Tablo yapısı : `customercaremodule_reviews`
#
CREATE TABLE `customercaremodule_reviews` (
`id` tinyint(3) NOT NULL auto_increment,
`subject` varchar(255) default NULL,
`reviews` text,
`first_lastname` varchar(255) default NULL,
`country` varchar(50) default NULL,
`email` varchar(255) default NULL,
`status` varchar(255) default 'pasif',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;