--- /dev/null
+DROP TABLE #PFX#bin5_table_order;
+CREATE TABLE #PFX#bin5_table_order (
+ mcode integer REFERENCES #PFX#bin5_matches (code) ON DELETE cascade ON UPDATE cascade,
+ ucode integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade,
+ pos integer
+ );
+
+ALTER TABLE #PFX#bin5_matches ADD COLUMN mult_next integer DEFAULT 1; -- current multiplier
+ALTER TABLE #PFX#bin5_matches ADD COLUMN mazzo_next integer; -- current card shaker
+
INSERT INTO #PFX#users (code, login, pass, email, type, flags) VALUES (3, 'tre', md5('thr'), 'tre@pluto.com', CAST (X'00010000' as integer), 0);
INSERT INTO #PFX#users (code, login, pass, email, type, flags) VALUES (4, 'qua', md5('for'), 'qua@pluto.com', CAST (X'00210000' as integer), 0);
INSERT INTO #PFX#users (code, login, pass, email, type, flags) VALUES (5, 'cin', md5('fiv'), 'cin@pluto.com', CAST (X'00010000' as integer), 0);
-
+ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 6;