|
发表于 2009-11-22 17:02:18
|
显示全部楼层
db.txt
SQL复制代码 -- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 11, 2008 at 10:50 AM
-- Server version: 4.1.22
-- PHP Version: 4.4.4
SET SQL_MODE ="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `ncsuxa_xacms`
--
-- --------------------------------------------------------
--
-- Table structure for table `assigns`
--
CREATE TABLE `assigns` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`groupid` INT(11) NOT NULL DEFAULT '0',
`userid` INT(11) NOT NULL DEFAULT '0',
`rank` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE =MyISAM DEFAULT CHARSET =latin1;
-- --------------------------------------------------------
--
-- Table structure for table `ci_sessions`
--
CREATE TABLE `ci_sessions` (
`session_id` VARCHAR(40) NOT NULL DEFAULT '0',
`session_start` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`session_last_activity` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`session_ip_address` VARCHAR(16) NOT NULL DEFAULT '0',
`session_user_agent` VARCHAR(50) NOT NULL DEFAULT '',
`session_data` text NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE =MyISAM DEFAULT CHARSET =latin1;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`groupid` INT(11) NOT NULL AUTO_INCREMENT,
`groupname` VARCHAR(255) NOT NULL DEFAULT '',
`description` VARCHAR(255) NOT NULL DEFAULT '',
`editable` tinyint (4) NOT NULL DEFAULT '1',
PRIMARY KEY (`groupid`)
) ENGINE =MyISAM DEFAULT CHARSET =latin1;
-- --------------------------------------------------------
--
-- Table structure for table `rememberme`
--
CREATE TABLE `rememberme` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(40) DEFAULT NULL,
`usernamehash` VARCHAR(128) DEFAULT NULL,
`random_string` VARCHAR(128) DEFAULT NULL,
`origin_time` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE =MyISAM DEFAULT CHARSET =latin1;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`userid` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL DEFAULT '',
`lastname` VARCHAR(100) DEFAULT NULL,
`firstname` VARCHAR(100) DEFAULT NULL,
`email` VARCHAR(100) NOT NULL DEFAULT '',
`password` VARCHAR(40) NOT NULL DEFAULT '',
`lastlogin` datetime DEFAULT NULL,
`lastactivity` INT(10) UNSIGNED DEFAULT '0',
`enabled` tinyint (1) NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
UNIQUE KEY `username` (`username`)
) ENGINE =InnoDB DEFAULT CHARSET =latin1; 复制代码
index.php 就是 CI 默认的,什么应用都不应该修改 CI 默认的 index.php 文件。 |
|