createdb.php

vpn虚拟专用网络的一个开源搭建工具

<?php
include('lib/conf.php');
$conn = mysql_connect($dbhost,$dbuser,$dbpass);

//mysql_query("DROP DATABASE `$dbname`;")
//or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_query("CREATE DATABASE `$dbname`;")
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_select_db($dbname)
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

//mysql_query("DROP TABLE IF EXISTS `COMM`;")
//or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_query("CREATE TABLE `COMM` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  `subnet` text NOT NULL,
  `netmask` text NOT NULL,
  `file_key` text,
  `host_srv` varchar(30) NOT NULL default '',
  `port_srv` int(11) NOT NULL default '0',
  `tot_usr` int(11) NOT NULL default '0',
  `type_vpn` enum('NOTCRYPT','CRYPT') NOT NULL default 'CRYPT',
  `max_usr` int(11) NOT NULL default '0',
  `key` text,
  `uname_admin` varchar(30) NOT NULL default '',
  `status` int(11) NOT NULL default '1',
  `type_comm` enum('NOTPUB','PUB') NOT NULL default 'NOTPUB',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;")
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

//mysql_query("DROP TABLE IF EXISTS `MEMB`;")
//or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_query("CREATE TABLE `MEMB` (
  `id` int(11) NOT NULL default '0',
  `id1` int(11) NOT NULL default '0',
  `ip_num` text NOT NULL,
  `confirmed` int(11) NOT NULL default '0',
  `hash` text NOT NULL,
  UNIQUE KEY `key` (`id`,`id1`,`hash`(32))
) TYPE=MyISAM;")
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

//mysql_query("DROP TABLE IF EXISTS `USERS`;")
//or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_query("CREATE TABLE `USERS` (
  `id` int(11) NOT NULL auto_increment,
  `hash` text NOT NULL,
  `pass` text NOT NULL,
  `email` varchar(30) NOT NULL default '',
  `user_name` varchar(30) NOT NULL default '',
  `name` varchar(30) NOT NULL default '',
  `surname` varchar(30) NOT NULL default '',
  `status` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY user_name (user_name),
  UNIQUE KEY email (email)
) TYPE=MyISAM;")
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_query("CREATE TABLE `sessions` (
   `ses_id` varchar(32) NOT NULL default '',
   `ses_time` int(11) NOT NULL default '0',
   `ses_start` int(11) NOT NULL default '0',
   `ses_value` text NOT NULL,
   PRIMARY KEY  (ses_id)
) TYPE=MyISAM;")
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

mysql_query("CREATE TABLE `email` (
  `id` int(11) NOT NULL auto_increment,
  `receiver` varchar(64) NOT NULL default '',
  `subject` varchar(64) NOT NULL default '',
  `body` text NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;")
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());

echo "Database and table are ready yo use";
mysql_close($conn);
?>