createdb.sql

来自「一个简单的pos机程序」· SQL 代码 · 共 56 行

create table CommodityInfo
(
  ID int,
  ComoCode vchar(13) PRIMARY KEY,
  ComoName vchar(50),
  ComoPrice money,
  ComoCount int,
  ComoDisc int,
  ComoClassNo int
);

insert into CommodityInfo values
(
  1, '2000040106449', 'note', 1.30, 10, 0, 1
);
insert into CommodityInfo values
(
  2, '2000040103456', 'pencil', 0.30, 100, 0, 1
);

create table EmployInfo
(
  ID int,
  EmpNo vchar(20) PRIMARY KEY,
  EmpName vchar(10),
  EmpPassword vchar(20),
  Memo vchar(100),
  Prior vchar(20)
);

insert into EmployInfo values
(
  1, '0001', 'admin', 'admin', '[e-mail]', 'manager'
);
insert into EmployInfo values
(
  2, '0002', 'tom', 'tom', '[e-mail]', 'common'
);

create table SupportInfo
(
  ID int,
  SupNo vchar(20) PRIMARY KEY,
  SumName vchar(100),
  Link vchar(50),
  Memo vchar(50)
);

insert into SupportInfo values
(
  1, '0001', 'P&G', '[e-mail]', 'no information'
);
insert into SupportInfo values
(
  2, '0002', 'panda', '[e-mail]', 'product:pencil'
);