vote.sql

来自「它统一管理各个应用系统用户的身份验证」· SQL 代码 · 共 24 行

drop table vote;
create table vote(
	id nvarchar(40) primary key,
	item nvarchar(40) ,	
	count numeric(10,0)	
);
insert into vote values ('Robin','Robin',0);
insert into vote values ('David','David',5);

drop table admin;
create table admin(
	name nvarchar(40) primary key,
	password nvarchar(40) 	

);
insert into admin values ('1','1');

drop table vote;
create table vote(
	item nvarchar(40) primary key,
	count numeric(10,0)	
);
insert into vote values ('Robin',0);
insert into vote values ('David',0);