View Single Post
  #7  
Old 05-20-2004, 11:00 PM
 
deniz deniz is offline
 

Advanced Member
  
Join Date: Sep 2003
Posts: 70
 

Default

sorry I forget SQL

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 ;
Reply With Quote