*/
/*** Triggers ***/
/***************************************** *************************************/TERM ^;
/* Trigger: DOLJN_BI0 */TRIGGER DOLJN_BI0 FOR DOLJNBEFORE INSERT POSITION 0
IF (NEW.id_doljn IS NULL) THEN.id_doljn=GEN_ID (gen_doljn, 1);
^
/* Trigger: KLIENT_BI0 */TRIGGER KLIENT_BI0 FOR KLIENTBEFORE INSERT POSITION 0
IF (NEW.id_klient IS NULL) THEN.id_klient=GEN_ID (gen_klient, 1);
^
/* Trigger: MATERIAL_BI0 */TRIGGER MATERIAL_BI0 FOR MATERIALBEFORE INSERT POSITION 0
IF (NEW.id_material IS NULL) THEN.id_material=GEN_ID (gen_material, 1);
^
/* Trigger: POST_BI0 */TRIGGER POST_BI0 FOR POSTBEFORE INSERT POSITION 0
IF (NEW.id_post IS NULL) THEN.id_post=GEN_ID (gen_post, 1);
^
/* Trigger: SDELKI_BI0 */TRIGGER SDELKI_BI0 FOR SDELKIBEFORE INSERT POSITION 0
IF (NEW.id_sdelki IS NULL) THEN.id_sdelki=GEN_ID (gen_sdelki, 1);
^
/* Trigger: SOTR_BI0 */TRIGGER SOTR_BI0 FOR SOTRBEFORE INSERT POSITION 0
IF (NEW.id_sotr IS NULL) THEN.id_sotr=GEN_ID (gen_sotr, 1);
^
/* Trigger: TOVAR_BI0 */TRIGGER TOVAR_BI0 FOR TOVARBEFORE INSERT POSITION 0
IF (NEW.id_tovar IS NULL) THEN.id_tovar=GEN_ID (gen_tovar, 1);
^
/* Trigger: TOVAR_MATERIAL_BI0 */TRIGGER TOVAR_MATERIAL_BI0 FOR TOVAR_MATERIALBEFORE INSERT POSITION 0
IF (NEW.id_tovar_material IS NULL) THEN.id_tovar_material=GEN_ID (gen_tovar_material, 1);
^
/* Trigger: TRANSPORT_BI0 */TRIGGER TRANSPORT_BI0 FOR TRANSPORTBEFORE INSERT POSITION 0
IF (NEW.id_transport IS NULL) THEN.id_transport=GEN_ID (gen_transport, 1);
^
/* Trigger: USLUGI_BI0 */TRIGGER USLUGI_BI0 FOR USLUGIBEFORE INSERT POSITION 0
IF (NEW.id_uslugi IS NULL) THEN.id_uslugi=GEN_ID (gen_uslugi, 1);
^
/* Trigger: ZAKAZ_BI0 */TRIGGER ZAKAZ_BI0 FOR ZAKAZBEFORE INSERT POSITION 0
IF (NEW.id_zakaz IS NULL) THEN.id_zakaz=GEN_ID (gen_zakaz, 1);
^
/* Trigger: ZAKAZ_USLUGI_BI0 */TRIGGER ZAKAZ_USLUGI_BI0 FOR ZAKAZ_USLUGIBEFORE INSERT POSITION 0
IF (NEW.id_zakaz_uslugi IS NULL) THEN.id_zakaz_uslugi=GEN_ID (gen_zakaz_uslugi, 1);
end
^ TERM; ^
2. Web -
Index.php
lt;! DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN gt;
lt; HTML gt;
lt; HEAD gt;
lt; META HTTP-EQUIV= Content-Type CONTENT= text/html; CHARSET=UTF8 gt;
lt; TITLE gt;- Lt;/TITLE gt;
lt; link rel= stylesheet type= text/css href= images/style.css gt;
lt; br/ gt;
lt;/HEAD gt;
lt; BODY BACKGROUND= images/tile.gif BGCOLOR= # FFFFFF gt;
lt; div style= position: absolute; top: 10; left: 10; z-index: 10 gt;
lt; font color= green gt; lt; h4 align= left gt;:
lt; script type= text/JavaScript gt;=new Array ( raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, );
dayName=new Array ( , raquo ;, raquo ;, raquo ;, raquo ;, raquo ;, );
now=new Date; .write (now.getDate () + + monName [now.getMonth ()] + laquo ;, + now.getHours () + : + now.getMinutes () + : + now.getSeconds () + laquo ;, + dayName [now.getDay ()]);
lt;/script gt;
lt;/h4 gt; lt;/font gt;
lt;/div gt;
lt;? php titles.php raquo ;;
? gt;
lt; BR gt;
lt; SPACER TYPE= HORIZONTAL SIZE= 52 gt; lt; FONT SIZE= 6 gt; lt; a href= lt;? php echo $ _SERVER [ PHP_SELF ];? gt; gt; lt; IMG SRC= images/smallglobe.jpg WIDTH= 39 HEIGHT= 39 ALIGN= BOTTOM BORDER= 0 gt; lt;/a gt; amp; nbsp;- Lt;/FONT gt; lt; BR gt;
lt; IMG SRC= images/largebanner.gif WIDTH= 1...
