-- phpMyAdmin SQL Dump -- version 2.7.0-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 14, 2006 at 12:52 PM -- Server version: 5.0.18 -- PHP Version: 4.4.1-pl1 -- -- Database: `tabs` -- -- -------------------------------------------------------- -- -- Table structure for table `zone` -- CREATE TABLE `zone` ( `zn_id` int(11) NOT NULL auto_increment, `zn_channel_out` varchar(20) collate latin1_general_ci NOT NULL, `zn_ndcode` varchar(10) collate latin1_general_ci NOT NULL, `zn_lacode` varchar(10) collate latin1_general_ci default NULL, `zn_type` varchar(20) collate latin1_general_ci default NULL, `zn_zmp` varchar(10) collate latin1_general_ci default NULL, `zn_name` varchar(200) collate latin1_general_ci NOT NULL, `zn_callrate` varchar(5) collate latin1_general_ci NOT NULL, PRIMARY KEY (`zn_id`), KEY `CodeIndex` (`zn_ndcode`,`zn_lacode`), KEY `ChOutIndex` (`zn_channel_out`) ) ENGINE=MyISAM;