13 lines
490 B
SQL
13 lines
490 B
SQL
-- Create missing sequence for commercials_json serialId
|
|
-- This sequence is required for generating unique serialId values for commercial property listings
|
|
|
|
CREATE SEQUENCE IF NOT EXISTS commercials_json_serial_id_seq START WITH 100000;
|
|
|
|
-- Verify the sequence was created
|
|
SELECT sequence_name, start_value, last_value
|
|
FROM information_schema.sequences
|
|
WHERE sequence_name = 'commercials_json_serial_id_seq';
|
|
|
|
-- Also verify all sequences to check if business listings sequence exists
|
|
\ds
|