http://www.lambda.ee/w/index.php?action=history&feed=atom&title=Schema.sql 2026-11-07T00:37:54Z Selle lehekülje redigeerimiste ajalugu MediaWiki 1.43.11 http://www.lambda.ee/w/index.php?title=Schema.sql&diff=8276&oldid=prev 2009-03-19T16:17:46Z

<p></p> <p><b>Uus lehekülg</b></p><div>&lt;pre&gt;<br /> create table t0 (<br /> id integer primary key --- unikaalne id (autoincrement)<br /> ,salvestaja varchar(40) NOT NULL --- laadija email, nimi voi hyydnimi<br /> ,f0 varchar(100)<br /> ,f1 varchar(100) <br /> ,f2 varchar(100)<br /> ,f3 varchar(100)<br /> ,f4 varchar(100)<br /> ,f5 varchar(100)<br /> ,f6 varchar(100)<br /> ,f7 varchar(100)<br /> ,f8 varchar(100)<br /> ,f9 varchar(100)<br /> ,f10 varchar(100)<br /> ,f11 varchar(100) <br /> ,f12 varchar(100)<br /> ,f13 varchar(100)<br /> ,f14 varchar(100)<br /> ,f15 varchar(100)<br /> ,f16 varchar(100)<br /> ,f17 varchar(100)<br /> ,f18 varchar(100)<br /> ,f19 varchar(100)<br /> );<br /> <br /> create table t1 (<br /> id integer primary key --- unikaalne id (autoincrement)<br /> ,salvestaja varchar(40) NOT NULL --- laadija email, nimi voi hyydnimi<br /> ,f0 varchar(100)<br /> ,f1 varchar(100) <br /> ,f2 varchar(100)<br /> ,f3 varchar(100)<br /> ,f4 varchar(100)<br /> ,f5 varchar(100)<br /> ,f6 varchar(100)<br /> ,f7 varchar(100)<br /> ,f8 varchar(100)<br /> ,f9 varchar(100)<br /> ,f10 varchar(100)<br /> ,f11 varchar(100) <br /> ,f12 varchar(100)<br /> ,f13 varchar(100)<br /> ,f14 varchar(100)<br /> ,f15 varchar(100)<br /> ,f16 varchar(100)<br /> ,f17 varchar(100)<br /> ,f18 varchar(100)<br /> ,f19 varchar(100)<br /> );<br /> <br /> create table t2 (<br /> id integer primary key --- unikaalne id (autoincrement)<br /> ,salvestaja varchar(40) NOT NULL --- laadija email, nimi voi hyydnimi<br /> ,f0 varchar(100)<br /> ,f1 varchar(100) <br /> ,f2 varchar(100)<br /> ,f3 varchar(100)<br /> ,f4 varchar(100)<br /> ,f5 varchar(100)<br /> ,f6 varchar(100)<br /> ,f7 varchar(100)<br /> ,f8 varchar(100)<br /> ,f9 varchar(100)<br /> ,f10 varchar(100)<br /> ,f11 varchar(100) <br /> ,f12 varchar(100)<br /> ,f13 varchar(100)<br /> ,f14 varchar(100)<br /> ,f15 varchar(100)<br /> ,f16 varchar(100)<br /> ,f17 varchar(100)<br /> ,f18 varchar(100)<br /> ,f19 varchar(100)<br /> );<br /> <br /> create table t3 (<br /> id integer primary key --- unikaalne id (autoincrement)<br /> ,salvestaja varchar(40) NOT NULL --- laadija email, nimi voi hyydnimi<br /> ,f0 varchar(100)<br /> ,f1 varchar(100) <br /> ,f2 varchar(100)<br /> ,f3 varchar(100)<br /> ,f4 varchar(100)<br /> ,f5 varchar(100)<br /> ,f6 varchar(100)<br /> ,f7 varchar(100)<br /> ,f8 varchar(100)<br /> ,f9 varchar(100)<br /> ,f10 varchar(100)<br /> ,f11 varchar(100) <br /> ,f12 varchar(100)<br /> ,f13 varchar(100)<br /> ,f14 varchar(100)<br /> ,f15 varchar(100)<br /> ,f16 varchar(100)<br /> ,f17 varchar(100)<br /> ,f18 varchar(100)<br /> ,f19 varchar(100)<br /> );<br /> <br /> create table t4 (<br /> id integer primary key --- unikaalne id (autoincrement)<br /> ,salvestaja varchar(40) NOT NULL --- laadija email, nimi voi hyydnimi<br /> ,f0 varchar(100)<br /> ,f1 varchar(100) <br /> ,f2 varchar(100)<br /> ,f3 varchar(100)<br /> ,f4 varchar(100)<br /> ,f5 varchar(100)<br /> ,f6 varchar(100)<br /> ,f7 varchar(100)<br /> ,f8 varchar(100)<br /> ,f9 varchar(100)<br /> ,f10 varchar(100)<br /> ,f11 varchar(100) <br /> ,f12 varchar(100)<br /> ,f13 varchar(100)<br /> ,f14 varchar(100)<br /> ,f15 varchar(100)<br /> ,f16 varchar(100)<br /> ,f17 varchar(100)<br /> ,f18 varchar(100)<br /> ,f19 varchar(100)<br /> );<br /> <br /> <br /> <br /> &lt;/pre&gt;</div>

Tammet