Menu
▾
▴
[Firebird-test] Ere's somethin to test
|
From: Nigel W. <nw...@ut...> - 2002-06-03 06:45:30
|
I've come up with a schema for a Firebird powered Web-based RPG.
Have a look through, and see if you'd play it.
I intend(someday), to use progressive layering of DIV's in the browser to
produce a primitive 3d image of the orcaan world(background first and small,
working towards the front)
Anyhow, it's the schema that needs optimising.
If you wouldn't mind running it on a spare FB machine, and pipe the output
to a file, I'd love to know how long it takes people to generate it.
I'm working on a dataset for it soon(so I've got something to render in the
browser)
I love feedback!!
Nige
begin 666 schema.sql
M+RH*3W)C86%N('-C:&5M82 H1FER96)I<F0@4&]W97)E9"D*+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T*3W)C86%N(&ES(&$@
M=FER='5A;"!W;W)L9"P@;6%P<&5D(&%S(&$@=&AR964@9&EM96YS:6]N86P@
M;6%Z90I4:&5R92!I<R!A('-U<F9A8V4@;V8@=&AE('=O<FQD+"!I;F-L=61I
M;F<@=&5X='5R97,H9W)A<W,L(')O8VLI+" *;V)J96-T<RAB=6EL9&EN9W,L
M('1R965S*2P@86YD('!E;W!L92AO=&AE<B!U<V5R<RP@;W(@<WES=&5M(&]R
M8VET97,I"D%L<V\@;VX@3W)C86%N+"!T:&5R92!A<F4@='5N;F5L<RP@=V%R
M<',L(&%N9"!T<F%P<RX*3V)J96-T:79E+B!&:6YD('1R96%S=7)E+"!G970@
M<')O<&5R='DL(&%S<V5T<RP@;&]V97)S+"!E=&,L(&%N9"!T<GD@=&\@=&%K
M92!O=F5R('1H92!P;&%C90H*5&AI<R!M=7-T(&YO="!B92!U<V5D('=I=&AO
M=70@<&5R;6ES<VEO;BX*06YY(&5N:&%N8V5M96YT<R!M=7-T(&)E('-U8FUI
M='1E9"!T;R!T:&4@875T:&]R"@I#;W!Y<FEG:'0@*$,I($YI9V5L(%=E96MS
M"FYW965K<T!U=&%S+F5D=2YA=0HM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+0HJ+PI3150@4U1!5#L*"D-/3DY%0U0@(G1W:7-T
M97(Z+W4Q+V1B+V]R8V%A;BYG9&(B.PI#3TU-250["@I$4D]0($1!5$%"05-%
M.PI#3TU-250["D-214%412!$051!0D%312 B='=I<W1E<CHO=3$O9&(O;W)C
M86%N+F=D8B(["D-/34U)5#L*"E-%3$5#5" G3W)C86%N(%1A8FQE)R!&4D]-
M(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%('1B;%]/<F-A86X@* H@(&EN
M=%],;V,@3E5-15))0R@Q-2PP*2!.3U0@3E5,3"P@+RH@5&AE(%5N:7%U92!L
M;V-A=&EO;B J+PH@(&EN=%]8($1/54),12!04D5#25-)3TXL("\J(%1H92!8
M('!O<VET:6]N(&]F('1H92!L;V-A=&EO;BAI9B!S<&5C:69I960I("HO"B @
M:6YT7UD@1$]50DQ%(%!214-)4TE/3BP@+RH@5&AE(%D@<&]S:71I;VX@;V8@
M=&AE(&QO8V%T:6]N*&EF('-P96-I9FEE9"D@*B\*("!I;G1?6B!.54U%4DE#
M*#$U+# I($1%1D%53%0@,"!.3U0@3E5,3"P@+RH@5&AE(&QA>65R('1H92!L
M;V-A=&EO;B!I<R!O;B J+PH@(" @4%))34%262!+15D@*&EN=%],;V,I"BD[
M"D-214%412!!4T,@24Y$15@@24Y$7T%30U]/4D-?3$]#($].('1B;%]/<F-A
M86X@*&EN=%],;V,I.PI#4D5!5$4@1$530R!)3D1%6"!)3D1?1$530U]/4D-?
M3$]#($].('1B;%]/<F-A86X@*&EN=%],;V,I.PH*4T5,14-4("=,;V-A=&EO
M;B!0<F]P97)T:65S)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%
M('1L:W!?3&]C4')O<" H"B @:6YT7TQO8R!.54U%4DE#*#$U+# I($Y/5"!.
M54Q,+ H@('-T<E]0<F]P(%9!4D-(05(H,3 I($Y/5"!.54Q,+ H@('-T<E]6
M86P@5D%20TA!4B@S,"D@3D]4($Y53$PL"B @("!04DE-05)9($M%62 H:6YT
M7TQO8RP@<W1R7U!R;W I+ H@(" @1D]214E'3B!+15D@*&EN=%],;V,I(%)%
M1D5214Y#15,@=&)L7V]R8V%A;BAI;G1?3&]C*2!/3B!54$1!5$4@0T%30T%$
M10HI.PI#4D5!5$4@05-#($E.1$58($E.1%]!4T-?4%)/4%],3T,@3TX@=&QK
M<%],;V-0<F]P("AI;G1?3&]C*3L*0U)%051%($1%4T,@24Y$15@@24Y$7T1%
M4T-?4%)/4%],3T,@3TX@=&QK<%],;V-0<F]P("AI;G1?3&]C*3L*0U)%051%
M($%30R!)3D1%6"!)3D1?05-#7U!23U!?4%)/4"!/3B!T8FQ?3W)C86%N("AI
M;G1?3&]C*3L*0U)%051%($1%4T,@24Y$15@@24Y$7T1%4T-?4%)/4%]04D]0
M($].('1B;%]/<F-A86X@*&EN=%],;V,I.PH*4T5,14-4("=/<F-A86X@4&%T
M:',G($923TT@<F1B)&1A=&%B87-E.PI#4D5!5$4@5$%"3$4@=&QN:U]/<F-0
M871H("@*("!I;G1?0TQO8R!.54U%4DE#("@Q-2PP*2!.3U0@3E5,3"P@+RH@
M5&AE(&-U<G)E;G0@3&]C871I;VX@*B\*("!I;G1?3DQO8R!.54U%4DE#("@Q
M-2PP*2!.3U0@3E5,3"P@+RH@5&AE($YE>'0@3&]C871I;VX@*B\*("!I;G1?
M5FES($E.5$5'15(@1$5&055,5" Q($Y/5"!.54Q,+" O*B!)9B!T:&4@9&5S
M=&EN871I;VX@:7,@=FES:6)L92 J+PH@(&EN=%]$:7(@24Y414=%4BP@+RH@
M5&AE(&1I<F5C=&EO;B H,#UU;FMN;W=N+" Q/6YO<G1H+#(]96%S="PS<V]U
M=&@L-'=E<W0I("HO"B @:6YT7U1Y<&4@24Y414=%4BP@+RH@4&%T:"!4>7!E
M("@P/75N8VAA<G1E9"P@,3UC:&%R=&5D+" R/7=A<G L(#,]='5N;F5L*2 J
M+PH@(&EN=%]);&QU;2!)3E1%1T52+" O*B!I;&QU;6EN871I;VX@*# ]<W5N
M+" Q/61A<'!L961L:6=H="P@,CUD965P<VAA9&]W<RP@,SUB;&%C:RD@*B\*
M("!I;G1?4V%F92!)3E1%1T52+" O*B!3869E='D@:6YD97@@*# ]<V%F92P@
M,3UR87)E('1R;W5B;&4L(#(]9G)E<75E;G0@=')O=6)L92P@,SU"861I92!H
M86YG;W5T*B\*(" @(%!224U!4ED@2T59("AI;G1?0TQO8RP@:6YT7TY,;V,I
M+ H@(" @1D]214E'3B!+15D@*&EN=%]#3&]C*2!2149%4D5.0T53('1B;%]O
M<F-A86XH:6YT7TQO8RD@3TX@55!$051%($-!4T-!1$4L"B @("!&3U)%24=.
M($M%62 H:6YT7TY,;V,I(%)%1D5214Y#15,@=&)L7V]R8V%A;BAI;G1?3&]C
M*2!/3B!54$1!5$4@0T%30T%$10HI.PI#4D5!5$4@05-#($E.1$58($E.1%]!
M4T-?4$%42%]#3$]#($].('1L;FM?3W)C4&%T:" H:6YT7T-,;V,I.PI#4D5!
M5$4@1$530R!)3D1%6"!)3D1?1$530U]0051(7T-,3T,@3TX@=&QN:U]/<F-0
M871H("AI;G1?0TQO8RD["D-214%412!!4T,@24Y$15@@24Y$7T%30U]0051(
M7TY,3T,@3TX@=&QN:U]/<F-0871H("AI;G1?3DQO8RD["D-214%412!$15-#
M($E.1$58($E.1%]$15-#7U!!5$A?3DQ/0R!/3B!T;&YK7T]R8U!A=&@@*&EN
M=%].3&]C*3L*0U)%051%($%30R!)3D1%6"!)3D1?05-#7U!!5$A?1$E2($].
M('1L;FM?3W)C4&%T:" H:6YT7T1I<BD["D-214%412!$15-#($E.1$58($E.
M1%]$15-#7U!!5$A?1$E2($].('1L;FM?3W)C4&%T:" H:6YT7T1I<BD["@I3
M14Q%0U0@)TET96US(&9O<B!C;VQL96-T:6]N("<@1E)/32!R9&(D9&%T86)A
M<V4["D-214%412!404),12!T8FQ?271E;2 H"B @:6YT7TET96T@3E5-15))
M0R@Q-2PP*2!.3U0@3E5,3"P*("!S=')?3F%M92!605)#2$%2*#4P*2!.3U0@
M3E5,3"P*("!S=')?1&5S8R!605)#2$%2*#(P,"DL"B @<W1R7U!O=V5R(%9!
M4D-(05(H-3 I+ H@(" @4%))34%262!+15D@*$EN=%])=&5M*0HI.PI#4D5!
M5$4@05-#($E.1$58($E.1%]!4T-?251%35])1"!/3B!T8FQ?271E;2 H:6YT
M7TET96TI.PI#4D5!5$4@1$530R!)3D1%6"!)3D1?1$530U])5$5-7TE$($].
M('1B;%])=&5M("AI;G1?271E;2D["D-214%412!!4T,@24Y$15@@24Y$7T%3
M0U])5$5-7TY!344@3TX@=&)L7TET96T@*'-T<E].86UE*3L*0U)%051%($1%
M4T,@24Y$15@@24Y$7T1%4T-?251%35].04U%($].('1B;%])=&5M("AS=')?
M3F%M92D["@I314Q%0U0@)TET96T@3&]C871I;VYS)R!&4D]-(')D8B1D871A
M8F%S93L*0U)%051%(%1!0DQ%('1B;%])=&5M0V]L;" H"B @:6YT7TQO8R!.
M54U%4DE#*#$U+# I($Y/5"!.54Q,+ H@(&EN=%])=&5M($Y5345224,H,34L
M,"D@3D]4($Y53$PL"B @:6YT7T5A8V@@24Y414=%4BP@+RH@2&]W(&UA;GD@
M82!U<V5R(&-A;B!T86ME*# ]971E<FYA;"AW871E<BDL(#$];VYE+W=O<FQD
M+" R/6]N92]U<V5R+" S/6]N92]U<V5R+V1A>2 I("HO"B @("!04DE-05)9
M($M%62 H:6YT7TQO8RP@:6YT7TET96TI"BD["@I314Q%0U0@)TET96T@57-E
M9"<@1E)/32!R9&(D9&%T86)A<V4["B\J(%1H:7,@:7,@=&\@<F5C;W)D('1H
M92!T86MI;F<@;V8@;V)J96-T<RX*4V]M92!O8FIE8W1S(&5X:7-T('!E<B!U
M<V5R*'1O;VP@8F5L="DL( IS;VUE('!E<B!W;W)L9" H2V5Y('1O('1H92!M
M;W5N=&%I;B!P<FEN8V5S<R<@8VAA<W1I='D@8F5L="DL( IS;VUE(&5T97)N
M86QL>2!R97!L96YI<V@@*'=A=&5R('-P<FEN9RD@*B\*0U)%051%(%1!0DQ%
M('1L;FM?271E;55S960@* H@(&EN=%],;V,@3E5-15))0R@Q-2PP*2!.3U0@
M3E5,3"P@+RH@5VAE<F4@=VAA<R!I="HO"B @:6YT7TET96T@3E5-15))0R@Q
M-2PP*2!.3U0@3E5,3"P@+RH@5&AE(&ET96T@=&AA="!W87,@=&%K96X@*B\*
M("!I;G1?54E$($Y5345224,H,34L,"D@3D]4($Y53$PL("\J($)Y('=H;R!W
M87,@:70@=&%K96X@*B\*("!D=&U?4W1A;7 @5$E-15-404U0($Y/5"!.54Q,
M+" O*B!!;F0@5VAE;B J+PH@(" @4%))34%262!+15D@*&EN=%],;V,L(&EN
M=%])=&5M+"!I;G1?54E$+"!D=&U?4W1A;7 I"BD["@I314Q%0U0@)U5S97)S
M(%1A8FQE)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%('1B;%]5
M<V5R("@*("!I;G1?54E$($Y5345224,H,34L,"D@3D]4($Y53$PL"B @<W1R
M7U5.86UE(%9!4D-(05(H,3 I($Y/5"!.54Q,+ H@('-T<E]516UA:6P@5D%2
M0TA!4B@U,"D@3D]4($Y53$PL"B @<W1R7U502&%S:"!605)#2$%2*#0P*2!.
M3U0@3E5,3"P*(" @(%!224U!4ED@2T59("AI;G1?54E$*0HI.PH*4T5,14-4
M("=5<V5R(%-T87-H)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%
M('1L:W!?55-T87-H("@*("!I;G1?54E$($Y5345224,H,34L,"D@3D]4($Y5
M3$PL"B @:6YT7U-T;W)E($E.5$5'15(@3D]4($Y53$PL("\J(# ]<&]C:V5T
M+" Q/7!O=6-H+" R/7!A8VL@*B\*("!I;G1?271E;2!605)#2$%2*#4P*2!.
M3U0@3E5,3"P@+RH@5&AE(&]B:F5C="!I;B!S=&]R86=E("HO"B @("!04DE-
M05)9($M%62 H:6YT7U5)1"P@:6YT7U-T;W)E*2P*(" @($9/4D5)1TX@2T59
M("AI;G1?271E;2D@4D5&15)%3D-%4R!T8FQ?271E;2 H:6YT7TET96TI($].
M(%501$%412!#05-#041%"BD["@H*4T5,14-4("=5<V5R($QO8V%T:6]N<R<@
M1E)/32!R9&(D9&%T86)A<V4["D-214%412!404),12!T;&YK7U5,;V,@* H@
M(&EN=%]5240@3E5-15))0R@Q-2PP*2!.3U0@3E5,3"P*("!I;G1?0TQO8R!.
M54U%4DE#*#$U+# I($Y/5"!.54Q,+ H@(" @4%))34%262!+15D@*&EN=%]5
M240L(&EN=%]#3&]C*2P*(" @($9/4D5)1TX@2T59("AI;G1?54E$*2!2149%
M4D5.0T53('1B;%]U<V5R*&EN=%]5240I($].(%501$%412!#05-#041%+ H@
M(" @1D]214E'3B!+15D@*&EN=%]#3&]C*2!2149%4D5.0T53('1B;%]O<F-A
M86XH:6YT7TQO8RD@3TX@55!$051%($-!4T-!1$4**3L*"E-%3$5#5" G57-E
M<B!,;V-A=&EO;B!(:7-T;W)Y)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%
M(%1!0DQ%('1L:W!?54QO8TAI<W0@* H@(&EN=%]5240@3E5-15))0R@Q-2PP
M*2!.3U0@3E5,3"P*("!I;G1?0TQO8R!.54U%4DE#*#$U+# I($Y/5"!.54Q,
M+ H@(&1T;5]3=&%M<"!424U%4U1!35 @1$5&055,5" G;F]W)R!.3U0@3E5,
M3"P*("!S=')?3F]T92!605)#2$%2*#$P,"DL"B @("!04DE-05)9($M%62 H
M:6YT7U5)1"P@:6YT7T-,;V,L(&1T;5]3=&%M<"DL"B @("!&3U)%24=.($M%
M62 H:6YT7U5)1"D@4D5&15)%3D-%4R!T8FQ?=7-E<BAI;G1?54E$*2!/3B!5
M4$1!5$4@0T%30T%$12P*(" @($9/4D5)1TX@2T59("AI;G1?0TQO8RD@4D5&
M15)%3D-%4R!T8FQ?;W)C86%N*&EN=%],;V,I($].(%501$%412!#05-#041%
M( HI.PH*4T5,14-4("=/<F-A86X@:&%S(&)E96X@8G5I;'0G($923TT@<F1B
+)&1A=&%B87-E.PH`
`
end
|
