Welcome Guest, Not a member yet? Register   Sign In
DB Create - Execute SQL Command
#3

[eluser]CI_avatar[/eluser]
@progr@mmer thank you. but the sql command that i am referring includes creating the database.
Like this

Code:
SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `_rms_lotto_db`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `_rms_lotto_db`;

#
# Structure for the `_users` table :
#

CREATE TABLE `_users` (
  `username` varchar(20) NOT NULL,
  `password` varchar(160) DEFAULT NULL,
  `type` enum('ad','rp') DEFAULT 'rp',
  PRIMARY KEY (`username`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Messages In This Thread
DB Create - Execute SQL Command - by El Forum - 01-13-2011, 08:59 PM
DB Create - Execute SQL Command - by El Forum - 01-13-2011, 09:12 PM
DB Create - Execute SQL Command - by El Forum - 01-13-2011, 09:17 PM



Theme © iAndrew 2016 - Forum software by © MyBB