65 lines
1.6 KiB
SQL
65 lines
1.6 KiB
SQL
-- Directus seed data script
|
|
-- Run this in Directus SQL editor to populate sample data
|
|
|
|
-- Sample restaurants
|
|
INSERT INTO restaurants (id, name, description, cuisine_type, website_url, status)
|
|
VALUES
|
|
(
|
|
'550e8400-e29b-41d4-a716-446655440001',
|
|
'La Bella Vita',
|
|
'Authentic Italian cuisine with fresh pasta and wood-fired pizza',
|
|
'Italian',
|
|
'https://example.com/bella-vita',
|
|
'published'
|
|
),
|
|
(
|
|
'550e8400-e29b-41d4-a716-446655440002',
|
|
'Dragon Palace',
|
|
'Traditional Chinese and Asian fusion dishes',
|
|
'Asian',
|
|
'https://example.com/dragon-palace',
|
|
'published'
|
|
),
|
|
(
|
|
'550e8400-e29b-41d4-a716-446655440003',
|
|
'The Steak House',
|
|
'Premium cuts and fine dining experience',
|
|
'American',
|
|
'https://example.com/steak-house',
|
|
'published'
|
|
);
|
|
|
|
-- Sample attractions
|
|
INSERT INTO attractions (id, name, description, category, distance_km, website_url, hours, status)
|
|
VALUES
|
|
(
|
|
'550e8400-e29b-41d4-a716-446655440010',
|
|
'City Museum',
|
|
'World-class art and history exhibits',
|
|
'Museum',
|
|
2.5,
|
|
'https://example.com/museum',
|
|
'10:00 AM - 6:00 PM Daily',
|
|
'published'
|
|
),
|
|
(
|
|
'550e8400-e29b-41d4-a716-446655440011',
|
|
'Central Park',
|
|
'Largest urban park with trails and recreational areas',
|
|
'Parks & Nature',
|
|
1.2,
|
|
'https://example.com/park',
|
|
'Dawn - Dusk',
|
|
'published'
|
|
),
|
|
(
|
|
'550e8400-e29b-41d4-a716-446655440012',
|
|
'Shopping District',
|
|
'Upscale boutiques and flagship stores',
|
|
'Shopping',
|
|
0.8,
|
|
'https://example.com/shopping',
|
|
'10:00 AM - 10:00 PM Daily',
|
|
'published'
|
|
);
|