wap_news.sql

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

 CREATE DATABASE wap_news;

DROP TABLE IF EXISTS wap_news;
CREATE TABLE wap_news(
 id int NOT NULL auto_increment,
 sortid smallint NOT NULL,
 title TINYTEXT,
 info text,
 PRIMARY KEY(id)) TYPE=MYISAM;
 INSERT INTO wap_news values('1','1','公司简介','公司简介');
 INSERY INTO wap_news values('2','2','公司新闻','公司新闻');
 INSERT INTO wap_news values('3','3','产品展示','产品展示');
 INSERT INTO wap_news values('4','4','联系我们','联系我们');
 INSERT INTO wap_news values('5','5','人才招聘','人才招聘');

DROP TABLE IF EXISTS 'wap_newssort';
CREATE TABLE wap_newssort(
 sortid smallint NOT NULL auto_increment,
 type int(1),
 sortname TINYTEXT,
 PRIMARY KEY(sortid)) TYPE=MYISAM;
 INSERT INTO wap_newssort values('1','0','公司简介');
 INSERT INTO wap_newssort values('2','1','公司新闻');
 INSERT INTO wap_newssort values('3','1','产品展示');
 INSERT INTO wap_newssort values('4','0','联系我们');
 INSERT INTO wap_newssort values('5','1','人才招聘');

CREATE TABLE users (
  user_id int(10) unsigned NOT NULL auto_increment,
  username varchar(20) NOT NULL default '',
  password varchar(23) NOT NULL default '',
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;
 INSERT INTO users values('1','admin','bc99cb27687ce9c4c8d64a7cd91cbdec');