· 8 years ago · Mar 11, 2018, 01:36 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
5/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
6/*!40101 SET NAMES utf8 */;
7
8
9CREATE TABLE IF NOT EXISTS `message` (
10 `msg` text NOT NULL,
11 `email` varchar(20) NOT NULL,
12 `ip` varchar(20) NOT NULL,
13 `date` varchar(20) NOT NULL,
14 `subj` varchar(20) NOT NULL,
15 `tusername` varchar(20) NOT NULL,
16 `tpassword` int(20) NOT NULL,
17 UNIQUE KEY `ip` (`ip`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1;