mysql.sql

来自「电子商务---产品发布系统 采用PHP+MYSQL+APACHE的环境,非常方」· SQL 代码 · 共 44 行

 drop database if exists cpfb;
 create database cpfb;
 use cpfb;
 
 create table RegUsers (
	user_id int(4) not null auto_increment,
	user_name varchar(20) not null,
	password varchar(50) not null,
	level int(2) not null,
	email varchar(20),
	regtime datetime,
	primary key (user_id)
	);

 create table products (
	id int(5) not null auto_increment,
	product_id varchar(12) not null,
	product_name varchar(30) not null,
	price decimal(6,2),
	class_name varchar(16) not null,
	origin varchar(30),
	photo_filename varchar(30),
	info mediumtext,
	primary key(id)
	);
 
 create table classes (
	class_id int(4) not null auto_increment,
	class_name varchar(20) not null,
	parent_id int(4) not null default 0,
	primary key(class_id)
	);
 
 create table origins (
	origin_id int(3) not null auto_increment,
	origin_name varchar(30) not null,
	primary key(origin_id)
	);

insert into regusers (user_name,password,level) values ('admin',md5(123456),'1');
insert into regusers (user_name,password,level) values ('admin1',md5(123456),'1');