Threaded Mode | Linear Mode

Ultima One · 01-09-2013 11:53 AM

Its for a web server.

For 'status' when you create the database, set the DEFAULT value to be 0. We never need to touch status from the website.

As for creating the table, you should not be creating tables through Sphere. Create the table via a sql script on phpMyAdmin or another mysql client.

Script below:

Code:

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`sphere` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `sphere`;

/*Table structure for table `accounts` */

DROP TABLE IF EXISTS `accounts`;

CREATE TABLE `accounts` (

  `userid` int(4) NOT NULL AUTO_INCREMENT,

  `login` varchar(255) NOT NULL,

  `password` varchar(255) NOT NULL,

  `email` varchar(255) NOT NULL,

  `status` tinyint(1) NOT NULL DEFAULT '0',

  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `ip` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`userid`)

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Threaded Mode \| Linear Mode Auto account PHP web
Author	Message