mysql.sql

Chinaxp 论坛源代码

# phpMyAdmin MySQL-Dump
# version 2.2.2
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Mar 21, 2002 at 08:25 PM
# Server version: 3.23.46
# PHP Version: 4.1.0
# Database : `forum`
# --------------------------------------------------------

#
# Create forum database
#
DROP DATABASE IF EXISTS forum;
CREATE DATABASE forum;

#
# Add user used by XP forum application
#
GRANT ALL PRIVILEGES ON forum.* TO xpforum@localhost IDENTIFIED BY 'demo1234';

# To fix Linux problem with error: 
#    Server configuration denies access to data source SQLState
GRANT ALL PRIVILEGES ON forum.* TO xpforum@www IDENTIFIED BY 'demo1234';

USE forum;

#
# Table structure for table `threads`
#

DROP TABLE IF EXISTS `threads`;
CREATE TABLE `threads` (
  `id` bigint(20) NOT NULL default '0',
  `title` varchar(200) default NULL,
  `content` blob,
  `author` varchar(15) default NULL,
  `timestamp` bigint(20) default NULL,
  `parent_id` bigint(20) default NULL,
  `category` int(11) default NULL,
  `last_update` bigint(20) default NULL,
  `reply` int(11) default NULL,
  `click` int(11) default '0',
  `replied_thread` bigint(20) NOT NULL default '0',
  `notify` varchar(1) default NULL,
  `columnThread` varchar(1) default NULL,
   PRIMARY KEY  (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `userName` varchar(15) NOT NULL,
  `password` varchar(15) default NULL,
  `email` varchar(30) default NULL,
  `columnWriter` varchar(1) default NULL,
   PRIMARY KEY(`userName`)
) TYPE=MyISAM;

#
# Dumping data for table `threads`
#
# demo data 
INSERT INTO threads VALUES (1, 'Test Thread', 'test content', 'jwtronics', 100, -1, 1, 100, 1, 0,0,'Y', 'N');
INSERT INTO threads VALUES (2, 'Test Thread', 'test content reply', 'john', 101, 1, 1, 101, 1, 0,0,'Y', 'N');
INSERT INTO threads VALUES (3, 'Test Thread (地地道道)', 'Chinese(GB2312): "地地道道" (Di Di Dao Dao)', 'john',102, 1, 1, 102, 1, 0,0,'Y', 'N');
INSERT INTO threads VALUES (4, '地地道道', 'Chinese(GB2312): "地地道道" (Di Di Dao Dao)', 'john',103, 1, 1, 103, 1, 0,0,'Y', 'N');

INSERT INTO account VALUES ('testuser', 'passwd', '[e-mail]', 'Y' );

INSERT INTO threads VALUES (5, 'title_testuser', '12312213213', 'testuser',103, -1, 1, 103, 1, 0,0,'Y', 'N');