install_post.php

聪明星企业wap网站系统 Version 1.0

<?
   include("db_connect.php");
   if($_GET['action'] == "install")
   {
   $CREATE1="CREATE TABLE wap_news (
 	id int NOT NULL auto_increment,
 	sortid smallint NOT NULL,
 	title TINYTEXT,
 	info text,
 	PRIMARY KEY (id))";
   $CREATE2="CREATE TABLE wap_newssort (
 	sortid smallint NOT NULL auto_increment,
 	type int(1),
 	sortname TINYTEXT,
 	PRIMARY KEY (sortid))";
   $CREATE3="CREATE TABLE feedback (
	id smallint NOT NULL auto_increment,
	username TINYTEXT,
	title TINYTEXT,
	datetime datetime default '0000-00-00 00:00:00',
	comments text,
	reply text default '',
	PRIMARY KEY (id))";
	$CREATE4="CREATE TABLE users (
  user_id int(10) unsigned NOT NULL auto_increment,
  username varchar(20) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  PRIMARY KEY  (user_id))";
   $INSERT1="INSERT INTO wap_news values('1','1','鍏