maker.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

BEGIN
CREATE TABLE [dbo].[user]([id] [int] IDENTITY(1,1) NOT NULL,
[username] [VARCHAR](40),
[userpwd] [VARCHAR](40),
[addTime] [VARCHAR](40),
[email] [VARCHAR](40),
) ON [PRIMARY]
END
BEGIN
CREATE TABLE [dbo].[commodity]([c_id] [int] IDENTITY(1,1) NOT NULL,
[commodityName] [VARCHAR](40),
[brandname] [VARCHAR](40),
[produceplace] [VARCHAR](40),
[unit] [VARCHAR](40),
[specs] [VARCHAR](40),
[passnumber] [VARCHAR](40),
[passlist] [VARCHAR](40),
[companyid] [VARCHAR](40),
[remark] [VARCHAR](40),
[addTime] [VARCHAR](40),
[picture] [VARCHAR](40),
[num] [VARCHAR](40),
[typeid] [int],
) ON [PRIMARY]
END
BEGIN
CREATE TABLE [dbo].[staff]([s_id] [int] IDENTITY(1,1) NOT NULL,
[s_name] [VARCHAR](40),
[s_sex] [VARCHAR](40),
[s_adress] [VARCHAR](40),
[s_tel] [VARCHAR](40),
[s_email] [VARCHAR](40),
) ON [PRIMARY]
END
BEGIN
CREATE TABLE [dbo].[company]([cp_id] [int] IDENTITY(1,1) NOT NULL,
[companyname] [VARCHAR](40),
[companyaddress] [VARCHAR](40),
[postalcode] [VARCHAR](40),
[tel] [VARCHAR](40),
[linkman] [VARCHAR](40),
[linkmanwechat] [VARCHAR](40),
[email] [VARCHAR](40),
[bank] [VARCHAR](40),
[bandaccounts] [VARCHAR](40),
[addtime] [VARCHAR](40),
) ON [PRIMARY]
END
BEGIN
CREATE TABLE [dbo].[stock]([id] [int] IDENTITY(1,1) NOT NULL,
[commodityid] [VARCHAR](40),
[companyid] [VARCHAR](40),
[number] [VARCHAR](40),
[pirce] [VARCHAR](40),
[stockdate] [VARCHAR](40),
[payment] [VARCHAR](40),
[factpayment] [VARCHAR](40),
[notpayment] [VARCHAR](40),
[manageman] [VARCHAR](40),
[username] [VARCHAR](40),