DROP TABLE IF EXISTS samplesprayright;

CREATE TABLE samplesprayright (
    uid INT NOT NULL PRIMARY KEY,
    data0 INT NOT NULL DEFAULT 0,
    data1 INT NOT NULL DEFAULT 0,
    data2 INT NOT NULL DEFAULT 0,
    data3 INT NOT NULL DEFAULT 0,
    data4 INT NOT NULL DEFAULT 0,
    data5 INT NOT NULL DEFAULT 0,
    data6 INT NOT NULL DEFAULT 0,
    data7 INT NOT NULL DEFAULT 0,
    data8 INT NOT NULL DEFAULT 0,
    data9 INT NOT NULL DEFAULT 0,
    data10 INT NOT NULL DEFAULT 0,
    data11 INT NOT NULL DEFAULT 0,
    data12 INT NOT NULL DEFAULT 0,
    data13 INT NOT NULL DEFAULT 0,
    data14 INT NOT NULL DEFAULT 0,
    data15 INT NOT NULL DEFAULT 0,
    data16 INT NOT NULL DEFAULT 0,
    data17 INT NOT NULL DEFAULT 0,
    data18 INT NOT NULL DEFAULT 0,
    data19 INT NOT NULL DEFAULT 0,
    data20 INT NOT NULL DEFAULT 0,
    data21 INT NOT NULL DEFAULT 0,
    data22 INT NOT NULL DEFAULT 0,
    data23 INT NOT NULL DEFAULT 0,
    data24 INT NOT NULL DEFAULT 0,
    data25 INT NOT NULL DEFAULT 0,
    data26 INT NOT NULL DEFAULT 0,
    data27 INT NOT NULL DEFAULT 0,
    data28 INT NOT NULL DEFAULT 0,
    data29 INT NOT NULL DEFAULT 0,
    data30 INT NOT NULL DEFAULT 0,
    data31 INT NOT NULL DEFAULT 0,
    data32 INT NOT NULL DEFAULT 0,
    data33 INT NOT NULL DEFAULT 0,
    data34 INT NOT NULL DEFAULT 0,
    data35 INT NOT NULL DEFAULT 0,
    data36 INT NOT NULL DEFAULT 0,
    data37 INT NOT NULL DEFAULT 0,
    data38 INT NOT NULL DEFAULT 0,
    data39 INT NOT NULL DEFAULT 0,
    data40 INT NOT NULL DEFAULT 0,
    data41 INT NOT NULL DEFAULT 0,
    data42 INT NOT NULL DEFAULT 0,
    data43 INT NOT NULL DEFAULT 0,
    data44 INT NOT NULL DEFAULT 0,
    data45 INT NOT NULL DEFAULT 0,
    data46 INT NOT NULL DEFAULT 0,
    data47 INT NOT NULL DEFAULT 0,
    data48 INT NOT NULL DEFAULT 0,
    data49 INT NOT NULL DEFAULT 0,
    data50 INT NOT NULL DEFAULT 0,
    data51 INT NOT NULL DEFAULT 0,
    data52 INT NOT NULL DEFAULT 0,
    data53 INT NOT NULL DEFAULT 0,
    data54 INT NOT NULL DEFAULT 0,
    data55 INT NOT NULL DEFAULT 0,
    data56 INT NOT NULL DEFAULT 0,
    data57 INT NOT NULL DEFAULT 0,
    data58 INT NOT NULL DEFAULT 0,
    data59 INT NOT NULL DEFAULT 0,
    data60 INT NOT NULL DEFAULT 0,
    data61 INT NOT NULL DEFAULT 0,
    data62 INT NOT NULL DEFAULT 0,
    data63 INT NOT NULL DEFAULT 0,
    data64 INT NOT NULL DEFAULT 0,
    data65 INT NOT NULL DEFAULT 0,
    data66 INT NOT NULL DEFAULT 0,
    data67 INT NOT NULL DEFAULT 0,
    data68 INT NOT NULL DEFAULT 0,
    data69 INT NOT NULL DEFAULT 0,
    data70 INT NOT NULL DEFAULT 0,
    data71 INT NOT NULL DEFAULT 0,
    data72 INT NOT NULL DEFAULT 0,
    data73 INT NOT NULL DEFAULT 0,
    data74 INT NOT NULL DEFAULT 0,
    data75 INT NOT NULL DEFAULT 0,
    data76 INT NOT NULL DEFAULT 0,
    data77 INT NOT NULL DEFAULT 0,
    data78 INT NOT NULL DEFAULT 0,
    data79 INT NOT NULL DEFAULT 0,
    data80 INT NOT NULL DEFAULT 0,
    data81 INT NOT NULL DEFAULT 0,
    data82 INT NOT NULL DEFAULT 0,
    data83 INT NOT NULL DEFAULT 0,
    data84 INT NOT NULL DEFAULT 0,
    data85 INT NOT NULL DEFAULT 0,
    data86 INT NOT NULL DEFAULT 0,
    data87 INT NOT NULL DEFAULT 0,
    data88 INT NOT NULL DEFAULT 0,
    data89 INT NOT NULL DEFAULT 0,
    data90 INT NOT NULL DEFAULT 0,
    data91 INT NOT NULL DEFAULT 0,
    data92 INT NOT NULL DEFAULT 0,
    data93 INT NOT NULL DEFAULT 0,
    data94 INT NOT NULL DEFAULT 0,
    data95 INT NOT NULL DEFAULT 0,
    data96 INT NOT NULL DEFAULT 0,
    data97 INT NOT NULL DEFAULT 0,
    data98 INT NOT NULL DEFAULT 0,
    data99 INT NOT NULL DEFAULT 0,
    last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO samplesprayright(uid)
VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),
(10),
(11),
(12),
(13),
(14),
(15),
(16),
(17),
(18),
(19),
(20),
(21),
(22),
(23),
(24),
(25),
(26),
(27),
(28),
(29),
(30),
(31),
(32),
(33),
(34),
(35),
(36),
(37),
(38),
(39),
(40),
(41),
(42),
(43),
(44),
(45),
(46),
(47),
(48),
(49),
(50),
(51),
(52),
(53),
(54),
(55),
(56),
(57),
(58),
(59),
(60),
(61),
(62),
(63),
(64),
(65),
(66),
(67),
(68),
(69),
(70),
(71),
(72),
(73),
(74),
(75),
(76),
(77),
(78),
(79),
(80),
(81),
(82),
(83),
(84),
(85),
(86),
(87),
(88),
(89),
(90),
(91),
(92),
(93),
(94),
(95),
(96),
(97),
(98),
(99),
(100);