/[Frey]/trunk/sql/strix.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /trunk/sql/strix.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 76 - (hide annotations)
Wed Jul 9 20:53:35 2008 UTC (14 years, 2 months ago) by dpavlin
File size: 355 byte(s)
fix schema so that SQL::Loader will correctly identify autoincrement,
and thus ->insert will magically work :-)
1 dpavlin 44 BEGIN TRANSACTION;
2     CREATE TABLE users (
3 dpavlin 76 id integer primary key autoincrement,
4 dpavlin 44 ime text,
5     prezime text,
6     email text
7     );
8     INSERT INTO "users" VALUES(NULL,'Anonymous','Coward','nobody@example.com');
9     INSERT INTO "users" VALUES(NULL,'Example','User','example@exaxmple.com');
10     INSERT INTO "users" VALUES(NULL,'Dobrica','Pavlinusic','dpavlin@rot13.org');
11     COMMIT;

  ViewVC Help
Powered by ViewVC 1.1.26