mysql_query("CREATE TABLE IF NOT EXISTS `transfer_fund` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `transfer_to` int(11) NOT NULL,\n `bank_id` int(11) NOT NULL,\n `amt` int(5) NOT NULL,\n `request_date` datetime NOT NULL,\n `status` int(1) NOT NULL,\n `transfer_date` datetime NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ");
mysql_query("CREATE TABLE IF NOT EXISTS `users` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `user_id` int(11) NOT NULL,\n `fb_id` int(50) NOT NULL,\n `username` varchar(100) NOT NULL,\n `password` varchar(25) NOT NULL,\n `first_name` varchar(50) NOT NULL,\n `last_name` varchar(100) NOT NULL,\n `dob` date NOT NULL,\n `gender` enum('male','female') NOT NULL DEFAULT 'male',\n `email` varchar(100) NOT NULL,\n `mobile` varchar(10) NOT NULL,\n `inr_bal` int(5) NOT NULL,\n `coupons` varchar(10) NOT NULL,\n `bank_id` int(11) NOT NULL,\n `game_status` varchar(5) NOT NULL,\n `unseen_notification` int(3) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ");
mysql_query("CREATE TABLE IF NOT EXISTS `t1_games` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `start_time` datetime NOT NULL,\n `content` varchar(150) NOT NULL,\n `content_table_id` int(5) NOT NULL,\n `crnt_plrs` int(6) NOT NULL,\n `a_plrs` text NOT NULL,\n `b_plrs` text NOT NULL,\n `c_plrs` text NOT NULL,\n `d_plrs` text NOT NULL,\n `e_plrs` text NOT NULL,\n `game_result` varchar(200) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ");
mysql_query("CREATE TABLE IF NOT EXISTS `t1_content` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `game_id` int(5) NOT NULL,\n `content_src` varchar(20) NOT NULL,\n `a_content` text NOT NULL,\n `b_content` text NOT NULL,\n `c_content` text NOT NULL,\n `d_content` text NOT NULL,\n `e_content` text NOT NULL,\n `time` varchar(15) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ");
mysql_query("CREATE TABLE IF NOT EXISTS `puzzles` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `puzzle_src` varchar(50) NOT NULL,\n `ans` varchar(100) NOT NULL,\n `solution` text NOT NULL,\n `used` int(11) NOT NULL,\n `upload_time` varchar(15) NOT NULL,\n `upload_by` int(11) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ");
mysql_query('CREATE TABLE IF NOT EXISTS `uploaders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fname` varchar(30) NOT NULL,
`lname` varchar(30) NOT NULL,
`username` varchar(30) NOT NULL,
`password` varchar(30) NOT NULL,
`reg_date` varchar(15) NOT NULL,
`last_login` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ');
mysql_query("INSERT INTO `uploaders` (`id`, `fname`, `lname`, `username`, `password`, `reg_date`, `last_login`) VALUES\n(1, 'Master', 'Admin', 'masteradmin', 'password', '', '')");
$dbh->add_clm("t1_games", "`crnt_money` INT(11) NOT NULL", "crnt_plrs");
$dbh->add_clm("puzzles", "`last_used` INT(11) NOT NULL", "used");
// $dbh->add_clm("tests", "`status` ENUM('closed', 'opened') NOT NULL DEFAULT 'closed'", "attempted_by");
// $dbh->add_clm("test_packages", "`std_type` tinytext NOT NULL");
$dbh->modify_clm("users", "`game_status`", "tinytext NOT NULL");
// $dbh->change_clm("test_series", "`desc`", "`description`", "text NOT NULL");
echo "Created succsessfully";
}
} else {
echo "Error! Try again.";
exit;
}
} else {
echo "ERROR! Please first Install this on Online server!";
}
