########potfix_sql########bigin################## CREATE TABLE alias ( username varchar(255) NOT NULL default'', goto text NOT NULL, domain varchar(255) NOT NULL default'', PRIMARY KEY (username) ) TYPE=MyISAM; CREATE TABLE domain ( domain varchar(255) NOT NULL default'', description varchar(255) NOT NULL default'', PRIMARY KEY (domain) ) TYPE=MyISAM; CREATE TABLE mailbox ( userid char(20) binary NOT NULL default'', username varchar(255) NOT NULL default'', password varchar(255) NOT NULL default'', home varchar(255) NOT NULL default'', maildir varchar(255) NOT NULL default'', name varchar(255) NOT NULL default'', uid smallint(5) unsigned NOT NULL default'12345', gid smallint(5) unsigned NOT NULL default'12345', quota varchar(255) NOT NULL default'', domain varchar(255) NOT NULL default'', create_date date NOT NULL default'0000-00-00', create_time time NOT NULL default'00:00:00', change_date date NOT NULL default'0000-00-00', change_time time NOT NULL default'00:00:00', last_access int(10) unsigned NOT NULL default'0', passwd_lastchanged int(10) unsigned NOT NULL default'0', status tinyint(4) NOT NULL default'1', PRIMARY KEY (username), KEY status (status) ) TYPE=MyISAM; #####################end######################## [root@localhost root]# mysql postfix < /work/postfix.sql |