migration...

svn path=/trunk/mono-tools/; revision=117283

1 files changed, 21 insertions, 0 deletions

diff --git a/webdoc/tables.sql b/webdoc/tables.sql
new file mode 100644
index 00000000..2e951946
--- /dev/null
+++ b/webdoc/tables.sql
@@ -0,0 +1,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);
+