1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
use monodoc;
drop table person;
drop table status;
create table person (
name varchar (80) not null,
password varchar (20) not null,
person_id int not null primary key auto_increment,
last_serial int not null,
last_update int not null,
is_admin int not null
);
create table status (
person_id int not null,
serial int not null,
status int not null
);
insert into person (name, password, last_serial, is_admin) values ('miguel@ximian.com', 'login1', 0, 1);
insert into person (name, password, last_serial) values ('nat@nat.org', 'login2', 0);
|