CREATE DATABASE IF NOT EXISTS XPanel;
CREATE TABLE IF NOT EXISTS XPanel.emails (
`id` int(9) unsigned NOT NULL auto_increment,
`email` varchar(64) NOT NULL default '',
`crypt` varchar(64) NOT NULL default '',
`clear` varchar(64) NOT NULL default '',
`name` varchar(128) NOT NULL default '',
`uid` int(9) unsigned NOT NULL default '36',
`gid` int(9) unsigned NOT NULL default '36',
`home` varchar(255) NOT NULL default '',
`maildir` varchar(255) NOT NULL default '',
`quota` int(9) NOT NULL default '100',
`status` varchar(128) NOT NULL default 'PENDINGCREATE',
`greylisted` enum('1','0') NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users emails';
CREATE TABLE IF NOT EXISTS XPanel.named (
`id` int(9) unsigned NOT NULL auto_increment,
`domain_name` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `domain_name` (`domain_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Domains for DNS';
CREATE TABLE IF NOT EXISTS XPanel.users (
`id` int(9) unsigned NOT NULL auto_increment,
`domainName` varchar(32) NOT NULL default '',
`status` varchar(32) NOT NULL default '',
`firstName` varchar(32) NOT NULL default '',
`lastName` varchar(32) NOT NULL default '',
`organization` varchar(64) NOT NULL default '',
`address` varchar(32) NOT NULL default '',
`city` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`zip` varchar(16) NOT NULL default '',
`country` char(2) NOT NULL default '',
`phone` varchar(16) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`gender` enum('1','0') NOT NULL default '1',
`birthDate` date NOT NULL default '1900-01-01',
`password` varchar(16) NOT NULL default '',
`category` tinyint(1) NOT NULL default '0',
`plan` tinyint(1) NOT NULL default '0',
`paymentTerm` enum('m','q','y') NOT NULL default 'q',
`question` tinyint(1) NOT NULL default '0',
`answer` varchar(128) NOT NULL default '',
`subscribe` enum('1','0') NOT NULL default '1',
`IP` varchar(15) NOT NULL default '',
`quotaSize` int(9) NOT NULL default '1',
`quotaUsed` int(9) NOT NULL default '0',
`dailyTrafficUsage` bigint(19) NOT NULL default '0',
`dailyTrafficUsageLimit` int(9) NOT NULL default '1',
`monthlyTrafficUsage` bigint(19) NOT NULL default '0',
`monthlyTrafficUsageLimit` int(9) NOT NULL default '1',
`mysqlDB` enum('1','0') NOT NULL default '0',
`emails` int(9) NOT NULL default '0',
`deleteExpired` enum('1','0') NOT NULL default '0',
`language` varchar(5) NOT NULL default 'en',
`comments` text,
`recordCreated` datetime NOT NULL default '0000-00-00 00:00:00',
`recordExpires` datetime NOT NULL default '0000-00-00 00:00:00',
`recordUpdated` datetime NOT NULL default '0000-00-00 00:00:00',
`updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`homedir` varchar(255) NOT NULL default '/tmp',
PRIMARY KEY (`id`),
UNIQUE KEY `domainName` (`domainName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='XPanel users';
INSERT IGNORE INTO XPanel.users (id, domainName) values ('999', 'www.xpanel.com');
ALTER IGNORE TABLE XPanel.users AUTO_INCREMENT=1000;
DELETE from XPanel.users where id=999;
INSERT IGNORE INTO mysql.user (Host, User, Password) VALUES('localhost', 'xpanel', PASSWORD('XPanel'));
INSERT IGNORE INTO mysql.db (Host, Db, User, Select_priv, Update_priv) VALUES ('localhost','XPanel','xpanel','Y','Y');
# mysql4 INSERT IGNORE INTO mysql.user VALUES ('localhost','root_xpanel',PASSWORD('MySQL_PassWord!'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
INSERT IGNORE INTO mysql.user VALUES ('localhost','root_xpanel',PASSWORD('MySQL_PassWord!'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
FLUSH PRIVILEGES;
|
