pmanage.sql

来自「Struts+iBatis做的增删改查功能。开发工具：MyEclipse+MyS」· SQL 代码 · 共 22 行

drop database mcm;

CREATE DATABASE IF NOT EXISTS mcm default charset utf8;

use mcm;

drop table pManage;

create table pManage(
pm_id int primary key auto_increment,
pm_title varchar(255) CHARACTER SET utf8,
pm_newProduct varchar(255) CHARACTER SET utf8,
pm_catalog varchar(255) CHARACTER SET utf8,
pm_catalogTitle varchar(255) CHARACTER SET utf8,
pm_catalogId varchar(255) CHARACTER SET utf8,
pm_kind varchar(255) CHARACTER SET utf8,
pm_kindId varchar(255) CHARACTER SET utf8,
pm_productTitle varchar(255) CHARACTER SET utf8,
pm_supplyTrader varchar(255) CHARACTER SET utf8,
pm_model varchar(255) CHARACTER SET utf8,
pm_productCP varchar(255) CHARACTER SET utf8
)type=myisam default charset utf8;