【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了createMobile.sql相关资料,希望对各位网友有所帮助!
DROP TABLE client;
CREATE TABLE client (
mobile VARCHAR(20) NOT NULL,
name VARCHAR(20),
sfzh VARCHAR(20),
PRIMARY KEY(mobile)
);
DROP TABLE information;
CREATE TABLE information (
infoid AUTO_INCREMENT NOT NULL,
mobile VARCHAR(15),
store VARCHAR(30),
productcode VARCHAR(30),
quantity VARCHAR(10),
price VARCHAR(10),
PRIMARY KEY(infoid)
);
DROP TABLE promotion;
CREATE TABLE promotion (
promotionid AUTO_INCREMENT NOT NULL,
senddate VARCHAR(30),
mobile VARCHAR(15),
message VARCHAR(75),
PRIMARY KEY(promotionid)
);