github.com/yongjacky/phoenix-go-orm-builder@v0.3.5/testdata/mysql_fiddle_data.sql (about)

     1  create table table1 (
     2    id int primary key,
     3    a  varchar(40),
     4    b  varchar(40),
     5    c  varchar(40)
     6  );
     7  
     8  create table table2 (
     9    id     int primary key,
    10    ref_id int,
    11    d      varchar(40)
    12  );
    13  INSERT INTO table1 (id, a, b, c)
    14  VALUES (0, '0', '0', '0');
    15  INSERT INTO table1 (id, a, b, c)
    16  VALUES (1, '1', '1', '1');
    17  INSERT INTO table1 (id, a, b, c)
    18  VALUES (2, '2', '2', '2');
    19  INSERT INTO table1 (id, a, b, c)
    20  VALUES (3, '3', '3', '3');
    21  INSERT INTO table1 (id, a, b, c)
    22  VALUES (4, '4', '4', '4');
    23  INSERT INTO table1 (id, a, b, c)
    24  VALUES (5, '5', '5', '5');
    25  INSERT INTO table1 (id, a, b, c)
    26  VALUES (6, '6', '6', '6');
    27  INSERT INTO table1 (id, a, b, c)
    28  VALUES (7, '7', '7', '7');
    29  INSERT INTO table1 (id, a, b, c)
    30  VALUES (8, '8', '8', '8');
    31  INSERT INTO table1 (id, a, b, c)
    32  VALUES (9, '9', '9', '9');
    33  INSERT INTO table1 (id, a, b, c)
    34  VALUES (10, '10', '10', '10');
    35  INSERT INTO table1 (id, a, b, c)
    36  VALUES (11, '11', '11', '11');
    37  INSERT INTO table1 (id, a, b, c)
    38  VALUES (12, '12', '12', '12');
    39  INSERT INTO table1 (id, a, b, c)
    40  VALUES (13, '13', '13', '13');
    41  INSERT INTO table1 (id, a, b, c)
    42  VALUES (14, '14', '14', '14');
    43  INSERT INTO table1 (id, a, b, c)
    44  VALUES (15, '15', '15', '15');
    45  INSERT INTO table1 (id, a, b, c)
    46  VALUES (16, '16', '16', '16');
    47  INSERT INTO table1 (id, a, b, c)
    48  VALUES (17, '17', '17', '17');
    49  INSERT INTO table1 (id, a, b, c)
    50  VALUES (18, '18', '18', '18');
    51  INSERT INTO table1 (id, a, b, c)
    52  VALUES (19, '19', '19', '19');
    53  INSERT INTO table1 (id, a, b, c)
    54  VALUES (20, '20', '20', '20');
    55  INSERT INTO table1 (id, a, b, c)
    56  VALUES (21, '21', '21', '21');
    57  INSERT INTO table1 (id, a, b, c)
    58  VALUES (22, '22', '22', '22');
    59  INSERT INTO table1 (id, a, b, c)
    60  VALUES (23, '23', '23', '23');
    61  INSERT INTO table1 (id, a, b, c)
    62  VALUES (24, '24', '24', '24');
    63  INSERT INTO table1 (id, a, b, c)
    64  VALUES (25, '25', '25', '25');
    65  INSERT INTO table1 (id, a, b, c)
    66  VALUES (26, '26', '26', '26');
    67  INSERT INTO table1 (id, a, b, c)
    68  VALUES (27, '27', '27', '27');
    69  INSERT INTO table1 (id, a, b, c)
    70  VALUES (28, '28', '28', '28');
    71  INSERT INTO table1 (id, a, b, c)
    72  VALUES (29, '29', '29', '29');
    73  INSERT INTO table1 (id, a, b, c)
    74  VALUES (30, '30', '30', '30');
    75  INSERT INTO table1 (id, a, b, c)
    76  VALUES (31, '31', '31', '31');
    77  INSERT INTO table1 (id, a, b, c)
    78  VALUES (32, '32', '32', '32');
    79  INSERT INTO table1 (id, a, b, c)
    80  VALUES (33, '33', '33', '33');
    81  INSERT INTO table1 (id, a, b, c)
    82  VALUES (34, '34', '34', '34');
    83  INSERT INTO table1 (id, a, b, c)
    84  VALUES (35, '35', '35', '35');
    85  INSERT INTO table1 (id, a, b, c)
    86  VALUES (36, '36', '36', '36');
    87  INSERT INTO table1 (id, a, b, c)
    88  VALUES (37, '37', '37', '37');
    89  INSERT INTO table1 (id, a, b, c)
    90  VALUES (38, '38', '38', '38');
    91  INSERT INTO table1 (id, a, b, c)
    92  VALUES (39, '39', '39', '39');
    93  INSERT INTO table1 (id, a, b, c)
    94  VALUES (40, '40', '40', '40');
    95  INSERT INTO table1 (id, a, b, c)
    96  VALUES (41, '41', '41', '41');
    97  INSERT INTO table1 (id, a, b, c)
    98  VALUES (42, '42', '42', '42');
    99  INSERT INTO table1 (id, a, b, c)
   100  VALUES (43, '43', '43', '43');
   101  INSERT INTO table1 (id, a, b, c)
   102  VALUES (44, '44', '44', '44');
   103  INSERT INTO table1 (id, a, b, c)
   104  VALUES (45, '45', '45', '45');
   105  INSERT INTO table1 (id, a, b, c)
   106  VALUES (46, '46', '46', '46');
   107  INSERT INTO table1 (id, a, b, c)
   108  VALUES (47, '47', '47', '47');
   109  INSERT INTO table1 (id, a, b, c)
   110  VALUES (48, '48', '48', '48');
   111  INSERT INTO table1 (id, a, b, c)
   112  VALUES (49, '49', '49', '49');
   113  
   114  INSERT INTO table2 (id, ref_id, d)
   115  VALUES (0, '0', '0');
   116  INSERT INTO table2 (id, ref_id, d)
   117  VALUES (1, '1', '1');
   118  INSERT INTO table2 (id, ref_id, d)
   119  VALUES (2, '2', '2');
   120  INSERT INTO table2 (id, ref_id, d)
   121  VALUES (3, '3', '3');
   122  INSERT INTO table2 (id, ref_id, d)
   123  VALUES (4, '4', '4');
   124  INSERT INTO table2 (id, ref_id, d)
   125  VALUES (5, '5', '5');
   126  INSERT INTO table2 (id, ref_id, d)
   127  VALUES (6, '6', '6');
   128  INSERT INTO table2 (id, ref_id, d)
   129  VALUES (7, '7', '7');
   130  INSERT INTO table2 (id, ref_id, d)
   131  VALUES (8, '8', '8');
   132  INSERT INTO table2 (id, ref_id, d)
   133  VALUES (9, '9', '9');
   134  INSERT INTO table2 (id, ref_id, d)
   135  VALUES (10, '10', '10');
   136  INSERT INTO table2 (id, ref_id, d)
   137  VALUES (11, '11', '11');
   138  INSERT INTO table2 (id, ref_id, d)
   139  VALUES (12, '12', '12');
   140  INSERT INTO table2 (id, ref_id, d)
   141  VALUES (13, '13', '13');
   142  INSERT INTO table2 (id, ref_id, d)
   143  VALUES (14, '14', '14');
   144  INSERT INTO table2 (id, ref_id, d)
   145  VALUES (15, '15', '15');
   146  INSERT INTO table2 (id, ref_id, d)
   147  VALUES (16, '16', '16');
   148  INSERT INTO table2 (id, ref_id, d)
   149  VALUES (17, '17', '17');
   150  INSERT INTO table2 (id, ref_id, d)
   151  VALUES (18, '18', '18');
   152  INSERT INTO table2 (id, ref_id, d)
   153  VALUES (19, '19', '19');
   154  INSERT INTO table2 (id, ref_id, d)
   155  VALUES (20, '20', '20');
   156  INSERT INTO table2 (id, ref_id, d)
   157  VALUES (21, '21', '21');
   158  INSERT INTO table2 (id, ref_id, d)
   159  VALUES (22, '22', '22');
   160  INSERT INTO table2 (id, ref_id, d)
   161  VALUES (23, '23', '23');
   162  INSERT INTO table2 (id, ref_id, d)
   163  VALUES (24, '24', '24');
   164  INSERT INTO table2 (id, ref_id, d)
   165  VALUES (25, '25', '25');
   166  INSERT INTO table2 (id, ref_id, d)
   167  VALUES (26, '26', '26');
   168  INSERT INTO table2 (id, ref_id, d)
   169  VALUES (27, '27', '27');
   170  INSERT INTO table2 (id, ref_id, d)
   171  VALUES (28, '28', '28');
   172  INSERT INTO table2 (id, ref_id, d)
   173  VALUES (29, '29', '29');
   174  INSERT INTO table2 (id, ref_id, d)
   175  VALUES (30, '30', '30');
   176  INSERT INTO table2 (id, ref_id, d)
   177  VALUES (31, '31', '31');
   178  INSERT INTO table2 (id, ref_id, d)
   179  VALUES (32, '32', '32');
   180  INSERT INTO table2 (id, ref_id, d)
   181  VALUES (33, '33', '33');
   182  INSERT INTO table2 (id, ref_id, d)
   183  VALUES (34, '34', '34');
   184  INSERT INTO table2 (id, ref_id, d)
   185  VALUES (35, '35', '35');
   186  INSERT INTO table2 (id, ref_id, d)
   187  VALUES (36, '36', '36');
   188  INSERT INTO table2 (id, ref_id, d)
   189  VALUES (37, '37', '37');
   190  INSERT INTO table2 (id, ref_id, d)
   191  VALUES (38, '38', '38');
   192  INSERT INTO table2 (id, ref_id, d)
   193  VALUES (39, '39', '39');
   194  INSERT INTO table2 (id, ref_id, d)
   195  VALUES (40, '40', '40');
   196  INSERT INTO table2 (id, ref_id, d)
   197  VALUES (41, '41', '41');
   198  INSERT INTO table2 (id, ref_id, d)
   199  VALUES (42, '42', '42');
   200  INSERT INTO table2 (id, ref_id, d)
   201  VALUES (43, '43', '43');
   202  INSERT INTO table2 (id, ref_id, d)
   203  VALUES (44, '44', '44');
   204  INSERT INTO table2 (id, ref_id, d)
   205  VALUES (45, '45', '45');
   206  INSERT INTO table2 (id, ref_id, d)
   207  VALUES (46, '46', '46');
   208  INSERT INTO table2 (id, ref_id, d)
   209  VALUES (47, '47', '47');
   210  INSERT INTO table2 (id, ref_id, d)
   211  VALUES (48, '48', '48');
   212  INSERT INTO table2 (id, ref_id, d)
   213  VALUES (49, '49', '49');