View file sql/cscp_wap.sql

# Generation Time: Apr 21, 2004 at 10:27 PM
# Server version: 3.23.49
# PHP Version: 4.2.1
# 
# Database : `cscp_wap`
# 

# --------------------------------------------------------

#
# Table structure for table `cscp_wap_menu`
#
# Creation: Apr 21, 2004 at 09:59 PM
# Last update: Apr 21, 2004 at 09:59 PM
#

CREATE TABLE `cscp_wap_menu` (
  `menu_name` varchar(25) NOT NULL default '',
  `menu_id` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `cscp_wap_menu`
#

INSERT INTO `cscp_wap_menu` VALUES ('News', 'news');
INSERT INTO `cscp_wap_menu` VALUES ('Home', 'index');

# --------------------------------------------------------

#
# Table structure for table `cscp_wap_news`
#
# Creation: Apr 21, 2004 at 09:49 PM
# Last update: Apr 21, 2004 at 09:49 PM
#

CREATE TABLE `cscp_wap_news` (
  `news_name` varchar(20) NOT NULL default '',
  `news_text` longtext NOT NULL,
  `news_date` date default NULL
) TYPE=MyISAM;

#
# Dumping data for table `cscp_wap_news`
#


# --------------------------------------------------------

#
# Table structure for table `cscp_wap_page`
#
# Creation: Apr 21, 2004 at 09:55 PM
# Last update: Apr 21, 2004 at 09:55 PM
#

CREATE TABLE `cscp_wap_page` (
  `page_name` varchar(20) NOT NULL default '',
  `page_subject` varchar(30) NOT NULL default '',
  `page_text` longtext NOT NULL,
  PRIMARY KEY  (`page_name`)
) TYPE=MyISAM;

#
# Dumping data for table `cscp_wap_page`
#

INSERT INTO `cscp_wap_page` VALUES ('index', 'Home', 'This is the first page of your WapSite. \r\n\r\nHere you can write greeting message or something else... ');

# --------------------------------------------------------

#
# Table structure for table `cscp_wap_files`
#
# Creation: Apr 25, 2004 at 09:01 PM
# Last update: Apr 25, 2004 at 09:01 PM
#

CREATE TABLE `cscp_wap_files` (
  `file_id` varchar(10) default NULL,
  `file_name` varchar(30) NOT NULL default '',
  `file_size` varchar(30) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `cscp_wap_files`
#

# --------------------------------------------------------

#
# Table structure for table `cscp_wap_options`
#
# Creation: Apr 25, 2004 at 09:46 PM
# Last update: Apr 25, 2004 at 10:02 PM
#

CREATE TABLE `cscp_wap_options` (
  `id` varchar(10) default NULL,
  `language` varchar(10) NOT NULL default '',
  `file_upload_dir` varchar(30) NOT NULL default '',
  `m_add` char(3) default NULL,
  `m_edit` char(3) default NULL,
  `m_delete` char(3) default NULL,
  `m_upload` char(3) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `cscp_wap_options`
#

INSERT INTO `cscp_wap_options` VALUES ('panel', 'eng', 'files', NULL, NULL, NULL, NULL);
INSERT INTO `cscp_wap_options` VALUES ('page', '', '', 'yes', 'yes', 'yes', NULL);
INSERT INTO `cscp_wap_options` VALUES ('news', '', '', 'yes', 'yes', 'yes', NULL);
INSERT INTO `cscp_wap_options` VALUES ('file', '', '', NULL, NULL, 'yes', 'yes');