order_data.sql

INSERT INTO Order_info
(
    order_ID,
    status,
    time,
    date,
    num_of_child_ticket,
    num_of_adult_ticket,
    num_of_senior_ticket,
    num_of_total_ticket,
    username,
    card_num,
    title,
    theater_ID
)
VALUES
(
    1,
    'complete',
    '13:59:59.999999',
    '2016-05-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    2,
    'complete',
    '13:59:59.999999',
    '2016-05-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie2",
    1
),
(
    3,
    'complete',
    '13:59:59.999999',
    '2016-05-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie3",
    1
),
(
    4,
    'complete',
    '13:59:59.999999',
    '2016-05-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie4",
    1
),
(
    5,
    'complete',
    '13:59:59.999999',
    '2016-05-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie5",
    1
),
(
    6,
    'complete',
    '13:59:59.999999',
    '2016-06-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie6",
    1
),
(
    7,
    'complete',
    '13:59:59.999999',
    '2016-06-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie7",
    1
),
(
    8,
    'complete',
    '13:59:59.999999',
    '2016-06-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie8",
    1
),
(
    9,
    'complete',
    '13:59:59.999999',
    '2016-06-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie9",
    1
),
(
    10,
    'complete',
    '13:59:59.999999',
    '2016-06-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie10",
    1
),
(
    11,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    12,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie11",
    1
),
(
    13,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    14,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    15,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    16,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    17,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    18,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    19,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    20,
    'cancelled',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    21,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    22,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    23,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    24,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    25,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    26,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    27,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    28,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    29,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    30,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    31,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    32,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    33,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    34,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    35,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    36,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    37,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    38,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    39,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    40,
    'unused',
    '13:59:59.999999',
    '2016-07-28',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie1",
    1
),
(
    41,
    'complete',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie11",
    1
),
(
    42,
    'complete',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie12",
    1
),
(
    43,
    'complete',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie13",
    1
),
(
    44,
    'complete',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie14",
    1
),
(
    45,
    'complete',
    '13:59:59.999999',
    '2016-07-08',
    1,
    1,
    0,
    2,
    'user1',
    1234561,
    "movie15",
    1
);