2018-07-09 14:44:27 +08:00
|
|
|
<?php
|
|
|
|
$stmt = $DB_con->prepare("SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO'");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("SET time_zone = '+05:30'");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("CREATE TABLE IF NOT EXISTS `hotspot_users` (
|
|
|
|
`user_id` int(11) NOT NULL,
|
|
|
|
`email` varchar(200) NOT NULL,
|
|
|
|
`date_added` date NOT NULL,
|
|
|
|
`firstname` varchar(30) NOT NULL,
|
|
|
|
`lastname` varchar(30) NOT NULL,
|
|
|
|
`password` varchar(60) NOT NULL,
|
|
|
|
`created_at` datetime NOT NULL,
|
|
|
|
`username` varchar(30) NOT NULL,
|
|
|
|
`user_level` int(11) NOT NULL DEFAULT '3',
|
|
|
|
`user_group` int(1) NOT NULL,
|
|
|
|
`image_path` varchar(50) NOT NULL,
|
|
|
|
`thumb_path` varchar(50) NOT NULL,
|
|
|
|
`status` varchar(20) NOT NULL
|
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("ALTER TABLE `hotspot_users`
|
|
|
|
ADD PRIMARY KEY (`user_id`),
|
|
|
|
ADD KEY `username` (`username`)");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("ALTER TABLE `hotspot_users`
|
|
|
|
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("CREATE TABLE IF NOT EXISTS `hotspot_vouchers` (
|
|
|
|
`id` int(11) NOT NULL,
|
|
|
|
`created_on` datetime DEFAULT NULL,
|
|
|
|
`created_by` varchar(30) DEFAULT NULL,
|
|
|
|
`creator` int(3) DEFAULT NULL,
|
|
|
|
`user_name` varchar(30) DEFAULT NULL,
|
|
|
|
`password` varchar(30) DEFAULT NULL,
|
|
|
|
`printed_times` int(3) DEFAULT NULL,
|
|
|
|
`printed_last` varchar(30) DEFAULT NULL,
|
|
|
|
`status` varchar(10) DEFAULT NULL,
|
|
|
|
`group_of` int(4) DEFAULT NULL,
|
|
|
|
`booking_id` int(11) DEFAULT NULL,
|
|
|
|
`limit_uptime` varchar(30) DEFAULT NULL,
|
|
|
|
`limit_bytes` varchar(30) DEFAULT NULL,
|
|
|
|
`profile` varchar(30) DEFAULT NULL,
|
|
|
|
`uid` VARCHAR(30) NOT NULL
|
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("ALTER TABLE `hotspot_vouchers`
|
|
|
|
ADD PRIMARY KEY (`id`)");
|
|
|
|
$stmt->execute(array());
|
|
|
|
|
|
|
|
$stmt = $DB_con->prepare("ALTER TABLE `hotspot_vouchers`
|
|
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT");
|
|
|
|
$stmt->execute(array());
|
2017-04-26 16:29:14 +08:00
|
|
|
?>
|